?
Solved

Linear Regerssion

Posted on 2004-09-21
4
Medium Priority
?
404 Views
Last Modified: 2008-01-09
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!
0
Comment
Question by:Navicerts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
Nestorio earned 2000 total points
ID: 12115231
Check this link:

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

You can create a query and apply those formula.
0
 
LVL 7

Author Comment

by:Navicerts
ID: 12115256
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
 
LVL 16

Expert Comment

by:Nestorio
ID: 12115455
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
 
LVL 7

Author Comment

by:Navicerts
ID: 12115628
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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question