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??

Answer 1

Yes, if:
- your data plots linearly on a graph
- your equation is linear (which it is)
- you expect to see linear results

Answer 2

Using a trend line is pretty much pointless since your assumption forces a straight-line relation between F and a. Your trend line will exactly duplicate your assumed function. Without experimental data on F as well as a you cannot prove or disprove your function.

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) ]