Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Fundamental Concepts|
|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.|
|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.|
|Section 2: Analyzing the Data|
|In this video you'll learn about the fundamental concepts behind t-tests and how they work.|
|In this video you'll be shown the data analysis tool for doing the kinds of t-Tests when you can't apply the central limit theorem.|
|Section 3: When the Samples Match|
|In this video you'll be introduced to and learn an Excel function for paired sample testing.|
|In this video you'll learn about a data analysis tool for carrying out t-Tests for paired samples.|
|Section 4: Testing Two Variances|
|In this video you'll be introduced to testing variances as well as the Excel functions of testing hypotheses about variances.|
|In this video you learn about the data analysis tool for testing hypothesis about two-sample variances|
|Section 5: Introducing ANOVA|
|In this video you'll be introduced to Analysis of Variance or ANOVA|
|In this video you'll learn all about a data analysis tool that Excel provides for you to do an analysis of variance.|
|This video shows you what to do after you've completed an analysis of variance.|
|Section 6: ANOVA with More Than Two Matched Samples|
|In this video you'll learn all about the fundamental concepts of repeated measures analysis of variance.|
|This video teaches you all about Excel's data analysis tool for performing a repeated measures analysis of variance.|
|In this video you learn about trend analysis a procedure one completes after analysis of variance that results in a significant F-ratio.|
|Section 7: Analyzing Two Independent Variables|
|In this video you'll be introduced to the concepts of the analysis of variance, when analyzing two independent variables.|
|In this video you'll learn about Excel's data analysis tool that you'll use to carry out the two-factor analysis of variance|
|In this video you'll learn what to do after completing a two-factor analysis of variance|
|Section 8: Introducing Regression|
|This video introduces linear regression and some of the functions|
|Regression-Related Excel Functions (SLOPE, INTERCEPT, STEYX, FORECAST, TREND, LINEST) In this video you'll learn about three of Excel's regression related functions--- forecast, trend and linest|
|Section 9: Introducing Correlation|
Founded in 1807, John Wiley & Sons, Inc. has 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 is a global provider of content and content-enabled workflow solutions in areas of scientific, technical, medical, and scholarly research; professional development; and education. Our core businesses produce scientific, technical, medical, and scholarly journals, reference works, books, database services, and advertising; professional books, subscription products, certification and training services and online applications; and education content and services including integrated online teaching and learning resources for undergraduate and graduate students and lifelong learners. Wiley's global headquarters are located in Hoboken, New Jersey, with operations in the U.S., Europe, Asia, Canada, and Australia. The Company is listed on the New York Stock Exchange under the symbols JWa and JWb.