Homework Help: Linear regression. How to calculate this problem

1. May 6, 2013

Drudge

1. The problem statement, all variables and given/known data
Why does excel give me this:

http://postimg.org/image/68b9z1lqt/ [Broken]

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/ [Broken]

2. Relevant 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

3. 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?
1. The problem statement, all variables and given/known data

2. Relevant equations

3. The attempt at a solution
1. The problem statement, all variables and given/known data

2. Relevant equations

3. The attempt at a solution

Last edited by a moderator: May 6, 2017
2. May 6, 2013

TheoMcCloskey

Drudge - I plugged the numbers into your suggested application (from www.alcula.com) and I get the Excel results. It looks like you switched the x and y data sets. Enter the x values first, then the y values, and you should get the Excel results.

3. May 6, 2013

Drudge

O no! of course. thank you very much