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) Use SPSS or Excel to DEVELOP scatter plot for this data. , use the Insert Menu for the scatterplot

and Add Trend Line for the regression line. For additional help, see the website: http://www.excel-

easy.com/examples/scatter-chart.html

b) Obtain the correlation for these two variables, display the regression line and the equation on the

chart. Copy and paste the chart into your Word file.

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? Justifyyou

answer using the results of parts a, b, and c.

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

Perform a 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. For additional help see the website http://www.excel-easy.com/examples/scatter-chart.html

b) A correlationmeasure r. Hint, use the Excel function CORREL

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

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

e) A discussion that explains how well body fat works as a predictor of BMI