Lynda - Excel Statistics Essential Training: 1 (2016)
Understanding statistics is more important than ever. Statistical operations are the basis for decision making in fields from business to academia. However, many statistics courses are taught in cookbook fashion, with an emphasis on a bewildering array of tests, techniques, and software applications. In this course, part one of a series, Joseph Schmuller teaches the fundamental concepts of descriptive and inferential statistics and shows you how to apply them using Microsoft Excel.
Table of Contents
Introduction1. Excel Statistics Essentials2. Understanding Data3. Probability4. Central Tendency5. Variability6. Distributions7. Normal Distributions8. Sampling Distributions9. Estimation10. Hypothesis Testing11. Mean Hypothesis Testing12. Variance Hypothesis Testing13. Z and T Hypothesis Testing14. Matched Sample Hypothesis Testing15. F-Test Hypothesis Testing16. Analysis of Variance17. After the Analysis of Variance18. Repeated Measures Testing19. Hypothesis Testing with Two Factors20. Regression21. CorrelationConclusion
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.