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.
Pavan K. N. S.
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.