+ Reply to Thread
Results 1 to 9 of 9

Regression analysis does not add up :s

  1. #1
    Registered User
    Join Date
    03-02-2009
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    26

    Regression analysis does not add up :s

    Can someone explain to me why my regression won't add up to my raw data calculations?
    I've attached the file and supplied more info on the attachment

    any help would be much appreciated!

    thanks again
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Regression analysis does not add up :s

    I don't know how you got your summary output. When I do it, I get the same result for CORREL and RSQ as the worksheet formulas.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-02-2009
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Regression analysis does not add up :s

    Quote Originally Posted by shg View Post
    I don't know how you got your summary output. When I do it, I get the same result for CORREL and RSQ as the worksheet formulas.
    hey could you give me a very brief guide on how you calculated your regression then, as i've tried so many times without any luck

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Regression analysis does not add up :s

    Tools > Data Analysis > Regression ...

  5. #5
    Registered User
    Join Date
    03-02-2009
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Regression analysis does not add up :s

    Quote Originally Posted by shg View Post
    Tools > Data Analysis > Regression ...
    ah i've done that 100 times it just does not add up

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Regression analysis does not add up :s

    What doesn't add up? That's all I did to get the same CORREL and RSQ. Are you looking at something else?

  7. #7
    Registered User
    Join Date
    03-02-2009
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Regression analysis does not add up :s

    okay, I've uploaded a video here filming myself carrying out the regression analysis
    video size 11.27 Megs

    http://hotfile.com/dl/29429309/03fe8...42-72.avi.html

    file was to just a little to big to upload here i think

  8. #8
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Regression analysis does not add up :s

    You could achieve the same educational effect in 15 Kb, just listing the steps you take and the buttons you click.

  9. #9
    Registered User
    Join Date
    03-02-2009
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Regression analysis does not add up :s

    could some provide me with a step by step way of doing this, i've tried on 3 different computers running different excel versions and still it comes out wrong, so i'm obviously going wrong somewhere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1