Download the Excel sheet and find the tab with your name. Clean the data and create calculated variables as follows:

Clean Gender and create "Gender$1$M$2$F$"$ with code Males$=1$ and Females$=2$

Clean Week and Day to numeric variables

Create a continuous variable "Time to first purchase" $=$ week$+($day$/7)$

Calculate "Total Satisfaction"$=$satisfaction$1+...+$satisfaction$6$

Create variable "Time Category" based off of the "Time to first purchase" variable created above where:

If Time to first Purchase is $<10,$ then Time Category$=1$

If Time to first Purchase is between $10-30,$ then Time Category$=2,$

If Time to first Purchase is$>30,$ then Time Category$=3$

Use VLOOKUP to bring your Score into the Basket column: $=$VLOOKUP$($B$2,$Score,$2,$FALSE$)$

Calculate a random number in the Scores column based on your Score: $=$IF$($C$2>5,$RANDBETWEEN$(40,90),$RANDBETWEEN$(10,60))$