# Essential Statistics for Data Analysis using Excel

Archived
Course
en
English
12 h
This content is rated 5 out of 5

You can't access an archived course

Conditions
• Self-paced
• Free Access
• Fee-based Certificate
• 6 Sequences
• Intermediate Level

## Course details

### Syllabus

Module 1: Descriptive Statistics
You will learn how to describe data using charts and basic statistical measures. Full use will be made of the new histograms, Pareto charts, Boxplots, and Treemap and Sunburst charts in Excel 2016.

Module 2: Basic Probability
You will learn basic probability including the law of complements, independent events, conditional probability and Bayes Theorem.

Module 3: Random Variables
You will learn how to find the mean and variance of random variables and then learn about the binomial, Poisson, and Normal random variables. We close with a discussion of the beautiful and important Central Limit Theorem.

Module 4: Sampling and Confidence Intervals
You will learn the mechanics of sampling, point estimation, and interval estimation of population parameters.

Module 5: Hypothesis Testing
You will learn null and alternative hypotheses, Type I and Type II error, One sample tests for means and proportions, Tests for difference between means of two populations, and the Chi Square Test for Independence.

### Prerequisite

• Secondary school (high school) algebra
• Ability to work with tables, formulas, and charts in Excel
• Ability to organize and summarize data using Excel analytic tools such as tables, pivot tables, and pivot charts
• Excel 2016 is required for the full course experience. Excel 2013 will work but will not support all the visualizations and functions

### Instructors

Liberty J. Munson
Microsoft

Matthew Minton
Senior Content Publishing Manager
Microsoft

Wayne Winston
Professor Emeritus of Decision Sciences at the Kelly School of Business
Indiana University

### Editor

Microsoft Corporation is an American multinational technology company headquartered in Redmond, Washington, that develops, manufactures, licenses, supports and sells computer software, consumer electronics and personal computers and services. Its best known software products are the Microsoft Windows line of operating systems, Microsoft Office office suite, and Internet Explorer web browser.

### Platform

Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

This content is rated 5 out of 5
(no review)
This content is rated 5 out of 5
(no review)
Complete this resource to write a review