Standard Additions plotting in excel

Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
4 replies · 3K views
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

 
Physics news on Phys.org
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

attachment.php?attachmentid=67427&stc=1&d=1394317262.jpg
 

Attachments

  • Capture.JPG
    Capture.JPG
    22.6 KB · Views: 814
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?