Solution
A)
The value of slope b1
a.1.103933
B) The value of Correlation Coefficient r
c. 0.928717
C) The value of constant bo
b. 18.16292
12. (9 Points) Using the Regression Computer Output to the right, find/calculate: SUMMARY OUTPUT Regression Statistics...
Dep.= % WRK Indep.= % MGT SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Significance df SS MS F F Regression 102.1488 148.9539 Residual Total 12.0000 Standard Coefficients Error t Stat P-value Lower 95% Upper 95% Intercept % MGT 0.4543 SE CI CI PI PI Predicted Predicted Lower Upper Lower Upper x0 Value Value 95% 95% 95% 95% 67.0000 67.8474 65.8779 69.8169 72.0000 70.1189 68.2003 72.0375 76.0000 71.9361 69.7884 74.0838 Dep.= % MGT...
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...
5- Interpret the coefficient of determination (R-squared) and the F test. SUMMARY OUTPUT Regression Statistics Multiple R 0.8811 R Square 0.7764 Adjusted R Square 0.7205 Standard Error 14.7724 Observations 16 ANOVA df SS MS F Regression 3 9091.7392 3030.5797 13.8874 Residual 12 2618.7008 218.2251 Total 15 11710.44 Coefficients Standard Error t Stat P-value Intercept 29.1385 174.7427 0.1668 0.8703 PFH -2.1236 0.3405 -6.2361 0.0000 PR 1.0345 0.4667 2.2164 0.0467 M 3.0871 0.9993 3.0892 0.0094
Table 4.1 SUMMARY OUTPUT Regression Statistics Multiple R 0.99794806 R Square Missing Adjusted R Square 0.99513164 Standard Error 1.64839211 Observations 20 ANOVA df SS MS F Significance F Regression Missing 10561.07486 Missing 1295.585 2.66E-19 Residual 16 43.47514498 2.717197 Total 19 10604.55 Coefficients Standard Error t Stat P-Value Intercept 0.562 1.327 0.424 0.677 X1 0.959 0.038 25.245 0.000 X2 1.117 0.125 8.916 0.000 X3 1.460 0.066 22.185 0.000 Consider the output shown in Table...
4- Indicate if the estimates are statistically significant at 0.1%, 1%, 5% or 10%. Regression summary output using Excel is as follows. SUMMARY OUTPUT Regression Statistics Multiple R 0.8811 R Square 0.7764 Adjusted R Square 0.7205 Standard Error 14.7724 Observations 16 ANOVA df SS MS F Regression 3 9091.7392 3030.5797 13.8874 Residual 12 2618.7008 218.2251 Total 15 11710.44 Coefficients Standard Error t Stat P-value Intercept 29.1385 174.7427 0.1668 0.8703 PFH -2.1236 0.3405 -6.2361 0.0000 PR 1.0345 0.4667 2.2164 0.0467 M...
SUMMARY OUTPUT Regression Statistics Multiple R 0.818616296 R Square 0.67013264 Adjusted R Square 0.658351663 Standard Error 9.16867179 Observations 30 ANOVA df SS MS F Significance F Regression 1 4781.80995 4781.80995 56.8826 3.2455E-08 Residual 28 2353.807187 84.06454239 Total 29 7135.617137 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 28.21496731 3.739591617 7.544932763 3.22E-08 20.55476114 35.87517349 Dividend 2.367177613 0.313863719 7.542055589 3.25E-08 1.724256931 3.010098296 c. You run a regression analysis using Data Analysis to answer the following question: Is stock selling...
Figure 2 Regression Output SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.921261 0.848722 0.8055 0.711125 10 ANOVA Significance MS 0.001347 Regression Residual Total 19.86011 9.930053 19.63628 3.539894 0.505699 23.4 Standard Error Upper 95% Coefficients 0.20018 2.211198 0.07185 tStat P-value Lower 95% Intercept Size (cubic Metres) Weight (00's kg 2.19481 1.794453 0.676122 3.270412 0.013667 0.612423 3.809974 0.47295 0.329255 0.84353 -0.23731 0.819212 0.169626 0.42356 0.684594 (a)Based on the above regression output, interpret the regression coefficients...
Based on the below data what will be the value of mse? Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 8 ANOVA df SS MS F Regression 1 23 23.0 11.5 Residual 6 12 2.0 Total 7 Coefficients Standard Error t Stat P-value Intercept 20 31.274666 3.984284 0.007248 Advertising (thousands of $) 41 6.19330674 1.610802 0.158349
7,10,11
Based on the following regression output, what is the equation of the regression line? Regression Statistics Multiple R 0.917214 R Square 0.841282 Adjusted R Square 0.821442 Standard Error 9.385572 Observations 10 ANOVA df SS MS Significance F 1 Regression 3735.3060 3735.30600 42.40379 0.000186 8 Residual 704.7117 88.08896 9 Total 4440.0170 Coefficients Standard Error t Stat P-value Lower 95% Intercept 31.623780 10.442970 3.028236 0.016353 7.542233 X Variable 1.131661 0.173786 6.511819 0.000186 0.730910 o a. 9; = 7.542233+0.7309 Xli o b....
QUESTION 6 SUMMARY OUTPUT Regression Statistics Multiple R 0.90 R Squared 0.80 Adjusted Rsq 0.79 Standard Error 82.06 Observations 19.00 ANOVA df SS MS Regression 1 467247.5 467247.5 Residual 17 114466.2 6733.3 Total 18 581713.7 Coefficients St Error t Stat Intercept 756.26 30.41 24.87 Age -10.27 1.23 -8.33 This output was obtained from data on the age of houses (in years) and the associated amount paid in rates ($). Predict the rates paid (in dollars correct to two decimal places)...