This course is all about mastering advanced statistical functions in EXCEL 2010 and 2013. You’ll dive into different distributions and learn to analyze data effectively. Plus, there are loads of practical examples and quizzes to help you really get it!
Learn how to use advanced statistics functions in EXCEL 2010 and 2013 to effectively analyze data.
Updated material to include latest advanced Statistical functions in EXCEL 2013
This course has been updated to include the latest advanced statistical functions in EXCEL 2013. It provides you with a vast array of analytical tools to handle most
The course is about using the advanced statistical functions in EXCEL for data analysis and analytics projects.
You will learn how to effectively use Advanced Excel Statistical Functions about the Normal distribution, Student-t distribution, chi square distribution, F distribution, Gamma, Log-normal, Negative Binomial, Exponential, etc.
You will learn how to calculate the margin of errors and use them to create confidence intervals. In addition, you will learn how to create Standard Normal tables as well as Student t tables.
This course is very well illustrated with lots of practical illustrations and quizzes to help you grasp the concepts of each function and understand them in a practical way. Excel files and screenshots are provided to make the understanding of the lectures very easy.
Depending on the prior preparation, this course can be completed in one month or less.
Taking this course will provide you with a rich array of advanced analytical tools that can be used for educational and professional work.
After completing this course, you will feel comfortable using EXCEL 2010-2013 advanced statistical functions for Analytics and Applied Statistical analyses.
In this course, you will learn advanced statistical functions about the Normal or Bell-Shaped distribution, Student t distribution, chi square, lognormal, negative binomial, etc..
You will effectively be able to solve inferential statistical problems using the functions you studied and feel comfortable using the power of EXCEL advanced statistical function for analyses.
9 Lectures
8 Lectures
5 Lectures
4 Lectures
8 Lectures
4 Lectures
3 Lectures
1 Lectures
I  have over 20 years of work experience in the field of statistics as an Applied Statistician. For the last  twelve years, I have also  been teaching undergraduate college level statistics courses at St Petersburg College,Florida, USA.As a Data scientist, my interests lie in applying Data science techniques (Exploratory Data Analyses, Statistical analyses and other Machine Learning) to real world...
This was very informative.
Hope to see an exercise file that goes along with the lecture eventually. If not, it's just listening to a typical lecture which can be found a lot in Youtube.
First, the course use Excel 2010 or +, which is easy to access for all, to summarize data and compute statistics commonly use in industry.
Second, the course goes through elementary details, not oftentimes taught in ordinary stat courses, to accommodate those with no statistical background.
third, the course provides statistical and professional interpretation of the computed statistics.
Luc explains how to use the various statistical functions in Excel 2010. I wish that I had taken this course before I studied statistics, I think I would have had a better understanding and would have obtained a better grade. This is the second course that I have taken under Luc and have just signed up for two more. Thanks Luc, the course material will be a useful reference source.
This level of Statistics can get very confusing when creating graphs and using Excel. This course helps to clarify all the topics and educate the student about each one. It provides everything you will need to know about Advanced Statistics! The professor is very knowledgeable about the course.
Your email address will not be published. Required fields are marked *
Bill C. O.
so far so good
Very detailed with every bit i always assumed