Output using excel :
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.97691069 | |||||
R Square | 0.95435451 | |||||
Adjusted R Square | 0.94783372 | |||||
Standard Error | 2.29204977 | |||||
Observations | 25 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 3 | 2306.637 | 768.8789 | 146.3558 | 3.11E-14 | |
Residual | 21 | 110.3233 | 5.253492 | |||
Total | 24 | 2416.96 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | -3.5292365 | 8.110462 | -0.43515 | 0.667896 | -20.3959 | 13.33739 |
Calls | 0.18649539 | 0.061442 | 3.035305 | 0.006292 | 0.05872 | 0.314271 |
Driven | 0.00654214 | 0.003295 | 1.98522 | 0.060334 | -0.00031 | 0.013395 |
x1x2 | -0.00001791 | 2.2E-05 | -0.81431 | 0.424607 | -6.4E-05 | 2.78E-05 |
Regression equation:
Commissions = (-3.529) + (0.186) Calls + (0.007) Miles + (0.00002) x1x2
----
Coefficients | Standard Error | t Stat | P-value | |
Intercept | -3.529 | 8.110 | -0.435 | 0.668 |
Calls | 0.186 | 0.061 | 3.035 | 0.006 |
Miles | 0.007 | 0.003 | 1.985 | 0.060 |
x1x2 | 0.000018 | 0.000022 | -0.814 | 0.425 |
Value of test statistic: -0.814
As p-value > 0.05, we reject the null hypothesis. There is no significant interaction between the number of calls and the miles driven.
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The...
Hello, I need a little help figuring out the answer to this homework problem. Can someone help me? I'm struggling with each question, (fill in the blank need answers and drop down questions as well). Below are the drop down options for answering At the .05 significance level is there a significant interaction between the number of sales calls and the miles driven? Significant or not significant ...... is no interaction or is interaction Exercise 14-10 (LO14-1, L014-6) Cincinnati Paint...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
please help Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected...