# Statistical Analysis Using Excel LiveLessons (Video Training) Volume II

• List Price: \$149.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.

## 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.

### Part 1: Excel Functions for Basic Inferential Statistics -- Special Cases, Downloadable Version

These two lessons comprise a deep discussion of the independent and dependent groups. In just over an hour you will be confident with functions such as unequal variances.

Part I:¿Excel Functions for Basic Inferential Statistics -- Special Cases

Lesson 1:¿ Independent groups, unequal variances

Lesson 2:¿ Dependent groups

Duration: 01:20:35  File Size: 182 MB

### Lesson 2

These four lessons will walk you through how to manage statistical power. One hour and 30 minutes is your time investment for mastering the challenging topics such as the standard deviation!

Part 2: Managing Statistical Power

Lesson 1:¿ Alpha in Chart of t values

Lesson 2:¿ The standard error of mean: Standard deviation and sample size

Lesson 3:¿ Directional and nondirectional tests reviewed

Lesson 4:¿ Visual recap of how sample size, alpha, directionality mean difference influence power

Duration: 01:31:17  File Size: 187 MB

### Lesson 3

In just over an hour, these four lessons tackle the excel functions for linear regression.

Part 3: Excel Functions for Linear Regression

Lesson 1:¿ LINEST() reviewed

Lesson 2:¿ The Meaning of "Best Combination"

Lesson 3:¿ Forcing a zero intercept

Lesson 4:¿ The Data Analysis add-in's Regression tool

Duration: 01:14:27  File Size: 165 MB

### Part IV: Comparing More than Two Means with ANOVA and Regression, Downloadable Version

This section includes seven lessons and will run three and a half hours.

Part 4: Comparing More than Two Means with ANOVA and Regression

Lesson 1:¿ Rationale for ANOVA

Lesson 2:¿ The route to the F test

Lesson 3:¿ The single factor ANOVA tool

Lesson 4:¿ Effect coding and regression

Lesson 5:¿ Factorial designs¿

Lesson 6:¿ Shared variance

Lesson 7:¿ Rationale for using regression instead of ANOVA

Duration: 03:37:07  File Size: 494 MB

### Lesson 5

In just 44 minutes, these two lessons¿explore multiple acomparisons and planned orthogonal contrasts.

Part 5: Multiple Comparisons

Lesson 1:¿ Rationale for Multiple Comparisons

Lesson 2:¿ Planned Orthogonal Contrasts

Duration: 00:46:40  File Size: 105 MB

### Lesson 6

This final section spends one hour on ANCOVA.

Part 6: Analysis of Covariance (ANCOVA)

Lesson 1:¿ The rationale for ANCOVA

Lesson 2:¿ Running ANCOVA in Excel

Duration: 01:02:33  File Size: 145 MB

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.

Actual product comes full screen and in high resolution.

## Description

• Edition: 1st
• ISBN-10: 0-7897-5097-X
• ISBN-13: 978-0-7897-5097-6

&>9+ Hours of Video Instruction

Statistical Analysis Using Excel Volume II LiveLessons provides over 9 hours of video instruction. Means, medians and modes are one thing. Multiple regression analysis is quite another! These training videos bring it into focus.

Bestselling author and experienced consultant Conrad Carlberg provides the novice with 9+ hours of hands-on step-by-step video training on the intricacies that comprise statistical analysis. This Volume II series moves from the basics to intermediate applications and how Excel supports them: for example, the Analysis of Variance (ANOVA) and how it's supported simplistically by the Data Analysis add-in, and more powerfully by worksheet functions such as LINEST and by the combination of effect coding with Excel's lookup functions. This volume concludes with discussions and demonstrations of more advanced techniques, showing how multiple regression combines with the General Linear Model to produce the analysis of covariance, and how Excel's mixed referencing makes it easy to visualize what's going on as new vectors enter an analysis.

Part 1: Excel Functions for Basic Inferential Statistics -- Special Cases
Lesson 1:  Independent groups, unequal variances
Lesson 2:  Dependent groups
Part 2: Managing Statistical Power
Lesson 1:  Alpha in Chart of t values
Lesson 2:  The standard error of mean: Standard deviation and sample size
Lesson 3:  Directional and nondirectional tests reviewed
Lesson 4:  Visual recap of how sample size, alpha, directionality mean difference influence power
Part 3: Excel Functions for Linear Regression
Lesson 1:  LINEST() reviewed
Lesson 2:  The Meaning of "Best Combination"
Lesson 3:  Forcing a zero intercept
Lesson 4:  The Data Analysis add-in's Regression tool
Part 4: Comparing More than Two Means with ANOVA and Regression
Lesson 1:  Rationale for ANOVA
Lesson 2:  The route to the F test
Lesson 3:  The single factor ANOVA tool
Lesson 4:  Effect coding and regression
Lesson 5:  Factorial designs
Lesson 6:  Shared variance
Lesson 7:  Rationale for using regression instead of ANOVA
Part 5: Multiple Comparisons
Lesson 1:  Rationale for Multiple Comparisons
Lesson 2:  Planned Orthgonal Contrasts
Part 6: Analysis of Covariance (ANCOVA)
Lesson 1:  The rationale for ANCOVA
Lesson 2:  Running ANCOVA in Excel

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 and Office Technologies, Business and Management, and more.  View all LiveLessons at Que Publishing: http://www.quepublishing.com/imprint/series_detail.aspx?st=87397