A real estate agency conducts a study to determine if the median selling price of homes
in a particular neighborhood has changed since last year. Last year the median selling
price was $188,500. The agency randomly selects 20 recently sold homes in that
particular neighborhood and finds that 14 of the homes sold for more than $188,500 and
that 6 of the homes sold for less than $188,500. Use Excel to conduct the appropriate
hypothesis test at = .10.
The sponsors of televisions shows targeted at the market of 5 – 8 year olds want to test
the hypothesis that children watch television at most 20 hours per week. The population
of viewing hours per week is known to be normally distributed with a standard
deviation of 6 hours. A market research firm conducted a random sample of 30 children
in this age group. The resulting data follows:
At a .10 level of significance, use Excel to test the sponsors’ hypothesis.