The fleet manager of a trucking company is trying to improve his pricing policy and has been investigating the amount spent on gasoline.

The fleet manager of a trucking company is trying to improve his pricing policy and has been

investigating the amount spent on gasoline. He would like to determine if there is a linear relationship

between the weight of a loaded truck and gas mileage. The following information was collected where x

is the weight of a loaded vehicle in hundreds of pounds and y is the miles per gallon.

x 26 35 29 39 20

y 22.0 16.1 18.8 15.7 23.4

a) SPSS or Excel to scatter plot for this data. , the Insert Menu for the scatterplot

and Add Trend Line for the regression line.  

b) get the correlation for these two variables, show the regression line and the equation on the

chart.

c) If the weight of a vehicle is 32, what do you predict the gas mileage will be?

d) Should there be a gasoline surcharge for vehicles that weigh more than 3200 pounds? Justify 

using the findings of parts a, b, and c.

2. In Problem 3 of Part 2, there are two data sets consisting of BMI and percent body fat.

regression analysis to see if body fat percentage is a good predictor of BMI. Use SPSS or Excel

and be sure to include the following:

a) A scatterplot. , use the Insert Menu for the scatterplot and Add Trend Line for the regression

line.

b) A correlation measure r. , use Excel function CORREL

c) The graph of the regression line on the scatterplot , Add a trend line to the Scatterplot

d) The regression equation. , include the equation option when adding the trend line

e) state how well body fat works as a predictor of BMI