2. The following table shows a sample of the expense ratios for different types of stock...

Transcribed Image Text:

2. The following table shows a sample of the expense ratios for different types of stock funds. Use a 95% ANOVA test using Excel to see if the mean expense ratios for all types of stock funds are the same. Be sure to show the appropriate Ho and Ha along with your conclusion. Print your Excel spreadsheet for this problem, attach it to your problem set and save this for future reference. Mid-Cap Funds Small-Cap Funds Hybrid Funds Specialty Funds 1.3 2.0 2.0 1.3 1.6 1.4 2.4 2.6 1.0 1.5 1.5 2.9 1.3 1.8 1.5 2.3 1.3 1.6 2.3 1.6 1.7 2.2 1.8 1.5 1.4 1.9 .09 1.9 1.3 1.5 1.4 1.9 1.3 1.4 1.4 2.1 1.7 1.8 .08 .09 2. The following table shows a sample of the expense ratios for different types of stock funds. Use a 95% ANOVA test using Excel to see if the mean expense ratios for all types of stock funds are the same. Be sure to show the appropriate Ho and Ha along with your conclusion. Print your Excel spreadsheet for this problem, attach it to your problem set and save this for future reference. Mid-Cap Funds Small-Cap Funds Hybrid Funds Specialty Funds 1.3 2.0 2.0 1.3 1.6 1.4 2.4 2.6 1.0 1.5 1.5 2.9 1.3 1.8 1.5 2.3 1.3 1.6 2.3 1.6 1.7 2.2 1.8 1.5 1.4 1.9 .09 1.9 1.3 1.5 1.4 1.9 1.3 1.4 1.4 2.1 1.7 1.8 .08 .09