1. Analyze the sale price data using descriptive statistics, frequency distribution, and other tools. In this question look only at sale price Use charts and figures to present and aid your analysis. Which measure of central tendency would you use?

2. Analyze what factors influence the sale price. Use any of the methods. Use Pivot tables to slice and dice based on multiple factors, create bar charts based on different factors, etc. Summarize your observations.

3. Build a (multi variable) regression model that predicts the sale price of an apartment unit. Present the regression output in your report.

General Management

Reference:

Title: Statistics. Data, Analysis & Decisions Modeling, 5th edition

Authors: James R. Evans

Publisher: Pearson

ISBN: 0132744287

o A B D E F II 1 2 3 4 5 6 7 8 9 FURNISH 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 END 0 0 1 0 1 1 1 1 1 1 1 1 1 0 0 1 1 1 0 1 0 11 15 2 12 13 14 15 16 17 18 0 0 0 19 0 20 1 0 0 21 0 0 OO 22 0 23 PRICE1000 FLOOR 199 204 275 209 259 264 264 264 254 264 279 204 199 249 264 209 259 204 274 199 199 274 180 254 284 269 159 199 204 190 261 159 261 169 199 189 294 199 204 279 159 151 151 159 190 DISTANCE VIEW 1 2 1 1 13 1 15 2 14 1 2 1 9 1 12 1 13 3 9 3 3 8 8 15 1 12 2 2 13 2 2 15 3 11 3 14 4 15 1 14 7 15 1 3 1 11 2 14 3 11 3 4 14 3 5 2 3 1 6 1 9 9 2 11 2 12 2 12 2 13 3 6 4 14 5 14 6 15 6 14 2 6 3 14 6 9 2 4 2 5 5 2 10 8 12 0 0 24 25 1 0 0 1 1 1 1 12 0 0 0 0 0 0 0 0 0 0 26 27 0 28 0 0 oa 0 0 0 0 0 0 29 30 31 32 0 0 0 1 0 0 33 0 34 0 1 0 0 0 0 0 0 0 0 35 0 0 36 0 37 0 38 0 39 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 40 41 42 0 0 0 0 43 0 44 0 0 0 0 0 0 45 0 0 46 0 0 A B C D E F F II 46 47 48 12 13 4 5 0 0 : 2 49 10 50 51 52 0 0 0 0 2 13 14 5 53 54 0 0 55 3 0 4 56 57 10 0 58 8 8 1 1 1 1 2 3 8 3 3 3 3 3 3 4 5 8 1 1 1 1 1 2 3 4 4 4 4 59 60 0 0 0 0 0 61 62 63 12 13 11 11 11 3 4 11 1 1 1 1 64 65 66 190 190 175 175 175 159 163 219 161 169 169 165 169 269 176 186 195 259 235 240 159 169 260 209 176 179 179 274 179 180 199 190 210 225 220 210 225 225 220 190 195 200 210 170 200 205 1 0 0 0 0 0 0 0 0 0 0 67 68 0 69 70 1 0 1 1 1 1 0 1 1 0 0 1 1 1 1 1 6 71 4 9 12 72 4 73 4 13 74 0 0 0 0 0 0 0 0 0 0 75 76 13 2 6 12 1 5 10 77 78 79 80 0 0 0 1 1 0 1 1 1 1 1 81 1 82 5 6 6 6 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 3 3 0 83 84 85 86 87 4 5 9 9 10 1 2 2 3 10 1 1 1 1 1 1 0 0 0 0 88 1 1 89 90 91 1 1 0 0 1 1 n LUJ B C D E F II IU 1 0 92 93 94 0 0 95 4 4 4 4 4 4 4 4 4 4 2 2 3 3 4 4 5 0 0 0 0 0 1 0 1 0 1 0 1 1 0 0 0 1 0 4 9 0 0 96 97 98 99 100 101 102 103 104 105 106 107 4 4 4 4 4 1 1 0 1 0 0 1 0 0 1 1 1 1 0 1 1 1 1 0 0 1 1 1 0 0 10 10 11 12 1 0 0 4 0 0 1 0 1 1 2 0 0 1 3 4 108 0 0 4 1 0 0 0 5 6 9 9 10 0 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 0 0 215 175 200 175 195 165 195 200 190 160 205 190 205 175 215 220 265 175 200 185 195 160 205 175 205 205 166 195 205 210 165 220 180 215 175 200 165 175 185 200 165 175 170 190 170 200 0 1 0 1 0 1 1 0 1 0 0 0 1 1 1 1 1 1 1 1 10 1 1 1 1 0 0 1 1 0 0 1 0 0 0 0 0 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 1 10 11 12 12 13 15 1 1 2 2 3 3 3 0 0 0 0 0 0 1 0 1 0 6 6 6 0 4 6 6 1 0 0 0 0 0 0 4 1 0 0 1 1 0 1 6 5 6 6 0 0 0 6 6 6 9 9 10 10 11 11 12 1 0 0 1 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 6 1 6 6 6 0 1 B D E F II U 12 1 1 1 0 6 6 0 1 1 138 139 140 141 142 143 7 7 7 7 1 1 0 1 0 0 0 0 0 1 1 0 1 0 7 7 13 14 1 1 2 2 3 3 3 4 4 4 5 9 9 9 10 10 11 11 OOOHOOOOPPLE 7 1 0 0 0 0 0 7 0 7 7 1 1 0 7 1 0 0 0 0 7 7 7 7 7 1 12 12 0 0 0 0 1 0 1 0 0 0 0 0 0 7 7 14 0 0 0 0 0 0 0 0 0 0 1 8 8 ZUU 195 195 205 180 195 170 195 186 200 175 190 195 170 200 180 190 180 190 175 195 190 180 205 175 215 175 195 170 185 175 175 205 165 200 175 205 190 205 195 150 140 130 182 175 164 249 1 0 1 1 1 0 0 1 0 0 1 0 1 2 2 2 3 8 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 0 0 1 0 0 0 1 0 0 0 3 8 8 8 8 8 8 8 8 4 1 0 4 0 0 0 0 5 5 5 0 0 6 8 8 0 0 0 1 8 0 0 9 9 10 10 8 0 0 0 1 0 0 1 0 1 0 1 1 1 1 1 0 0 1 1 0 1 11 8 8 8 8 8 8 3 5 5 0 0 0 0 0 RBW B 12 13 14 13 0 0 0 1 0 1 0 0 1 2 0 0 6 5 0 1 1 1 1 1 1 0 4 5 5 4 1 14 1 1 1 0 0 0 0 B C D E F II 0 0 184 185 186 187 188 4 7 7 2 8 1 2 3 4 1 1 0 0 1 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 189 0 0 0 190 191 0 0 0 0 0 0 1 1 1 0 A 249 215 199 190 295 217 265 202 177 189 197 205 206 231 255 250 230 279 215 306 190 200 195 180 175 195 190 175 1 13 12 5 13 13 10 1 4 4 11 12 1 13 4 10 14 14 12 1 15 6 6 6 6 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 1 1 10 1 1 1 4 8 3 3 2 7 4 7 1 4 6 3 3 3 1 1 2 3 4 5 7 8 0 1 1 1 1 0 0 1 0 1 0 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 0 0 6 0 1 1 6 6 6 6 6 D 1 0