The exercise involving data in this and subsequent sections were designed to be

Question

The exercise involving data in this and subsequent sections were designed to be solved using Excel The following estimated regression equation is based on 30 observations. = 18.2-4.0x1-2.3x2 + 7.4x3 + 2.9x4 The values of SST and SSR are 1,806 and 1,761, respectively. a. Compute R2 (to 3 decimals). b. Compute Ra (to 3 decimals). c. How good is the fit provided by the estimated regression equation? Select your answer- The estimated regression equation provided an excellent fit The estimated regression equation provided a moderately good fit The estimated regression equation did not provide a good fit

Explanation / Answer

Answer to the question here:

a. Rsquare = SSR/SST = 1761/1806 = .975

b. Rsquare adjusted = 1- (1-R^2)(N-1)/(N-p-1) = 1- (1-.975^2)*(30-1)/(30-4-1) = .943

c. Rsquare given the variance of DV explained by IV. Since Rsquare adj. is quiet high at .943, we can
conclude that the estimated regression equation provided an excelled fit

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---