Assignment Questions (Complete in Excel)

Q.1 Select one variable that is categorical: (20% of mark)

a) Perform the appropriate descriptive (summary) analysis for this variable. Show your

work.

b) Interpret the descriptive results (what do the results tell us?); include comments on the

central tendency and variability of responses.

Q.2 Select one variable that is metric (20% of mark):

a) Perform the appropriate descriptive (summary) analysis for this variable. Show your

work.

b) Interpret the descriptive results (what do the results tell us?); include comments on the

central tendency and variability of responses.

Q.3 Using the 95% confidence interval: (20% of mark)

a) Estimate the population value range for the response to survey question #3 - How

satisfied are you with the QUALITY OF COFFEE at The Bean?. Show your work.

b) Explain what the interval tells us (how would you interpret the interval?)

Using the appropriate Excel function for confidence interval, assume an alpha value of: 0.05 (for a 95% level of confidence).

Q.4 Is there a significant difference in the average amount spent per visit at The Bean when comparing those who identify as Male vs Female? Show your work and explain your answer. (20% of mark)

Q.5. Is there a relationship between satisfaction with the Quality of Coffee and Overall Satisfaction with The Bean? If so, how strong is this relationship? Show your work and explain your answer. (20% of mark)