Video description
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. If you're looking for advanced real-world statistical analysis with Excel 2013 instruction, you'll find it here.
http://www.wiley.com/WileyCDA/Section/id-825413.html
Table of Contents
Introducing Two-Sample Hypothesis Testing
Fundamental Concepts
00:17:11
Excel’s Data Analysis Tool: z-Test: Two Sample for Means
00:04:56
Analyzing the Data
How t-Tests Work
00:12:38
Excel’s Data Analysis Tool for t-Tests
00:09:06
Paired Samples
Paired Sample t-Test
00:09:48
Excel’s Data Analysis Tool for Paired t-Test
00:06:48
Testing Variances
Testing Hypotheses About Variances
00:11:11
f-Test Data Analysis Tool
00:06:21
Introducing Analysis of Variance (ANOVA)
ANOVA Fundamental Concepts
00:15:26
Analysis of Variance Data Analysis Tool
00:10:18
Post ANOVA Comparisons
00:05:42
Working with Repeated Measures ANOVA
Fundamental Concepts of Repeated Measures Analysis of Variance
00:11:57
Data Analysis Tool for Repeated Measures ANOVA
00:08:25
Trend Analysis
00:16:08
Analyzing Two Independent Variables
Fundamental Concepts of Analyzing Two Independent Variables
00:23:32
Data Analysis Tool for Analyzing Two Independent Variables
00:05:31
Procedures to Follow After the Two-Factor ANOVA
00:23:48
Introducing Regression
Scatterplots and What They Show
00:30:59
Excel’s Regression Related Functions
00:17:03
Data Analysis Tool for Regression
00:10:17
Multiple Regression
00:14:23
Revisiting Regression Data Analysis Tool and Multiple Regression
00:07:14
Introducing Correlation
Fundamental Concepts and Excel Functions
00:14:56
Excel’s Data Analysis Tool for Correlation
00:06:59
Importing Data from the Web as Input to Excel’s Data Analysis tool for Correlation
00:07:26