Statistical Analysis Excel 2013 Essentials

Learn the ins and outs of statistical analysis with Excel 2013
3.9 (13 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.
464 students enrolled
$50
Take This Course
  • Lectures 21
  • Contents Video: 4 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 - learn the ins and outs of statistical analysis with Excel.

Learn 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 toutilizing Pivot Tables - with Statistical Analysis with Excel 2013 Essentials. 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, even if you’ve never taken a statistics course. 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 4 hours of statistical analysis with Excel 2013 video training.

This coursem also includes lessons that allow you to practice and master the skills you have learned.

If you're looking for real-world statistical analysis with Excel 2013 instruction, you'll find it here.

What are the requirements?

  • Students shuold have an intermediate knowledge of how to use Excel
  • Having access to Excel 2013 is helpful for practicing the skills you have learned

What am I going to get from this course?

  • Learn how to locate the built-in functions, how to set-up a shortcut to the functions and how to load the Data Analysis ToolPak.
  • Learn how to group data into intervals with a built in function and the data analysis tool, sort tables and summarize your data by counting your data points.
  • Explore the three common types of charts featured in excel: column, line, and pie and scatter.
  • Discover how to use Sparklines and PowerView in Excel.
  • Learn how to calculate the statistics of central tendency, also known as, the average, median, mode in Excel. Find the mean and standard deviation together.
  • Apply normal distributions and understand the concept of sampling distributions.
  • Discover the connection between hypotheses and sampling distribution in excel and learn how to test hypothesis about variances.
  • Create and interpret statistics in a business or classroom setting.

What is the target audience?

  • Intermediate through Advanced Excel Users
  • For students who want to take advantage of formulas, Pivot Tables, dashboards, and reporting tools
  • If you need to effectively and efficiently analyze data within Excel this course is for you.

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: Introducing Excel's Statistical Capabilities
03:22
In this video you'll learn how to locate the built-in functions, how to set-up a shortcut to the functions and how to load the Data Analysis ToolPak.
05:16
In this lesson you will discover how to use excel's built in statistical functions.
03:25
In this video you will learn how to use the Data Analysis ToolPak.
Section 2: Working with Data
14:05
In this lesson you will learn how to group data into intervals with a built in function and the data analysis tool.
04:30
In this video you will learn how to sort data in tables.
11:52
In this lesson you will learn how to summarize your data by counting your data points.
20:05
In this video you will explore the three common types of charts featured in excel: collumn, line, and pie.
17:44
In this lesson you will learn how to use excel's bar and scatter charts.
12:39
In this video you will dicover how to use Sparklines and PowerView in excel.
05:37
In this lesson you will discover the statistics on the status bar and quick analysis features in excel.
Section 3: Statistical Concepts
13:58
In this video you will learn how to calculate the statistics of central tendancy, also known as, the average, median, mode in excel.
10:12
Learn all about excel functions to find the variablilty in a set of numbers with this lesson.
07:34
In this lesson you will learn how to use the mean and standard deviation together.
Section 4: The Normal Distribution
20:45
With this video you will become more familiarized with normal distributions.
11:51
This lesson discusses excel's normal distribution functions in the contecxt of the IQ distribution feature.
Section 5: Applying the Normal Distribution
21:35
In this video you will learn how to apply normal distributions and understand the concept of sampling distributions.
09:35
Finding Confidence Limits For a Mean
12:11
This video discusses the t distribution function in excel.
Section 6: Introducing Hypothesis Testing
14:37
In this lesson you will discover the connection between hypotheses and sampling distribution in excel.
16:33
In this video you will learn about practical hypothesis testing.
09:14
In this lesson you will learn how to test hypothesis about variances.

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