# The US Department of Housing and Urban Development provides data to show the fair market monthly rent for metropolitan areas. The  data in cells E1 to J4 show the fair market monthly rent (\$) in 2005 for one-bedroom, two-bedroom, and three-bedroom apartments for five metropolitan areas.      At the .05 level of significance test whether the mean fair market rent is the same for each metropolitan area and state your conclusion. Place your output in cell A5.      BostonMiamiSan DiegoSan JoseWashingtonOne Bedroom107777597511071045Two Bedrooms1266929118313131187Three Bedrooms15131204172518891537

Question
Asked Dec 7, 2019
1 views
 The US Department of Housing and Urban Development provides data to show the fair market monthly rent for metropolitan areas. The  data in cells E1 to J4 show the fair market monthly rent (\$) in 2005 for one-bedroom, two-bedroom, and three-bedroom apartments for five metropolitan areas. At the .05 level of significance test whether the mean fair market rent is the same for each metropolitan area and state your conclusion. Place your output in cell A5. Boston Miami San Diego San Jose Washington One Bedroom 1077 775 975 1107 1045 Two Bedrooms 1266 929 1183 1313 1187 Three Bedrooms 1513 1204 1725 1889 1537
check_circle

Step 1

Null Hypothesis:

The mean fair market rent is same for each metropolitan area and state.

Alternative Hypothesis:

The mean fair market rent is not same for each metropolitan area and state.

Enter the given data in EXCEL sheet as shown below:

Step 2

Step-by-step procedure to obtain the ANOVA using EXCEL:

• Go to Data > Data analysis > ANOVA: Single Factor.
• Select the input range of the data as “\$A\$1:\$E\$4”.
• Select Labels in first row.
• E...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in