Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Statistics for Data Analysis Using Excel 2016

via Udemy

Overview

Plain & Simple Lessons on Descriptive & Inferential Statistics Theory With Excel Examples for Business & Six Sigma

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.

>>> 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 aboutStatistics and Data Analysis. The course will teach you the basic concepts related to Statistics and Data Analysis and help you apply 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 by doing manual calculations and by MS Excel.


What are other students saying about this course?

  • Very structured and clear lessons on how each excel function can be used for different statistical analysis. I have benefited tremendously from attending this course. (5 stars by Kang Han Qi)

  • I have learned a lot already and it is still a long way to go! (5 stars by Dennis Dominic Mendoza)

  • Great course, great synergy between theory and practical used. (5 stars by Patrick Silangit)

  • .... this is awesome and really easy to understand the statistical concepts without any stress for a guy like me who used to fail in math classes. (5 stars by Lester Deepak Martis)

  • He's better than all my university lecturers, very clear, concise and seamless progression of the evolution of concepts in a systematic way that makes it easy to understand...Bravo!! (5 stars by Ayanda Peter)

  • A well-planned curriculum, fantastic resources for downloads, professionally presented slides, very easy to understand, truly the best course for every financial analyst. (5 stars by Arumugam K Chandrasekar)

  • I am fan of his teachings. it is recommended to every other person who is not confident in Statistics and want to be a pro. (5 stars by Apnatav Bhatia)

  • Its more than my expectations, absolutely wonderful since it start with basics. (5 stars by Boikaego Raditlatla)

  • Great course for learning business statistics or statistics in general. (5 stars by Sudesh Pandey)

  • Brilliant course. Takes the difficult, sometimes even boring Statistics model and breaks them into easy bite size portions. Explains the theory behind it and then the Excel way of doing it. (5 stars by Karthikeyan Stalin)

  • The self study step by step and the excel examples are very great. I can follow the course and practice on my computer alongside. Thank you for putting this whole thing together. Not a very exciting subject to teach so I appreciate being able to put this long course together to make it easy for people like us to utilize and study. (5 stars by Dr Stanley Adjabeng)


What are you waiting for?

This course comes with Udemy's 30 days money-back guarantee. If you are not satisfied with the course, get your money back.

I hope to see you on the course.

Taught by

Sandeep Kumar ­ and Quality Gurus Inc.

Reviews

4.6 rating at Udemy based on 5570 ratings

Start your review of Statistics for Data Analysis Using Excel 2016

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.