Standard Additions plotting in excel

AI Thread Summary
The discussion revolves around difficulties in plotting standard additions data in Excel, specifically the challenge of including negative integers on the horizontal axis. Users express confusion about how to create the necessary plots and extrapolate the calibration line backwards to obtain negative values. Some participants note that Excel supports negative numbers, but the original poster seeks guidance on the plotting process itself. Clarification is requested on whether the issue lies in plotting and fitting the data or in the extrapolation step. Assistance is sought to effectively create the required standard additions plot in Excel.
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: 778
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?
 
Thread 'Confusion regarding a chemical kinetics problem'
TL;DR Summary: cannot find out error in solution proposed. [![question with rate laws][1]][1] Now the rate law for the reaction (i.e reaction rate) can be written as: $$ R= k[N_2O_5] $$ my main question is, WHAT is this reaction equal to? what I mean here is, whether $$k[N_2O_5]= -d[N_2O_5]/dt$$ or is it $$k[N_2O_5]= -1/2 \frac{d}{dt} [N_2O_5] $$ ? The latter seems to be more apt, as the reaction rate must be -1/2 (disappearance rate of N2O5), which adheres to the stoichiometry of the...
Back
Top