Statistical Analysis with Excel 2013 Advanced Skills

Statistical Analysis with Excel 2013 Advanced Skills

by
Released January 2014
Publisher(s): Wiley
ISBN: 9781118942963

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Master statistical analysis with Excel 2013 on your own terms with this one-of-a-kind video training course. Big data is big business, and many professionals are turning to Excels data analysis tools to help them make sense of their organizational data. Now, you can learn the ins and outs of statistical analysis with Excel - from importing data to utilizing Pivot Tables - with Statistical Analysis with Excel 2013 Advanced Skills. Our instructors provide expert, straight-forward, user-friendly training to help you tackle new topics the way you want to learn. Master basic skills, boost your creativity, and challenge yourself in bold new directions. Understand Excels data analysis capabilities and how they can be applied in your organization Work with data, normal distributions, hypothesis testing, variances, rank, and percentiles Take advantage of formulas, Pivot Tables, dashboards, and reporting tools to display your data Includes 5 hours of advanced statistical analysis with Excel 2013 video training. If you're looking for advanced real-world statistical analysis with Excel 2013 instruction, you'll find it here.

http://www.wiley.com/WileyCDA/Section/id-825413.html

Table of contents

  1. Introducing Two-Sample Hypothesis Testing
    1. Fundamental Concepts 00:17:11
    2. Excel's Data Analysis Tool: z-Test: Two Sample for Means 00:04:56
  2. Analyzing the Data
    1. How t-Tests Work 00:12:38
    2. Excel's Data Analysis Tool for t-Tests 00:09:06
  3. Paired Samples
    1. Paired Sample t-Test 00:09:48
    2. Excel's Data Analysis Tool for Paired t-Test 00:06:48
  4. Testing Variances
    1. Testing Hypotheses About Variances 00:11:11
    2. f-Test Data Analysis Tool 00:06:21
  5. Introducing Analysis of Variance (ANOVA)
    1. ANOVA Fundamental Concepts 00:15:26
    2. Analysis of Variance Data Analysis Tool 00:10:18
    3. Post ANOVA Comparisons 00:05:42
  6. Working with Repeated Measures ANOVA
    1. Fundamental Concepts of Repeated Measures Analysis of Variance 00:11:57
    2. Data Analysis Tool for Repeated Measures ANOVA 00:08:25
    3. Trend Analysis 00:16:08
  7. Analyzing Two Independent Variables
    1. Fundamental Concepts of Analyzing Two Independent Variables 00:23:32
    2. Data Analysis Tool for Analyzing Two Independent Variables 00:05:31
    3. Procedures to Follow After the Two-Factor ANOVA 00:23:48
  8. Introducing Regression
    1. Scatterplots and What They Show 00:30:59
    2. Excel's Regression Related Functions 00:17:03
    3. Data Analysis Tool for Regression 00:10:17
    4. Multiple Regression 00:14:23
    5. Revisiting Regression Data Analysis Tool and Multiple Regression 00:07:14
  9. Introducing Correlation
    1. Fundamental Concepts and Excel Functions 00:14:56
    2. Excel's Data Analysis Tool for Correlation 00:06:59
    3. Importing Data from the Web as Input to Excel's Data Analysis tool for Correlation 00:07:26

Product information

  • Title: Statistical Analysis with Excel 2013 Advanced Skills
  • Author(s):
  • Release date: January 2014
  • Publisher(s): Wiley
  • ISBN: 9781118942963