Frequency Distributions in Statistics
Frequency Distributions in Statistics
Dobbah Alghamdi
Department of Statistics
Faculty of Sciences
Building 90, Office 26F41
King Abdulaziz University
[Link]
Main Reference
Elementary Statistics
A Step by Step Approach
By
Allan Bluman
1
Chapter 2
Frequency Distributions
and
Graphs
Objectives
2-1
Other types of graphs such as time series graph and stem and leaf
plot are presented.
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
2
Introduction
2-2
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Organizing Data
2-3
When data are collected in their original form, they are called raw
data.
Example: Blood Type Data
A B B AB O O A O O B A B O AB
O AB B B A A O B B O O O A O
Then, the raw data can be organized into a table form that is called
frequency distribution using classes and frequencies.
Types of frequency distributions are categorical frequency
distribution, ungrouped frequency distribution and grouped
frequency distribution
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
3
Categorical Frequency Distributions
2-4
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Instructions:
• Open Excel
• Enter the data in
column A
• Enter the values
of 1’s in column
B
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
4
Categorical Frequency Distributions
2-6
Instructions:
• Select INSERT
• Select PivotTable
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Instructions:
• Select OK
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
5
Categorical Frequency Distributions
2-8
Instructions:
• Drag the variable
BLOOD TYPE
into the ROWS
area
• Drag the constant
FREQ into the
VALUES area
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Instructions:
• Rename the table
columns as
Blood Type
Frequency
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
6
Categorical Frequency Distributions
2-10
Instructions:
• Select the table
• Press Ctrl+C to
copy the table
• Press Ctrl+V to
paste the table
into your
document
• Edit the table
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
7
Categorical Frequency Distributions
2-12
Instructions:
• Select ANALYZE
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Instructions:
• Select Fields,
Items & Sets
• Select Calculated
Field
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
8
Categorical Frequency Distributions
2-14
Instructions:
• Enter the name of
the variable as
Percent
• Enter the Formula
for calculating the
percent as
FREQ/28
• Select OK
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Instructions:
• Select column C
• Select HOME
• Select % to change
the format of the
column to %.
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
9
Categorical Frequency Distributions
2-16
Instructions:
• Select the table
• Copy and paste it
into your document
• Edit the table
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Sample Size
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
10
The Most Common Graphs for Categorical Data
2-18
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
11
The Most Common Graphs for Categorical Data
2-20
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
Blood Type
A
21%
O
39%
AB
11%
B
29%
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
12
The Most Common Graphs for Categorical Data
2-22
The bar charts display the data using vertical bars of various heights
to reflect the frequencies of the categories. It is the best graph for
displaying the ordinal level or discrete type of data.
Example: Education levels
Education Level Frequency
Level 1 47
Level 2 15
Level 3 12
Level 4 7
Level 5 19
Total 100
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
13
The Most Common Graphs for Categorical Data
2-24
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
14
Ungrouped Frequency Distributions
2-26
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
15
Ungrouped Frequency Distributions
2-28
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
16
Ungrouped Frequency Distributions
2-30
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
17
Ungrouped Frequency Distributions
2-32
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
The bar charts display the data by using vertical bars of various
heights to reflect the frequencies of the categories. It is the best graph
for displaying the discrete type of data or ordinal level of qualitative
data.
Example: Number of patients
9
8
No. of Patients Frequency 7
4 8 6
5
5 3 4
3
8 5 2
Grand Total 16 1
0
4 5 8
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
18
The Most Common Graphs for Categorical Data
2-34
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
19
Grouped Frequency Distributions
2-36
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
20
Grouped Frequency Distributions
2-38
Class Rules
There should be between 5 and 20 classes.
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
21
Grouped Frequency Distributions
2-40
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
22
Grouped Frequency Distributions
2-42
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
23
Grouped Frequency Distributions
2-44
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
24
Grouped Frequency Distributions
2-46
40 100.0
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
20
15
10
Birthweight
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
25
The Most Common Graphs for Continuous Data
2-48
Percent
20.0
paste it into your 15.0
document 10.0
5.0
0.0
32 51 70 89 108 127 146
Birthweight
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
50.0
25.0
0.0
32 51 70 89 108 127 146
Birthweight
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
26
Other Types of Graphs
2-50
The time series graph represents data that occur over a specific
period of time.
Example: Yearly cargo and mail traffic of an airline
Instructions:
• Copy the data table Cargo and Mail
Year
Traffic
into Excel sheet 1998 199368
1999 203402
2000 209102
2001 192702
2002 214587
2003 203480
2004 222418
2005 221344
2006 198063
2007 209119
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
The time series graph represents data that occur over a specific
period of time.
Example: Yearly cargo and mail traffic of an airline
Instructions:
• Edit the table
• Select Cargo and
Mail Traffic,
column B
• Select INSERT
• Select Line Chart
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
27
Other Types of Graphs
2-52
The time series graph represents data that occur over a specific
period of time.
Example: Yearly cargo and mail traffic of an airline
Instructions:
• Edit the graph by
selecting the
horizontal axis
• Click right on the
mouse
• Select Select Data
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
The time series graph represents data that occur over a specific
period of time.
Example: Yearly cargo and mail traffic of an airline
Instructions:
• Select Edit on the
right box
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
28
Other Types of Graphs
2-54
The time series graph represents data that occur over a specific
period of time.
Example: Yearly cargo and mail traffic of an airline
Instructions:
• Select the data in
Year, column A
• Click OK
• Click OK again
• Copy the graph
into your document
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
The time series graph represents data that occur over a specific
period of time.
Example: Yearly cargo and mail traffic of an airline
Instructions:
• Edit the graph Cargo and Mail Traffic
225000
220000
215000
210000
205000
200000
195000
190000
185000
180000
175000
1998 1999 2000 2001 2002 2003 2004 2005 2006 2007
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
29
Other Types of Graphs
2-56
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
30
Grouped Frequency Distributions
2-58
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
31
Grouped Frequency Distributions
2-60
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
32
Grouped Frequency Distributions
2-62
Summary
2-63
When data are collected in the original form, they called raw data.
Since little information can be obtained from raw data, they must
be organized in a frequency distribution.
Categorical frequency distribution is used for qualitative data
(nominal or ordinal)
Ungrouped frequency distribution is used for discrete data.
Grouped frequency distribution is used for continuous data.
Pie chart is used mostly to represent nominal data.
Bar chart are used mostly to represent discrete and ordinal data.
Histogram, frequency polygon and ogive graphs are used to
represent continuous data.
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
33
Summary
2-64
Time series graph is used to represent data that occur over specific
period of time.
Stem and leaf plot is a combination of sorting and graphing. It
retains the actual data while showing them graphically.
© All rights are preserved for Dr. Saeed A. Dobbah Alghamdi, Department of Statistics, Faculty of Sciences, KAU
34