+ Reply to Thread
Results 1 to 1 of 1

Thread: Regression analysis in MS Excel

  1. #1
    Points: 4, Level: 1
    Level completed: 7%, Points required for next Level: 46

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Regression analysis in MS Excel




    I have a very simple model, in which Y is the average of three variables (A, B and C).

    Now I would like to know how much of the variance in Y is explained by A, by B and by C (obviously, the sum should be 100%). Anyone who knows how you can get this in MS Excel?

    In attachment the data. Or here: http://oi65.tinypic.com/2zp5ikn.jpg.
    Attached Images  

+ Reply to Thread

           




Posting Permissions

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






Advertise on Talk Stats