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.
In this video, we show how to compute probabilities of the Weibull distribution. It is extensively used in the field of reliability engineering for measuring component lifetime.
In the lecture we talk about the new advanced statistical functions introduced in EXCEL 2013
This lecture explains the use of the newly introduced function Gamma function in EXCEL 2013 to evaluate the gamma of the numbers that are greater or equal to one.
In this lecture, we illustrate how to use the Gauss function to evaluate standard normal distribution probabilities.
This lecture explains how to use PHI function in EXCEL 2013 to evaluate the density of the standard normal distribution.
I have over 18 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. As an Applied Statistician, I have developed over the years a strong interest in using EXCEL as a statistical tool with my classes in order to give to the students real world hands-on experience with Statistics.