Homework Help is Here – Start Your Trial Now!
Math
Statistics
2. The manager of the 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:

2. The manager of the 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:

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)
Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)
6th Edition
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Bruce Crauder, Benny Evans, Alan Noell
Chapter5: A Survey Of Other Common Functions
Section5.3: Modeling Data With Power Functions
Problem 6E: Urban Travel Times Population of cities and driving times are related, as shown in the accompanying...
See similar textbooks
icon
Related questions
Question
2. The manager of the 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: Maintenance Cost Miles Driven Car Age (years) (Pesos) 16,320 7 36000 15,100 8. 42000 18,500 8. 54600 10,200 3 27000 9,175 3 19500 12,770 7 34500 8,600 26250 7,900 27000
Transcribed Image Text:2. The manager of the 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: Maintenance Cost Miles Driven Car Age (years) (Pesos) 16,320 7 36000 15,100 8. 42000 18,500 8. 54600 10,200 3 27000 9,175 3 19500 12,770 7 34500 8,600 26250 7,900 27000
a. Using Excel, develop a multiple regression equation for these data. (Answer should be handwritten). b. What is the coefficient of determination for this regression equation? (Answer should be handwritten). c. What is the increase in the annual maintenance of the police cars when the car's age remained constant? (Solution should be handwritten). d. What is the increase in the annual maintenance of the police cars when miles are driven stay the same? (Solution should be handwritten). e. Forecast the annual maintenance cost for a police car that is 5 years old and will be driven 10,000 miles in 1 year. (Solution should be handwritten). f. Attach the summary output of the excel.
Transcribed Image Text:a. Using Excel, develop a multiple regression equation for these data. (Answer should be handwritten). b. What is the coefficient of determination for this regression equation? (Answer should be handwritten). c. What is the increase in the annual maintenance of the police cars when the car's age remained constant? (Solution should be handwritten). d. What is the increase in the annual maintenance of the police cars when miles are driven stay the same? (Solution should be handwritten). e. Forecast the annual maintenance cost for a police car that is 5 years old and will be driven 10,000 miles in 1 year. (Solution should be handwritten). f. Attach the summary output of the excel.
Expert Solution
steps

Step by step

Solved in 5 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer