SOS Statistics Multiple Linear Regression Help....Please help at testing the model!

[Qianglong]

I used excel to generate an ANOVA table for 100 individuals and their salary based on 4 variables such as company size, employee size, sales revenue and ROI.

I am wondering what is the right way to test the signifinance of the model? Do I use the F table and look at the F statistics generated by excel??

 

[Joony]

I knew how to do this 3 months ago , didn't want to remember anything after finishing Stats.

Test the signifinance with all the Rs and stuff? Then the F? then the P values?

 

[JayHu]

significance of the full model should be given by the f-statistic. (MSR/MSE) I've never used excel to do regression, post the anova table.

 

[zerocool1]

yes.. anova gives a F score and should give a sig value (this is a pvalue)