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

    0

    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:

                                                                                                                                      Order Now