A large mail-order house believes that there is a linear relationship between the weight of the mail it receives and the number of orders to be filled. It would like to investigate this relationship in order to predict the number of orders to be filled based on the weight of the mail. From an operational perspective, knowledge of the number of orders to be filled will help in the planning of the order-fulfillment process. A sample of 15 mail shipments is selected within a range of 200 to 700 pounds. The results are as follows. Weight of Mail (Pounds) Orders to be Filled (In Thousands) 240 6.5 290 9.0 237 7.2 380 11.5 342 10.3 384 10.6 482 14.5 430 13.6 409 12.8 553 16.5 572 17.1 501 15.8 628 19.0 670 19.6 620 19.2 a. Construct a scatter plot using Excel. b. Assuming a linear relationship, determine the regression results by using Excel. What are the values for the regression coefficients b0 and b1 for this problem? c. Interpret the meaning of the slope, b1, in this problem.

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
icon
Concept explainers
Question
A large mail-order house believes that there is a linear relationship between the weight of the mail it receives and the number of orders to be filled. It would like to investigate this relationship in order to predict the number of orders to be filled based on the weight of the mail. From an operational perspective, knowledge of the number of orders to be filled will help in the planning of the order-fulfillment process. A sample of 15 mail shipments is selected within a range of 200 to 700 pounds. The results are as follows. Weight of Mail (Pounds) Orders to be Filled (In Thousands) 240 6.5 290 9.0 237 7.2 380 11.5 342 10.3 384 10.6 482 14.5 430 13.6 409 12.8 553 16.5 572 17.1 501 15.8 628 19.0 670 19.6 620 19.2 a. Construct a scatter plot using Excel. b. Assuming a linear relationship, determine the regression results by using Excel. What are the values for the regression coefficients b0 and b1 for this problem? c. Interpret the meaning of the slope, b1, in this problem. d. Predict the mean number of orders to be filled when the weight of the mail is 500 pounds. e. Determine the coefficient of determination r2 and interpret its meaning. f. Find the standard error of the estimate. g. At the 0.05 level of significance, is there evidence of a linear relationship between the weight of the mail and the number of orders to be filled? h. Construct a 95% confidence interval estimate of the population slope, β1, for this problem. i. How useful do you think this regression model is for predicting the number of orders to be filled? Why?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Deviation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education