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