126k views
0 votes
The exercise involving data in this and subsequent sections were designed to be solved using Excel. Consider the following estimated regression equation, based on 10 observations. y^ = 29.1270 + .5906x1 + .4980x2 The values of SST and SSR are 6724.125 and 6216.375, respectively. Find SSE (to 2 decimals). Compute R2 (to 3 decimals). Compute Ra2 (to 3 decimals). How good is the fit provided by the estimated regression equation?

2 Answers

3 votes

Answer:

SSE = 507.75

R² = 0.924

Ra² = 0.812

Explanation:

The estimated regression equation is given by

y = 29.1270 + 0.5906x₁ + 0.4980x₂

Find SSE

The total sum of squares is given by

SST = SSR + SSE

Where SSR is the sum of squares due to regression and SSE is sum of squares due to error

SSE = SST - SSR

SSE = 6724.125 - 6216.375

SSE = 507.75

Compute R²

The Coefficient of determination is given by

R² = SSR/SST

R² = 6216.375/6724.125

R² = 0.924

Compute Ra²

The adjusted coefficient of determination is given by

Ra² = 1 - ((1 - R²)(N - 1)/(N - P - 1))

Where N is the total number of samples and P is the number of predictors

Ra² = 1 - ((1 - 0.924²)(10 - 1)/(10 - 2 - 1))

Ra² = 0.812

How good is the fit provided by the estimated regression equation?

The coefficient of determination can provide a good insight about the fitness of estimated regression equation.

A higher value of R² indicates a good fit on the other hand a lower value of Ra² also indicates a good fit. Since we have got a high value of R² and low value of Ra², we can conclude that that it is a good fit.

User Nickhil
by
8.3k points
3 votes

Answer:

Explanation:

SSE= 6724.125 - 6216.375 = 507.75

R2 = 6216.375/6724.125 = 0.924

Ra2 = 0.924 - (1 - 0.924)*

(2/(10-2-1)) = 0.902

92.4% of variations y around its mean are explained by x1 and x2 together

User Chitrank Dixit
by
7.8k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Categories