What is the adjusted R-squared of the regression?

Question

From a multiple regression analysis of stock market data, the following ANOVA table output was obtained from EXCEL.
df SS MS F
Regression 2 97.21 48.605 12.72186
Residual 17 64.95 3.820588
Total 19 162.16

Answer 1

First you need R-squared

R-Squared = 1 - SS(E)/SS(T) = 1- 64.95/162.16 = .40053

Adjusted = 1 - (1-R-squared)(n-1)/(n-p-1)
So a stab at this is = 1 - (.40053)(19)/17 = 0.552348

You need to check my n-1 and n-p-1, but the idea is there