Video description
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 to utilizing 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 youve 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. If you're looking for real-world statistical analysis wilth Excel 2013 instruction, you'll find it here.
http://www.wiley.com/WileyCDA/Section/id-825413.html
Table of contents
-
Introducing Excel's Statistical Capabilities
- Introducing Statistics in Excel 00:03:38
- Working with the Built-in Statistical Functions 00:04:50
- Working with the Data Analysis ToolPak 00:03:14
-
Working with Data
- Grouping Data into Distributions 00:14:04
- Sorting Data in Tables 00:04:30
- Summarizing Data 00:11:40
- Show and Tell: Using Excel Graphics 00:19:28
- Bar Charts and Scatter Charts 00:16:57
- Working with Tables, Sparkline's, and Power View 00:12:09
- Instant Statistics: Statistics on the Status Bar and Quick Analysis 00:05:27
- Statistical Concepts
-
The Normal Distribution
- The Normal Distribution 00:19:10
- Excel's Normal Distribution Functions 00:11:26
-
Applying the Normal Distribution
- Understanding Sampling Distributions 00:21:13
- Estimating Confidence 00:08:39
- The T- Distribution 00:12:08
- Introducing Hypothesis Testing
Product information
- Title: Statistical Analysis with Excel 2013 Essentials
- Author(s):
- Release date: January 2014
- Publisher(s): Wiley
- ISBN: 9781118942901
You might also like
video
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. …
video
Microsoft Excel 2013 Data Analysis Essentials
Master data analysis with Excel 2013 on your terms with this one-of-a-kind video training course. Excel …
video
Statistical Analysis Using Excel LiveLessons (Video Training)
Most statistical writing is vague and abstract; these videos make the concepts concrete using Excel charts, …
video
Predictive Analytics for Excel
In this easy-to-follow video course, learn how to forecast trended time series accurately in Excel: the …