Section 3: Quantitative Data Analysis
Analyze your quantitative data using descriptive statistics. All work should be done using Excel.
a. Provide a list of your original data sorted in ascending order.
This should be a list of at least 41 numbers that are entered into the spreadsheet.
b. Create a frequency distribution table using the methods described in class.
Show upper and lower class limits, frequencies, relative frequencies, and cumulative frequencies.
c. Create a histogram using the frequencies found in part (b). Be sure to include a title and axis labels. d.
Create a Stem and Leaf display. Be sure to left justify the leaf column.
Section 7: Qualitative Data Analysis
Analyze your qualitative data using descriptive statistics. All work should be done using Excel.
a. Create a frequency table for your categories. Include relative frequencies.
b. Create a Pareto Diagram. Be sure to include a title and axis labels. Nominal data categories should be
sorted from highest frequency to lowest.
c. Create a Pie Chart. Be sure to include a title and axis labels