Question

The end-of-year report for last year indicated the average sell price for houses in Las Cruces is $190,000. A realtor wants to conduct an experiment to show that the house sell price has increased this year compared to last year. He randomly selected 35 houses that are sold this year, and the data is provided in the Excel file provided.

1. Make a boxplot on the house sell price, and identify if there are outliers observed from the data. Attach the boxplot here.

2. Take out the outliers (simply delete the outlier data). There is no other information provided for the study, which hypothesis test will be appropriate to address the research question? (z test or t test)

3. Use Excel to conduct the hypothesis test. Attach the Excel output here, then write the 5-step procedure of the test below. (Don’t forget to create the dummy variable before choosing the “t test: Two-Sample Assuming Unequal Variances”)

4. Based on your conclusion of part (3), what type of error could you possibly make? (type I or Type II)

Answer 1

Please provide the excel data to solve the question.

It is not possible without it.

Thank you