Home > Store > Home & Office Computing > Microsoft Applications

Statistical Analysis Using Excel LiveLessons (Video Training)

Statistical Analysis Using Excel LiveLessons (Video Training)

Your browser doesn't support playback of this video. Please download the file to view it.

Downloadable Video

  • Your Price: $45.00
  • 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.

Buy Lessons

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. Requires the free QuickTime Player software.

Lesson 1

Part I: About Excel and Statistical Analysis, Downloadable Version

After watching this 30-minute video, you'll have a solid understanding of the following: Accuracy of functions, Appropriate use of statistical functions, and an Overview of the Data Analysis Add-In.

Duration: 00:31:10  File Size: 59 MB

Lesson 2

Part II: Using Excel One Variable at a Time, Downloadable Version

At almost two hours, these 10 videos thoroughly cover training on the variables of statistical analysis:

                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

Duration: 01:56:06  File Size: 222 MB

Lesson 3

Part III: Using One Variable to Analyze Another, Downloadable Version

These seven videos tackle using one variable to analyze another in just under two hours. 

                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

Duration: 02:25:52  File Size: 289 MB

Lesson 4

Part IV: Basic Hypothesis Testing, Downloadable Version

In about an hour, these three videos explore basic hypothesis testing:

                Hypothesis testing: single sample z tests

                Single sample z tests: Excel’s normal distribution functions

                Z tests, alpha and statistical power

Duration: 01:02:20  File Size: 133 MB

Lesson 5

Part V: Using the t Distribution in Excel, Downloadable Version

These three videos focus on using the t distribution in Excel. Running time is 1:34:02.

                Mean differences and the t distribution

                Two-sample t tests Two-sample t tests

                Recap of consistency and compatibility functions

Duration: 01:35:12  File Size: 203 MB

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2013
  • 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

Downloads

Downloads

Download the companion files

Sample Content

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

Updates

Submit Errata

More Information

ONE MONTH ACCESS!

WITH PURCHASE


Get unlimited 30-day access to thousands of Books & Training Videos about technology, professional development and digital media 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.