Forecast model for annual maintenance costs

Assignment Help Basic Statistics
Reference no: EM13957074

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.

Reference no: EM13957074

Questions Cloud

Is paul a risk avoider, a risk taker, or risk neutral : Compare the result in part c with the decision using the expected value approach.
Write paper on riordan manufacturing project management plan : Write a paper on Riordan Manufacturing Project Management Plan.
What mass will now balance the bags : In an experiment, five identical bags of rice are balanced by a 10 kg mass. Two bags of rice are added to the other five. What mass will now balance the bags?
How much additional work must you do to fully compress : You are loading a spring loaded dart gun and do an amount of work W such that the spring is only 1/3 compressed. How much additional work must you do to fully compress it from 1/3 to fully compressed? Answer in terms of W.
Forecast model for annual maintenance costs : 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 car..
Develop a performance management framework to recommend : Develop a performance management framework to recommend to the client. You'll need to make sure you address the following: Alignment of the performance management framework to the organizational business strategy.
What is the average force of the bat on the ball : An incoming 0.14 kg baseball has a speed of 45 m/s. The batter hits the ball, giving it a speed of 60 m/s. If the contact time is 0.040 s, what is the average force of the bat on the ball?
Is this an appropriate way to make this decision : Complete the table above so that you can show the Jackson's what their expected payoff is.
Cost per item-number of items : Scenario: Regression equations are created by modeling data, such as the following: Sales = (Cost Per Item - Number of Items) - Constant Charges

Reviews

Write a Review

Basic Statistics Questions & Answers

  A histogram showing the different responses from five

a histogram showing the different responses from five groups of government employees is used in a report to emphasize

  Describe a fictional two-group experiment that could be

describe a fictional two-group experiment that could be tested with an independent t-test but violates the assumption

  A market survey was conducted to estimate the proportion of

question a market survey was conducted to estimate the proportion of homemakers in ontario who would recognize the

  Weather and ground operations

Airlines monitor the causes of flights arriving late. 75% of flights are late because of weather, 35% of flights are late because of ground operations. 10% of flights are late because of weather and ground operations.

  Develop a 95 confidence interval estimate of the mean

a survey conducted by the american automobile association showed that a family of four spends an average of 215.60

  Scatter diagram-sample correlation-coefficient determination

What does the coefficient of determination tell you about the variation attendance and the variation in the number of exhibitors?

  Find the mean and the median of the number of items

Find the mean and the median of the number of items. Find the range and the standard deviation of the number of items.

  Importance of time series analysis

Importance of time series analysis -Subject : Basic Statistics and Grade Level : Post Graduate Level

  Difference in two population proportions and means

Which of the given signifies difference in two population proportions?

  Can not answer because the test statistics also depends on

suppose we are testing the hypotheses h0 ? 100 and ha?lt 100. suppose the population variance is unknown. which sample

  Write out the multiple regression equation

Thompson Machine Works purchased several new, highly sophisticated machines. The production department needed some guidance with respect to qualifications needed by an operator. Four variables were listed.

  Identify the unacceptable rate of defects

Estimate the probability of rejecting a batch if the supplier is manufacturing the bolts with a defect rate of 10%. Is this monitoring plan likely to identify the unacceptable rate of defects?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd