Please answer the following questions:

1.Using the data on the pilot (cluster-analysis-data.xsls) to do cluster analysis. You need to repeat the analysis five times in order to choose the right number of clusters (from 3 to 7) according to the sum of minimal distance (your objective function in the optimization step). Please use the following four variables in the analysis:

I tend to plan things very carefully

I sometimes have trouble controlling my spending

I think it is important to purchase products that are made locally

I carefully consider the health benefits of what I eat

2.Which cluster should the restaurant chain to target? In answer the question, you need to compare the characteristics between each identified cluster in the first step, and the number of respondents and the percentage of customers. The percentage of customers comes from a survey item: customer(0: no 1: yes). Hint: using pivotTable to get the summary statistics.

3.Which location do you recommend for the new restarant? There are four potentials, as listed in the word file ("Description of new restaurant location options") on Pilot.

B C D E F A I think it is important to customer (0: no I tend to plan things very I sometimes have trouble purchase products that are I carefully consider the health controlling my spending made locally benefits of what I eat 1 obs 1: yes) carefully UI AWN UI A W N 1 IN 3 IN NN 10 2 12 HWNN 1 00 10 18 11 NNWH 12 13 22 14 24 N H 15 25 16 26 17 28 18 29 o o o o o o o O O O O O O O O O O O O O O O O O O O O O O O 0 0 0 N H N F N P N N N N N N N H W N H N N N N N N W N H W N N HW A N N N H H W W H N H N N N H NANNY WINN 19 30 20 31 D A W N W N W A W A W A D N W A N A W W AA DAWNN 21 32 22 34 23 38 HNNNNNNP 24 40 25 41 26 42 27 43 28 45 29 46 30 48 31 49 32 50 NNNNNNAT 33 51 34 52A A B c D E F I think it is important to I tend to plan things very I sometimes have trouble purchase products that are | carefully consider the health 1 . carefully controlling my spending made locally benets of what I eat A A B c D E F customer I think it is important to (0: no I tend to plan things very I sometimes have trouble purd'lase products that are | carefully consider the health 1 obs 1: yes) carefully controlling my spending made locally benets of what I eat 57_ 89 0 2 1 2 58 _ 59. so __ 61 93 0 2 2 62 94 0 1 1 63 95 0 1 1 64 _ 65 as _ 67 103 o 3 68 0 3 1 1 69 0 1 1 2 70 0 1 4 3 71 72 73 _ 74 0 2 75 0 1 76 0 2 77 0 1 78 79 _ so 116 o 3 81 0 1 2 82 0 4 2 83 0 2 2 84 0 3 2 85 as _ 87 126 o 2 _ customer (0: no I tend to plan things very I sometimes have trouble I think it is important to purchase products that are I carefully consider the health 1 obs 1: yes) carefully controlling my spending made locally benets of what I eat 89 us__ \" 1291 91 130 3 93 132 1 3 2 1 95 135 1 2 2 1 96 13711 2 2 97 mm 98 139_ 100 141 2 3 2 2 _ 102 143 1 2 2 1 104 145 1 3 2 3 _ 106 148 2 1 2 2 _ 108 150 2 1 3 3 _ 110 153 2 3 2 2 112 156 1 1 1 1 113 157 -__ 114 mm 115 1511m 1611 117 162 2 119 165 2 3 2 121 D E F customer I think it is important to (0: no I tend to plan things very I sometimes have trouble purd1ase products that are | carefully consider the health 1: yes) carefully controlling my spending made lomlly benets of what I eat 3 2 3 3 3 2 3 2 2 1 2 2 4 4 2 3 2 1 2 2 2 2 2 2 2 2 2 3 2 2 1 2 2 3 2 1 3 2 2 4 2 2 4 1 1 4 2 2 3 2 3 4 3 3 2 2 4 2 1 2 1 1 2 3 3 3 2 2 3 2 2 4 2 2 4 2 2 1 1 2 3 2 2 3 2 2 4 3 2 3 1 2 2 2 2 3 1 2 A A B c D E F customer I think it is important to (0: no I tend to plan things very I sometimes have trouble purd1ase products that are | carefully consider the health 1 obs 1: yes) carefully controlling my spending made locally benefits of what I eat 155 212 o 2 __ 2 156 2 157 3 158 0 4 2 2 159 0 3 2 2 160 0 4 1 3 161 0 2 2 2 162 0 3 2 2 163 m-___ 2 164 2 165_ 1 166 __ 3 167_ 1 mam 2 3 4 159 m 4 170 0 1 1 1 171 0 1 3 2 172 0 1 1 1 173 0 4 3 3 174 0 4 2 1 175 0 2 2 2 116 2 12_ 2 11__ 2 129 249 o 1 _ 2 130 -:__ 4 181 2 182 m 2 183 253 0 3 1 184 254 0 2 2 185 255 0 3 3 186 257 0 2 2 187 258 0 2 3 A B C D E F customer I think it is important to (0: no I tend to plan things very I sometimes have trouble purchase products that are I carefully consider the health 1 obs 1: yes) carefully controlling my spending made locally benefits of what I eat 188 260 189 261 190 264 191 265 192 266 boOOO NAN NA IN 193 267 194 268 NNY 195 269 196 270 197 271 198 272 - P P 199 273 200 274 - H 201 275 202 278 203 279 204 280 205 281 206 283 207 284 208 285 209 86 210 287 211 .88 212 289 213 190 214 291 215 92 216 293 217 218 295 219 296 220 298 N W N H P HH WHWNHANNHWNNNNHWANWNNY NNNNNADWANHWWANWAWNWWAWWWWNWNAW W H N N H W H N N N H N NN HANNNN HANNANNNHAF A B C D E customer I think it is important to I tend to plan things very purchase products that are I carefully consider the health (0: no I sometimes have trouble 1 obs 1: yes) carefully controlling my spending made locally benefits of what I eat 221 299 222 300 223 301 224 302 NNNWWA NNANN 225 303 226 304 227 305 228 306 229 307 230 308 231 309 232 310 233 311 234 312 235 313 236 314 H N N P P P H W H N P P N N H N H W N N N N N W N N N WW HHHH 237 315 238 316 239 317 AHWAHNWWWWNWA N N N N N N N N N N N N N N N H N H N N NN HN WN HANNWANNNHANHHUNNY 240 318 241 319 242 320 243 321 244 322 245 323 246 324 247 325 248 326 249 327 250 328 NNNNNNNNHAH 251 329 252 330 N 153 331 DWANDANADAHWAB E customer I think it is important to (0: no I tend to plan things very I sometimes have trouble purchase products that are | carefully consider the health 1 obs 1: yes} carefully controlling my spending made locally benefits of what I eat 254 332 1 2 2 3 2 255 333 1 1 3 2 2 256 334 1 2 3 2 1 257 335 1 2 4 1 1 258 336 1 1 4 1 2 259 337 1 3 4 2 2 260 338 1 2 2 1 2 261 339 1 3 4 2 2 262 340 1 1 4 2 1 263 341 1 1 4 1 1 264 342 1 1 3 2 1 265 343 1 1 4 2 2 266 344 1 1 4 2 2 267 345 1 2 4 2 2 268 346 1 2 3 2 3 269 347 1 1 4 4 1 270 348 1 2 4 2 1 271 349 1 2 4 2 2 272 350 1 1 1 1 1 273 351 1 2 2 2 1 274 352 1 1 2 1 2 275 353 1 2 2 2 2 276 354 1 1 4 2 1 277 355 1 1 4 2 1 278 356 1 3 4 2 1 279 357 1 2 3 3 2 280 359 1 1 4 1 1 281 360 1 2 2 1 1 282 361 1 2 4 1 1 283 362 1 3 2 1 2 284 363 1 2 2 2 2 285 364 1 1 2 1 1 286 365 1 1 1 1 1 customer I think it is important to (0: no I tend to plan things very I sometimes have trouble purchase products that are | carefully consider the health 1 obs 1: yes) carefully controlling my spending made locally benets of what I eat 287 366 1 2 3 2 3 288 367 1 2 2 2 2 289 368 1 2 4 2 1 290 369 1 2 3 3 3 291 370 1 3 2 2 2 292 371 1 2 3 2 2 293 372 1 1 4 2 2 294 373 1 1 4 1 1 295 374 1 2 2 2 2 296 375 1 2 3 2 2 297 376 1 1 4 1 1 298 377 1 1 2 1 1 299 378 1 2 2 1 1 300 379 1 2 3 2 2 301 381 1 1 4 1 1 302 382 1 3 2 4 3 303 383 1 1 3 2 1 304 384 1 2 3 2 2 305 385 1 2 3 2 2 306 386 1 3 2 2 1 307 387 1 1 4 2 1 308 388 1 2 3 2 2 309 389 1 3 2 2 2 310 390 1 2 2 2 1 311 391 1 1 4 2 1 312 392 1 2 4 1 2 313 393 1 1 4 2 1 314 394 1 2 4 2 1 315 395 1 1 2 2 2 316 396 1 3 2 1 2 317 397 1 2 3 2 3 318 398 1 2 3 1 1 319 399 1 2 3 1 2 E E F A B C D I think it is important to customer I sometimes have trouble purchase products that are I carefully consider the health (0: no I tend to plan things very made locally benefits of what I eat 1 obs 1: yes) carefully controlling my spending 20 400 21 401 $22 402 23 403 24 404 25 406 26 407 27 408 UNNNEN 28 410 $29 411 30 412 $31 413 32 414 33 415 34 416 35 417 36 418 37 419 38 420 :39 421 $40 422 $41 423 H N N H H H W H N H H N N N N H N W N H N N H H N H W N N H N H N N H P N N N N H HANNA N U N D D D A N N N N A H N A N A N A N N N N N A W W N A N N N N A A N NW NADW WN WW 42 424 W N H W WW WW N H W H N W N H N N W N N W N N H HN NN NNWHWNHWNAHNANA 343 425 344 426 $45 427 " N N P P P W N N N P N H W N P N N N H N N H N N H W N HAWNHANNA 346 428 $47 429 348 430 349 431 $50 432 51 433 $52 434 $53 435 54 436 437 $56 438 57 439 $58 440 $59 441 60 442 443 362 444 363 446 64 447 165 448F C D E A B customer I think it is important to (0: no I tend to plan things very I sometimes have trouble purchase products that are I carefully consider the health obs carefully controlling my spending made locally benefits of what I eat 1: yes) 148 149 450 NNP 452 453 154 455 456 457 458 459 160 461 0o 462 463 466 N P P N N N N N N N N N N N H N N H P P P N P N NN NNNNH W AA N W A A N N N A N A H H N A W W H N WNA A WAAAANN H H H N W W N N P N N N N N H N H W N H H H W W H H N N N N H W 467 NUNN NHANHNNNN WHWHHHHANNNANNY 468 469 470 471 472 473 474 475 476 477 OUT A W N 178 479 480 481 182