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

Expert Answer

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:

help_outline

Image Transcriptionclose

1 Boston Miami San Diego San jose Washington 2 1077 775 975 1107 1045 929 1313 1187 3 1266 1183 1725 1513 1204 1889 1537 4 5.

fullscreen
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...
help_outline

Image Transcriptionclose

Anova: Single Factor SUMMARY Count Groups Sum Average Variance Boston 3 3856 1285.333333 47804.33333 Miami 3 2908 969.3333333 47230.33333 San Diego 3 3883 1294.333333 149921.3333 San jose 3 4309 1436.333333 164289.3333 Washington 3 3769 1256.333333 64121.33333 ANOVA Source of Variation F crit df P-value MS Between Groups 350202 87550.5 0.924764101 0.487119575 3.478049691 Within Groups 946733.3333 10 94673.33333 Total 1296935.333 14

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Math

Statistics

Hypothesis Testing

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: You oversee the marketing department for a US based company.  The company has decided to expand into...

A: It is given that the percentage of access method strategies in the United States and Canada.

question_answer

Q: 44) Which of the following assumptions is not made for the F-test for comparing three 44) more means...

A: 44) Assumptions for F-test for comparing three or more means: All treatments or groups have similar ...

question_answer

Q: The graph of the discrete probability to the right represents the number of live births by a mother ...

A: Given probability distribution is as follows:   

question_answer

Q: From a sample with n 36, the mean duration of a geyser's eruptions is 3.72 minutes and the standard ...

A: Given information:n = 36Mean duration = 3.72Standard deviation = 0.98Upper limit = 6.66Lower limit =...

question_answer

Q: 47) A researcher is comparing 4 data values altogether. The degrees of freedom for the Between (dfB)...

A: 47) From the given information, the researcher is comparing 4 groups and there are 64 data values. T...

question_answer

Q: In the digital age of marketing, special care must be taken to make sure that programmatic ads appea...

A: Null Hypothesis:All the population means are equal.Alternative Hypothesis:At least two population me...

question_answer

Q: what does the mean and the standard deviation represent in data set? how would i interpret the Z-sco...

A: Mean and standard deviation in data set:The mean represent the average value in a data set. In other...

question_answer

Q: the area to the right of z=-2.26 is

A: The normal distribution:A continuous random variable X is said to follow normal distribution with me...

question_answer

Q: Use the traditional method to test the given hypothesis. Assume that the samples are independent and...

A: We are given:Of 1000 people who said that they attend a religious service at least once a week, 31 s...