EDIT ANSWER TO THE FOLLOWING QUESTION IN WORD (SEE SAMPLE MODEL ANSWER AND ANSWER IN EXCEL) I NEED ANSWER TO BE CORRECT AND CONSOLIDATED INTO THE WORD FORMAT.
Use the Data Sets Appendix A (see attached) to complete the following exercises.
1. Refer to the Buena School District bus data. Information provided by manufacturers of school buses suggests the mean maintenance cost per month is $455 per bus. Use statistical software to find the mean and the standard deviation for the Buena buses. Does the Buena data seem to be in line with that reported by the manufacturer? Specifically, what is the probability of the sample mean being less than Buena’s, given the manufacturer’s data?
2. Refer to the Buena School District bus data.
a. Develop a 95% confidence interval for the mean bus maintenance.
b. Develop a 95% confidence interval for the mean bus miles.
c. Write a business memo to the state transportation official to report your results.
3. Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 season. Assume the 2012 data represents a sample.
a. Develop a 95% confidence interval for the mean number of home runs per team.
b. Develop a 95% confidence interval for the mean number of errors committed by each team.
c. Develop a 95% confidence interval for the mean number of stolen bases for each team.
The software that is recommended to complete these exercises is MegaStat for Microsoft Excel. This was developed by J.B. Orris and is a full-featured Excel add-in that is available at www.mhhe.com/megastat. It will work with Excel 2003, 2007, and 2010. After you access the website you have 10 days to successfully download MegaStat on your local computer. Once installed, MegaStat will remain active in Excel with no expiration date or time limitations. The software performs statistical analysis within an Excel workbook. It does basic functions, such as descriptive statics, frequency distribution, and probability calculations as well as hypothesis testing, ANOVA, and regression. Screencam tutorials are included that provide a walkthrough of major business statistics topics. Help files are built in, and an introductory user’s manual is also included.
Papers are written from scratch We have molded our writers to develop content for all assignments from scratch. This way, we promote originality and reduce cases of plagiarism that might affect your grades and hinder you from realizing your academic goals. We encourage our clients to indicate the deliverables that should be featured in the final paper. Our online help services allow one to make a clarification and even interact with the writer directly to help them understand the needs of the assignment. Many of our writers are professional tutors who understand the approaches that should be used to fulfill the specified instructions. Every time a client places an order on our system, we link them with the most qualified writer in the subject of interest.
YUnlike other writing companies, we encourage clients to draw back their money at any stage of the writing process if they experience any uncertainties with the quality of generated content. However, you will hardly have to make this decision because of our business approach that suits your needs.
We have an advanced plagiarism-detection system that flags any work that fails to meet the required academic expectations. Our company thrives in honesty, and as such, you will be guaranteed to achieve a paper that meets your expectations.
We encourage our clients to return papers for revision seven days after the last submission for free. Depending on the proposed changes, we will work on your article to achieve the desired expectations.
We uphold confidentiality and privacy through our interactions with clients, an aspect that has enhanced our relationship with prospective customers seeking for assignment help. We do not disclose your information with third-parties
We boast of a diverse pool of ENL and ESL professionals who respond with a personal touch to the needs of every client. Our focus is to become the best platform that offers specialized services to individuals to accomplish their academic goals.