How Do You Calculate Descriptive Statistics Using Analysis Toolpak?
Descriptive statistics is a branch of statistics that organizes and summarizes the information for a given set of data. Descriptive statistics include statistics functions such as mean, median, standard error, standard deviation, sample variance and others. Each of these functions requires its own formula and complex calculations. However, there is a simple tool in Excel called Analysis ToolPak for easy calculations of these functions. With the Analysis ToolPak, 13 different descriptive statistics can be calculated with ease and without using any complex formulas. These 13 descriptive statistics are mean, standard error, mode, median, standard deviation, sample variance, kurtosis, skewness, range, minimum value, maximum value, sum and count. With this simple tool you can calculate all 13 functions in less than two minutes with a few simple clicks. Open Excel 2007 and add the numbers for which you want to calculate descriptive statistics in the first column. For example, add the numbers
