Statistical Analysis Excel 2013 Essentials
3.8 (39 ratings)
625 students enrolled
Wishlisted Wishlist

Statistical Analysis Excel 2013 Essentials

Learn the ins and outs of statistical analysis with Excel 2013
3.8 (39 ratings)
625 students enrolled
Last updated 11/2014
English
Current price: \$10 Original price: \$50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 4 hours on-demand video
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• 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.
View Curriculum
Requirements
• Students shuold have an intermediate knowledge of how to use Excel
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
04:06:40
+
Introducing Excel's Statistical Capabilities
3 Lectures 12:03
 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.
Preview 03:22

 In this lesson you will discover how to use excel's built in statistical functions.
Preview 05:16

 In this video you will learn how to use the Data Analysis ToolPak.
Preview 03:25
+
Working with Data
7 Lectures 01:26:32
 In this lesson you will learn how to group data into intervals with a built in function and the data analysis tool.
Grouping Data into Distributions
14:05

 In this video you will learn how to sort data in tables.
Sorting Data in Tables
04:30

 In this lesson you will learn how to summarize your data by counting your data points.
Summarizing Data
11:52

 In this video you will explore the three common types of charts featured in excel: collumn, line, and pie.
Show and Tell: Using Excel Graphics
20:05

 In this lesson you will learn how to use excel's bar and scatter charts.
Bar Charts and Scatter Charts
17:44

 In this video you will dicover how to use Sparklines and PowerView in excel.
Working with Tables, Sparklines, and PowerView
12:39

 In this lesson you will discover the statistics on the status bar and quick analysis features in excel.
Instant Statistics: Statistics on the Status Bar and Quick Analysis
05:37
+
Statistical Concepts
3 Lectures 31:44
 In this video you will learn how to calculate the statistics of central tendancy, also known as, the average, median, mode in excel.
Statistics in the Center: Mean, Median, and Mode
13:58

 Learn all about excel functions to find the variablilty in a set of numbers with this lesson.
Statistics out of the Center: Variance and Standard Deviation
10:12

 In this lesson you will learn how to use the mean and standard deviation together.
Using the Mean and the Standard Deviation Together: Standard Scores
07:34
+
The Normal Distribution
2 Lectures 32:36
 With this video you will become more familiarized with normal distributions.
What is "The" Normal Distribution and Why Do We Care?
20:45

 This lesson discusses excel's normal distribution functions in the contecxt of the IQ distribution feature.
Working With Excel's Normal Distribution Functions
11:51
+
Applying the Normal Distribution
3 Lectures 43:21
 In this video you will learn how to apply normal distributions and understand the concept of sampling distributions.
Understanding Sampling Distributions
21:35

 Finding Confidence Limits For a Mean
Finding Confidence Limits For a Mean
09:35

 This video discusses the t distribution function in excel.
When The Normal Distributio Isn't Practical: The t Distribution
12:11
+
Introducing Hypothesis Testing
3 Lectures 40:24
 In this lesson you will discover the connection between hypotheses and sampling distribution in excel.
Hypotheses and Sampling Distributions
14:37

 In this video you will learn about practical hypothesis testing.
Working with Hypotheses - Related Excel Functions About Means
16:33

 In this lesson you will learn how to test hypothesis about variances.
Working with Hypotheses - Related Excel Functions About Variances
09:14