Descriptive Statistics Summarizing qualitative data Summarizing quantitative data
- Slides: 22
Descriptive Statistics • Summarizing qualitative data • Summarizing quantitative data
Summarizing Qualitative Data • • • The frequency distribution The relative frequency distribution The percent frequency distribution The pie graph The bar graph
Frequency Distribution A frequency distribution is a tabular summary of data showing the frequency (or number) of items in each of several nonoverlapping classes. The objective is to provide insights about the data that cannot be quickly obtained by looking only at the original data.
Marada Inn Example Guests staying at Marada Inn were asked to rate the quality of their accommodations as being excellent, above average, below average, or poor. The ratings provided by a sample of 20 guests are: Below Average Above Average Above Average Below Average Poor Above Average Excellent Above Average Average
Frequency Distribution Rating Poor 2 Below Average 3 Average 5 Above Average 9 Excellent 1 Total 20
Using Excel’s COUNTIF function to construct a frequency distribution Formula Worksheet Rows 9 -21 not shown
Relative Frequency Distribution • The relative frequency of a class is the fraction or proportion of the total number of data items belonging to the class. • A relative frequency distribution is a tabular summary of a set of data showing the relative frequency for each class.
Percent Frequency Distribution • The percent frequency of a class is the relative frequency multiplied by 100. • A percent frequency distribution is a tabular summary of a set of data showing the percent frequency for each class.
Using Excel’s COUNTIF function to construct a frequency distribution Value Worksheet Rows 9 -21 not shown
Relative Frequency and Percent Frequency Distributions Rating Relative Frequency Poor Below Average Above Average Excellent Total . 10. 15. 25. 45. 05 1. 00 Percent Frequency 10 15 25 45 5 100 . 10(100) = 10 1/20 =. 05
Using Excel’s COUNTIF function to construct a percent frequency distribution Formula Worksheet Rows 9 -21 and columns A-B are not shown
Using Excel’s COUNTIF function to construct a percent frequency distribution Value Worksheet Rows 9 -21 and columns A-B are not shown
Bar graph • These are used to display qualitative data. • On one axis (usually the horizontal axis), we specify the labels that are used for each of the classes. • A frequency, relative frequency, or percent frequency scale can be used for the other axis (usually the vertical axis).
Bar Graph Marada Inn Quality Ratings 10 9 The bars are separated to emphasize the fact that each class is a separate category. Frequency 8 7 6 5 4 3 2 1 Poor Below Average Above Excellent Average Rating
Using Excel’s Chart Wizard to Construct Bar Graphs Step 1 Step 2 Step 3 Select cells C 1: D 6 Click the Chart Wizard button When the Chart Type dialog box appears: Choose Column in the Chart type list Choose Clustered Column from the Chart sub-type display Click Next > Step 4 When the Chart Source Data dialog box appears Click Next > … continued
Using Excel’s Chart Wizard to Construct Bar Graphs Step 5 When the Chart Options dialog box appears: Select the Titles tab and then Type Marada Inn Quality Ratings in the Chart title box Type Quality Rating in the Value (X) axis box Type Frequency in the Value (Y) axis box Select the Legend tab and then Remove the check in the Show Legend box Click Next > … continued
Using Excel’s Chart Wizard to Construct Bar Graphs Step 6 When the Chart Location dialog box appears: Specify the location for the new chart Click Finish to display the bar graph
Using Excel’s Chart Wizard to Construct Bar Graphs
Soft Drink Demonstration Note: Excel file contained on text CD (Chapter 2 --Softdrink
Pie Chart n The pie chart is a commonly used graphical device for presenting relative frequency distributions for qualitative data. n First draw a circle; then use the relative frequencies to subdivide the circle into sectors that correspond to the relative frequency for each class. n Since there are 360 degrees in a circle, a class with a relative frequency of. 25 would consume. 25(360) = 90 degrees of the circle.
Above Average 45% Below Average 15% Average 25%
Soft Drink Demonstration Note: Excel file contained on text CD (Chapter 2 --Softdrink
- Frequency distribution for qualitative data
- Data analysis qualitative and quantitative
- Qualitative data quantitative data
- Summarizing quantitative data
- Summarizing quantitative data
- Summarizing quantitative data
- Summarizing quantitative data
- Data gathering for quantitative research
- Qualitative vs quantitative
- Qualitative and quantitative data difference
- Qualitative and quantitative data analysis
- Is a bipolar survey qualitative or quantitative
- What is holistic perspective in qualitative research
- Longitudinal study qualitative or quantitative
- Qualitative vs quantitative measurements
- What is quantitative data biology
- Telephone number quantitative or qualitative
- Quantitative vs qualitative
- Quantitative vs qualitative observations
- Different between qualitative and quantitative
- Quantitative variables examples
- Qualitative quantitative differenzierung
- Density qualitative or quantitative