Solved

Linear Regerssion

Posted on 2004-09-21
4
396 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
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
Nestorio earned 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

810 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