Sale price ($k)

Number of bedroom

Size (sq ft)

Distance from City centre (km)

Number of Bath room

Refer to the Real Estate dataset, which reports information on homes sold in the Denver, Colorado, area during 2020.

263.1

4

2,300

17

2

182.4

4

2,100

19

2

1. Select 10 homes using a sampling method. Calculate mean and standard deviation. Repeat 5 times. Which method did you use , why and how?

242.1

3

2,300

12

2

2.Create a sampling probability distribution for selling price of your 5 samples.

213.6

2

2,200

16

2.5

139.9

2

2,100

28

1.5

3. What is the proability of your sampling distribution mean to be more or less than population mean? Is it equal or not? Why or why not?

245.4

2

2,100

12

2

327.2

6

2,500

15

2

Use excel functions to calculate mean, standard deviation for relevant variables

271.8

2

2,100

9

2.5

plese provide answer in excel sheet

221.1

3

2,300

18

1.5

266.6

4

2,400

13

2

292.4

4

2,100

14

2

209.2

1

1700

8

1

270.8

6

2,500

7

2

246.1

4

2,100

18

2

194.4

2

2,300

11

2

281.3

3

2,100

16

2

172.7

4

2,200

16

2

207.5

5

2,300

21

2.5

198.9

3

2,200

10

2

209.3

6

1,900

15

2

252.3

4

2,600

8

2

192.9

4

1,900

14

2.5

209.3

5

2,100

20

1.5

345.3

8

2,600

9

2

326.3

6

2,100

11

3

173.1

2

2,200

21

1.5

257.2

2

2,100

9

2

180.4

2

2,000

11

2

182.7

4

2,000

14

2.5

312.1

6

2,600

7

2.5

199.8

3

2,100

19

2

273.2

5

2,200

16

3

192.6

6

2,200

14

2

236.4

5

2,200

20

2

172.4

3

2,200

23

2

251.4

3

1,900

12

2

236.8

4

2,600

17

2

164.1

4

2,300

19

2

217.8

3

2,500

12

2

192.2

2

2,400

16

2.5