# Statistic Assignment

**Statistic Assignment**

**ORDER A PLAGIARISM FREE PAPER NOW**

Complete the problems below from the textbook. You will need to use the “Baseball 2016 Data,” “Lincolnville School District Bus Data,” and the “Century National Bank Data” files for this assignment.

- Chapter 11 – Problem 14
- Chapter 11 – Problem 41
- Chapter 11 – Problem 48
- Chapter 11 – Problem 49
- Chapter 12 Case A – Century National Bank

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.**

- The null and alternate hypotheses are:H0: μ1 ≤ μ2H1: μ1 > μ2 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.

- Refer to the Baseball 2016 data, which report information on the 30 Major League Baseball teams for the 2016 season.
- At the .05 significance level, can we conclude that there is a difference in the mean salary of teams in the American League versus teams in the National League?
- 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?
- 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? At the .05 significance level, is there a difference in the mean attendance for the two groups?
- Refer to the Lincolnville 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.

- Century National Bank Refer to the description of Century National Bank on page 129 at the end of the Review of Chapters 1–4. With many other options available, customers no longer let their money sit in a checking account. For many years the mean checking balance has been $1,600. Do the sample data indicate that the mean account balance has declined from this value? Recent years have also seen an increase in the use of ATM machines. When Mr. Selig took over the bank, the mean number of transactions per month per customer was 8; now he believes it has increased to more than 10. In fact, the advertising agency that prepares TV commercials for Century would like to use this on the new commercial being designed. Is there sufficient evidence to conclude that the mean number of transactions per customer is more than 10 per month? Could the advertising agency say the mean is more than 9 per month? The bank has branch offices in four different cities: Cincinnati, Ohio; Atlanta, Georgia; Louisville, Kentucky; and Erie, Pennsylvania. Mr. Selig would like to know whether there is a difference in the mean checking ac-count balances among the four branches. If there are differences, between which branches do these differences occur?