Standard Additions plotting in excel

Click For Summary

Discussion Overview

The discussion revolves around the challenges faced in plotting data from a standard additions practical in Excel, specifically regarding the inclusion of negative integers on the horizontal axis. Participants are exploring the technical aspects of creating the plot and fitting a calibration line.

Discussion Character

  • Homework-related
  • Technical explanation

Main Points Raised

  • One participant expresses difficulty in plotting values in Excel, particularly needing to include negative integers on the horizontal axis.
  • Another participant asserts that Excel supports negative numbers, questioning the nature of the problem.
  • A third participant agrees with the previous assertion, indicating confusion about the issue presented.
  • A later post reiterates the original problem, emphasizing the need to extrapolate the calibration line backwards to achieve negative values on the X-axis, and requests assistance with the plotting process.
  • One participant seeks clarification on whether the issue lies in plotting and fitting the data or in the understanding of how to perform those tasks in Excel.

Areas of Agreement / Disagreement

There is no consensus on the nature of the problem, as some participants believe Excel should handle negative numbers without issue, while the original poster continues to express difficulty in achieving the desired plot.

Contextual Notes

Participants have not provided specific details on the steps taken to plot the data or the exact nature of the difficulties encountered, leaving some assumptions and methods unspecified.

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: 805
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?
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 15 ·
Replies
15
Views
26K
Replies
7
Views
3K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K