# ANOVA

** Please see the attached file for the data **

Thank you in advance.

In the attached file, named Savings Rate data to figure out the below is annotated. The .xls contains the yields for a money market account, a one-year certificate of deposit (CD), and a five-year CD for 23 banks in the metropolitan New York area, as of May 28, 2009.

a) At the 0.05 level of significance, is there evidence of a difference in the mean yields of the different accounts?

b) If appropriate, determine which accounts differ in mean yields.

c) At the 0.05 level of significance, is there evidence of a difference in the variation in the yields among the different accounts?

d) What effect does your result in (c) have on the validity of the results in (a) and (b)?

© BrainMass Inc. brainmass.com June 4, 2020, 2:30 am ad1c9bdddfhttps://brainmass.com/statistics/analysis-of-variance/anova-level-significance-462000

#### Solution Preview

** Please see the attachment for the complete solution. **

I have submitted the solution in Excel. If you need the solution in word file please message me.

Thanks.

Solution:

a) The null and alternative hypothesis are

Ho: μ1 = μ2 = μ3

H1: At ...

#### Solution Summary

This solution illustrates a testing of a hypothesis problem using an analysis of variance (ANOVA) test.