Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Linear Regerssion

Posted on 2004-09-21
4
Medium Priority
?
409 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 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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

580 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