- Watch. Free Plagiarism Che.. Movieruiz | Watch B... M Gmail Youtube 2/4 - 100% + Part I: Conduct a Test of Variance 1. The following data represent the 2016 team salary, in millions of dollars, for the 30 Major League Baseball teams, classified by league: American League Teams Team Salary National League Teams Team Salary Baltimore Orioles 115.6 Arizona Diamondbacks 70.8 Boston Red Sox 182.2 Atlanta Braves 87.6 Chicago White Sox 98.7 Chicago Cubs 116.7 Cleveland Indians 86.3 Cincinnati Reds 116.7 Detroit Tigers 172.3 Colorado Rockies 98.3 Houston Astros 69.1 Los Angeles Dodgers 223.4 Kansas City Royals 112.9 Miami Marlins 84.6 Los Angeles Angels 146.5 Milwaukee Brewers 98.7 Minnesota Twins 108.3 New York Mets 99.6 New York Yankees 213.5 Philadelphia Phillies 133.1 Oakland Athletics 80.3 Pittsburgh Pirates 85.9 Seattle Mariners 122.7 San Diego Padres 126.4 Tampa Bay Rays 73.7 San Francisco Giants 166.5 Texas Rangers 144.3 St. Louis Cardinals 120.3 Toronto Blue Jays 112.9 Washington Nationals 166.0 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: Ho: Of S ON (The subscript A stands for American League and the N stands for National League.) HI: 04 > ON To answer the question, complete the following steps: (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). (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). (c) Click on the Data tab. 11:19 PM 412/2/2022 Search(c) Click on the Data tab. (d) Click on Data Analysis (far right of the menu). (e) In the Data Analysis window, click on F-Test Two-Sample for Variances. Click OK. (f) In Variable 1 Range, enter Al: A16. (g) In Variable 2 Range, enter B1:B16. (h) Check Labels. (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 "Reject the null hypothesis." If F