235x 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.