MPP On-Demand: Essential Statistics for Data Analysis using Excel (DAT222x) Course Outline
*** 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.
Histograms and Skewness
Descriptive Statistics with Analysis ToolPak
Categorical Data, PivotTables, and PivotCharts
Summarizing Hierarchical Data
80-20 Rule and Pareto Charts
Introduction to Probability
Law of Complements
Mutually Exclusive and Independent Events
Law of Total Probability and Bayes Rule
Additional Reading and Review
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
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
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
View outline in Word