Problem 63 Page 734
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?
>Source
This is fictitious data. 00
, 00
00
, 00
00
,400
$10,600 , 00
,200
0
,700
Data
Month
Units
Cost
1
3
$
10
6
2
4
$
13
8
3
5
$16,400
4
200
$
7
5
300
6
350
$
11
9
7
460
$
15
8
480
$15,800
9
12
$5,400
10
760
$24,200
11
580
$22,000
12
340
$
14
13
120
$7,900
14
100
$7,200
15
500
$19,600