A cruise line has a loyalty program for regular customers. The table just below shows how many days sailed, the name of the loyalty level and the code. For example, a customer that has sailed $10$ days with the cruise line $(1-29$ days$)$ would be a gold member and would get the code $"2."$

$\backslash$table$[[$#Days,Group Name,Code$],[0,$Blue,$1],[1-29,$Gold,$2],[30-49,$Ruby,$3],[50-149,$Platinum,$4],[150+,$Elite,$5]]$

Use the dataset attached here under the label "QUES $21"$ and do the following:

Exam$3-$data.x$|$sx

For each customer, use vlookup to put the code for each for number of days sailed. For example, customer $1$ is a gold member $(20$ days is between $1-29)$ so in the next column on Excel, put a $"2"$ next to the number of days sailed. Repeat this for the whole dataset.

Sum the column of codes. Give the sum $($whole number$)$ as your answer below.

Which of the following are discreet variables $($select all that apply$)?$

# sales rung up each week

customer travel distance

total salesperson hours clocked in$/$out per day

location A or B $($where purchase was made$)$

a normal distribution

purchaser postal$/$zip code

customer year of birth

none of the above are discrete