Statistics for Data Analysis Using Excel 2016
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Plain & Simple Lessons on Descriptive & Inferential Statistics Theory With Excel Examples for Business & Six SigmaDescription
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 workplace 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 concepts. 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.
The 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.
Note: We are not a representative of ASQ®, IASSC® or any other certification organization.
ASQ® is the registered trademark of the American Society for Quality.
IASSC® is the registered trademark of the International Association for Six Sigma Certification.
We are an independent training provider. We are neither associated nor affiliated with the certification organization(s) mentioned in our courses. The name and title of the certification exam mentioned in this course are the trademarks of the respective certification organization. We mention these names and/or the relevant terminologies only for describing the relevant exam processes and knowledge (i.e. Fair Use).
Requirements
- You should have some basic understanding of Microsoft Excel.
Sandeep Kumar Â
4.7 Raiting
Complete Introduction to Business Data Analysis
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Move beyond BASIC reports and learn data ANALYSIS. Learn to easily turn data into information, insight and intelligence Just take a look at the recent comments and reviews!...
From Beginner to Master of Pivot Tables - Best Tool in Excel
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Pivot Tables are the your most important tool in your Excel tool belt! Over 1500+ enrolled since January 2016! One of Udemy's fastest growing courses!...
Learn By Example: Statistics and Data Science in R
- 3.8
-
![]()
![]()
![]()
![]()
![]()
A gentle yet thorough introduction to Data Science, Statistics and R using real life examples Taught by a Stanford-educated, ex-Googler and an IIT, IIM - educated ex-Flipkart lead analyst....
Excel Power Tools for Data Analysis
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot and Power BI, three power tools for transforming, analysing and presenting data....
