1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Linear regression. How to calculate this problem

  1. May 6, 2013 #1
    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. jcsd
  3. May 6, 2013 #2
    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.
     
  4. May 6, 2013 #3
    O no! of course. thank you very much
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted



Similar Discussions: Linear regression. How to calculate this problem
  1. Calculator problem (Replies: 2)

  2. Linear Regression (Replies: 1)

Loading...