Bardi Trucking Co., located in Cleveland, Ohio, makes deliveriesin the Great Lakes region, the Southeast, and the Northeast. JimBardi, the president, is studying the relationship between thedistance a shipment must travel and the length of time, in days, ittakes the shipment to arrive at its destination. To investigate,Mr. Bardi selected a random sample of 20 shipments made last month.Shipping distance is the independent variable and shipping time isthe dependent variable. The results are as follows:

Shipment	Distance (miles)	Shipping Time (days)	Shipment	Distance (miles)	Shipping Time (days)
1		808	3		11	618	4
2		622	12		12	634	13
3		618	8		13	667	7
4		786	8		14	638	6
5		776	9		15	844	15
6		838	3		16	783	14
7		620	6		17	756	9
8		751	11		18	840	10
9		780	11		19	754	13
10		649	7		20	742	15

Click here for the Excel Data File

1. Draw a scatter diagram. Based on these data, does it appear thatthere is a relationship between how many miles a shipment has to goand the time it takes to arrive at its destination?

1. On the graph below, use the point tool to plot the pointcorresponding to the first Distance and its Shipping Time (Distance1).

2. Repeat the process for the remainder of the sample (Distance 2,Distance 3, … ).

3. To enter exact coordinates, double-click on the point and enterthe exact coordinates of x and y.

1. b-1. Fill in the blanks. (Round youranswers to 3 decimal places. Negative values should be indicated byminus sign.)

x¯x¯
y¯y¯
Sx
Sy
r

1. b-2. State the decision rule for 0.05significance level: H₀: ρ ≤ 0;H₁: ρ > 0. (Round youranswer to 3 decimal places.)

1. b-3. Compute the value of the test statistic.(Negative value should be indicated by a minus sign. Roundyour answer to 3 decimal places.)

1. b-4. Can we conclude that there is a positivecorrelation between distance and time? Use the 0.05 significancelevel.

1. c-1. Determine the coefficient ofdetermination. (Round your answer to 3 decimalplaces.)

1. c-2. Fill in the blank below. (Roundyour answer to 1 decimal place.)

1. Determine the standard error of estimate. (Round youranswer to 3 decimal places.)

1. Would you recommend using the regression equation to predictshipping time?