top of page
• StudentGuiders

# BA 303 - BUSINESS STATISTICS – Week 5: Learning Unit 2: Discussion 2: Chapter 7, Problem 46

46. For the data in the Excel file Freshman College Data.

A. Use ANOVA to determine whether significant differences exist in the mean retention rate for the different colleges over the four-year period.

B. Use ANOVA to determine if significant differences exist in the mean ACT scores among the different colleges.

C. Use ANOVA to determine if significant differences exist in the mean SAT scores among the different colleges.

46. For the data in the Excel file Freshman College Data.

A. Use ANOVA to determine whether significant differences exist in the mean retention rate for the different colleges over the four-year period.

Using ANOVA, we are trying to determine if there is any significant difference in mean retention rate of the different colleges. First, we set up our two hypotheses that we will be looking to prove.

H0= there is no significant differences in the mean retention rate for different colleges

H1= there is a significant difference in the mean retention rate for different colleges

We will assume that the level of significance is 0.05 and will reject the null hypothesis if the test statistic F is greater than the critical value for F. Using the ANOVA: single factor function in excel, we calculate the following data.

Based on this data, we see that the F statistic is 11.15 while the F critical value is 2.13 which means that the null hypothesis is rejected. This means that there is a significant difference in the mean retention rate for the different colleges over four years.

B. Use ANOVA to determine if significant differences exist in the mean ACT scores among the different colleges.

Using ANOVA, we are trying to determine if there is any significant difference in mean ACT scores of the different colleges. First, we set up our two hypotheses that we will be looking to prove.

H0= there is no significant differences in the mean ACT scores for different colleges

H1= there is a significant difference in the mean ACT scores for different colleges

We will assume that the level of significance is 0.05 and will reject the null hypothesis if the test statistic F is greater than the critical value for F. Using the ANOVA: single factor function in excel, we calculate the following data.

Based on this data, we see that the F statistic is 110.61 while the F critical value is 2.13 which means that the null hypothesis is rejected. This means that there is a significant difference in the mean ACT scores for the different colleges.

C. Use ANOVA to determine if significant differences exist in the mean SAT scores among the different colleges.

Using ANOVA, we are trying to determine if there is any significant difference in mean SAT scores of the different colleges. First, we set up our two hypotheses that we will be looking to prove.

H0= there is no significant differences in the mean SAT scores for different colleges

H1= there is a significant difference in the mean SAT scores for different colleges

We will assume that the level of significance is 0.05 and will reject the null hypothesis if the test statistic F is greater than the critical value for F. Using the ANOVA: single factor function in excel, we calculate the following data.

Based on this data, we see that the F statistic is 126.99 while the F critical value is 2.13 which means that the null hypothesis is rejected. This means that there is a significant difference in the mean ACT scores for the different colleges.

## Recent Posts

See All

The community health nurse is providing information to a COPD support group. The nurse shares information about the Air Quality Index (AQI) and encourages clients to review the information and plan th

When infusing pantoprazole, use a separate IV line, a pump, and an in-line filter. A brown wrapper and frequent vital signs are not needed. A client has gastroesophageal reflux disease (GERD). The pro

What is an example of a biological health risk? a. pesticides b. bacteria contaminated dirnking water c. loud machinery d. garden fertilizer b. bacteria contaminated drinking water Which would a

bottom of page