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?

2

>Source

This is fictitious data.

Data

00

,

00

2

00

,

00

3

00

4

,400

5

$10,600

6

,

00

7

,200

8

9

0

10

11

12

,700

13

14

15

Month	Units	Cost
1		3		$	10	6
	4	$	13	8
	5	$16,400
200	$	7
300
350	$	11	9
460	$	15
480	$15,800
	12	$5,400
760	$24,200
580	$22,000
340	$	14
120	$7,900
100	$7,200
500	$19,600