Physics lab

[jellz]

Alrighty, my lab asks me to find the slope and coefficient of regression for the best fit line on this graph. Can anyone tell me how I do this in excel? I tried google, and went to microsoft's, but didn't really understand it. thanks in advance! O it's excel 2007.

 

[swiftaw]

Did you find this site: http://www.ncsu.edu/labwrite/res/gt/gt-reg-home.html

 

[Abstract]

Did you try right-clicking on the graph and clicking on "Add Trendline"?

There should be an option that allows you to add the equation of that fitted line, along with the "R" value.

 

[swiftaw]

On a side note, as a statistician, I go crazy every time anyone wants me to do statistical analysis in Excel.

 

[jellz]

hmm. I got two ways now and 2 different answers. First, I tried abstract's way and got a slope of 3.042 and a Rsquared value of .995. The second way was I entered the values on the spreadsheet and went to "more formulas" and had it calculate the slope and the Rsquared value with the data. With this method I got a slope of 3.098 and Rsquared value of .997

 

[swiftaw]

hmm. I got two ways now and 2 different answers. First, I tried abstract's way and got a slope of 3.042 and a Rsquared value of .995. The second way was I entered the values on the spreadsheet and went to "more formulas" and had it calculate the slope and the Rsquared value with the data. With this method I got a slope of 3.098 and Rsquared value of .997

Perhaps the second way fixes the intercept at 0?

 

[jellz]

Oh, I fixed the intercept at 0 with the first results. It's an area of a circle versus Radii squared graph. With the data I didn't bother entering 0,0 in. I guess I'll go with the first set of numbers.