Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Anniebabygirl
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A scatter plot with a 2 column data source SamB Charts and Charting in Excel 4 August 23rd 07 11:44 PM
Plot the sin curve along the line y=x Rbp9ad Charts and Charting in Excel 3 December 21st 05 12:43 AM
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . fh Charts and Charting in Excel 0 June 3rd 05 01:07 PM
Plot a line? Set dymanic axis Max min Stan Altshuller Charts and Charting in Excel 3 December 9th 04 08:04 PM
equation for smoothed XY Scatter line mark Charts and Charting in Excel 2 December 7th 04 04:27 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"