This assignment is based on the cardiogood fitness case

Question

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.

Answer 1

Review the case study named - CardioGood Fitness Case, Chapter 3 (page 144) sections and performs the following tasks. Question: Prepare 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 must exhibit the given descriptive statistics for each and every variable: a) Mean b) Median c) 1st Quartile d) 3rd Quartile e) Sample variance f) Sample standard deviation The tables must encompass titles and must be clear and simple to read. Make use of clear and consistent formatting. For illustration, format dollar values as dollar values, make use of a consistent number of places after the decimal point, use borders around your tables and so on.