by Conrad Carlberg | Released December 2012 | ISBN: 9780133150827

Most statistical writing is vague and abstract; these videos make the concepts concrete using Excel charts, tools, and functions. Statistical analysis takes two main forms: descriptive statistics and inferential statistics. Descriptive statistics provide numbers that describe how values cluster together (averages), disperse (standard deviations), and vary together (correlations). Inferential statistics informs us regarding the probability that the descriptive statistics that we calculate from samples are accurate estimators of the populations from which we took the samples. These techniques are well worked out in theory and in applications such as Microsoft Excel. They have applicability in fields as diverse as politics and sports, as economics and agriculture, as psychology and business management, as achievement testing and manufacturing.This tutorial on statistical analysis is designed to provide conceptual overviews of topics such as testing the reliability of the difference between the means of a treatment group and a control group, followed by demonstrations of how to handle the topic in Excel. Topics such as statistical power are crucial to understanding inferential analysis but history shows that they are very difficult to communicate through text. By using auditory explanations in combination with Excel's powerful charting capabilities, it's possible to communicate these abstract notions in a concrete fashion. Students and other consumers of this sort of information find it much easier to follow, and much faster to assimilate.About the Author:Conrad Carlberg has a doctorate in statistics from the University of Colorado, Boulder and studied under one of the foremost statisticians of the last century, Gene Glass. he is a multi-time recipient of Microsoft's MVP/Excel award, and has written somewhere around 15 books on Excel, including one originally published in 1995 and now in its 4th edition. Conrad's book Predictive Analytics: Microsoft Excel 2010 was published in July 2012. Show and hide more

1. Introduction
   • Introduction to Statistical Analysis Using Excel LiveLessons 00:06:08
2. About Excel and Statistical Analysis
   • Learning objectives 00:01:21
   • Accuracy of functions 00:05:23
   • Appropriate use of statistical functions 00:10:52
   • Overview of the Data Analysis Add-in 00:12:23
3. Using Excel one variable at a time
   • Learning objectives 00:01:35
   • Central Tendency 1 00:15:23
   • Central Tendency 2 00:08:02
   • Variability 1 00:08:17
   • Variability 2 00:13:55
   • Variability 3 00:08:45
   • Array formulas using statistical functions 00:13:41
   • Array formulas or pivot tables? 00:12:02
   • Confidence intervals 00:11:48
   • Descriptive Statistics tool 00:12:59
   • Confidence intervals with the Descriptive Statistics tool 00:08:28
4. Using one variable to analyze another
   • Learning objectives 00:01:30
   • Two variables at a time 00:12:48
   • Correlation and scattercharts 00:15:11
   • Regression and shared variance 00:21:10
   • Regression diagnostics 00:20:43
   • Understanding regression coefficients 00:23:28
   • Forecasting with the TREND() function 00:23:49
5. Basic hypothesis testing
   • Learning objectives 00:01:23
   • Hypothesis testing: single sample z tests 00:18:35
   • Single sample z tests: Excel’s normal distribution functions 00:20:58
   • Z tests, alpha and statistical power 00:20:13
6. Using the t distribution in Excel
   • Learning objectives 00:01:37
   • Mean differences and the t distribution 00:27:48
   • Two-sample t tests 00:30:19
   • Recap of consistency and compatibility functions 00:34:18
Show and hide more