You should first check to see if the Data Analysis ToolPak is active on your computer. To do this, open a new Excel workbook and click on the Data tab. If you see Data Analysis on the far right of the ribbon, then the ToolPak is active and you can begin the project (directions begin on the next page). If you do not have Data Analysis, then you will need to activate the Data Analysis functions using the following directions:

1. Click on File.

2. Click on Options (at the end of the list).

3. Click on Add-Ins (left column, near end of list).

4. In the Inactive Applications, click on Analysis ToolPak.

5. Click on Go (at the bottom of the page).

6. In the Add-Ins window, check Analysis ToolPak. Click OK.

You are now ready to begin the project on the next page.

Directions for the Project: Part I: Conduct a Test of Variance

1. The following data represent the classified by league:

American League Teams Team Baltimore Orioles 115.6 Boston Red Sox 182.2 Chicago White Sox 98.7 Cleveland Indians 86.3 Detroit Tigers 172.3 Houston Astros 69.1 Kansas City Royals 112.9 Los Angeles Angels 146.5 Minnesota Twins 108.3 New York Yankees 213.5 Oakland Athletics 80.3 Seattle Mariners 122.7 Tampa Bay Rays 73.7 Texas Rangers 144.3 Toronto Blue Jays 112.9

2016 team salary, in millions of dollars, for the 30 Major League Baseball teams,

Salary

National League Teams Arizona Diamondbacks 70.8 Atlanta Braves 87.6 Chicago Cubs 116.7 Cincinnati Reds 116.7 Colorado Rockies 98.3 Los Angeles Dodgers 223.4 Miami Marlins 84.6 Milwaukee Brewers 98.7 New York Mets 99.6 Philadelphia Phillies 133.1 Pittsburgh Pirates 85.9 San Diego Padres 126.4 San Francisco Giants 166.5 St. Louis Cardinals 120.3 Washington Nationals 166.0

Team Salary

At the .05 significance level, is there more variation in the team salaries for the American League?

The null and alternate hypothesis are the following: H (The subscript A stands for American League and the N stands for National League.) H1:

To answer the question, complete the following steps:

1. (a) In row 1, column A of the Excel worksheet, type the label for the first set of data, American League. Do not type in the names of all of the teams. Below the label, in column A, type in the data (the team salaries).

2. (b) In row 1, column B, type the label for the second set of data, National League. Do not type the names of all of the teams. Below the label, in column B, type in the data (the team salaries).

3. (c) Click on the Data tab.

4. (d) Click on Data Analysis (far right of the menu).

5. (e) In the Data Analysis window, click on F-Test Two-Sample for Variances. Click OK.

6. (f) In Variable 1 Range, enter A1:A16.

7. (g) In Variable 2 Range, enter B1:B16.

8. (h) Check Labels.

9. (i) Check Output Range and enter D1. Click OK.

(j) To make your decision regarding the null hypothesis, compare the value of F to the value of F Critical one-tail. If

F > F-critical, then the decision is Reject the null hypothesis. If F < F-critical, then the decision is Do not reject

the null hypothesis. In a cell below the statistics, type your decision regarding the null hypothesis. (k) Based on the hypothesis that has been accepted, answer the question asked at the beginning of the problem. Type

your answer in a cell below your decision.

Part II: Conduct an ANOVA Test

The following data represent the number of games won by the 30 Major League Baseball teams in the 2016 season, classified by the teams total attendance: less than 2.0 million, 2.0 up to 3.0 million, and 3.0 million or more.

Less than 2.0 Chicago White Sox Cleveland Indians

Miami Marlins

Oakland Athletics Tampa Bay Rays Philadelphia Phillies Minnesota Twins Cincinnati Reds

Games Won 78

94 79 69 68 71 59 68 

2.0 up to 3.0 Baltimore Orioles

Boston Red Sox

Houston Astros

Texas Rangers

Milwaukee Brewers Arizona Diamondbacks Atlanta Braves

Colorado Rockies Detroit Tigers New York Mets

Kansas City Royals Pittsburgh Pirates

San Diego Padres

Washington Nationals Seattle Mariners

Games Won 89

93 84 95 73 69 68 75 86 87 81 78 68 95 86 

3.0 or more Chicago Cubs

Los Angeles Angels New York Yankees Toronto Blue Jays

Los Angeles Dodgers St. Louis Cardinals San Francisco Giants

Games Won 103

74 84 89 91 86 87 

At the .05 significance level, is there a difference in the mean number of games won among the three groups?

The null and alternate hypothesis are as follows: H0: 1 = 2 = 3

H1: At least one treatment mean is different.

To answer the question, click on the sheet 2 tab at the bottom of the worksheet to open a new worksheet and complete the following steps:

1. (a) In row 1, column A of the Excel worksheet, type the label for the first set of data, Less than 2.0. Do not type in

   the names of all of the teams. Below the label, in column A, type in the data (the games won).

2. (b) In row 1, column B, type the label for the second set of data, 2.0 up to 3.0. Do not type the names of all of the

   teams. Below the label, in column B, type in the data (the games won).

3. (c) In row 1, column C, type the label for the second set of data, 3.0 or more. Do not type the names of all of the teams. Below the label, in column C, type in the data (the games won).

4. (d) Click on the Data tab.

5. (e) Click on Data Analysis (far right of the menu).

6. (f) Scroll up and Click on Anova: Single Factor. Click OK.

7. (g) In Input Range, enter A1:C16.

8. (h) Check Labels in First Row.

9. (i) Click on Output Range and enter E1. Click OK. Note: Excel uses the term Between Groups for treatments andWithin Groups for error; however, they have the same meaning.

10. (j) To make your decision regarding the null hypothesis, compare the value of F to the value of F Critical one-tail. If F > F-critical, then the decision is Reject the null hypothesis. If F < F-critical, then the decision is Do not reject

    the null hypothesis. In a cell below the statistics, type your decision regarding the null hypothesis.

(k) Based on the hypothesis that has been accepted, answer the question asked at the beginning of the problem. Type

your answer in a cell below your decision.