Assignment: Graphical and Numerical Descriptive Statistics
General Instructions:
For this assignment you will practice using descriptive statistics to help a fitness equipment company better understand their customers.
urpose of assignment:
- Practice generating summary tables, histograms, and descriptive statistics for selected variables from a data file
- Practice drawing conclusions from descriptive statistics and communicating them in a professional manner
- This is an individual assignment
Assignment Tasks:
This assignment is based on the CardioGood Fitness Case, Chapter 2 (page 83) section. The data for the case is stored in the attached spreadsheet file (CardioGoodFitness.xlsx). Please read the text of the case in the textbook and then perform the following tasks:
1. Create two summary tables (similar to table 2.2 on p. 38), one for product TM195 and one for product TM498. The tables should display the percentages of purchasers of the product for each fitness level (1-5).
2. For product TM195 and TM498 create a distribution table that displays frequency and percentage for average number of miles the customer expects to run/walk each week. Then, create histograms from the distribution tables. (To recap, for each product you will be creating a distribution table and a histogram. So, you will be creating a total of two distribution tables and two histograms).
3. Write a business memo/report comparing and contrasting customers purchasing product TM195 with product TM498. Include the tables and graphs you created in the memo/report and refer to them for evidence as you compare and contrast the customers. (Please limit your analysis to the variables we have addressed in this assignment: fitness and miles. That is, you do not need to comment on the other variables in the data file.)