- #1
Drudge
- 30
- 0
Homework Statement
Why does excel give me this:
http://postimg.org/image/68b9z1lqt/
And various online calulators (for example http://www.alcula.com/calculators/statistics/linear-regression/), and my own calulations give me this:
http://postimg.org/image/kpljm4awx/
Homework Equations
Raw data:
Y: 18.9, 31.9, 18.5, 33.9, 24.9, 15.2, 26.9, 26.9, 29.9, 29.9, 35.9, 21.9, 16.9, 8.9, 24.9
X: 5, 4, 3, 1, 4, 8, 3, 6, 7, 5, 3, 3, 9, 14, 4
The Attempt at a Solution
I get the linear equation of: y = -0.29967x + 12,5667
The book I am studying has the answer that you get from excel
Which one is right? Am I going insane or is there somwthing really wrong here?
Last edited by a moderator: