Advanced Statistical functions in EXCEL 2010 (Part 2)
Udemy
Course Summary
Learn how to use advanced statistical functions in EXCEL 2010

+
Course Description
You will learn how to effectively use Advanced Excel Functions about the Normal distribution, Studentt distribution, chi square distribution, F distribution, Gamma, Lognormal, Negative Binomial, Exponential, etc.
You will learn how to calculate the margin of errors respectively for the Normal and Student t distributions and use them to create confidence intervals.
You will learn how to create Standard Normal tables as well as Student t tables.
You will use these advanced functions of Statistics in Excel 2010 to obtain Pvalues when testing various hypotheses about the mean, variance, proportion, etc.
Clear, relevant and easy to understand examples are shown in each video to increase your understanding.</p>

+
Course Syllabus
 Welcome to Statistical functions in EXCEL 2010 (Part 2 Intermediate and Advanced)
 What this class is about
 How to insert functions into EXCEL 2010 main window
 Functions related to the normal or bellshaped distribution
 Normal Distribution NORM.DIST function
 Finding the standard normal distribution probabilities
 Finding the inverse of a normal distribution
 Find the inverse (Zvalue) of the standard normal distribution
 How to plot the standard normal distribution curve
 Creating a standard normal distribution table
 How to standardize by computing the Z value
 Using a Ztest to test an hypothesis about the population mean
 Computing the margin of error for a large sample size confidence interval about the population mean
 Functions related to the Student t distribution
 Obtaining a lefttailed Pvalue about the population mean with T.DIST
 Finding the critical table value corresponding to a lefttailed student t distribution
 Finding the critical table value corresponding to a twotailed t distribution
 Finding the righttailed Pvalue using for testing a population mean using Student t distribution
 Finding a twotailed Pvalue when testing an hypothesis about the mean using Student t distribution
 Creating a Student t table with a T.INV function
 Testing hypothesis about two populations means using Student ttest
 Computing the margin of error for estimating a population mean using Student t distribution
 Computing Chisquare distribution probabilities and critical values
 Finding the lefttailed Pvalue for testing an hypothesis about the population variance using chi.dist
 Finding the righttailed Pvalue for testing an hypothesis about a population variance using the Ch square distribution
 Finding the critical table value for testing a lefttailed hypothesis about a population variance using Chi Square distribution
 Find the critical table value for testing a righttailed hypothesis about a population variance using the Chi square distribution
 Testing an hypothesis of independence using the Chi square test
 Computing FDistribution probabilities
 Computing a lefttailed Pvalue for testing the equality of two population variances using the F distribution
 Computing a righttailed Pvalue for testing the equality of two populations variances using the Fdistribution
 Finding a righttailed critical value for testing two variances using the F.INV.RT
 Testing equality of two populations variances with the Ftest
 Other advanced Statistical functions in EXCEL 2010
 Computing Exponential distribution probabilities
 Fitting exponential growth models to data with the growth function
 Evaluating Gamma distribution probabilities
 Computing factorials with the Gamma related functions
 Computing probabilities of the Negative binomial distribution
 Using the Log normal distribution function to compute probabilities
 Finding the inverse of Log normal distribution
 Using the Weibull distribution to compute probabilities
 Practice project files and Quizzes
 Project and practice files
 Solving problems using the normal distribution (Part1)
 Find probabilities under the standard normal distribution
 Finding the left tailed Pvalue for a Student t distribution
 Finding the righttailed Pvalue for a Student t distribution
 Finding the two tailed Pvalue for a Student t distribution
 Practice using the inverse of the standard normal distribution
 Finding the inverse of the Student t distribution
 Closing remarks and follow up
 Closing remarks and suggestions