Welcome to ONLC Training Centers

MPP On-Demand: Essential Statistics for Data Analysis using Excel (DAT222x) Course Outline

 (3 days)

*** Note: This is an On-Demand Self Study Class ***
You can take this class at any time; there are no set dates. It features hands-on labs so you can practice new skills at your workstation. Other parts of the course include video lectures that you can view on-the-go from your phone or tablet. In all cases, customers must call us directly to register this class at 800-288-8221.

MPP On-Demand Series
This course is part of the Microsoft Professional Program Series, MPP: Data Science Track. It can be taken individually or as part of the 9-course series, plus a capstone project. You will need to purchase a validated certificate to get credit for this class as part of the MPP. Request the certificate at time of registration.

On-Demand Learner Profiles
MPP On-Demand is a self-study training solution that was designed for two types of learners. First, MPP On-Demand is a great fit for experienced IT professionals who don't need traditional 5-day classes to upgrade their existing skills. They can pick and choose topics to make the most effective use of their time. Second, MPP On-Demand is perfect for highly-motivated individuals who are new to a technology and need to space their learning over a period of weeks or months. These learners can take their time and repeat sections as needed until they master the new concepts.

Verified Certificate Included!
If you plan to use your course for job applications, promotions, or school applications, an MPP certificate will help you get recognized. The certificate is verifiable and is included in all MPP purchases. Itís also a great way to give yourself an incentive to complete the course and celebrate your success. For more information regarding Verified Certificates, go to
MPP Verified Certificates

Gain a solid understanding of statistics and basic probability, using Excel, and build on your data analysis and data science foundation.

This Microsoft authorized class is an online elearning course that should take between 12 to 24 hours of effort, depending on your background.

Course Outline

Descriptive Statistics
Defining Data
Histograms and Skewness
Descriptive Statistics with Analysis ToolPak
Categorical Data, PivotTables, and PivotCharts
Summarizing Hierarchical Data
80-20 Rule and Pareto Charts

Basic Probability
Introduction to Probability
Law of Complements
Mutually Exclusive and Independent Events
Conditional Probability
Law of Total Probability and Bayes Rule
Additional Reading and Review

Random Variables
Random Variable Definitions
Mean, Variance, and Standard Deviation of a Random Variable
Mean, Variance, and Standard Deviation for Sum of Random Variables
Binomial Random Variable
Poisson Random Variable
Normal Random Variable
Central Limit Theorem
Z Scores

Sampling and Confidence Intervals
Populations and Samples
Point Estimation of a Population Mean and Proportion
The Standard Normal
Confidence Interval Estimation
Sample Size Determination
The Finite Correction Factor
Additional Reading

Hypothesis Testing
Defining Hypotheses
Type I and Type II Error
One Sample Z-Test
One Sample T-Test
Single Sample Test for Population Proportion
Testing Equality of Variances
Testing the Difference Between Two Population Means
Chi-Squared Test for Independence
Additional Reading

View outline in Word


Attend hands-on, instructor-led MPP On-Demand: Essential Statistics for Data Analysis using Excel (DAT222x) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name