Do your work in an Excel file. Make Excel do the teststatistic calculation.!!!!!!!!!
Do people generally receive the asking price when they selltheir home? The accompanying table lists the asking price and saleprice for a random sample of ten single-family home sales inTahlequah, OK.
Home | Asking price | Selling price |
1 | 98,000 | 94,300 |
2 | 122,500 | 119,800 |
3 | 109,900 | 105,000 |
4 | 98,000 | 100,000 |
5 | 79,900 | 77,000 |
6 | 275,000 | 265,000 |
7 | 99,700 | 96,000 |
8 | 97,900 | 99,200 |
9 | 209,000 | 209,000 |
10 | 173,900 | 169,000 |
Perform a hypothesis test with a = .05 to determine whetherthere is a significant difference between the asking price and theselling price.
