You will learn how to effectively use Advanced Excel 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 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 P-values 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>