excel descriptive statistics and visual displays 1

law of supply and law of demand
March 24, 2023
one pager presentation 1
March 24, 2023

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.

SLP ASSIGNMENT EXPECTATIONS

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

  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.
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.