Data Set Exercise

Can you help me understand this Statistics question?

Data Set Exercise – Each Data Set Exercise is worth 20 points
Use the Data Sets found in Appendix A in the back of your book 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 $450.70 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.

However if you use and have access to Minitab, SPSS, or JMP you can use these software tools to solve the business statistics exercises in the text.

Submit the completed Assignment to your Faculty Mentor. Make sure to label the files correctly.

Assignment Outcomes

Identify and perform appropriate statistical tests for independent and dependent samples.

Calculate best linear unbiased estimators for simple and multiple regression models with and without the software programs

Construct and test a multiple regression model using a data set.

Understand that statistics are value neutral, but can be used to support discriminatory and biased value positions.