Hello,

I am trying to find a deviation from a linear regression with Access.  I have two columns....

Weight (grams)         Food Consumption (grams)
55                                         200
54                                         205
44                                         190
56                                         222
34                                         122
66                                         230

Any Ideas?

Thank You!
LVL 7
###### Who is Participating?

Commented:

http://science.widener.edu/svb/stats/regress.html

You can create a query and apply those formula.
0

Author Commented:
ThankYou!  Was the math that i needed refreshing on.  I get so used to just looking for pre made functions that i overlook this :)
0

Commented:
You will need a first query (q1) to calculate the slope (m) and the intersection point (b). Then a query like this:

Select Weight, Food, Food - (m*Weight + b) as Deviation
From YourTable, q1
0

Author Commented:
Got It :)

Weight (grams)         Food Consumption (grams)      Deviation
55                                         200                              -15.98337422
54                                         205                      19.53093486
44                                         190                      2.045243936
56                                         222                       -6.203325157
34                                         122                      12.54810575
66                                         230                     -11.93758517

Thank You!!

Now on to make it easier to impliment, hopefully i can get through that one alone.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.