Data, Statistical & Research Analysis with Microsoft Excel complete master class course.
About Course
A complete guide into statistical & research analysis.
Highlights:
Statistical calculations, Demographic analysis, Statistical charts, Research, Survey, Questionnaires, Inferences, Statistical tests, Hypothesis.
Statistical & Research analysis is the science of investigating trends, patterns, and relationships using quantitative data.
Also, It is an important and demanding skill used by scientists, governments, businesses, academic institutes, and other organizations.
In addition, this course provides the most complete, detailed, interactive, and practical training on Statistical & Research Analysis with Microsoft Excel.
The course is divided into six (6) practical sections;
1. Basic Statistical Calculations
2. Statistical Charts and maps
3. Demographic/Population Analysis/Dashboard
4. Descriptive statistics
5. Research analysis & Questionnaires
6. Statistical tests.
Serving as a Guardian for you to know how to make witted summation aiding your statistical efficiency.
Course Content
INTRODUCTION TO DATA ANALYSIS
-
Introduction to Data Analysis
00:00 -
Agenda and Principles of Process Management
06:28 -
The Voice of the Process
04:36 -
Working as One Team for Improvement
00:00 -
Exercise: The Voice of the Customer and the Voice of the Process
00:00 -
An Introduction to Performance Data Tools for Data Analysis that Works
00:00 -
The Pareto Chart: Highlighting Priorities
00:00 -
The Histogram: Showing the Range Performance
00:00 -
The Run Chart: Showing Performance Over Time
00:00 -
Exercise: Presenting Performance Data
00:00 -
Understanding Variation
00:00 -
The Control Chart Highlighting the Variation in the Data
00:00 -
Control Chart Example
00:00 -
Control Chart Special Cases
00:00 -
Interpreting the Control Chart
00:00 -
Exercise: The Control Chart
00:00 -
Strategies to Deal with Special Cause and Common Cause Variation
00:00 -
Using Data to Drive Improvement
00:00 -
A Structure for Performance Management
00:00 -
Exercise: Data Analysis
00:00 -
Project: Making a Start with Data Analysis and Performance Management
00:00 -
Test your Understanding
00:00 -
Introduction to Data Analysis
-
Module Summary
00:00