Standard Additions plotting in excel

4 replies · 3K views · last reply
Divine
Messages
2
Reaction score
0

Homework Statement



I have a set of values from a laboratory work (standard Additions practical), which I am required to plot. I am finding difficulties in plotting the values in excel because the horizontal axis must have some negative integers.

Homework Equations





The Attempt at a Solution

 
No idea what your problem is, last time I used it, Excel supported negative numbers.
 
Have to agree w/ Borek. Can't see what your problem is

Excel line chart of y against x with points at x = -2, -1, 1, 2, 3, 4 and y values 0, -1, 2, -1, 1, 2, joined by straight lines, with the spreadsheet data listed beside it.
 
Attachments
  • Excel screenshot of a line chart with x-axis from -2 to 4 and y-axis from -2 to 5, plotting points connected by straight line segments; the adjacent cells list x values -2, -1, 1, 2, 3, 4 with y values 0, -1, 2, -1, 1, 2.
    Capture.JPG
    22.6 KB · Views: 835
Standard Additions

Divine said:

Homework Statement



I have a set of values from a laboratory work (standard Additions practical), which I am required to plot. I am finding difficulties in plotting the values in excel because the horizontal axis must have some negative integers.

Homework Equations





The Attempt at a Solution


Hello Borek,
My problem is that I don't know how to make such plots in excel. As you might be aware, there is the need to extrapolate the calibration line backwards so as to obtain a negative value on the X-axis. This is what I cannot do and will appreciate it if someone could help me.
The example given below is of no help as it looks nothing like a standard additions plot.

Thanks.
 
Have you plotted your data and fit a line already and don't know how to extrapolate or do you not know how to plot and fit data?