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 2number 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:Weight of Mail (pounds)11201661218 2325 Number of Employees61095814 1316 Draw a scatter diagram for the data and discuss its shape.Using Excel, conduct the following regression modules for the data:LinearQuadraticThird Degree PolynomialExponentialLogarithmicPowerDetermine which model is the best and state the reason for your choiceWhat percentage of the variation in the number of employees its explained by the regression model chosen?If the company receives 15 pounds of mail, how many employees should be assigned for mail duty?

Introduction: It is required to use Excel to identify the best model that fits the data.

Answered: Each box of one brand of breakfast…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

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 use the weight of the incoming mail to determine the 2number 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:

Weight of Mail (pounds)	11	20	16	6	12	18	23	25

Number of Employees	6	10	9	5	8	14	13	16

Draw a scatter diagram for the data and discuss its shape.
Using Excel, conduct the following regression modules for the data:
Linear
Quadratic
Third Degree Polynomial
Exponential
Logarithmic
Power
Determine which model is the best and state the reason for your choice
What percentage of the variation in the number of employees its explained by the regression model chosen?
If the company receives 15 pounds of mail, how many employees should be assigned for mail duty?