Case Study on Real Estate

profileVeerpal
Real_Estate.xlsx
Home>Mathematics homework help>Statistics homework help>Case Study on Real Estate

Sheet2

Row Labels Average of SalePrice Count of Pool StdDev of SalePrice
No 202763.157894737 38 33716.9731982287
Yes 225258.064516129 62 46371.9585574599
Grand Total 216710 100 43246.6020151709

RealEstate

House_No Bedrooms Size Age Pool Construction Garage Baths SalePrice Appraisal_1 Appraisal_2
1 4 2,349 8 No Brick Yes 2 263,000 237,000 249,000 Variable descriptions
2 4 2,102 7 Yes Wood No 2 182,000 164,000 156,000 Bedrooms = # of bedrooms
3 3 2,271 6 Yes Brick No 2 242,000 219,000 228,000 Size = square footage of home
4 2 2,188 6 Yes Stucco No 2.5 214,000 194,000 186,000 Age = age of home in years
5 2 2,148 10 Yes Stucco No 1.5 140,000 127,000 131,000 Pool = Yes or No
6 2 2,117 2 No Stucco Yes 2 245,000 223,000 216,000 Construction = Brick, Wood, Stucco
7 5 2,484 7 Yes Brick Yes 2 300,000 298,000 304,000 Garage = Yes or No
8 2 2,130 6 Yes Stucco Yes 2.5 272,000 249,000 244,000 Baths = # of baths
9 3 2,254 2 No Stucco No 1.5 221,000 202,000 204,000 SalePrice = Price in 2015
10 4 2,385 3 Yes Wood Yes 2 267,000 245,000 243,000 Appraisal_14 = 2014 Appraisal
11 4 2,108 4 Yes Brick Yes 2 292,000 269,000 282,000 Appraisal_15 = 2015 Appraisal
12 2 1,715 5 Yes Wood Yes 1.5 209,000 193,000 183,000
13 5 2,495 1 Yes Wood Yes 2 271,000 250,000 260,000
14 4 2,073 6 Yes Brick Yes 2 246,000 228,000 219,000
15 2 2,283 2 Yes Brick No 2 194,000 180,000 185,000
16 3 2,119 7 Yes Stucco Yes 2 281,000 261,000 253,000
17 4 2,189 2 No Brick No 2 173,000 161,000 164,000
18 5 2,316 1 No Wood No 2.5 207,000 193,000 189,000
19 3 2,220 5 No Wood Yes 2 199,000 186,000 188,000
20 5 1,901 4 No Wood Yes 2 209,000 196,000 194,000
21 4 2,624 8 Yes Wood Yes 2 252,000 237,000 249,000
22 4 1,938 4 No Stucco Yes 2.5 193,000 182,000 173,000
23 5 2,101 6 Yes Brick No 1.5 209,000 197,000 205,000
24 5 2,141 9 Yes Brick Yes 3 320,000 309,000 318,000
25 2 2,198 5 No Brick Yes 1.5 173,000 164,000 159,000
26 2 1,912 5 Yes Wood No 2 187,000 178,000 182,000
27 2 2,117 7 Yes Wood Yes 2 257,000 245,000 240,000
28 3 2,162 10 Yes Brick Yes 1.5 233,000 223,000 225,000
29 2 2,041 7 Yes Brick No 2 180,000 172,000 170,000
30 2 1,712 7 Yes Brick Yes 2 234,000 225,000 236,000
31 2 1,974 1 Yes Brick Yes 2 207,000 199,000 189,000
32 5 2,438 5 Yes Stucco Yes 2 248,000 239,000 249,000
33 3 2,019 7 No Stucco Yes 2 166,000 160,000 154,000
34 2 1,919 1 Yes Brick Yes 2 177,000 171,000 176,000
35 4 2,023 5 No Wood No 2.5 183,000 178,000 173,000
36 4 2,310 9 Yes Stucco No 2 216,000 210,000 214,000
37 5 2,639 4 Yes Brick Yes 2.5 312,000 304,000 298,000
38 3 2,069 5 Yes Brick Yes 2 200,000 195,000 197,000
39 5 2,182 9 Yes Stucco Yes 3 273,000 267,000 264,000
40 3 2,090 9 No Brick No 1.5 206,000 202,000 212,000
41 3 1,928 4 No Stucco Yes 1.5 232,000 228,000 217,000
42 4 2,056 7 No Stucco Yes 1.5 198,000 195,000 203,000
43 3 2,012 3 No Wood No 2 205,000 202,000 194,000
44 4 2,262 5 No Wood Yes 2 176,000 174,000 179,000
45 3 2,431 3 No Stucco Yes 3 308,000 305,000 296,000
46 5 2,217 2 Yes Brick Yes 3 269,000 267,000 272,000
47 3 2,157 4 Yes Stucco Yes 2.5 225,000 224,000 220,000
48 3 2,014 8 No Wood No 2 172,000 171,000 173,000
49 3 2,221 4 Yes Stucco Yes 2 217,000 217,000 215,000
50 5 2,236 8 No Stucco No 2 193,000 193,000 203,000
51 5 2,189 7 Yes Brick Yes 2 236,000 236,000 224,000
52 3 2,218 8 Yes Brick No 2 172,000 173,000 180,000
53 3 1,937 1 Yes Stucco Yes 2 251,000 253,000 243,000
54 5 2,296 6 Yes Brick Yes 3 246,000 248,000 255,000
55 5 1,749 9 No Stucco No 2 147,000 148,000 144,000
56 4 2,230 10 Yes Stucco Yes 2 176,000 178,000 182,000
57 3 2,263 10 Yes Brick Yes 1.5 228,000 231,000 226,000
58 3 1,593 9 No Brick No 2.5 166,000 169,000 171,000
59 4 2,221 10 Yes Stucco Yes 2 189,000 192,000 190,000
60 5 2,036 3 Yes Brick Yes 3 290,000 296,000 281,000
61 5 2,170 4 No Wood Yes 2.5 270,000 276,000 287,000
62 2 2,007 4 Yes Stucco No 2 154,000 158,000 152,000
63 2 2,054 7 Yes Brick Yes 2 222,000 228,000 235,000
64 5 2,247 5 No Stucco Yes 2 210,000 216,000 210,000
65 3 2,190 3 No Brick Yes 2 191,000 197,000 201,000
66 4 2,495 6 No Brick Yes 2 254,000 263,000 258,000
67 3 2,080 3 No Stucco No 2 207,000 214,000 216,000
68 4 2,210 7 No Stucco Yes 2 210,000 218,000 216,000
69 2 2,133 7 Yes Stucco Yes 2.5 294,000 306,000 321,000
70 2 2,037 7 No Brick No 2 176,000 183,000 174,000
71 3 1,900 3 No Stucco Yes 2 224,000 234,000 225,000
72 2 1,871 8 Yes Wood No 1.5 125,000 131,000 135,000
73 4 2,584 7 No Brick Yes 2 237,000 249,000 242,000
74 4 2,312 3 Yes Wood No 2 164,000 173,000 176,000
75 3 2,498 9 Yes Brick No 2 218,000 230,000 225,000
76 2 2,407 2 Yes Stucco No 2.5 192,000 203,000 205,000
77 2 2,363 2 Yes Stucco No 1.5 126,000 133,000 132,000
78 2 2,329 1 No Stucco Yes 2 221,000 234,000 246,000
79 5 2,732 8 Yes Brick Yes 2 295,000 313,000 297,000
80 2 2,343 5 Yes Stucco Yes 2.5 245,000 261,000 271,000
81 3 2,479 3 No Stucco No 1.5 199,000 212,000 204,000
82 4 2,624 2 Yes Wood Yes 2 240,000 256,000 264,000
83 4 2,319 1 Yes Brick Yes 2 263,000 281,000 273,000
84 2 1,887 4 Yes Wood Yes 1.5 188,000 202,000 206,000
85 4 2,280 6 Yes Brick Yes 2 221,000 238,000 240,000
86 2 2,511 5 Yes Brick No 2 175,000 189,000 187,000
87 3 2,331 9 Yes Stucco Yes 2 253,000 273,000 287,000
88 4 2,408 2 No Brick No 2 155,000 168,000 160,000
89 5 2,548 1 No Wood No 2.5 187,000 203,000 211,000
90 3 2,442 6 No Wood Yes 2 179,000 194,000 186,000
91 5 2,091 1 No Wood Yes 2 188,000 205,000 211,000
92 4 2,886 10 Yes Wood Yes 2 227,000 247,000 240,000
93 4 2,132 2 No Stucco Yes 2.5 174,000 190,000 194,000
94 5 2,311 7 Yes Brick No 1.5 188,000 206,000 202,000
95 5 2,355 4 Yes Brick Yes 3 294,000 323,000 320,000
96 3 2,442 2 Yes Wood Yes 2 179,000 197,000 207,000
97 5 2,091 10 No Stucco Yes 2.5 188,000 207,000 197,000
98 4 2,886 1 Yes Brick No 1.5 227,000 251,000 261,000
99 4 2,132 3 Yes Wood Yes 2 174,000 192,000 184,000
100 5 2,311 1 Yes Brick Yes 3 188,000 208,000 214,000

Sheet1

Inder Pal Singh
Module 5
Problem 1
With Pools Without Pools Difference
Mean 216710 Mean 202763.157894737 Mean -70
Standard Error 5889.244626045 Standard Error 5469.6153084445 Standard Error 753.6115066998
Median 226000 Median 198500 Median -500
Mode 188000 Mode 221000 Mode 8000
Standard Deviation 46371.9585574599 Standard Deviation 33716.9731982287 Standard Deviation 7536.1150669977
Sample Variance 2150358540.45478 Sample Variance 1136834281.65007 Sample Variance 56793030.3030303
Kurtosis -0.5771553839 Kurtosis 1.4688644631 Kurtosis -1.0867808121
Skewness -0.0287498583 Skewness 1.0605821475 Skewness -0.0574177119
Range 195000 Range 161000 Range 31000
Minimum 125000 Minimum 147000 Minimum -15000
Maximum 320000 Maximum 308000 Maximum 16000
Sum 13966000 Sum 7705000 Sum -7000
Count 62 Count 38 Count 100

Sheet3