1
$\begingroup$

The Financial Review wished to estimate the amount of annual government spending using tax revenue and level of nationwide debt. Data from 1958-2008 (inclusive) was used. All variables were measured in billions of dollars. It was found that the mean square error for the regression was 15 and the total sum of squares was 12200. Hence, what percentage of the variation in annual government spending is explained by the regression equation? Give your answer correct to two decimal places.

My Perspective:

Mean square of error (MSE) = 15
Total sum of squares (SST) = 12200 

The question is asking for R squared, so

$R^2 = SSR / SST$, but so far we only have $SST$. How do we derive $SSR$ from the $MSE$ in this case?

$\endgroup$
1
$\begingroup$

Think about how many degrees of freedom there must be (total, residual & regression). Then you can work backwards from the $MSE$ to get the missing $SS$s.

| cite | improve this answer | |
$\endgroup$
  • $\begingroup$ df in this case is unknown because we do not know how many variables there are? I believe for MSE, it is SSE/(n-k-1), where k is the number of independent variables and n is the total number of variables. n is unknown from this question. $\endgroup$ – Unistudent87 May 11 '13 at 15:44
  • $\begingroup$ If it were true that the df is unknowable, then the question is unanswerable. Since they want you to answer it, I infer that they believe the df can be figured out. From the problem description, I can guess how many variables are being used to predict amount of government spending & the number of of total data. $\endgroup$ – gung - Reinstate Monica May 11 '13 at 15:59
  • $\begingroup$ k = 2, since there is tax revenue and level of nationwide debt. But how do we find out what n is? $\endgroup$ – Unistudent87 May 11 '13 at 16:06
  • $\begingroup$ How many data points are there? I suspect the answer is in the problem statement. $\endgroup$ – gung - Reinstate Monica May 11 '13 at 16:10
  • $\begingroup$ Omg is it 2008-1958 = 50? Oh dear..is that it? $\endgroup$ – Unistudent87 May 11 '13 at 16:13
0
$\begingroup$

The question wants to find out R-sq

Rsq = Variance of Variables in the model/Total variance

Variance = MSE/df; hence df is required.

let n be number of years of observation =51. Let k be number of variables (treatments) in the model = 2 (tax revenue, natl debt)

Hence; SSTr = MSTr/treatment df = (12200-15)/(51-2)

And

Rsq = {(12200-15)/(51-2)}/(12200/51-1)

| cite | improve this answer | |
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.