Statistics for Data Analysis Using Excel 2016
What you'll learn
- You will learn Descriptive and Inferential Statistics with the help of simple but practical examples.
- You will learn to use the power of Microsoft Excel to perform statistical calculations for you. No need to remember long formulas and equations.
- You will understand statistics from basic to advance level to solve business problems using Microsoft Excel.
- You will learn to make sense out of vast amount of data around you, to make fact based decisions.
Course content
- Preview04:37
- 04:59Statistics Defined
Requirements
- You should have some basic understanding of Microsoft Excel.
Description
Start loving data and making sense of it. Leverage the power of MS Excel to make it easy!
Learn statistics, and apply these concepts in your work place using Microsoft Excel.
This course is about Statistics and Data Analysis. The course will teach you the basic concepts related to Statistics and Data Analysis, and help you in applying these concept. Various examples and data-sets are used to explain the application.
I will explain the basic theory first, and then I will show you how to use Microsoft Excel to perform these calculations.
Following areas of statistics are covered:
Descriptive Statistics - Mean, Mode, Median, Quartile, Range, Inter Quartile Range, Standard Deviation
Data Visualization - 3 commonly used charts: Histogram, Box and Whisker Plot and Scatter Plot
Probability - Basic Concepts, Permutations, Combinations
Population and Sampling
Probability Distributions - Normal, Binomial and Poisson Distributions
Hypothesis Testing - One Sample and Two Samples - z Test, t Test, p Test, F Test, Chi Square Test
ANOVA - Perform Analysis of Variance (ANOVA) step by step doing manual calculation and by MS Excel.
Who this course is for:
- Business managers and data analysts who are trying make decision based on data and facts
- Six Sigma Green and Black Belt professionals using MS Excel to conduct statistical analysis
Featured review
![Rajeev R Prasad](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Instructor
- 4.5 Instructor Rating
- 30,121 Reviews
- 146,828 Students
- 25 Courses
PMI-PMP, IRCA Registered Lead Auditor, ASQ - CSSBB, CQA, CQE, CMQ/OE, IIA - CIA
Sandeep Kumar has more than 35 years of Quality Management experience. He has worked as Quality Manager/Director on a number of projects, including Power, Oil and Gas and Infrastructure projects.
In addition, he provides consulting services to implement Lean Six Sigma to improve performance.
His areas of specialization include Quality Assurance, ISO 9001:2015, Lean, Six Sigma, Risk Management, QMS Audits, Supplier Quality Surveillance, Supplier Pre-qualification, Construction Quality, Mechanical Inspection and Quality Training.
Professional Qualifications:
His professional qualification/certifications include:
• ASQ-CSSBB, Certified Six Sigma Black Belt
• ASQ-CMQ/OE Certified Manager of Quality/Organizational Excellence
• PMI-PMP Certified Project Management Professional
• IRCA Registered Lead Auditor (QMS-2015)
• IIA-CIA Certified Internal Auditor
• ASQ-CSSGB, Certified Six Sigma Green Belt
• ASQ-CQA Certified Quality Auditor
• ASQ-CQE Certified Quality Engineer