->
Lynda - Excel Statistics Essential Training: 1 - 5026557
Lynda - Excel Statistics Essential Training: 1
Data isn’t valuable until you put it to good use. Statistics transforms data into meaningful information, enabling organizations to make better decisions and predictions. That’s why statistics—collecting, analyzing, and presenting data—is a valuable skill for anyone in business or academia. In this course, Joseph Schmuller teaches the fundamentals of descriptive and inferential statistics and shows you how to apply them in Microsoft Excel—an inexpensive and accessible application that offers an array of powerful statistical tools. Using the built-in functions, and charts, along with the Analysis Toolpak add-on, Joe explains how to organize and present data, understand sampling distributions, test hypotheses, and draw conclusions. He covers probabilities, averages, variability, distribution, estimation, variance, regression testing, and more. By the end of the course, you should be able to fully understand and apply basic statistical concepts to a wide variety of data.


Table of Contents

  • Introduction
  • 1. Excel Statistics Fundamentals
  • 2. Types of Data
  • 3. Probability
  • 4. Central Tendency
  • 5. Variability
  • 6. Distributions
  • 7. Normal Distributions
  • 8. Sampling Distributions
  • 9. Estimation
  • 10. Hypothesis Testing
  • 11. Testing Hypotheses about a Mean
  • 12. Testing Hypotheses about a Variance
  • 13. Independent Samples Hypothesis Testing
  • 14. Matched Samples Hypothesis Testing
  • 15. Testing Hypotheses about Two Variances
  • 16. The Analysis of Variance
  • 17. After the Analysis of Variance
  • 18. Repeated Measures Analysis
  • 19. Hypothesis Testing with Two Factors
  • 20. Regression
  • 21. Correlation
  • Conclusion
  • Lynda - Excel Statistics Essential Training: 1


     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.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss