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.
Instructor Details
Courses : 7
Specification: Statistics for Data Analysis Using Excel 2016
|
19 reviews for Statistics for Data Analysis Using Excel 2016
Add a review Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Price | $12.99 |
---|---|
Provider | |
Duration | 14.5 hours |
Year | 2020 |
Level | All |
Language | English |
Certificate | Yes |
Quizzes | Yes |
$94.99 $12.99
Chijioke Nwachukwu –
yes it was
Samy Elwany –
Very useful well designed course. I recommended it to my postgraduate students to facilitate the statistical work of their researches.
meenakshi singh –
Course content is easy to understand and apply on daily tasks.
Rishi –
Yes
Daniel Egerud –
too basic so far
Karri Shekar –
excellent
Uwibambe Jeannette –
your course is very important in my life
Shreeyash Goel –
It was extremely lovely knowing the in depth about various subtopics that I didnt have knowledge about!
Kokkula Harikrishna –
yeah…..! its good.
Tim Essenburg –
The instructor is great pacing, knowledge and logical flow of material. Excellent course. I have already recommended it to others.
Prabhat Singh –
Explained in very simple and comprehensive manner.
Gaganpal Singh Dua –
Very simple and easy to understand.
Jonathan Boylan –
Good explanation of statistics using excel. Class seemed long if going at normal speed for the information covered.
Varghese N Ouseph –
Understanding
Paul Morse –
.
Narendra Dev Diwakar –
excellent course
Carlos Calder n Ram rez –
pretty good so far.
Tatiana Mathis –
So far yes, I’m glad that the professor is talking about the limitations of excel. That is very useful to know with data management and analysis in the future.
Alina Belashova –
I regret I did not check the course once I have bought it. Sound is awful, image is so much bad that I hardly can read what is written on the board/ lecturer speaks in such a way that is impossible to listen to. I am frustrated to get this