excel descriptive statistics and visual displays 1

Assume once again that you are a consultant who works for the Diligent Consulting Group. You collected only the “Age” of customers in the Module 1 Case scenario. You realized, however, that you need more customer information and collected the following additional variable: “Annual Amount Spent on Organic Food.” You want to conduct additional analysis on this customer database.


Complete the following tasks in the Module 1 SLP assignment template:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
  1. Calculate mean, median, mode, range, standard deviation, and skewness for both variables using the Descriptive Statistics tool in Excel.
  2. What are the characteristics of the “average” customer?
  3. What are the characteristics of the “typical” customer?
  4. Comment on the skewness of the variables: Which variable is most skewed? Which variable is least skewed?
  5. Given your answers to question 4 above, which measure of central tendency best describes customers?
  6. Comment on additional variables that would be useful to collect in order to analyze customers in greater detail. List at least two additional variables and explain why they are important for this analysis.