A shipping company is attempting to determine how its shipping costs for a month

A shipping company is attempting to determine how its shipping costs for a month depend on the number of units shipped during a month. The number of units shipped and total shipping cost for the last 15 months are given in the file P12_ 63. xlsx.a. Determine a relationship between units shipped and monthly shipping cost.b. Plot the errors for the predictions in order of time sequence. Is there any unusual pattern?c. It turns out that there was a trucking strike during months 11 through 15 and you believe that this might have influenced shipping costs. How can the answer to part a be modified to account for the effect of the strike? After accounting for this effect does the unusual pattern in part b disappear?
1
300
106002
400
138003
500
164004
200
74005
300
106006
350
119007
460
152008
480
158009
120
540010
760
2420011
580
2200012
340
1470013
120
790014
100
720015
500
19600 Page
Month
Units
CostThis is fictitious data.

Attachments: