The manager of the Salem police department motor pool wants to develop a forecast model for annual maintenance on police cars based on mileage in the past year and age of the cars. The following data have been collected for eight different cars:

a. Using Excel develop a multiple regression equation for these data.
b. What is the coefficient of determination for this regression equation?
c. Forecast the annual maintenance cost for a police car that is four years old and will be driven 10,000 miles in oneyear.

Transcribed Image Text:

Miles Driven Car Age (years) Maintenance CostI) 14,320 15,100 17415 9,370 7,230 12,045 8,100 6.300 $1120 1610 1545 900 650 1500 550 730