There are five (5) parts to completing your managerial report worth ten (10) points each. You will be using Excel’s functions to summarize and compute your sample statistics. Your written report must be done in Word about 2-3 pages in length. This assignment tests your knowledge on how Ito compute and interpret the sample mean, variance, standard deviation, interval estimate of a population mean and other methods you’ve learned on how to organize and interpret your data. You must submit both your results in Excel and written report in Word
Metropolitan Research, Inc.
Metropolitan Research, Inc. a consumer research organization, conducts surveys designed to evaluate a wide variety of products and services available to consumers. In one particular study, Metropolitan looked at consumer satisfaction with the performance of automobiles produced by a major Detroit manufacturer. A questionnaire sent to owners of one of the manufacturer’s full-sized cars revealed several complaints about early transmission problems. To learn more about the transmission failures. Metropolitan used a sample of actual transmission repairs provided by a transmission repair firm in the Detroit area. The following data show the actual number of miles driven for 50 vehicles at the time of transmission failure.
85.092 32.609 59.465 77.437 32.534 64,090 32.464 59.902
39.323 89.641 94.219 116,803 92,857 63.436 65.605 85,861
64,342 61.978 67 998 59.817 101,769 95,774 121.352 69,568
74,276 66.998 40,001 72.069 25.066 77.098 69,922 35.662
74.425 67.202 118.444 53,500 79,294 64,544 86,813 116,269
37.831 89.341 73.341 85.288 138,114 53,402 85.586 82.256
1. Use appropriate descriptive statistics to summarize the transmission failure data.
2. Develop a 95% confidence interval for the mean number of miles driven until transmission failure for the population of automobiles with transmission failure. Provide a managerial interpretation of the interval estimate.
3. Discuss the implication of vour statistical findings in terms of the belief that some owners of the automobiles experienced early transmission failures
4. How many repair records should be sampled if the research firm wants the population mean number of miles driven until transmission failure to be estimated with a margin of error of 5000 miles? Use 95% confidence.
5. What other information would you like to gather to evaluate the transmission failure problem more fully?
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more