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

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

*** 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.


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

Duration
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
Boxplots
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

DAT222x
View outline in Word

ED222X

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.