Regression Analysis
Not what you're looking for?
1. The manager of Erehwon police department motor pool wants to develop a forecast model for annual maintenance costs on police cars, based on mileage in the past year, and age of cars. The following data have been collected for eight different cars:
Miles Driven Car Age (yr.) Maintenance Cost ($)
16,320 7 1,200
15,100 8 1,400
18,500 8 1,820
10,200 3 900
9,175 3 650
12,770 7 1,150
8,600 2 875
7,900 3 900
a. Using Excel,develop a multiple regression equation for these data.
b. What is the coefficient of determination? What does it mean?
c. Forecast the annual maintenance cost for a police car that is 5 years old and will be driven 10,000 miles in 1 year.
Purchase this Solution
Solution Summary
This solution is comprised of a detailed explanation of various aspects of Regression Analysis as it pertains to the given problem. Supplemented with EXCEL output, this step-by-step explanation of this complicated topic provides students with a clear perspective of Regression Analysis.
Education
- MSc, Osmania University
- MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
- BSc, Banaras Hindu University
Recent Feedback
- "Very fast turnaround. Excellent communication! Much appreciated!"
- "excellent"
- "excellent"
- "excellent work"
- "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.