Question

In: Statistics and Probability

PART B The following output was obtained from a regression analysis of the dependent variable Rating...

PART B

  1. The following output was obtained from a regression analysis of the dependent

variable Rating and an independent variable Price. (10 points)

ANOVA

df                          SS                      MS               F

Regression             1                      372.707              372.707      42.927

Residual                15                     130.234                8.682

Total                        16                     502.941

Coefficients       Standard Error          t Stat        P-value

Intercept             45.623                   3.630                 12.569        0.000

Price                    0.107                    0.016                  6.552         0.000

  1. Use the critical value approach to perform an F test for the significance of the linear relationship between Rating and Price at the 0.05 level of significance.
  2. Calculate the coefficient of determination.
  3. What percentage of the variability of Rating can be explained by its linear

relationship with Price? What is the sample correlation coefficient?

  1. What is the estimated regression equation?
  2. Use the p-value approach to perform a t test for the significance of the linear relationship between Price and Rating at the 0.05 level of significance.

Solutions

Expert Solution


Related Solutions

The following output was obtained from a regression analysis of the dependent variable Rating and an...
The following output was obtained from a regression analysis of the dependent variable Rating and an independent variable Price. (10 points) ANOVA df SS MS F Regression 1 372.707 372.707 42.927 Residual 15 130.234 8.682 Total 16 502.941 Coefficients Standard Error t Stat P-value Intercept 45.623 3.630 12.569 0.000 Price 0.107 0.016 6.552 0.000 Use the critical value approach to perform an F test for the significance of the linear relationship between Rating and Price at the 0.05 level of...
The following output was obtained from a regression analysis of the dependent variable Sales volume and...
The following output was obtained from a regression analysis of the dependent variable Sales volume and an independent variable “location distance from the downtown branch.       ANOVA df SS MS F Regression 2 552.137 267.069 24.235 Residual 10 110.22 11.02 Total 12 662.357 Coefficients Standard Error t Stat P-value Intercept -38.623 3.630 12.569 0.000 Location distance 0.309 0.016 6.552 0.000 Calculate and interpret the correlation coefficient. What does it tell us? (1.5 marks) Calculate and interpret the coefficient of determination. (1.5...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.617 2.998 2.541 0.010 x1 0.224 0.069 3.246 0.000 x2 ? 1.144 0.559 ? 2.047 0.028 x3 ? 0.071 0.120 ? 0.592 0.114 x4 0.675 0.354 1.907 0.001 x5 ? 0.057 0.025 ? 2.280 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,113.40 422.7...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.617 2.998 2.541 0.010 x1 0.224 0.069 3.246 0.000 x2 ? 1.144 0.559 ? 2.047 0.028 x3 ? 0.071 0.120 ? 0.592 0.114 x4 0.675 0.354 1.907 0.001 x5 ? 0.057 0.025 ? 2.280 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,113.40 422.7...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.131 3.085 2.312 0.010 x1 0.203 0.170 1.194 0.000 x2 − 1.176 0.553 − 2.127 0.028 x3 − 0.089 0.311 − 0.286 0.114 x4 0.682 0.381 1.790 0.001 x5 − 0.030 0.025 − 1.200 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,946.79 389.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE T P-vaule Constant 7.096 3.245 2.187 0.010 x1 0.222 0.117 1.897 0.000 x2 -1.024 0.562 -1.822 0.028 x3 -0.337 0.192 -1.755 0.114 x4 0.623 0.263 2.369 0.001 x5 -0.056 0.029 -2.000 0.112 Analysis of Variance Source DF SS MS F P-Value Regression 5 2009.28 401.9 7.33 0.000 Residual Error 50 2741.54 54.83...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.166 3.075 2.330 0.010 x1 0.228 0.302 0.755 0.000 x2 − 1.184 0.586 − 2.020 0.028 x3 − 0.193 0.110 − 1.755 0.114 x4 0.572 0.293 1.952 0.001 x5 − 0.056 0.022 − 2.545 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,847.24 369.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.166 3.075 2.330 0.010 x1 0.228 0.302 0.755 0.000 x2 − 1.184 0.586 − 2.020 0.028 x3 − 0.193 0.110 − 1.755 0.114 x4 0.572 0.293 1.952 0.001 x5 − 0.056 0.022 − 2.545 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,847.24 369.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.131 3.085 2.312 0.010 x1 0.203 0.170 1.194 0.000 x2 − 1.176 0.553 − 2.127 0.028 x3 − 0.089 0.311 − 0.286 0.114 x4 0.682 0.381 1.790 0.001 x5 − 0.030 0.025 − 1.200 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,946.79 389.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars.    Predictor Coef SE Coef T     Constant 10.237 3.447 2.97 X1 0.392 -0.209 -1.88 X2 -0.392 -0.099 3.96 X3 0.207 -0.110 -1.88 X4 0.794 0.201 3.95 X5 -0.335 -0.126 2.66      Analysis of Variance   Source DF SS MS F   Regression 5 3710.00 742.00 15.14   Residual Error 48 2647.38 57.55   Total 53 6357.38    X1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT