Question
Each box of one brand of breakfast cereal contains a coupon entitling purchasers to a free package of vegetable seeds. At the home office, they
Each box of one brand of breakfast cereal contains a coupon entitling purchasers to a free package of vegetable seeds. At the home office, they use the weight of the incoming mail to determine the number of employees to be assigned to collecting coupons and sending out seed packages each day. (The company policy is that all mail received will be answered the same day.) Following is the data for a random sample of 8 days: (15 points)
Weight of mail (pounds) 11 20 16 6 12 18 23 25
Number of employees 6 10 9 5 8 14 13 16
a. Draw a scatter diagram for the data and discuss its shape.
b. Using Excel conduct the following regression modules for the data:
I. Linear
II. Quadratic
III. Third degree polynomial
IV. Exponential
V. Logarithmic
VI. Power
c. Determine which model is the best and state the reason for your choice.
d. What percentage of the variation in the number of employees is explained by the regression model chosen?
e. If the company receives 15 pounds of mail, how many employees should be assigned for mail duty?
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