Statistical Analysis with Excel 2013 Advanced Skills

Master statistical analysis using Excel 2013 with our comprehensive video training course. Learn essential skills for data analysis and boost your career.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course is all about getting cozy with Excel 2013 for statistical analysis. You’ll dive into data, learn essential skills, and find your way through tools like Pivot Tables, t-tests, and ANOVA. Perfect for anyone looking to level up their data game!

Key Points

  • Master statistical analysis with Excel 2013
  • Learn to import data and use Pivot Tables
  • Understand normal distributions and hypothesis testing
  • Utilize Excel formulas, dashboards, and reporting tools
  • Explore z-Test, t-tests, and ANOVA

Learning Outcomes

  • Gain proficiency in Excel's statistical tools
  • Perform hypothesis testing
  • Create and analyze Pivot Tables
  • Understand data distributions and variances
  • Confidence to tackle real-world data challenges

About This Course

Master statistical analysis with Excel 2013 on your own terms with this one-of-a-kind video training course.

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.

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

Instructor

Profile photo of John Wiley & Sons
John Wiley & Sons

Founded in 1807,  Wiley, In has long been a valued source of information and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Wiley and its acquired companies have published the works of more than 450 Nobel laureates in all categories: Literature, Economics, Physiology or Medicine, Physics, Chemistry, and Peace.       Wiley...

Review
4.9 course rating
4K ratings
ui-avatar of Pavan Kumar Naga Sannala
Pavan K. N. S.
1.0
2 years ago

Lecture may be bit informative if we have alots of time to understand over several times. Resources are non retrievable from pdf or word formats. that i tried few. Not sure if this course is worth, a try. Resources were not opening on phone or lap top, that worse too.

  • Helpful
  • Not helpful
ui-avatar of Natalia Vlasova
Natalia V.
3.5
3 years ago

The instructor could be a little bit more excited about his stuff, it always felt as if he was reading

  • Helpful
  • Not helpful
ui-avatar of Jaidip Jagtap
Jaidip J.
4.0
5 years ago

Course contain good theoretical background. I wish author could have more functions covered may be briefly by adding one more section. Thanks

  • Helpful
  • Not helpful
ui-avatar of Anonymized User
Anonymized U.
5.0
5 years ago

Very good

  • Helpful
  • Not helpful
ui-avatar of Jasmin Vijily. V
Jasmin V. V.
4.5
5 years ago

Yes it was good session. Thank you so much

  • Helpful
  • Not helpful
ui-avatar of Tejkaran Charan
Tejkaran C.
4.0
5 years ago

I wish the instructor would have taken some more time to explain the underlying theory as well. Rest all is easy.

  • Helpful
  • Not helpful
ui-avatar of Victor Okrobodo
Victor O.
3.0
5 years ago

Average, it could be better.

  • Helpful
  • Not helpful
ui-avatar of Natalie Kowalke
Natalie K.
4.0
6 years ago

This is a very basic course. I did find some information useful about excel; however, I have had quite a bit of experience with stats so it was a little basic for me. However, for a person with little experience with stats this would be a useful course.

  • Helpful
  • Not helpful
ui-avatar of Lesley Lane
Lesley L.
5.0
6 years ago

This was an incredible course. I was able to learn a lot of information that will help me on my statistical journey. I just wish I would have found this early in the beginning, and at that time, understood the significance of what he is teaching. This instructor was precise and right to the point. He will show you all the possibilities there are to get to your answers. I hope that he will make another course in different areas sometime soon. If he does, then count me in.

  • Helpful
  • Not helpful
ui-avatar of Andrew Parchment
Andrew P.
3.5
7 years ago

Overall the course was pretty good, I wish I knew more about statistics when I started, but this was more about showing us Excel's capabilities for handling Statistics in that respect it does a good job.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses