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
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
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
Tools > Data Analysis > Regression ...
What doesn't add up? That's all I did to get the same CORREL and RSQ. Are you looking at something else?
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
You could achieve the same educational effect in 15 Kb, just listing the steps you take and the buttons you click.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks