For all Models, Calculate Adjusted R^2 =
1-(1-R^2)*((n-1)/(n-m-1)), n
- number of data
points, m - number of independent variables in the model (meanwhile m = 1
in all our models)
Calculating R^2 for Test Data. Add additional expressions
to the
Straight Table for Test Data.
R^2 = 1-SSE/SST
The linear correlation coefficient (Pearson) measures the
strength and the direction of a linear relationship between two
variables. Correlation coefficient has value between -1 (strong negative
correlation) and 1 (strong positive correlation).
Create Text Objects with the following Value:
='Correlation AGST vs Price ' & Num(Correl(Price, AGST))