Video description
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.
Table of contents
- Introduction
-
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
-
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
-
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
-
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
-
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
Product information
- Title: Statistical Analysis Using Excel LiveLessons (Video Training)
- Author(s):
- Release date: December 2012
- Publisher(s): Que
- ISBN: 0133150828
You might also like
book
HBR Emotional Intelligence Ultimate Boxed Set (14 Books) (HBR Emotional Intelligence Series)
How to be human at work. HBR's Emotional Intelligence Series features smart, essential reading on the …
book
Excel Data Analysis For Dummies, 4th Edition
Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key …
video
Stephens' Visual Basic® Programming 24-Hour Trainer
Unique book-and-DVD package for novice Visual Basic programmers Start from scratch, and even if you don?t …
book
Statistical Analysis with Excel For Dummies, 3rd Edition
Take the mystery out of statistical terms and put Excel to work! If you need to …
