Excel, Descriptive Statistics
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.
Leave a Reply
Want to join the discussion?Feel free to contribute!