9213 AM Tue Jun 28 Insert Draw Layout Review View Simple Regression Exercise 7 Value 50 points: The management of a soft drink bottling company wants to develop a method of allocating delivery costs to customers. Although the costs are clearly related to time travel on a given route, another variable cost reects the time required to unload the boxes of soda at the delivery point. A representative sample of the delivery routes has been chosen with the delivery time and the number of boxes delivered being recorded. 1. Develop the regression model to predict the delivery time based on the number of boxes delivered. 2. From the first exercise, make the table explained in class with all the values and using the linear regression formula to obtain the equation of the line. Then this same exercise corroborates through Excel and performs: the Pearson correlation coefcient, the dispersion diagram, determination coefficient r and establishes the data analysis. 3. In exercise 3 you do everything without the manual table. 4. The value of this nal work is 50 points. 5. Explain the correlation of the exercises. >18%I 9213 AM Tue Jun 28 Exercise 1 Insert Draw Layout Review View Clients Number of boxes Due Date (Minutes) Y 32 X 2 4 6 11 33 12 13 l4 15 >18%I 18% 9:13 AM Tue Jun 28 Home Insert Draw Layout Review View Q Trabajo final regresion copy Times New Roman 12 B I U aA v AV v Exercise 2 Clients Number of boxes Due Date (Minutes) X Y 2 4 3 6 N N 4 8 6 38 39 0 00 41 10 40 8 46 9 13 50 10 14 52 E 15 45 12 16 54 13 14 60 14 17 64 15 18 68