Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I find the equation of a line using a scatter plot?
I am taking a chem lab and right now we are studying rate laws using
kenetics. we had to graph the results of our experiment and then find the equation of the line. such as y=mx+b but i cant fiugre out how to do it. or if i am supposed to put a trend line in the graph, but if that is what I am supposed to do how do I find the equation of it? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I find the equation of a line using a scatter plot?
First: to make trendline. Right click on the data in the chart; use Add
trendline; specify Linear; on Options tab, check shoe equation Secondly:To get slope and intercept: Let's say you x-values are in A2:A11 and y-values in B2:B11 for slope use formula =SLOPE(A2:A11, B2:B11) for intercept use INTERCEPT(A2:A11, B2:B11) -- Bernard V Liengme (he taught Intro Chem for 38 years!) www.stfx.ca/people/bliengme remove caps from email "Anniebabygirl" wrote in message ... I am taking a chem lab and right now we are studying rate laws using kenetics. we had to graph the results of our experiment and then find the equation of the line. such as y=mx+b but i cant fiugre out how to do it. or if i am supposed to put a trend line in the graph, but if that is what I am supposed to do how do I find the equation of it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A scatter plot with a 2 column data source | Charts and Charting in Excel | |||
Plot the sin curve along the line y=x | Charts and Charting in Excel | |||
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . | Charts and Charting in Excel | |||
Plot a line? Set dymanic axis Max min | Charts and Charting in Excel | |||
equation for smoothed XY Scatter line | Charts and Charting in Excel |