Question: Please view Parts 11 and 12 of your spreadsheet to complete this activity. This activity involves the partially completed ANOVA table in Part 12 of your spreadsheet and your state's sample size and sample mean of your trimmed set of prices found in Part 11 of your spreadsheet.


Let's say we want to test the hypothesis that there is no significant difference in the average selling prices of (all reasonably priced) homes for the states Alaska, Nevada, Rhode Island, South Dakota, Wyoming, and Your State that are advertised on forsalebyowner.com.

Here are the respective sample sizes that were taken for each of those states: 34, 40, 32, 30, 30, and your state’s sample size for the trimmed price data.

Here are the respective sample means that were reported for each of those states: $294241, $225860, $334,278, $249253, $355783, and your state’s sample mean for the trimmed prices.


Provide an appropriate response to each of the following.

1. State the null hypothesis and the alternative hypothesis.
2. Using a 0.05 level of significance, state the critical value(s).
3. In Part 12 of your state's spreadsheet, you will find a partially completed ANOVA table. It contains for this test of hypotheses, the Sum of Squares Within (also known as Sum of Squares Error) and the Sum of Squares Total. To calculate the test statistic's value, you need to first complete the rest of the ANOVA table by replacing the question marks with the correct values. As a response to this part of the activity, please state the following values:
   i) sum of squares between
   ii) d.f. between
   iii) d.f. within
   iv) d.f. total
   v) mean square between
   vi) mean square within
   vii) the test statistic value, F

Note: If you prefer, for part c, you can either state each of the above values without a table, or you can replace the question marks in the table below (copy and paste it into the text editor box) with the appropriate values, or copy and paste the table from your spreadsheet directly into the text box.

d) State your decision regarding H _o .(Do you reject H _o or do you fail to reject H _o ?)

e) Which of the following can you reasonably conclude:

 There is no significant difference in the average advertised selling prices of (reasonably priced) homes for sale in the states of Alaska, Nevada, Rhode Island, South Dakota, Wyoming, and 'Your State' that are advertised on forsalebyowner.com.

 There is a significant difference in at least one of the average advertised selling prices of (reasonably priced) homes for sale in the states of Alaska, Nevada, Rhode Island, South Dakota, Wyoming, and 'Your State' that are advertised on forsalebyowner.com from the other average advertised selling prices of homes for sale in those states.

 There is a significant difference in all of the average advertised selling prices of (reasonably priced) homes for sale in the states of Alaska, Nevada, Rhode Island, South Dakota, Wyoming, and 'Your State' that are advertised on forsalebyowner.com. In other words, each of those states has a mean advertised selling price that is significantly different from the other five states in this list.

Price: $2.99

Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document