Please answer the following questions:

Using the data on the pilot $($cluster$-$analysis$-$dataxsls$)$ 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

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.

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"