Hello I need in SPSS when possible please This has been answ

Hello

I need in SPSS when possible please, This has been answered on Chegg but may used excel instead of SPSS.

Shipping Costs

The staff of a grocery products manufacturer is developing a model for the production and distribution of its cereal products. The model requires transportation costs for a very large number of origins and destinations. It is impractical to do the detailed tariff analysis for every possible combination, so a random sample of 50 routes is selected. For each route, the mileage and the shipping rate (in dollars per 100 pounds) are found. The data are in a file named shipping costs.sav.

Graph the data. Does it appear that shipping rate can be predicted by mileage?

Find the equation of a straight line that describes how shipping rate varies with mileage.

Test the null hypothesis that shipping rate is unaffected by mileage. State your conclusion.

What is the effect of each additional mile on the shipping rate? Give a 95% confidence interval estimate.

One of the staff members objects that the equation doesn’t make sense. If the mileage is zero, then shipping rates should also be zero, she reasons. Give an explanation why the intercept of the equation is not zero.

Test the null hypothesis that the intercept is zero in the population of all routes, i.e., that the reason that the intercept is not zero for this sample is just sampling error. State your conclusion.

What is the mean shipping rate for routes that are 300 miles long? Give a 95% confidence interval.

One possible route is 350 miles long. Give an estimate of its shipping rate, using a 95% confidence interval.

Here is the data:

50   12.7
60   13.0
80   13.7
80   14.1
90   14.6
90   14.1
100   15.6
100   14.9
100   14.5
110   15.3
110   15.5
110   15.9
120   16.4
120   11.1
120   16.0
120   15.8
130   16.0
130   16.7
140   17.2
150   17.5
170   18.6
190   19.3
200   20.4
230   21.8
260   24.7
300   24.7
330   18.0
340   27.1
370   28.2
400   30.6
440   31.8
440   32.4
480   34.5
510   35.0
540   36.3
600   41.4
650   46.4
700   45.8
720   46.6
760   48.0
800   51.7
810   50.2
850   53.6
920   57.9
960   56.1
1050   58.7
1200   75.8
1650   89.0
300  
350  

Solution