Scatterplot Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a few points, graphed as a scatterplot and the points are connected by
a smooth line. (For example: (0,0), (5, 6), (6, 8), (10, 20).)

Since the points are connected by 3 different smooth lines, each line has a
different slope/degree. Is there any way to have Excel determine the y-value
of a point that is not a plotted point (anything besides x = 0, 5, 6, 10)?
For example, based on the smooth line, can I ask Excel to find the y-value of
x=1 or x=9?

Thank you very much for your help!
 
Thank you for your reply.

While I understand that this allows you to "read off" the value of the
point, is there any way to ask Excel to compute that value? Also, while the
website may help when the point plotted is in the same worksheet as the
graph, I don't quite know how to drag the point to the graph, if the graph is
 
Do you know what is meant by curve fitting? If you find the equation that
fits the curve, simple math will let Excel compute Y given X. You data can
be fitted to a 3rd order polynomial. See
www.stfx.ca/people/bliengme/ExcelTips for the use of LINEST to get the
parameters of a polynomial fit into cells. Then come back for more.

On separate sheets: do you now how to use Window|New Window to display to
sheets side by side?
 
Back
Top