Data Set Exercise

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 Baseball 2012 data, which reports information on the 30 Major League Baseball teams for the 2012 season. Set up three variables:

• Divide the teams into two groups, those that had a winning season and those that did not. That is, create a variable to count the teams that won 81 games or more, and those that won 80 or less.

• Create a new variable for attendance, using three categories: attendance less than 2.0 million, attendance of 2.0 million up to 3.0 million, and attendance of 3.0 million or more.

• Create a variable that shows the teams that play in a stadium less than 15 years old versus one that is 15 years old or more.

Answer the following questions.

a. Create a table that shows the number of teams with a winning season versus those with a losing season by the three categories of attendance. If a team is selected at random, compute the following probabilities:

1. The team had a winning season.

2. The team had a winning season or attendance of more than 3.0 million.

3. The team had a winning season given attendance was more than 3.0 million.

4. The team has a winning season and attracted fewer than 2.0 million fans.

b. Create a table that shows the number of teams with a winning season versus those that play in new or old stadiums. If a team is selected at random, compute the following probabilities:

1. Selecting a team with a winning season.

2. The likelihood of selecting a team with a winning record and playing in a new stadium.

3. The team had a winning record or played in a new stadium.

2. Refer to the Baseball 2012 data. Compute the mean number of home runs per game. To do this, first find the mean number of home runs per team for 2012. Next, divide this value by 162 (a season comprises 162 games). Then multiply by 2 because there are two teams in each game. Use the Poisson distribution to estimate the number of home runs that will be hit in a game. Find the probability that:

a. There are no home runs in a game.

b. There are two home runs in a game.

c. There are at least four home runs in a game.

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.