Good day,

E\" 'E" Assignment 2 Part B - Regression . 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) Weightofmail (pounds) 11 20 16 s 12 18 23 25 Numberofemployees 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: I. Linear II. Quadratic III. Third degree polynomial IV. Exponential V. Logarithmic VI. Power Determine which model is the best and state the reason for your choice. . What percentage of the variation in the number of employees is explained by the regression model chosen? If the company receives 15 pounds of mail, how many employees should be assigned for mail duty? 5-7!\" '5' Assignment 2 Part C - Time Series and Non-Parametric Tests . The number of fishing rods selling each day is given below. Perform analyses of the time series to determine which model should be used for forecasting. (10 points) 3 day moving average analysis 4 day moving average analysis 3 day weighted moving average analysis with weights w1=0.2, w2=0.3 and w3=0.5 with w1 on the oldest data . exponential smoothing analysis with a = 0.3. Which model prevides a better fit of the data? Forecast day 13 sales of fishing rods using the model chosen in part {e}. Day Rods sold 1 60 2 70 3 110 4 80 5 7D 6 7 8 9 85 115 105 65 10 75 11 95 12 85