Assume once again that you are a consultant who works for the Diligent Consulting Group. You collected only the “Age” of customers i
EXCEL, DESCRIPTIVE STATISTICS, AND VISUAL DISPLAYS
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:
Calculate mean, median, mode, range, standard deviation, and skewness for both variables using the Descriptive Statistics tool in Excel.
What are the characteristics of the “average” customer?
What are the characteristics of the “typical” customer?
Comment on the skewness of the variables: Which variable is most skewed? Which variable is least skewed?
Given your answers to question 4 above, which measure of central tendency best describes customers?
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
