pid Ftype 130 287 43 31 210 104 66 149 37 236 274 82 138 140 152 68 17 179 139 113 119 228 252 188 226 180 168 212 97 133 99 280 190 32 56 244 78 204 184 22 48 128 261 129 lastreno 8 1 6 1 3 2 1 4 5 4 7 4 4 2 5 7 6 1 2 2 1 6 9 1 1 6 2 3 6 8 9 5 3 3 8 5 7 8 8 9 5 8 1 9 marketing 0 5 6 2 5 10 5 3 1 7 5 3 10 3 5 1 5 6 5 0 9 4 8 2 6 8 0 1 7 1 0 5 4 2 3 9 7 2 7 0 2 5 0 4 budget age 7 190200 4 159900 1 129800 6 99800 1 30200 3 30200 1 30200 2 29800 4 29700 5 29300 6 29300 2 29200 4 29200 3 29200 7 29200 1 29100 4 28800 4 28800 5 28700 4 28700 4 28700 5 28300 2 28300 4 28200 5 28200 3 28200 4 28200 1 28200 6 27800 5 27800 6 27800 3 27300 4 27200 4 27200 2 27200 6 27200 3 27200 2 27200 1 27200 7 27200 3 27200 2 27100 7 26900 4 26800 spend 26 60 61 39 40 32 49 46 22 49 46 64 50 26 64 27 30 48 23 21 35 25 49 47 63 49 37 24 35 56 20 38 28 41 45 55 41 33 51 20 58 54 37 57 4300 11800 4700 11700 11300 11300 8300 7700 4600 3400 1400 10300 8300 7300 4300 3200 11700 9700 14600 11600 6600 4400 2400 10300 10300 9300 7300 2300 11700 7700 5700 2400 13300 9300 8300 8300 7300 6300 4300 4300 2300 2200 1800 8700 137 65 227 125 177 250 282 170 54 242 122 154 158 148 49 191 183 111 211 262 24 40 306 166 38 216 299 249 233 219 59 121 201 81 105 268 272 162 142 198 150 118 281 63 169 3 2 5 6 4 8 8 7 3 3 2 7 2 8 5 1 6 7 5 4 4 3 1 2 1 8 2 8 3 5 1 4 1 2 7 3 7 2 4 1 7 4 5 4 2 6 6 6 3 2 0 6 2 0 1 3 9 0 2 3 0 0 6 8 11 2 10 4 8 0 1 10 9 7 1 7 0 1 0 1 1 7 8 9 8 0 7 8 2 2 5 5 1 7 1 1 4 2 5 4 2 3 3 4 2 6 1 1 6 3 3 4 7 4 1 4 7 4 1 4 1 2 2 1 6 2 6 5 2 2 7 6 6 4 5 26800 26800 26800 26700 26700 26300 26300 26200 26200 26200 26200 26200 26200 26100 25800 25800 25800 25700 25700 25300 25200 25200 25200 25200 25100 25100 24900 24900 24900 24800 24800 24800 24800 24800 24700 24300 24300 24200 24200 24100 24100 24100 23900 23800 23800 21 37 47 45 43 22 65 26 31 45 56 31 60 22 55 42 29 35 20 46 42 64 27 39 40 57 43 49 45 49 41 25 29 50 25 62 35 50 30 23 34 44 58 21 59 8700 3700 3700 12600 10600 10400 10400 13300 9300 6300 5300 3300 3300 4200 9700 3700 2700 10600 8600 7400 13300 13300 6300 5300 14200 10200 13800 1800 1800 7700 6700 4700 3700 3700 600 3400 1400 9300 7300 10200 6200 4200 800 14700 11700 79 107 283 89 145 23 221 290 264 116 50 194 206 156 108 172 70 58 218 265 243 153 73 205 181 33 93 195 127 238 258 132 106 80 94 196 136 160 257 271 241 173 109 267 101 7 2 9 7 2 8 9 3 2 8 3 9 1 2 9 3 5 6 6 5 3 2 3 5 2 1 4 8 3 9 7 5 1 9 7 1 8 6 2 4 7 6 2 4 5 2 10 5 2 8 1 7 11 9 1 5 10 9 0 9 5 5 3 5 11 7 4 0 9 7 10 8 6 9 5 8 6 10 0 6 1 3 9 10 0 0 2 0 10 3 3 6 6 4 1 4 7 2 3 1 2 4 1 7 4 4 2 4 1 3 2 2 4 2 6 3 6 6 7 6 4 2 2 3 6 1 3 1 1 2 4 2 2 7 6 23800 23800 23800 23700 23700 23700 23700 23300 23300 23200 23200 23200 23200 23200 23200 23100 23100 23100 23100 22900 22900 22800 22800 22800 22800 22800 22800 22800 22700 22300 22200 22200 22200 22200 22200 22200 22100 22100 21900 21900 21900 21800 21800 21800 21800 30 64 64 51 36 33 49 53 29 61 32 63 54 48 59 28 46 22 34 55 34 24 64 29 21 26 46 39 25 57 42 45 55 49 61 22 61 50 29 52 46 27 42 46 26 9700 5700 4700 5600 1600 1600 1600 9400 7400 8300 7300 7300 6300 3300 1300 12200 11200 4200 1200 10800 5800 13700 10700 9700 9700 6700 2700 1700 13600 8400 12300 12300 9300 6300 2300 1300 12200 11200 13800 11800 5800 8700 8700 7700 6700 213 225 57 27 186 64 144 110 220 259 275 307 253 87 251 295 263 25 95 100 26 44 62 273 245 141 67 301 45 300 298 84 134 234 92 202 98 291 185 19 285 75 39 209 159 3 9 6 9 5 6 2 3 9 3 6 7 8 1 7 1 7 2 8 2 8 9 6 3 2 8 5 6 5 9 1 6 4 1 6 1 7 7 8 8 7 3 4 3 8 5 6 5 1 3 6 2 6 2 7 5 8 4 7 7 4 7 8 3 4 8 7 3 8 6 4 3 7 2 7 10 7 5 4 3 6 2 10 10 8 8 99 8 8 6 7 1 5 3 4 5 2 1 2 7 1 1 7 5 7 6 7 3 3 2 6 1 3 3 6 7 2 2 7 1 1 1 4 5 2 5 3 6 2 5 6 3 3 5 7 21800 21800 21700 21700 21200 21200 21200 21100 21100 20900 20900 20900 20900 20800 20800 20800 20800 20800 20700 20200 20100 20100 20100 19900 19900 19800 19800 19800 19700 19300 19200 19200 19200 19200 19200 19200 19100 18900 18800 18800 18800 18800 18800 18700 18700 55 55 38 60 26 59 59 31 44 42 46 63 30 64 36 57 56 27 49 38 58 58 23 62 43 47 20 47 42 58 21 59 46 24 24 34 48 40 54 23 30 21 46 58 58 700 700 1600 1600 15300 14300 10300 13200 3200 13800 9800 8800 3800 12700 10700 5700 5700 2700 13600 6300 14200 10200 9200 9800 7800 9700 8700 6700 10600 8400 9300 9300 7300 6300 6300 5300 3200 4800 14700 7700 3700 1700 700 12600 7600 61 270 254 230 248 256 260 102 74 192 146 30 112 309 303 255 289 175 223 131 189 135 163 72 126 224 293 35 203 103 302 182 34 214 20 114 294 90 278 96 86 120 77 53 83 4 4 2 5 1 4 6 1 8 7 8 4 1 9 3 1 1 7 1 8 1 4 7 4 7 2 8 7 9 8 3 9 1 2 8 6 2 8 7 6 6 4 6 2 4 1 0 5 10 5 3 4 8 9 8 5 0 1 0 10 7 3 4 2 0 8 10 1 3 4 1 5 4 2 6 0 5 7 7 0 8 5 2 3 1 6 6 5 6 4 5 2 2 2 6 7 3 3 7 6 3 2 6 7 7 1 4 2 7 7 6 5 3 6 2 2 6 4 4 6 1 2 2 1 3 6 6 5 6 2 2 6 7 5 5 18700 18300 18300 18300 18300 18300 18300 18200 18200 18200 18200 18100 18100 18000 17900 17900 17900 17800 17800 17800 17800 17800 17700 17200 17200 17100 16900 16800 16800 16700 16300 16200 16200 16200 16200 16200 16200 16200 16200 16200 16100 16100 15800 15800 15800 40 39 34 43 36 47 21 36 50 52 27 57 46 43 56 35 39 44 64 52 59 26 29 45 60 38 28 24 56 54 33 60 62 25 50 30 40 63 54 57 43 59 40 30 29 1600 12400 11400 9400 8400 2400 1400 13300 8300 7300 3300 10200 2200 13000 14800 13800 9800 12700 11700 7700 4700 1700 1600 3300 3300 8200 13800 8700 1700 7600 2400 13300 10300 9300 8300 7300 6300 5300 4300 2300 15200 12200 11700 11700 6700 207 197 143 85 276 60 200 174 222 279 71 229 155 115 69 187 171 161 308 266 232 52 42 178 176 28 239 305 123 151 247 29 91 193 304 240 296 284 246 76 269 231 277 157 199 9 8 9 8 6 3 4 7 9 4 9 6 4 1 7 2 4 2 4 5 3 9 5 2 9 2 6 1 2 2 9 9 1 6 7 3 5 2 6 3 2 1 4 2 5 3 1 3 2 5 0 3 9 0 0 6 0 3 3 3 4 9 7 5 10 11 4 9 0 8 4 8 0 9 9 0 1 9 7 6 3 3 8 5 7 9 0 4 7 7 5 7 7 5 3 5 2 7 2 2 1 5 2 3 1 6 5 3 3 1 4 5 2 7 7 6 2 2 7 4 1 1 6 1 2 6 6 2 2 4 7 2 4 3 7 15800 15700 15700 15700 15300 15200 15200 15200 15100 14900 14800 14800 14800 14800 14800 14800 14700 14700 14300 14300 14300 14200 14200 14200 14200 14100 13900 13800 13800 13800 13800 13800 13800 13800 13300 13300 13300 13300 13300 13200 12900 12900 12800 12800 12800 37 33 22 23 24 26 22 55 63 34 61 39 44 42 63 21 21 38 30 47 24 31 28 24 52 22 57 41 55 40 39 63 32 33 39 56 24 30 59 54 30 51 39 44 62 6700 10600 6600 1600 7400 8300 6300 6300 6200 9800 13700 7700 6700 5700 4700 4700 3600 1600 11400 10400 8400 14300 6300 5300 4300 12200 11800 14700 11700 7700 4700 3700 3700 1700 7400 4400 3400 1400 1400 14300 13800 4800 14700 6700 5700 147 235 215 47 292 46 18 164 124 208 237 297 117 41 217 51 21 288 286 36 88 167 55 165 Total 4 3 1 9 6 2 8 8 4 2 6 5 1 6 5 4 3 7 5 4 7 1 8 6 293 4 1 4 5 0 8 0 5 2 9 6 3 9 8 3 8 1 1 7 2 50 10 0 1 6 2 7 1 2 2 1 2 2 3 4 7 3 5 7 5 6 6 3 7 5 5 2 5 12800 12800 12800 12700 12300 12200 12200 12200 12100 12100 11900 11900 11800 11800 11800 11700 11700 11300 11300 11200 11200 10800 10800 10700 22119.4539 35 25 55 42 47 31 53 48 58 47 28 65 26 29 57 32 27 36 46 57 57 59 43 29 293 5700 4700 3700 6600 12400 12300 11300 9300 14200 10200 7800 4800 12700 10700 10700 9600 6600 7400 3400 7300 3300 11700 5700 2600 2206000 Dinc lastrenospen wood 3 74000 4 254000 2 59000 4 218000 2 246000 3 96000 6 285000 4 65000 6 153000 6 56000 6 252000 5 223000 3 231000 6 212000 2 144000 6 176000 5 176000 6 122000 5 57000 3 112000 1 293000 1 54000 2 71000 1 244000 3 56000 3 208000 3 288000 6 200000 3 249000 1 51000 3 72000 4 54000 1 150000 2 137000 1 217000 3 147000 2 166000 6 254000 3 108000 5 106000 3 70000 3 204000 6 184000 4 199000 MDF 4 0 3 1 1 9 0 8 5 0 0 3 7 3 3 1 2 1 5 12 3 4 2 7 9 9 3 0 4 8 0 3 9 5 3 3 2 2 2 4 2 0 2 0 gender 0 12 2 11 10 2 8 0 0 3 2 7 1 4 1 2 10 9 8 0 4 0 1 3 1 0 4 3 8 0 6 0 3 4 5 5 5 4 2 0 1 3 1 9 csat 0 0 0 1 1 1 0 1 1 1 0 0 1 1 0 0 0 1 0 0 1 1 0 1 1 1 1 1 1 0 1 0 0 0 1 1 0 1 0 1 1 0 1 1 PFtype 1 5 3 4 4 4 4 5 4 3 5 5 2 5 3 1 4 1 3 5 5 4 2 5 4 2 3 1 1 4 1 1 1 5 1 3 3 4 3 2 1 2 2 3 4 9 5 0 8 3 5 5 9 7 5 6 3 9 1 7 7 8 3 9 1 0 2 0 5 1 3 2 5 2 0 8 8 3 2 4 2 0 6 6 8 9 3 1 3 1 6 3 6 5 6 3 1 4 5 5 2 6 4 6 6 1 1 1 6 2 1 6 3 6 6 3 6 4 6 5 3 6 6 1 3 5 3 5 6 5 6 6 6 153000 228000 66000 108000 259000 290000 78000 191000 165000 113000 201000 162000 89000 115000 152000 203000 168000 115000 151000 127000 223000 78000 137000 154000 102000 105000 131000 274000 67000 247000 210000 134000 133000 65000 60000 228000 246000 72000 205000 296000 88000 290000 121000 232000 286000 2 3 3 6 5 1 5 1 7 0 1 1 1 0 9 3 3 6 3 4 11 1 1 0 10 10 9 2 3 6 1 4 0 3 1 0 0 4 1 10 3 1 0 12 3 7 1 1 6 6 9 5 11 2 6 4 2 2 4 1 1 0 5 6 3 1 11 5 5 3 0 4 1 0 2 6 1 4 1 1 3 2 5 6 0 3 3 2 1 9 1 0 0 1 0 1 1 0 1 0 0 1 1 0 1 0 0 1 1 1 0 0 1 1 1 1 0 0 1 1 1 1 1 1 1 1 0 0 1 0 1 0 0 0 1 1 5 3 2 4 1 4 4 1 5 5 4 4 2 5 2 3 3 1 5 5 4 2 1 5 1 4 2 2 5 5 5 2 1 3 2 2 5 3 1 5 1 1 5 5 0 8 8 6 3 3 6 8 1 9 9 2 3 0 4 0 9 8 6 1 5 8 6 0 8 0 0 8 5 2 3 9 3 0 4 5 0 1 5 8 2 6 4 3 9 5 5 2 5 2 3 2 1 5 6 1 6 3 3 5 6 1 5 6 2 4 6 4 3 2 1 5 2 5 2 3 2 5 6 6 3 1 4 6 3 5 4 2 2 5 93000 177000 93000 191000 258000 129000 122000 135000 288000 131000 68000 52000 277000 111000 135000 218000 61000 182000 134000 116000 221000 61000 215000 149000 128000 259000 129000 132000 64000 60000 256000 227000 269000 203000 203000 130000 76000 243000 224000 120000 149000 152000 94000 197000 253000 10 2 3 0 1 0 3 4 7 2 2 0 5 1 0 6 3 1 1 9 5 12 4 2 4 4 1 3 9 5 10 6 2 3 0 0 11 11 9 2 3 9 0 4 5 0 4 2 6 2 3 0 5 0 6 5 7 1 2 2 6 8 3 1 2 1 1 7 8 6 3 2 0 4 3 2 6 7 3 3 2 1 0 4 10 3 0 9 4 2 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 1 0 1 0 0 1 1 1 0 1 0 0 1 0 1 1 1 0 1 1 1 1 0 1 0 0 0 0 5 3 3 4 2 2 2 1 5 4 2 5 4 4 5 5 5 4 2 4 5 5 1 5 2 3 1 2 2 4 3 2 3 3 2 1 2 5 1 1 1 3 5 2 4 8 5 1 3 9 6 7 4 6 9 3 2 5 7 6 9 5 5 6 2 5 6 1 0 5 2 4 7 4 0 7 0 2 5 5 8 0 2 6 5 4 1 3 0 3 6 1 3 4 3 6 2 6 1 5 4 3 4 1 4 1 4 2 2 5 1 6 3 1 2 5 1 2 6 3 6 5 5 6 1 5 1 5 6 2 5 2 3 4 6 268000 265000 251000 153000 61000 176000 178000 114000 299000 120000 180000 253000 298000 215000 147000 201000 132000 211000 133000 211000 172000 95000 154000 265000 95000 244000 177000 158000 143000 271000 91000 53000 220000 214000 83000 171000 267000 133000 261000 61000 159000 180000 236000 143000 239000 0 2 1 2 4 0 1 12 0 4 1 7 3 10 7 1 3 3 11 6 3 10 6 0 2 1 8 0 0 6 9 9 0 2 6 5 0 3 11 6 1 2 1 0 8 2 0 2 1 9 13 9 0 3 9 9 2 1 2 4 5 3 0 2 0 10 0 3 10 6 9 1 7 11 2 0 0 7 4 0 0 3 2 2 2 3 1 1 12 0 1 0 0 1 1 0 1 1 0 1 0 1 0 1 0 1 0 1 1 0 0 0 0 0 1 1 1 0 1 0 0 1 0 0 0 0 1 0 0 0 1 1 1 1 0 1 5 4 1 4 3 2 1 4 3 2 4 2 2 5 1 1 5 4 2 3 2 2 1 5 2 4 4 3 4 3 4 2 4 5 5 3 1 3 2 1 3 3 3 4 9 6 6 1 4 1 0 7 0 8 6 8 7 7 1 3 2 1 6 3 4 2 0 8 4 8 7 5 6 9 0 6 4 7 6 6 0 8 4 9 7 7 9 5 5 6 2 2 3 6 6 5 3 3 6 2 1 5 2 3 2 4 3 1 2 4 4 5 6 6 6 4 1 5 3 3 3 1 1 4 2 2 1 3 6 1 2 6 5 6 282000 288000 242000 199000 123000 207000 208000 67000 243000 211000 77000 83000 250000 247000 74000 174000 281000 279000 129000 52000 167000 295000 272000 277000 208000 189000 247000 86000 252000 135000 113000 238000 166000 208000 143000 198000 121000 227000 124000 82000 284000 137000 280000 148000 156000 2 9 0 6 2 3 1 11 4 2 1 7 1 7 13 6 5 2 4 3 1 2 0 3 3 3 4 5 1 7 2 9 4 2 7 6 4 1 2 2 6 9 5 12 7 1 3 11 3 6 0 1 1 4 5 2 3 2 5 0 7 5 10 8 5 4 1 3 0 0 5 9 4 2 1 1 3 6 7 1 1 2 4 2 1 7 3 7 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 1 0 0 1 0 1 0 0 0 0 1 1 0 1 0 1 1 1 0 0 0 1 0 1 0 5 4 3 4 2 4 2 3 2 5 1 4 1 4 3 3 2 4 2 4 4 3 5 4 5 2 1 5 1 2 4 2 1 4 1 5 4 4 4 2 3 3 5 4 5 0 2 9 8 5 4 6 3 9 5 2 1 1 2 0 4 2 9 4 6 7 7 7 3 8 5 3 7 5 8 6 3 8 7 9 0 6 7 6 5 8 8 6 4 2 4 3 4 3 1 4 4 4 3 4 6 5 4 6 6 1 1 1 3 2 6 2 5 5 4 2 2 6 1 1 6 5 2 3 6 3 3 3 3 6 2 4 6 1 4 121000 103000 66000 150000 207000 295000 120000 91000 222000 77000 172000 249000 162000 150000 280000 182000 93000 248000 206000 298000 284000 150000 223000 185000 119000 245000 100000 106000 136000 138000 224000 92000 70000 225000 135000 53000 231000 284000 214000 258000 102000 122000 251000 67000 217000 7 5 7 0 2 3 4 0 6 6 11 1 0 1 0 1 2 3 10 3 7 1 2 5 3 2 8 12 12 8 4 1 1 2 5 4 1 0 2 13 13 3 3 7 4 0 6 0 3 5 5 2 6 0 4 2 7 7 5 5 4 2 0 1 7 1 12 4 0 1 10 4 1 0 0 1 3 3 1 2 0 2 2 0 0 0 2 10 0 2 1 1 0 0 0 0 0 1 1 1 1 1 0 1 1 0 1 1 1 0 1 0 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 1 0 1 1 0 0 1 0 4 1 2 1 3 1 1 2 1 3 1 1 2 1 2 1 2 3 2 3 1 4 3 3 3 5 4 5 4 3 5 2 2 2 2 4 2 1 1 2 1 3 5 4 3 2 8 1 9 2 1 8 7 4 0 0 1 2 8 6 2 6 8 3 6 4 4 6 4 5 7 8 8 3 9 9 6 9 7 0 5 5 1 9 4 6 0 7 2 6 2 3 6 5 2 2 6 6 6 2 5 5 3 1 1 2 2 6 3 4 6 1 4 3 293 185000 226000 111000 267000 249000 171000 158000 145000 296000 210000 265000 149000 91000 183000 69000 295000 242000 121000 147000 106000 168000 160000 171000 241000 299000 3 4 4 7 2 3 9 7 13 4 3 1 1 9 9 3 7 6 2 4 1 3 0 0 1171 3 1 0 0 10 9 2 2 0 6 5 4 11 2 2 7 0 1 1 3 2 9 6 3 1030 1 0 1 1 0 0 1 0 0 1 0 0 1 1 0 0 1 1 0 1 1 1 1 0 141 5 2 2 5 5 4 1 4 4 3 4 5 3 3 5 1 5 1 3 4 5 1 4 1 4 9 2 6 9 7 2 5 5 7 8 4 1 8 0 0 8 2 0 3 9 4 8 1 5 1365 %spending/budget 0.02260778 0.07379612 0.03620955 0.11723447 0.37417219 0.37417219 0.27483444 0.25838926 0.15488215 0.11604096 0.04778157 0.35273973 0.28424658 0.25 0.14726027 0.10996564 0.40625 0.33680556 0.5087108 0.40418118 0.22996516 0.15547703 0.08480565 0.36524823 0.36524823 0.32978723 0.25886525 0.08156028 0.42086331 0.27697842 0.20503597 0.08791209 0.48897059 0.34191176 0.30514706 0.30514706 0.26838235 0.23161765 0.15808824 0.15808824 0.08455882 0.08118081 0.0669145 0.32462687 0.32462687 0.1380597 0.1380597 0.47191011 0.39700375 0.39543726 0.39543726 0.50763359 0.35496183 0.24045802 0.20229008 0.1259542 0.1259542 0.16091954 0.37596899 0.14341085 0.10465116 0.41245136 0.33463035 0.29249012 0.52777778 0.52777778 0.25 0.21031746 0.56573705 0.4063745 0.55421687 0.07228916 0.07228916 0.31048387 0.27016129 0.18951613 0.14919355 0.14919355 0.0242915 0.1399177 0.05761317 0.38429752 0.30165289 0.42323651 0.25726141 0.17427386 0.0334728 0.61764706 0.49159664 0.40756303 0.2394958 0.19747899 0.23628692 0.06751055 0.06751055 0.06751055 0.40343348 0.31759657 0.35775862 0.31465517 0.31465517 0.27155172 0.14224138 0.05603448 0.52813853 0.48484848 0.18181818 0.05194805 0.47161572 0.25327511 0.60087719 0.46929825 0.4254386 0.4254386 0.29385965 0.11842105 0.0745614 0.59911894 0.37668161 0.55405405 0.55405405 0.41891892 0.28378378 0.1036036 0.05855856 0.5520362 0.50678733 0.63013699 0.53881279 0.26484018 0.39908257 0.39908257 0.35321101 0.30733945 0.03211009 0.03211009 0.07373272 0.07373272 0.72169811 0.6745283 0.48584906 0.62559242 0.15165877 0.66028708 0.46889952 0.42105263 0.18181818 0.61057692 0.51442308 0.27403846 0.27403846 0.12980769 0.65700483 0.31188119 0.70646766 0.50746269 0.45771144 0.49246231 0.3919598 0.48989899 0.43939394 0.33838384 0.53807107 0.43523316 0.484375 0.484375 0.38020833 0.328125 0.328125 0.27604167 0.16753927 0.25396825 0.78191489 0.40957447 0.19680851 0.09042553 0.03723404 0.67379679 0.40641711 0.0855615 0.67759563 0.62295082 0.5136612 0.45901639 0.13114754 0.07650273 0.73076923 0.45604396 0.4010989 0.18131868 0.56353591 0.12154696 0.72222222 0.82681564 0.77094972 0.54748603 0.71348315 0.65730337 0.43258427 0.26404494 0.09550562 0.09039548 0.19186047 0.19186047 0.47953216 0.81656805 0.51785714 0.10119048 0.45508982 0.14723926 0.82098765 0.63580247 0.57407407 0.51234568 0.45061728 0.38888889 0.32716049 0.2654321 0.14197531 0.94409938 0.75776398 0.74050633 0.74050633 0.42405063 0.42405063 0.67515924 0.42038217 0.10191083 0.48366013 0.54605263 0.41447368 0.41447368 0.41059603 0.65771812 0.92567568 0.52027027 0.4527027 0.38513514 0.31756757 0.31756757 0.24489796 0.10884354 0.7972028 0.72727273 0.58741259 1.00704225 0.44366197 0.37323944 0.3028169 0.86524823 0.84892086 1.06521739 0.84782609 0.55797101 0.34057971 0.26811594 0.26811594 0.12318841 0.55639098 0.33082707 0.2556391 0.10526316 0.10526316 1.08333333 1.06976744 0.37209302 1.1484375 0.5234375 0.4453125 0.4453125 0.3671875 0.2890625 0.51968504 1.00813008 1.00819672 0.92622951 0.76229508 1.17355372 0.84297521 0.65546218 0.40336134 1.07627119 0.90677966 0.90677966 0.82051282 0.56410256 0.65486726 0.30088496 0.65178571 0.29464286 1.08333333 0.52777778 0.24299065 UNSW School of Economics ECON1203 Business and Economic Statistics Session 1, 2017 Major project: Call of the Furniture Store Purpose The idea is of this assignment is to simulate a professional work task involving statistical analysis. It is designed to help students learn about what is involved in undertaking basic statistical analysis to understand a realworld problem, and communicating the results of this analysis to business stakeholders. Context and Problem You are working as a consultant for Big 4 Consultants Australia (\"B4CA\"), a Sydneybased company that specializes in providing statistical consulting services to Australian companies seeking intelligence about their present or potential customers. Your company is contacted by Wooden Furniture Inc. (hereinafter called \"Store\") an owner of several furniture stores in Sydney. It sells two types of furniture, wooden and medium density fibreboard (MDF). You are told that the CEO of the company, Jonathan Lee, is interested in using market research to make informed expansion decisions (i.e., decisions about what to stock, who to target and how to market etc.). You attend a breakfast meeting with Mr. Lee and a senior B4CA consultant to discuss his concerns in more detail. At the meeting, Mr. Lee says: \"So the situation is that we hired a marketresearch firm to come in and run an intercept survey (intercept survey: a survey of shoppers leaving a store) for us, which they did, and the data were collected in a single week in December 2016. I'm now looking for someone with statistical expertise to analyse the data and give us some recommendations. The purpose of the survey was twofold: the first objective was to help us understand our customers, such as: 1. the profile of our customers (e.g. age, gender, disposable income, last renovation etc.); 2. our customers spending habits (e.g. what they purchased?, material of the furniture, number of items etc.); 3. how they found out about us; and 4. the proportion of their furnishing budget dedicated to our store purchase. The second objective was focused on how we can improve our business and expansion opportunities; thus we gathered data on: 1. our customer satisfaction; 2. what they wanted to see more of and what. We hope that this will provide us with a better idea of what might do well in the store and inform expansion decision e.g. what type of customers are purchasing the different types of wood products (e.g. who is buying Wood and MDF?) as these products have different profit margins. In short, we need someone to help us crunch the numbers and provide us with a summary of findings from the survey. The next part of the project is focused on gaining specific insights about our business. In particular, I am looking for the following: Based on casual observation, my sense is that our biggest shopper segment is established adults above 40 with a significant amounts of annual disposable incomes i.e. with disposable incomes between $80,001 and $100,000 per year. Can you establish whether this conjecture is true? Did the majority of our customers purchase wood products rather than MDF? More precisely, does wood make up more than 50% of our total sales? Of the customers who purchased wooden products, do they spend more than those who purchase MDF products. We're also interested in examining ways on how we can expand our sales e.g. what furniture and furniture type should I be making more of (i.e. wood or mdf)? What advertising media should I be using? Anything you can tell me about how to improve our appeal to our main shopper types would be great!\" Based on these comments, you and your partner draw up a consulting brief, which you send to Mr. Lee. He approves it and hires you and your partner to perform the analysis required to address his concerns. Mr. Lee then sends you an Excel file containing the data from the intercept survey. You and your partner are given the responsibility of providing a statistical analysis of this data and for producing an associated report that addresses Mr. Lee's concerns. Report It is natural to associate different parts of the project work with the coverage of relevant material in particular Sharpe chapters and lectures. However, remember you are writing a professional report, not providing a sequence of answers to assignment problems. Thus, you and your partner should try to write a flowing report organized around ideas, not methods. The report should include a brief Executive Summary. Mr. Lee, your audience, is an intelligent person but he is not a statistician. The Executive Summary needs to be nontechnical so that he can assess what you and your partner have done and understand your basic conclusions. Your colleague at B4CA is familiar with technical analysis, and will be reviewing the report before it is sent out to the client to ensure that the conclusions discussed in the Executive Summary are reasonable and based on sound statistical analysis. You can see from the marking rubric below that while your project mark will be based primarily on the substance of your statistical work, the presentation of the material will also be considered. Reports should be typed and should use appropriate graphical techniques to represent the data, as well as other appropriate statistical analysis. For some guidance on what or how these types of reports might look like, please check the \"Project\" section of Moodle where some actual examples of statistical reports are posted. As is the case in any actual work environment, there is no \"one right way\" to construct a report like this, and hence there is no rigid template for what your project should look like, nor is there only one way to approach the analysis. 2 Data Each student will be assigned a personalized data set. Each individual data set refers to the problem above and has the same structure. However, values of some of the key variables will vary across students, meaning that statistical results and any inferences drawn from them may differ across students. Since this is a pairwise project, please download only one set of data using any one of your zIDs. In the \"Project\" folder on Moodle, you will find an Excel file that you and your partner will download in order to obtain your personalized data set. Once you enter your zID into the highlighted cell in the Excel worksheet, a personalized data set will be generated. Copy and paste the generated data into a new Excel workbook, where you two will conduct your analysis. Each data set contains a sample of 293 observations, where each observation refers to a separate survey response. There are 14 variables, and they are as follows: Variable Description pid FType Survey response identifier Main types of furniture purchased by the respondent from the Store 1 = Storages 2= Entertainment 3 = Dining Tables 4 = Dining Chairs 5 = Indoor Benches 6 = Sofa and Deep Seaters 7 = Occasional Tables 8 = Desks 9 = Outdoor Set How the respondent heard about the Store: 1 = Web search 2 = Store visit 3 = Word of mouth 4 = Store Website 5 = Social media 6 = Junk mail 7 = Other Respondent's estimate of his/her budget for furnishing Amount spent in the 'Store' Respondent's age Total disposable income of the respondent, where: 1 = up to $20,000 per year; 2 = $20,001$40,000 per year; 3 = $40,001$60,000 per year; 4 = $60,001$80,000 per year; 5 = $80,001$100,000 per year; 6 = $100,001 or more per year. Number of years (rounded to nearest year) since the respondent completed the last renovation of his/her home marketing budget spend age Dinc lastreno 3 lastrenospend wood MDF gender csat PFType Amount spent by the respondent on their last renovation Number of wood items purchased by the respondent from the Store Number of MDF items purchased from the Store Gender of the respondent where: 1=male 0=female Respondent's satisfaction of his/her purchase. 1 = very unhappy 2 = unhappy 3 = neutral 4 = happy 5 = very happy Potential furniture types. This describes the main type of furniture the respondent would like to see more of: 0 = Nothing 1 = Storages 2 = Entertainment 3 = Dining Tables 4 = Dining Chairs 5 = Indoor Benches 6 = Sofa and Deep Seaters 7 = Occasional Tables 8 = Desks 9 = Outdoor Set Tutorial work You and your partner should think about the problem and plan what needs to be done before you actually start undertaking extensive computing work. In order to assist in this process, there will be some project discussion time in tutorials. In particular, in your Week 7 tutorial you and your partner will be asked to review the problem and to discuss with other students what is required by way of analysis. You should generate your data, and then copy, paste, and save it into a new Excel workbook that you bring along to class as part of your preparation for your Week 7 tutorial. In this Excel workbook, you and your partner should take time before class to generate some descriptive statistics for your data that both of you can show your tutor in Week 7. This will confirm that the both of you have correctly created your data set and that you and your partner are ready to commence your analysis. These descriptive statistics will also be required to answer a Week 7 tutorial question. In your Week 9 tutorial, time will be devoted to monitoring your progress and discussing how more recently covered material might be relevant to the project tasks. Naturally the both of you should consult your tutor or lecturer should any of you have any other questions regarding the project. 4 Details Length: Cover sheet: Project mark: Due date: Late submission: Plagiarism: Coverage: No longer than 1500 words, excluding tables and graphs. Total length including all discussion, tables and graphs should not exceed 12 pages. Attach the Project Assessment sheet (given below) as your first page. Check that you have completed the top (grey) sections in full, including your signatures. Do not use plastic sheets or binders. Simply attach the completed cover sheet and staple the pages together. The project will be marked out of 20, and will constitute 20% of your total course mark. Only one hard copy of your assignment for you and your partner is to be submitted to your tutor in or before your scheduled tutorial in week 11 (beginning May 15). In addition to the hard copy, you must also submit one electronic copy (for both you and your partner) to the course website by 6 pm on Friday May 19. Upload your assignment via the Turnitin link on the course website. Browse and upload a copy of your document (only one for the both of you) do not paste text. Use both of your student zIDs in the file name (e.g., z1234567&z2345678.doc). 20% of the value of the project will be deducted for every day or part thereof that the hard copy is turned in after the start time of your Week 11 tutorial (including the weekend). Projects submitted more than five days late will not be marked and will be assigned a mark of zero. You and your partner can and should be working on the material regularly before the due date. Extensions will only be granted in exceptional circumstances and must be approved by the lecturerincharge. For more details about late submission, see the Course Outline. All assignments will be checked for plagiarism on the Turnitin software into which they are uploaded. Therefore, you and your partner must submit the soft copy via Turnitin only once. Please refer to \"Due Date\" above for detail. The software will automatically check against all other projects ever submitted. Material copied from previous projects will be found and the source will be identified. Evidence of plagiarism will be treated extremely seriously: automatic and immediate failure in the course is a possible penalty. See Part B of the course outline for further details about UNSW's policies on plagiarism. If you are in doubt about how to identify or avoid plagiarism, follow the link to and complete the selfpaced Working with Academic Integrity module on Moodle. In your work for this project, you are only expected to use the statistical techniques developed in the text and lectures up until the end of week 9. 5 ECON1203 Business and Economic Statistics PROJECT ASSESSMENT Name ___________________________________________ zID __________________ (Member 1) Name ___________________________________________ zID __________________ (Member 2) Workshop Group (Tutor, Time and Place) ____________________________________ (Member 1) Workshop Group (Tutor, Time and Place) ____________________________________ (Member 2) We declare that this assessment item is our own work except where acknowledged, and acknowledge that the assessor of this item may, for the purpose of assessing this item: (1) Reproduce this assessment item and provide a copy to another member of the University; and/or (2) Communicate a copy of this assessment item to a plagiarism checking service (which may then retain a copy of the assessment item on its database for the purpose of future plagiarism checking) We certify that we have read and understood the University Rules in respect of Student Academic Misconduct. Signed ______________________________________ Date _____________________ (Member 1) Signed ______________________________________ Date _____________________ (Member 2) ANALYSIS and DISCUSSION (14 marks) Motivation, production and evaluation of hypotheses (3 marks) Missing ( ) Poor ( ) Adequate ( ) Good ( ) Excellent ( ) Justification of main conclusions (2 marks) Missing ( ) Poor ( ) Adequate ( ) Good ( ) Excellent ( ) Executive summary (2 marks) Missing ( ) Poor ( ) Adequate ( ) Good ( ) Excellent ( ) MECHANICS (6 marks) Characterizing key features of the data (7 marks) Missing ( ) Poor ( ) Adequate ( ) Good ( ) Excellent ( ) Presentation (3 marks) Poor ( ) Adequate ( ) Good ( ) Excellent ( ) Use of graphics (3 marks) Missing ( ) Poor ( ) Adequate ( ) Good ( ) Excellent ( ) Other Some problems with spelling ( ) Poor spelling ( ) Some problems with grammar ( ) Poor grammar ( ) Some confused or offtarget discussion and interpretations ( ) Well argued ( ) Too long (you need to condense your argument) ( ) GENERAL COMMENTS 6