Confederate Express Service is attempting to determine how its shipping costs for a month depend on the number of units shipped during a month. For the last 15 months, the number of units shipped and...


Confederate Express Service is attempting to determine how its shipping costs for a month depend on the number of units shipped during a month. For the last 15 months, the number of units shipped and total shipping cost are given in Table (file Ship.xls).





























































































Units



Total



Month



Shipped



Shipping Cost



1



300



$1,060



2



400



$1,380



3



500



$1,640



4



200



$740



5



300



$1,060



6



350



$1,190



7



460



$1,520



8



480



$1,580



9



120



$540



10



760



$2,420



11



580



$2,200



12



340



$1,470



13



120



$790



14



100



$720



15



500



$1,960



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 We have been told that there was a trucking strike during months 11–15, and we believe that this may have influenced shipping costs. How could the answer to 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?



May 25, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here