MS excel prob.?

Question

I have some data. I have theorized that it should be close to the linear trend Applied Force predicted [N] = 0.225 [KG] * Acceleration [m/s/s].

I take the acceleration data I have collected and put it through this predictive function. I plot the resulting theoretical data as Forve vs. Acceleration.

Should I instruct MS excel to add a linear trend(along with the y=mx+b output the linear fit produces) to this predictive data?

why or why not??


please help!!! thanks!!

Answer 1

What is it that you're trying to do? If you do a linear fit, then you should output the values predicted by the fitted equation at the points that you measured.

Your chart should then graph the measured data vs. the predicted data at those points.

Your regression coefficient R should be displayed on your chart to show that the linear fit is good.

If you want to get fancy, you can compare the fit against other possibilities, i.e., power law, exponential, log, etc.

Answer 2

No need to if you've done the regression correctly. The linear trend line in MSExcel does the same function without showing the equation.

Answer 3

in case you imagine the courting is linear (which it sounds like it will be) including a type line with the linear regression. you are able to discover how properly the recommendations suits the linear variety by technique of choosing "exhibit R squared cost in chart". this may inform you only how reliable of a in good structure the variety is. An r-squared of one million.0 (one hundred%) exhibits a desirable in good structure. The formula for r is: r(X,Y) = [ Cov(X,Y) ] / [ StdDev(X) x StdDev(Y) ]