Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Decision Makers

Authors: Peter Atrill

9th Edition

1292311436, 978-1292311432

More Books

Students also viewed these Finance questions

Question

=+21.1. Prove ( e-ux2 /2 dx =1-1/2. ,00 12 T = 00

Answered: 1 week ago

Question

Describe the nature of negative messages.

Answered: 1 week ago