Question

Do your work in an Excel file. Make Excel do the test statistic calculation.!!!!!!!!!

Do people generally receive the asking price when they sell their home? The accompanying table lists the asking price and sale price for a random sample of ten single-family home sales in Tahlequah, 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 whether there is a significant difference between the asking price and the selling price.

Answer 1

The test can be performed by setting data analysis under data after entering data in excel sheet. after that we need tp select the test which we wantn to perform.

Here, after performing the test, we can find that p value is 0.916595311039667 > 0.05. So we will accept the null hypothesis. And thus, in this case, there is no significant difference between the asking price and the selling price.