Updated course to include Statistical functions in EXCEL 2013
The course has been updated to include the latest fundamental statistical functions found in EXCEL 2013. With this update, you are given a new set of capabilities to enhance your analytics toolbox using EXCEL.
Understand and solving statistical problems using EXCEL
This course is about learning to leverage the power of EXCEL 2010 and 2013 statistical tools for solving data analysis problems in Business, education and many other areas where analytics are needed.
You will learn how to use many excel statistical functions for obtaining descriptive statistics, correlations, probabilities, histograms, fitting a linear regression, obtaining XY plots, bar graphs, frequencies, percentiles, quartiles, ranking data, etc.
Over 56 videos with detailed explanations using real data to illustrate the concepts.
Course can be completed in 8-10 weeks depending of background, assiduity and interest.
Quizzes and a final project to test your understanding with real world problems
Carefully selected examples in the videos to increase your understanding of each topic.
Take this Excel Statistical course now and have a great understanding of using Excel Statistical Functions for analytics.
How do you compute the sample standard deviation?
This quiz will test your understanding about using the Analysis Tool Pack to obtain descriptive statistics.
About using the NEW statistical functions introduced in EXCEL 2013
In this lecture, you will learn about SKEW.P a new function introduced in EXCEL 2013 to compute the skewness coefficient of a population.
In this lecture, you will learn about PERMUTATIONA a new function introduced in EXCEL 2013 to compute the number of permutations with repetitions. You will understand in practice what is a permutation with repetitions.
In this lecture, you will learn about COMBINA a new function introduced in EXCEL 2013 to compute the number of combinations with repetitions. You will understand in practice what is a combination with repetitions.
After this lecture, you will have a mastery of the capabilities of the new function BINOM.DIST.RANGE and will be able to use them to effectively compute Binomial probabilities.
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.