Unlock Over 2,000 Lessons
Subscribe today and join the thousands of worldclass organizations already learning with Gemba Academy.
Generating Descriptive Statistics in Microsoft Excel
Learn how to quickly generate descriptive statistics using Microsoft Excel.
Course Videos
The 7 QC Tools Overview
04:44
2QC Tool 1 - The Graph
03:57
3Bar Charts
02:39
4Broken Line Graphs
02:50
5Pie Charts
02:59
6Band Graphs
03:17
7Radar Charts
02:35
8QC Tool 2 - The Check Sheet
03:59
9QC Tool 3 - The Pareto Chart
03:40
10Creating a Pareto Chart in Microsoft Excel
04:04
11QC Tool 4 - The Cause & Effect Diagram
08:02
12Basic Statistics
03:42
13Measures of Central Tendency
04:15
14Measures of Dispersion
04:29
Current Video
Generating Descriptive Statistics in Microsoft Excel
04:04
Next VideoQC Tool 5 - The Scatter Diagram
04:00
17Creating Scatter Diagrams and Regression Statistics in Microsoft Excel
06:12
18QC Tool 6 - The Histogram
04:31
19Calculating Cp and Cpk
05:21
20Creating Histograms and Cp and Cpk Statistics in Microsoft Excel
02:35
21QC Tool 7 - The Control Chart
03:24
22Creating Control Charts in Microsoft Excel
04:17
You must be logged in to access Gemba Academy resources.
Video Resources
Course Resources
Quiz
Next Video QC Tool 5 — The Scatter Diagram
Learn what the Scatter Diagram is and how to create one. Also, learn about Simple Linear Statistics, such as R Squared and how to build predictive statistical models.