Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Statistical Analysis with Excel 2013 Advanced Skills
Rating: 4.0 out of 5(121 ratings)
1,309 students

Statistical Analysis with Excel 2013 Advanced Skills

Master statistical analysis with Excel 2013 on your own terms with this one-of-a-kind video training course.
Created byJohn Wiley & Sons
Last updated 11/2014
English
English [Auto],

What you'll learn

  • Learn about the z-Test and the fundamental concepts behind t-tests and how they work.
  • Learn an Excel function for paired sample testing and the data analysis tool for carrying out t-Tests for paired samples.
  • You'll be introduced to Analysis of Variance or ANOVA and learn all about a data analysis tool that Excel provides for you to do an analysis of variance.
  • Learn all about the fundamental concepts of repeated measures analysis of variance and the about Excel's data analysis tool.
  • Learn about trend analysis a procedure one completes after analysis of variance that results in a significant F-ratio.

Course content

9 sections • 25 lectures • 5h 7m total length

  • My FiANOVA Concepts: Three Kinds of Variance – Between Groups, Withinrst Lecture17:10
    ANOVA Concepts: Three Kinds of Variance – Between Groups, Within Groups, and Total In this video you'll be introduced to hypothesis testing that involves two samples specifically hypothesis about means.
  • Data Analysis Tool: Anova: Single Factor4:56
    In this video you learn about the z-Test: Two Sample for Means data analysis tool that allows you to supply the population variance and it gives you the means.

Requirements

  • You should have experience with Statistical Analysis before beginning this course.
  • We recommend beginning with our Beginner to Intermediate course on statistical analysis, Statistical Analysis Excel 2013 Essentials

Description

Big data is big business - Excels data analysis tools to help them make sense of their organizational data.

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 with lessons for you to practice what you have learned. If you're looking for advanced real-world statistical analysis with Excel 2013 instruction, you'll find it here.

Who this course is for:

  • Intermediate to Advanced Excel user
  • Data Analysis professionals needing to organize their data and apply the results to strengthen their orgaization
  • Data Analysis professional looking to advance their skills and career

Report abuse