Sally Bird of Big Rapids Realty has received data on 60 houses that were recently sold in Mecosta County in Michigan. The data are recorded in the table shown below. Included in this data set are observations for each of the following variables:
· The appraised value of each house (in thousands of dollars)
· The selling price of each house (in thousands of dollars)
· The size of each house (in hundreds of square feet)
· The number of bedrooms in each house
-(A) Suppose that Sally wishes to examine a representative subset of these 60 houses that has been stratified by the number of bedrooms. Use Excel to assist her by finding such a stratified sample of size 10 with proportional sample sizes. (
B) Explain how Sally could apply cluster sampling in selecting a sample of size 15 from this frame. (
C) What are the advantages and disadvantages of employing cluster sampling in this case?

Question

Sally Bird of Big Rapids Realty has received data on 60 houses that were recently sold in Mecosta County in Michigan. The data are recorded in the table shown below. Included in this data set are observations for each of the following variables:
· The appraised value of each house (in thousands of dollars)
· The selling price of each house (in thousands of dollars)
· The size of each house (in hundreds of square feet)
· The number of bedrooms in each house 
-(A) Suppose that Sally wishes to examine a representative subset of these 60 houses that has been stratified by the number of bedrooms. Use Excel to assist her by finding such a stratified sample of size 10 with proportional sample sizes. ​ (
B) Explain how Sally could apply cluster sampling in selecting a sample of size 15 from this frame. ​ (
C) What are the advantages and disadvantages of employing cluster sampling in this case?

Quizplus · Accepted Answer

The Answer of Sally Bird of Big Rapids Realty has received data on 60 houses that were recently sold in Mecosta County in Michigan. The data are recorded in the table shown below. Included in this data set are observations for each of the following variables:
· The appraised value of each house (in thousands of dollars)
· The selling price of each house (in thousands of dollars)
· The size of each house (in hundreds of square feet)
· The number of bedrooms in each house 
-(A) Suppose that Sally wishes to examine a representative subset of these 60 houses that has been stratified by the number of bedrooms. Use Excel to assist her by finding such a stratified sample of size 10 with proportional sample sizes. ​ (
B) Explain how Sally could apply cluster sampling in selecting a sample of size 15 from this frame. ​ (
C) What are the advantages and disadvantages of employing cluster sampling in this case?

Sally Bird of Big Rapids Realty Has Received Data on 60