Statistics table

Extra Credit Assignment for ADMN 210 – Spring 2020

Case study, Starbucks

The case study for extra credit deals with Starbucks debit cards. The description of the database is found at the end of chapter 13 (yes, I know we didn’t do that chapter…we are just using it for this case). Here’s what I would like you to do:

1) As a review of chapter 2, create a frequency distribution for the age of the customer. In other words, form a pivot table for age. Draw the appropriate type of graph to display the data.

2) As a review of chapter 3, calculate descriptive stats for age. In other words, find the measures of central tendency (mean, median, and mode) and measure of spread (standard deviation). Also, find skewness and kurtosis and interpret…are the data skewed (lopsided) or symmetrical, and are they peaked or flat or approximately bell shaped?

3) As a review of chapter 8, find the 95% confidence interval for income, and interpret.

4) Previously, it was known that people put an average of $25 on the pre-paid card. A researcher believes the figure has increased. Do the data indicate that the amount on the debit cards has significantly increased? As a review of chapter 9, perform a hypothesis test using a 5% level of significance.

5) As a review of chapter 12, develop a regression model to study how well the amount of the prepaid card can be predicted by income. Interpret the printout completely (r, r-squared, and the model). Then predict dollar amount for a person earning $40,000.

Upload your Excel file and interpretations to Blackboard. BTW, the interpretations can either be place in Excel (in a way that I can find them please!) or in a Word document.