Complete the problems below from the textbook. You will need to use the "Baseball 2012 Data," "Buena School District Bus Data," and the "Century National Bank Data" files for this assignment.
For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.
Submit output in one Excel file.
You are not required to submit this assignment to Turnitin.
14. The null and alternate hypotheses are:H0: m1 # m2H1: m1 . m2 A random sample of 20 items from the first population showed a mean of 100 and a standard deviation of 15. A sample of 16 items for the second population showed a mean of 94 and a standard deviation of 8. Use the .05 significant level.
41. An investigation of the effectiveness of an antibacterial soap in reducing operating room con-tamination resulted in the accompanying table. The new soap was tested in a sample of eight operating rooms in the greater Seattle area during the last year. The following table reports the contamination levels before and after the use of the soap for each operating room.
Attached is screen shot
48. Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 season. a. At the .05 significance level, can we conclude that there is a difference in the mean sal-ary of teams in the American League versus teams in the National League? b. At the .05 significance level, can we conclude that there is a difference in the mean home attendance of teams in the American League versus teams in the National League? c. Compute the mean and the standard deviation of the number of wins for the 10 teams with the highest salaries. Do the same for the 10 teams with the lowest salaries. At the .05 significance level, is there a difference in the mean number of wins for the two groups?
49. Refer to the Buena School District bus data. Is there a difference in the mean maintenance cost for the diesel versus the gasoline buses? Use the .05 significance level.
Preview of Grand-Canyon-MBA-SYM-506-O1-Assignment-2016.xlsx