• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Linear Regerssion


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!
  • 2
  • 2
1 Solution
Check this link:


You can create a query and apply those formula.
NavicertsAuthor 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 :)
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
NavicertsAuthor 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.

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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now