In: Statistics and Probability
Develop a null and alternative hypothesis for a test of whether or not there is a statistically significant relationship between the variables and find the descriptive statistics on the three relevant variables in the table. Highlight the means, standard deviations, and observations. (IN EXCEL PLEASE)
TABLE C9-1: House & Holmes Appraisal Values by Appraised Home in $000s + Total Homes on Market | |||
Home | House Appraisal | Holmes Appraisal | Total Homes on Market |
1 | 235 | 228 | 161 |
2 | 210 | 205 | 179 |
3 | 231 | 219 | 184 |
4 | 242 | 240 | 205 |
5 | 205 | 198 | 218 |
6 | 230 | 223 | 141 |
7 | 231 | 227 | 225 |
8 | 210 | 215 | 217 |
9 | 225 | 222 | 155 |
10 | 249 | 245 | 103 |
11 | 299 | 303 | 69 |
12 | 201 | 196 | 170 |
13 | 243 | 239 | 160 |
14 | 259 | 249 | 89 |
15 | 345 | 339 | 58 |
16 | 387 | 383 | 101 |
17 | 305 | 311 | 81 |
18 | 294 | 290 | 109 |
19 | 271 | 266 | 112 |
20 | 333 | 338 | 70 |
.