Excel Statistics Essential Training: 1 (2019)
MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 3h 37m
Genre: eLearning | Language: English + Sub | Size: 475 MB
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. Topics include: Using Excel functions and graphics Data types and variables Calculating probability Mean, median, and mode Calculating variability Organizing and graphing distributions Visualizing normal distributions Sampling distributions Making estimations Testing hypotheses: mean, z- and t-testing, and more Analyzing variance Performing repeated measure testing Regression testing Hypotheses testing with correlation HOMEPAGE https://www.lynda.com/Excel-tutorials/Excel-Statistics-Essential-Training-1/5026557-2.html
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.