by Wiley | Released January 2014 | ISBN: 9781118942901

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 Show and hide more

1. 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
2. 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
3. Statistical Concepts
   • Statistics in the Center: Mean, Median, and Mode 00:13:27
   • Statistics out of the Center: Variance and Standard Deviation 00:10:10
   • Using the Mean and the Standard Deviation Together: Standard Scores 00:07:18
4. The Normal Distribution
   • The Normal Distribution 00:19:10
   • Excel's Normal Distribution Functions 00:11:27
5. Applying the Normal Distribution
   • Understanding Sampling Distributions 00:21:13
   • Estimating Confidence 00:08:39
   • The T- Distribution 00:12:08
6. Introducing Hypothesis Testing
   • Hypotheses and Sampling Distributions 00:14:24
   • Working with Hypotheses - Related Excel Functions About Means 00:16:04
   • Working with Hypotheses - Related Excel Functions About Variances 00:09:05
Show and hide more