Statistical Analysis Using Excel LiveLessons (Video Training)
- By Conrad Carlberg
- Published Jan 25, 2013 by Que. Part of the LiveLessons series.
Downloadable Video
- Your Price: $119.99
- List Price: $149.99
- About this video
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.
Register your product to gain access to bonus material or receive a coupon.
Description
- Copyright 2013
- Dimensions: 5-23/64" x 7-21/32"
- Edition: 1st
- Downloadable Video
- ISBN-10: 0-7897-5029-5
- ISBN-13: 978-0-7897-5029-7
7+ Hours of Video Instruction
Statistical Analysis Using Excel LiveLessons is the world’s first complete video training course of its kind on the topic.
Bestselling author and trainer Conrad Carlberg provides the novice with 7+ hours of hands-on step-by-step video training on the fundamentals of statistical analysis. 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 training 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.
Part I: About Excel and Statistical Analysis
Accuracy of functions
Appropriate use of statistical functions
Overview of the Data Analysis Add-in
Part II: 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
Part III: 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
Part IV: Basic hypothesis testing
Hypothesis testing: single sample z tests
Single sample z tests: Excel’s normal distribution functions
Z tests, alpha and statistical power
Part V: 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
LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more. View All LiveLessons at: http://www.quepublishing.com/imprint/series_detail.aspx?st=87397
Extras
Related Articles
Using Excel Tools to Handle Nested and Random Factors in ANOVA
Using Excel with Mixed and Nested Models
Sample Content
Excerpts
Video: Is Excel Appropriate for Statistical Analysis?
Video: Statistical Analysis Using Excel: Variability
Table of Contents
Part I: About Excel and Statistical Analysis
Accuracy of functions
Appropriate use of statistical functions
Overview of the Data Analysis Add-in
Part II: 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
Part III: 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
Part IV: Basic hypothesis testing
Hypothesis testing: single sample z tests
Single sample z tests: Excel’s normal distribution functions
Z tests, alpha and statistical power
Part V: 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