433x Filetype XLS File size 1.09 MB Source: people.highline.edu
Descriptive Statistics: Tabular and Graphical Summarization
Why? Because it is hard to see patterns and trends when you are looking at
Raw Data! Our Goal is to create useful information from the raw data so that
we can see patterns and trends. This will help in Decision Making.
Data
Categorical Quantitative
Data Data
Tabular Graphic Tabular Graphic
Methods Methods Methods Methods
1) Frequency Distr. Charts: 1) Frequency Distr. 1) Dot Plot
2) Relative/Percent 1) Column 2) Relative/Percent 2) Histogram
Frequency Distr. 2) Pie Frequency Distr. 3) Ogive
3) Crosstabulation 3) Cumulative 4) Stem & Leaf
Frequency Distr. Display
4) Cumulative 5) Scatter
Relative/Percent Diagram
Frequency Distr.
5) Crosstabulation
Item
Number Topic Excel Feature Data Type
1 Frequency Distribution Formula Categorical Data
2 Relative Frequency Distribution Formula Categorical Data
3 Percent Frequency Distribution Formula Categorical Data
Column Chart From Frequency Distribution Made With
4 Formula Chart Categorical Data
5 Frequency Distribution Pivot Table Categorical Data
6 Relative Frequency Distribution Pivot Table Categorical Data
7 Percent Frequency Distribution Pivot Table Categorical Data
Pie Chart From Percent Frequency Distribution Made
8 With Pivot Table Chart Categorical Data
9 Cross Tabulation Pivot Table Categorical Data
10 Percentage Cross Tabulation Pivot Table Categorical Data
11 Cross Tabulation Formula Categorical Data
12 Percentage Cross Tabulation Formula Categorical Data
13 Pareto Chart Chart Categorical Data
14 Using Other Categories Formula Categorical Data
15 Using Other Categories Pivot Table Categorical Data
16 Frequency Distribution Formula Quantitative Data
17 Relative & Percent Frequency Distribution Formula Quantitative Data
Cumulative & Percent Cumulative Frequency
18 Distribution Formula Quantitative Data
Histogram Chart From Frequency Distribution Made
19 With Formula Chart Quantitative Data
20 Ogive Chart Chart Quantitative Data
21 Skew Chart Quantitative Data
Frequency Distribution where Source Data are Integers
22 (Pivot Table Grouping Sees Data) Pivot Table Quantitative Data
Frequency Distribution where Source Data are Decimals
(Pivot Table Grouping Sees Data) (Use Replace Feature
23 to Change Pivot Table Labels) Pivot Table Quantitative Data
24 Relative Frequency Distribution Pivot Table Quantitative Data
25 Percent Frequency Distribution Pivot Table Quantitative Data
Histogram Chart From Frequency Distribution Made
26 With Pivot Table Chart Quantitative Data
Cumulative & Percent Cumulative Frequency
27 Distribution Pivot Table Quantitative Data
28 Dot Plot Chart Formula Quantitative Data
29 Stem & Leaf Chart Formula Quantitative Data
30 Cross Tabulation Pivot Table Quantitative Data
31 Scatter Diagram Chart Quantitative Data
Data Analysis Add-in: Frequency Distribution, Histogram
32 & Percent Cumulative Chart (and creating labels) Data Analysis Quantitative Data
Type Of
Descriptive Number of
Statistic Variables
Tabular 1
Tabular 1
Tabular 1
Graphical 1
Tabular 1
Tabular 1
Tabular 1
Graphical 1
Tabular 2
Tabular 2
Tabular 2
Tabular 2
Graphical 1
Tabular 1
Tabular 1
Tabular 1
Tabular 1
Tabular 1
Graphical 1
Graphical 1
Graphical 1
Tabular 1
Tabular 1
Tabular 1
Tabular 1
Graphical 1
Tabular 1
Graphical 1
Graphical 1
Tabular 2
Graphical 2
no reviews yet
Please Login to review.