** 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 ad1c9bdddf
** 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.
a) The null and alternative hypothesis are
Ho: μ1 = μ2 = μ3
H1: At ...
This solution illustrates a testing of a hypothesis problem using an analysis of variance (ANOVA) test.