Solution :
From given that ,
Sample correlation coefficient
= -(SSR / SST)
= -(5048.818 / 8181.479)
= -0.7856
(minus because slope and r has the same sign )
BUSINESS STATISTICS Shown below is a portion of a computer output for a regression analysis relating...
Q 10: Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). Degrees of Freedom Regression 205 Residual 53.28 Total 341.33 SS Coefficients Standard Error t Stat p-value Intercept 53.90 6.7105 8.0379 0.001 Volume 4.06 0.8724 4.6505 0.009 the estimated regression equation that relates (Y) to (X)? ce the coefficient of determination between Y and X. e result.
Below you are given a partial computer output based on a sample of 21 observations, relating an independent variable (x) and a dependent variable (y). Coefficient Standard Error 1.181 Intercept 30.139 0.022 X -0.252 Analysis of Variance SOURCE SS Regression 1,759.481 259.186 Error Develop the estimated regression line At a 0.05, perform an F test. Determine the coefficient of determination. a. b. c. d. Determine the coefficient of correlation.
12. (9 Points) Using the Regression Computer Output to the right, find/calculate: SUMMARY OUTPUT Regression Statistics Multiple R 0.928717 R Square 0.862516 Adjusted R Square 0.835019 Standard Error 1.987885 Observations (A) The value of the Slope, b. ANOVA df 31.36785 a. 1.103933 b. 18.16292 c. 5.6007 d. 3.951685 e. 2.004566 Regression Residual Total SS MS 123.9559 123.9559 19.758433.951685 143.7143 Intercept Coefficients 18.16292 1.103933 Standard Error 2.004566 0.197106 t Stat 9.060773 5.6007 P-value 0.000274 0.002507 (B) The value of the Correlation...
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 7.032 0.184 t-Stat -1.3456 4.1793 Intercept Analysis of Variance SOURCE Regression Error (Residual) 400 138 a. Develop the estimated regression line. b. At a = 0.05, perform an F test. C. Determine the coefficient of determination.
A regression model relating x, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where n total=26. a. Write the estimated regression equation (to whole number). y=_____+_____x b. Compute the F statistic and test the significance of the relationship at a .05 level of significance. (to 2 decimals) F-value ____ p-value is _______, we _________ h0 c. Compute the...
Following a regression analysis output : SUMMARY OUTPUT Regression Statistics Multiple R 0.719422 R Square Adjusted R Square 0.477366 Standard Error Observations 14 ANOVA df SS MS F Regression 1 3.028885709 Residual 12 2.823257148 Total 13 5.852142857 Coefficients Standard Error t Stat P-value Intercept 1.157091 0.566482479 0.063699302 Satisfaction with Speed of Execution 0.636798 0.177478218 0.003726861 Group of answer choices R Square is 0.517 Standard error is 0.386 Residuals are 2.823 F-test is 11.87 R Square is 0.517 Standard error is...
Below you are given a partial computer output based on a sample of fifteen (15) observations. ANOVA df SS Regression 1 50.58 Residual Total 14 106.00 Coefficients Standard Error t Stat p-value Intercept 16.156 1.42 0.0000 Variable x -0.903 0.26 0.0000 The coefficient of determination is. 0.5228 0.4772 0.6535 0.3465
O 10 an relatin sile) and shown below is, Excel output for portion of analysis Y Celependent regression Cdependent vari Cinde pendent variable) х ANOVA df Regression 3338,312 Residual 1 2036.195 Total 9 14514.400 coefficients standad tstat P-value error Intercept 241.67 83.280 1.684 0.030 148.27 38-312 1.283 0.035 a) what is the estimated equation that relates y regression +o b) what is the estimated value of Y if x = 3.5? c) Compute the value of the coefficient determination and...
A regression model relating 2, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where Miotal = 30. 0 ANOVA 0 MSF Significance F SS 6361.5 Regression Residual Total 8844.6 P-value 85.0 5.418 Coefficients Standard Error Stat Intercept 10.553 Number of 43.0 Salespersons a. Write the estimated regression equation (to whole number). y= + b. Compute the F statistic...
A regression model relating number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where th =26. ANOVA SS MS F Significance F u Significance Regression Residual Total 8756.4 p-value 510 s.com Coefficients Standard Error Stat Intercept 7 7.0 10.723 Number of 5.609 Salespersons Write the estimated regression equation (to whole number). V= b. Compute the statistic and test the...