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
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …
video
Case Study: How Indeed uses the FOSS Contributor Fund to Sustain Critical Open Source Dependencies
As companies deploy products that depend on free and open source software (FOSS), corporate funding has …
video
Data Science and Machine Learning with Python – Hands-On!
Become a data scientist in the tech industry! Comprehensive data mining and machine learning course with …
video
Business App Development in Dynamics 365 for Non-Programmers
Build useful apps for mobile and the web using the PowerApp platform from Microsoft About This …
