practice the six steps of the analytics of segmenting, targeting, and positing (STP) for Chipotle. In this process, you will run a cluster analysis on either Excel, R, or Python. This case analysis should take you about 45 to 85 minutes. You will need to download these two files:
Chipotle Questionnaire and Data Key (student).docx Download Chipotle Questionnaire and Data Key (student).docx
Chipotle Excel Sheet (student).xlsx Download Chipotle Excel Sheet (student).xlsx
Note, if you want to use R or Python instead of Excel, please view the Excel data above, but there are unique and specific data files for these applications below under the analysis steps section highlighted below that will walk you through running cluster analysis on whichever tool you prefer.
Task #2:
Follow this STP analytics process outlined below, you may use Excel, R, or Python, there are how-to and data sets highlighted below this task.
Open Chipotle.xlsx (found above) in Excel or Google Sheets. And open Chipotle Data Key.docx (found above) in Word or Google Docs.
Classify each variable in the Chipotle dataset as the following (or “none”):
A. Demographic segmentation
B. Psychographic segmentation
C. Behavioral segmentation
D. Outcome
E. Marketing mix
– Product
– Place
– Price
– Promotion
F. Not to be used
3. Decide on a distinct number of clusters (3 or 4), discussing whether there is a marketing reason for this number of clusters.
4. Open Chipotle.xlsx to run a cluster analysis (or R or Python, see highlight section below).
5. Segment the data using the K-means method. Choose whatever variables you think are best for segmentation: demographic, psychographic or behavioral variables. State which you chose and why.
D and is recommended by NICE as a primary treatment (NICE, 2018). It is seen as a cognitive-behavioural treatment combined with aspects of exposure therapy (Boudewyns & Hyer, 1996) and it works by the participant recalling the traumatic events that they experienced whilst simultaneously having their attention directed to a physical bilateral stimulation they are receiving, such as hearing tones in alternating ears, moving eyes rapidly from side to side, or tapping sensations of either side of the body. Similarly to ET, this therapy works by allowing the mind to safely experience traumatic events, letting the mind process them fully in order to heal appropriately (Shapiro, 1996). A systematic narrative review was carried out on the effectiveness of EMDR for PTSD from four randomized control trials and two meta-analyses. It was found that the therapy was able to reduce the symptoms as well as symptoms that were trauma related, and also appeared more effective than other treatments for trauma as well as effective across different cultures. However, there was a consistent limitation which was the small sample sizes. It also did not take into account the amount of people who were withdrawn from the trials. Despite this, EMDR is shown to be able to reduce the symptoms of PTSD by treating the cause of the problem (Wilson, Farrell, Barron, Hutchins, Whybrow & Kiernan, 2018). This, in turn, leads to a lessening of symptoms.
Although the above mentioned therapies may be effective at treating the psychological damages, there is evidence to show that people who suffer with PTSD have physiological changes too. A meta-analysis studied brain regions of PTSD participants compared to controls and found that the hippocampus and left amygdala volumes as well as the anterior cingulate cortex were all significantly smaller compared to controls and trauma-exposed participants (Karl, Schaefer, Malta, Dorfel, Rohleder & Werner, 2006). Other studies have made observations that there are differences in grey matter volumes, hypothalamus, and even the prefrontal cortex between PTSD participants and controls (Flemingham et al, 2009). Multiple types of medication can be prescribed to alleviate the symptoms of PTSD, and these can include anti-depressants, anti-anxiety medication and anti-psychotics (Ipser & Stein, 2012), however the most commonly used in the U.K. as a treatment for PTSD are antidepressants (De Vries, De Jonge, van den Heuvel, Turner & Roest, 201