How to Calculate Descriptive Statistics Using Analysis ToolPak

1. Open Excel 2007 and add the numbers for which you want to calculate descriptive statistics in the first column. For example, add the numbers 210, 110, 50, 50, 70 and 80 in A2, A3, A4, A5, A6 and A7 cells of Excel.
2. Click on the 'A9' cell. This is the cell where you will calculate the descriptive statistics using Analysis ToolPak. Please note, you don't have to select 'A9' cell for the descriptive statistics calculation; any cell under your chosen values can be selected.
3. Click on the 'Data' tab and then 'Data Analysis' found on the top right-hand side of the Excel spreadsheet. A window titled 'Data Analysis' will pop open.
4. Click on the 'Descriptive Statistics.' A window titled 'Descriptive Statistics' will pop open. In the Input Range of window, select and drag from A2 to A7 cells. In the Output Range of Window, select A9 cell.
5. Click on the 'Summary Statistics' of the window. A check mark will appear next to Summary Statistics. Click 'OK.'
6. Thirteen descriptive statistics have been successfully calculated starting from 'A9' cells. In this example, the following will appear as your calculated values.Mean 96.66666667
Standard Error24.17528582
Median 75
Mode 50
Standard Deviation59.21711464
Sample Variance3506.666667
Kurtosis 3.549458572
Skewness 1.854360629
Range 160
Minimum 50
Maximum 210
Sum 580
Count 6