Statistical Analysis with Excel 2013 Advanced Skills
4.1 (30 ratings)
607 students enrolled
Wishlisted Wishlist

# 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.
4.1 (30 ratings)
607 students enrolled
Last updated 11/2014
English
Current price: \$10 Original price: \$50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
• 5 hours on-demand video
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• 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.
View Curriculum
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
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
05:07:56
+
Fundamental Concepts
2 Lectures 22:06
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.
Preview 17:10

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.
Data Analysis Tool: Anova: Single Factor
04:56
+
Analyzing the Data
2 Lectures 21:43
In this video you'll learn about the fundamental concepts behind t-tests and how they work.
t-Tests and How they Work (T.TEST)
12:37

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.
Data Analysis Tool: t-Test: Two Sample
09:06
+
When the Samples Match
2 Lectures 16:36
In this video you'll be introduced to and learn an Excel function for paired sample testing.
Matched Samples t-Tests and How They Work (T.TEST)
09:48

In this video you'll learn about a data analysis tool for carrying out t-Tests for paired samples.
Data Analysis Tool: t-Test: Paired Two Sample for Means
06:48
+
Testing Two Variances
2 Lectures 17:32
In this video you'll be introduced to testing variances as well as the Excel functions of testing hypotheses about variances.
Hypothesis Testing for Variances (F.TEST, F.DIST, F.DIST.RT, F.INV, F.INV.RT)
11:11

In this video you learn about the data analysis tool for testing hypothesis about two-sample variances
Data Analysis Tool: F-Test Two Sample for Variances
06:21
+
Introducing ANOVA
3 Lectures 31:25
In this video you'll be introduced to Analysis of Variance or ANOVA
What Excel Left Out: Post-Analysis Comparisons and How to Do Them
15:25

In this video you'll learn all about a data analysis tool that Excel provides for you to do an analysis of variance.
Analysis of Variance Data Analysis Tool
10:18

This video shows you what to do after you've completed an analysis of variance.
Post ANOVA Comparisons
05:42
+
ANOVA with More Than Two Matched Samples
3 Lectures 36:28
In this video you'll learn all about the fundamental concepts of repeated measures analysis of variance.
Introducing Repeated Measures
11:57

This video teaches you all about Excel's data analysis tool for performing a repeated measures analysis of variance.
Data Analysis Tool: Anova: Two Factor Without Replication
08:24

In this video you learn about trend analysis a procedure one completes after analysis of variance that results in a significant F-ratio.
What Excel Left Out: Analyzing Trend
16:07
+
Analyzing Two Independent Variables
3 Lectures 52:51
In this video you'll be introduced to the concepts of the analysis of variance, when analyzing two independent variables.
Fundamental Concepts
23:32

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
Data Analysis Tool: Two Factor Anova With Replication
05:31

In this video you'll learn what to do after completing a two-factor analysis of variance
After the Analysis
23:48
+
Introducing Regression
5 Lectures 01:19:54
This video introduces linear regression and some of the functions
Scatterplots and What They Show
30:59

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
Regression-Related Excel Functions (SLOPE, INTERCEPT, STEYX, FORECAST, TREND, LI
17:02

 In this video you'll learn about excel's data analysis tool for regression
Data Analysis Tool: Regression
10:17

 In this video you'll explore multiple regression and you'll revisit the Excel functions trend and linest
Multiple Regression
14:22

 In this video you'll use Excel's regression data analysis tool in the context of multiple regression
Revisiting TREND, LINEST, and Data Analysis Tool: Regression
07:14
+
Introducing Correlation
3 Lectures 29:21
 This video introduces you to correlation and shows you Excel's functions for correlation
Fundamental Concepts and Excel Functions
14:56

 This video shows you Excel's data analysis tool for correlation
Data Analysis Tool: Correlation
06:59

 In this video you'll import data from the Web and use it as input to Excel's data analysis tool for correlation
Importing Data from the Web
07:26