Excel 2010: Statistical Analysis

This advanced-level Microsoft Excel 2010 training course teaches you how to use Excel to perform statistical analyses of your data. To begin, you’ll review the many functions available to help you describe your data. You’ll learn how to calculate the arithmetic mean, as well as the geometric mean and the standard deviation. You’ll also learn how to rank values and find the kurtosis of a distribution. Next, you’ll review a number of ways to compare variables, for example by finding the linear slope and predicting future values by using an existing value. You’ll also explore a range of tests that you can perform on your data to determine a specific outcome, and you’ll gain tips on how to analyze your data by utilizing the Data Analysis ToolPak.

This course is part of our Excel 2010 training series. It features clear audio and step-by-step visual instruction to help you perform both simple and complex statistical analyses using Excel.