Assignment: Numerical Descriptive Statistics
General Instructions:
- For this assignment you will be using Excel to calculate numerical descriptive statistics that describe customers of a fitness equipment company
- Purpose of assignment:
- Practice calculating descriptive statistics for selected variables from a data file
- This is an individual assignment
Assignment Tasks:
This assignment is based on the CardioGood Fitness Case, Chapter 3 (page 144) sections. The data for the case is stored in the attached spreadsheet file. Please read the text of the case and then perform the following tasks:
1. Create two tables of descriptive statistics for the fitness, miles, and income variables, one table for product TM195 and one table for product TM498. The tables should show the following descriptive statistics for each variable:
a. Mean
b. Median
c. 1st Quartile
d. 3rd Quartile
e. Sample variance
f. Sample standard deviation
g. Coefficient of variation
h. Maximum
i. Minimum
j. Range
k. Count
l. Skewness
m. Kurtosis
The tables should have titles, and should be clear and easy to read. Use clear and consistent formatting. For example, format dollar values as dollar values, use a consistent number of places after the decimal point, use borders around your tables, etc.