Confederate Express is attempting to determine how its monthly shipping costs depend on the number o

Confederate Express is attempting to determine how its monthly shipping costs depend on the number of units shipped during a month. The file P11_48.xlsx contains the number of units shipped and total shipping costs for the last 15 months.a.Use regression to determine a relationship between units shipped and monthly shipping costs.b.Plot the errors for the predictions in order of time sequence. Is there any unusual pattern?c.You have now been told that there was a trucking strike during months 11 through 15, and you believe that this might have influenced shipping costs. How can the analysis in part a be modified to account for the effects of the strike? After accounting for the effects of the strike, does the unusual pattern in part b disappear?Month123456789101112131415 Units300400500200300350460480120760580340120100500 Cost$10,600$13,800$16,400$7,400$10,600$11,900$15,200$15,800$5,400$24,200$22,000$14,700$7,900$7,200$19,600 This isis fictitiousfictitious data.data.This