The manager of the Medicine Hat 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 km in one year.

Transcribed Image Text:

Car Age Maintenance Cost ($) Km Driven (years) $1120 14,320 15,100 1610 1545 17,415 9370 3 900 7230 650 12,045 1500 8100 550 6300 3 730 2. en