Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A local transport company delivers food to local supermarkets. To develop better work schedules, the managers want to estimate the total daily amount of food

image text in transcribed
A local transport company delivers food to local supermarkets. To develop better work schedules, the managers want to estimate the total daily amount of food delivered by the drivers. Initially the managers believed that the total daily amount of food delivered would be closely related to the number of miles travelled in making the daily deliveries. Linear regression analysis is conducted to model the relationship between the dependent variable food delivered (y) and miles travelled (x) Scatterplot for food delivered (tonnes) vs. miles travelled food delivered (tonnes), y Driver ID Miles Travelled, x food delivered ONWAGONOUS * . .. (tonnes), y 1 100 9.3 50 4.8 100 8.9 20 10 60 80 100 120 100 6.5 Miles travelled, x 50 4.2 80 6.2 Normal Probability Plot 75 7.4 65 6 90 7 .6 90 6.1 85 7.4 food delivered (tonnes), y 62 6.4 98 8.4 58 1.9 73 5. 81 7.8 20 40 80 100 120 66 5.2 72 7.3 Sample Percentile 53 1.4 20 56 1.6 Miles travelled Residual Plot 1.5 T SUMMARY OUTPUT 15 + 0 Regression Statistics Residuals 05 4 20 40 80 100 120 Multiple R .845712116 R Square 0.715228983 Adjusted R Square 0.699408371 1.5 Standard Error 0.812698537 -2 Observations 20 Miles travelled, x ANOVA df SS MS ignificance F Regression 1 29.85937957 29.85937957 45.20867965 0.000002650 Residual 18 11.88862043 0.660478913 Total 19 41.748 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 1.146205652 0.825428616 1.388618748 0.181893905 -0.587955518 2.88036682 Miles Travelled (x) 0.071991946 0.010707128 6.723740005 0.000002650 0.049497105 0.09448679

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

Introductory Algebra

Authors: Alan S Tussy, Rosemary Karr, Marilyn Massey, Diane Koenig, R David Gustafson

5th Edition

1305161866, 9781305161863

More Books

Students also viewed these Mathematics questions

Question

Discuss how direct listings can be a good thing for investors.

Answered: 1 week ago