Question
Regression Statistics Multiple R 0.945118787 R Square 0.893249521 Adjusted R Square 0.857666028 Standard Error 330.4090747 Observations 5 ANOVA df SS MS F Significance F Regression
Regression Statistics | ||||||||
Multiple R | 0.945118787 | |||||||
R Square | 0.893249521 | |||||||
Adjusted R Square | 0.857666028 | |||||||
Standard Error | 330.4090747 | |||||||
Observations | 5 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 2740489.53 | 2740489.53 | 25.10291836 | 0.015305995 | |||
Residual | 3 | 327510.47 | 109170.1567 | |||||
Total | 4 | 3068000 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 2649.464867 | 603.2802742 | 4.391764459 | 0.021872547 | 729.5577876 | 4569.371947 | 729.5577876 | 4569.371947 |
X Variable 1 | 0.798510935 | 0.159374473 | 5.010281266 | 0.015305995 | 0.291310233 | 1.305711637 | 0.291310233 | 1.305711637 |
Required:
Please round all answers to the nearest penny.
Copy of
Goofy Moving Company documented the miles driven and total moving van costs for the past five months as follows:
| Number of miles | Total vehicle costs |
January | 3,000 | 4,800 |
February | 4,800 | 6,500 |
March | 3,750 | 6,100 |
April | 2,250 | 4,000 |
May | 3,000 | 6,000 |
|
|
|
In order to budget total vehicle costs for the upcoming summer months, Reliable wishes to estimate total vehicle costs. Regression output:
PELASE SHOW ALL WORK
B. Using the regression output, determine the estimated total vehicle costs if the company expects to drive 9,000 miles in June.
C. Why are the answers to A & B different? Why would a manager choose one equation over another?
D. How accurate is the model calculated in equation B?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started