Question

In: Math

Shown below is a portion of a computer output for a regression analysis relating Y (demand)...

Shown below is a portion of a computer output for a regression analysis relating Y (demand) and X (unit price). ANOVA df SS Regression 1 Error 3132.661 Total 47 8181.479 Coefficients Standard Error Intercept 80.390 3.102 X -2.137 0.248 (a) Compute the coefficient of determination and fully interpret its meaning. Be very specific. (b) Find the standard error for b1 (Sb1). (c) Perform a t test and determine whether or not demand and unit price are related. Let  = 0.05. (d) Perform an F test and determine whether or not demand and unit price are related. Let  = 0.05

Solutions

Expert Solution

Solution

Preparatory Work

Let us first complete the ANOVA Table: [given figures in bold, others derived.]

Source of Variation

df

SS

MS

F

Fcrit

Regression

1

5048.818

5048.818

74.137

4.04

Error

46

3132.661

68.101

Total

47

8181.479

Explanations

df for Error = df for Total – df for Regression.

SS for Regression = SS for Total - SS for Error

MS = SS/df

F = MSR/MSE

Fcrit = upper 5% point of F1, 46

Other Details given

Intercept = 80.390 with standard error = 3.102 ......................................................................................... (1)

Slope coefficient, b = - 2.137 with standard error = 0.248 ........................................................................ (2)

Now, to work out the solution,

Part (a)

Coefficient of determination = SSR/SST

= 0.6171 Answer 1

Interpretation

Coefficient of determination, r2 represents the proportion of the variation in the response variable that is explained by the variation in the predictor variable. In the present scenario, 62% of the variation in demand is accounted for by unit price. Answer 2

Part (b)

Standard error for b1 = 0.248 [vide (2)] Answer 3

Part (c)

t- test to determine whether or not demand and unit price are related at a = 0.05. i.e., to test population correlation coefficient, ρ is zero or not.

Hypotheses:

Null: H0: ρ = 0 Vs Alternative H1: ρ ≠ 0

Test Statistic:

t = r√{(n - 2)/(1 – r2)}

= √(0.6171 x 46/0.3829) [df for SST in ANOVA = n - 1]

= 8.795

Distribution, Significance Level, α, Critical Value,

t ~ tn – 2

So, Critical Value = upper (α/2) % point of tn – 2 = t46, 0.025 = 2.015

Decision

H0 is rejected since | tcal | > tcrit

Conclusion:

There is sufficient evidence to suggest that the linear correlation between demand and price is significant and hence we conclude that demand and unit price are related. Answer 4

Part (d)

F test to determine whether or not demand and unit price are related, i.e., ANOVA

Referring to the ANOVA Table at the top, F > Fcrit.

So, we conclude demand and unit price are related. Answer 5

DONE


Related Solutions

Shown below is a portion of the computer output for a regression analysis relating sales (Y...
Shown below is a portion of the computer output for a regression analysis relating sales (Y in millions of dollars) and advertising expenditure (X in thousands of dollars). Predictor Coefficient Standard Error Constant 4.00 0.800 X -0.12 0.045          Analysis of Variance SOURCE DF SS Regression 1 1,400 Error 18 3,600 Please answer the following questions with showing all the steps needed.      a.  (8’) What has been the sample size for the above? Please explain how you obtain the answer using the...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1.   What is the estimated regression equation that relates Y to X? (2 Points) 2.   Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this question. (2...
Below you are given a partial computer output from a multiple regression analysis based on a...
Below you are given a partial computer output from a multiple regression analysis based on a sample of 16 observations. Coefficients Standard Error Constant 12.924 4.425 x1 -3.682 2.630 x2 45.216 12.560 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Mean Square F Regression 4853 2426.5 Error 485.3 ​ Carry out the test of significance for the variable x1 at the 1% level. The null hypothesis should be options: be tested for β₃ instead. be rejected....
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F Regression   60 Residual Total 19 140 Coefficients Standard Error Intercept 10.00 2.00 x1 -2.00 1.50 x2 6.00 2.00 x3 -4.00 1.00 a. Use the above results and write the regression equation. [4 Marks] b. Compute the coefficient of determination and fully interpret its meaning. [4 Marks] c. Is the regression model significant? Perform the test at let α = 0.05. [4 Marks] d. At...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F Regression   60 Residual Total 19 140 Coefficients Standard Error Intercept 10.00 2.00 x1 -2.00 1.50 x2 6.00 2.00 x3 -4.00 1.00 a. Use the above results and write the regression equation. [4 Marks] b. Compute the coefficient of determination and fully interpret its meaning. [4 Marks] c. Is the regression model significant? Perform the test at let α = 0.05. [4 Marks] d. At...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three independent variables. The three independent variables are price per unit (Price in $100s), advertising (ADV in $1,000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price -0.1524 0.1411 ADV 0.8849 0.2886 Lines -0.1463 1.5340 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Regression 2708.61 Error (Residuals) Required:...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three independent variables. The three independent variables are price per unit (Price in $100s), advertising (ADV in $1,000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price -0.1524 0.1411 ADV 0.8849 0.2886 Lines -0.1463 1.5340 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Regression 2708.61 Error (Residuals) Required:...
Below you are given a partial computer output based on a sample of 8 observations relating...
Below you are given a partial computer output based on a sample of 8 observations relating an independent variable ( x) and a dependent variable ( y). Coefficient Standard Error Intercept 13.251 10.77 x   0.803   0.385 ​ ANOVA SS Regression Error (Residual) 41.674 Total 71.875 ​ a. Develop the estimated regression equation. b. At α = .05, test for the significance of the slope. c. At α = .05, perform an F test. d. Determine the coefficient of determination.
Consider the set of ordered pairs shown below. Assuming that the regression equation is y with...
Consider the set of ordered pairs shown below. Assuming that the regression equation is y with caret=1.087+0.724x and the SSE=5.362​, construct a​ 90% prediction interval for x=1.     x 6 1 4 4 4 1     y 6 2 5 4 2 2 Calculate the upper and lower limits of the prediction interval. UPL= LPL=
Consider the set of ordered pairs shown below. Assuming that the regression equation is y with...
Consider the set of ordered pairs shown below. Assuming that the regression equation is y with caret=5.322-0.029x and the SSE=18.794​, construct a​ 95% prediction interval for x=6.     x 4 6 3 3 5    ------------------  y 6 7 4 7 2 Click the icon to view a portion of the​ student's t-distribution table. Calculate the upper and lower limits of the prediction interval. UPL= LPL=
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT