RSQ for multiple regression?

[Anna Turton]

Hi I wonder if anyone can help me. Ive just compelted a multiple regression
using the LINEST function using an array however i need to find RSQ but im
not sure how to do this? I no how to do this for just one independent
variable but nor for multiple variables? Thanks

 

[Mike Middleton]

Anna Turton -

If the fourth argument of LINEST, Stats, is TRUE, then array-entered LINEST
returns multiple r-squared in the third row of the first column. Of course,
in order to see it, you must select at least three rows before
array-entering the LINEST function. See Excel's Help.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel