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.
3.6 (16 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
449 students enrolled
$50
Take This Course
  • Lectures 25
  • Contents Video: 5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

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

What are the 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

What am I going to get from this course?

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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Fundamental Concepts
17: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.
04: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.
Section 2: Analyzing the Data
12:37
In this video you'll learn about the fundamental concepts behind t-tests and how they work.
09:06
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
09:48
In this video you'll be introduced to and learn an Excel function for paired sample testing.
06:48
In this video you'll learn about a data analysis tool for carrying out t-Tests for paired samples.
Section 4: Testing Two Variances
11:11
In this video you'll be introduced to testing variances as well as the Excel functions of testing hypotheses about variances.
06:21
In this video you learn about the data analysis tool for testing hypothesis about two-sample variances
Section 5: Introducing ANOVA
15:25
In this video you'll be introduced to Analysis of Variance or ANOVA
10:18
In this video you'll learn all about a data analysis tool that Excel provides for you to do an analysis of variance.
05:42
This video shows you what to do after you've completed an analysis of variance.
Section 6: ANOVA with More Than Two Matched Samples
11:57
In this video you'll learn all about the fundamental concepts of repeated measures analysis of variance.
08:24
This video teaches you all about Excel's data analysis tool for performing a repeated measures analysis of variance.
16:07
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
23:32
In this video you'll be introduced to the concepts of the analysis of variance, when analyzing two independent variables.
05:31
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
23:48
In this video you'll learn what to do after completing a two-factor analysis of variance
Section 8: Introducing Regression
30:59
This video introduces linear regression and some of the functions
17:02
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
10:17
In this video you'll learn about excel's data analysis tool for regression
14:22
In this video you'll explore multiple regression and you'll revisit the Excel functions trend and linest
07:14
In this video you'll use Excel's regression data analysis tool in the context of multiple regression
Section 9: Introducing Correlation
14:56
This video introduces you to correlation and shows you Excel's functions for correlation
06:59
This video shows you Excel's data analysis tool for correlation
07:26
In this video you'll import data from the Web and use it as input to Excel's data analysis tool for correlation

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course