Home > Store > Home & Office Computing > Microsoft Applications
Statistical Analysis Using Excel LiveLessons (Video Training)
- By Conrad Carlberg
- Published Jan 25, 2013 by Que. Part of the LiveLessons series.
- Copyright 2013
- Edition: 1st
- Downloadable Video
- ISBN-10: 0-7897-5029-5
- ISBN-13: 978-0-7897-5029-7
Register your product to gain access to bonus material or receive a coupon.
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.
Downloads
Table of Contents
| About Excel and Statistical Analysis | |
| Accuracy of functions | |
| Appropriate use of statistical functions | |
| Overview of the Data Analysis Add-in | |
| Using Excel one variable at a time | |
| Central Tendency 1 | |
| Central Tendency 2 | |
| Variability 1 | |
| Variability 2 | |
| Variability 3 | |
| Array formulas using statistical functions | |
| Array formulas or pivot tables? | |
| Confidence intervals | |
| Descriptive Statistics tool | |
| Confidence intervals with the Descriptive Statistics tool | |
| Using one variable to analyze another | |
| Two variables at a time | |
| Correlation and scattercharts | |
| Regression and shared variance | |
| Regression diagnostics | |
| Understanding regression coefficients | |
| Testing the overall regression with the F ratio | |
| Forecasting with the TREND() function | |
| Basic hypothesis testing | |
| Hypothesis testing: single sample z tests | |
| Single sample z tests: Excel’s normal distribution functions | |
| Z tests, alpha and statistical power | |
| Using the t distribution in Excel | |
| Mean differences and the t distribution | |
| Two-sample t tests Two-sample t tests | |
| Recap of consistency and compatibility functions |
DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Downloadable Video
$149.99
$119.99
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
