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
- Analyzing Two Independent Variables
-
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
Product information
- Title: Statistical Analysis with Excel 2013 Advanced Skills
- Author(s):
- Release date: January 2014
- Publisher(s): Wiley
- ISBN: 9781118942963
You might also like
video
Statistical Analysis with Excel 2013 Essentials
Learn statistical analysis with Excel 2013 on your own terms with this one-of-a-kind video training course. …
book
Statistical Analysis: Microsoft Excel 2016
USE EXCEL’S STATISTICAL TOOLS TO TRANSFORM YOUR DATA INTO KNOWLEDGE Nationally recognized Excel expert Conrad Carlberg …
video
Statistical Analysis Using Excel LiveLessons (Video Training)
Most statistical writing is vague and abstract; these videos make the concepts concrete using Excel charts, …
book
Statistical Analysis with Excel For Dummies, 3rd Edition
Take the mystery out of statistical terms and put Excel to work! If you need to …