Excel 2016: Statistical Analysis

This Microsoft Excel 2016 training course teaches you how to perform simple to complex statistical analyses of your data by utilizing Excel’s highly-powerful statistical tools and functions. To begin, you’ll explore the many options available for describing your data. You’ll learn how to find the arithmetic and geometric mean, as well as the standard deviation, variance, and the kurtosis of a distribution. Next you’ll discover ways of comparing variables to better understand the relationship between values. You’ll also explore a range of tests of significance that you can perform on your data to determine a specific outcome, and you’ll learn how to activate and effectively utilize the capabilities available with the Data Analysis ToolPak.