# How to do Your Statistics Homework with Microsoft Excel

## Introduction

Following on from my article **How to Calculate Standard Deviation** I have been asked to extend and expand my Math related Hubs since visitors find them easy to follow. This hub focuses on using the Excel Descriptive Statistics tool. I am still using Excel 2003 since I find the ribbon very irritating but the commands are still the same or very close.

### Excel will calculate the following for you in a few clicks, , if you are not sure what these statistical terms mean then one of the best places on the Internet to obtain definitions is Wikipedia. (Click the word)

- Mean
- Standard Error
- Median
- Mode
- Standard Deviation
- Sample Variance
- Kurtosis
- Skewness
- Range
- Minimum
- Maximum
- Sum
- Count
- Largest
- Smallest
- Confidence Level

## Step 1 start off with a series of numbers in an excel sheet row

## Highlight the numbers

## Click on Tools the Data Analysis

(if Data Analysis is not there click on Add-in and say Ok to add AnalysisToolPack)

## When you select data analysis the box will open, scroll down and select Descriptive Statistics... press Ok

## The Descriptive Statistics dialog box will open

This box has two important things;-

The Input

At the top of this box you can click on the little red arrow if your input range is different, or select if it is in columns instead of rows and if the first row contains the labels... experiment with this, just start over again if you select the wrong thing..

The Output

The Output range is where Excel is going to put the answers, so you can have it on this sheet, on a new sheet, in a new workbook..

## Always remember context help in Excel, when you have this Descriptive Statistics box open click on help and specific help for this box choices will open..

Assuming you have not much experience in using this tool just pick a cell in clear space on your sheet for the output and select all the other options and select Ok.

Using the data or list of numbers you selected Excel will produce the analysis below, as you can see it has calculated the Mean and the Standard Deviation and a range of other things.

Ok so imagine another example with a range of different data, you are asked to perform a comparison between three data sets.

Same procedure - The Input, at the top of this box you can click on the little red arrow for this different input range, or again select if it is in columns instead of rows and if the first row contains the labels... experiment with this, just start over again if you select the wrong thing..

The Output

The Output range is where Excel is going to put the answers, so you can have it on this sheet, on a new sheet, in a new workbook..

Ok so the dialog box should look like this !!

So the table of descriptive statistics will look like this, it has loads of analysis of the numbers.

## So each of these measurements can be analysed and thought about and talked about depending upon what you want to know or discover from the data

.

..

## More Math Related hubs from Drax

- How to Calculate Standard Deviation

A step by step guide on how to calculate standard deviation together with excel screenshots and a link to a downloadable version of the spreadsheet. - What is Standard Deviation

A description of What is Standard Deviation in plain English

.

..

## More by this Author

- 8
a few robot poems from Irish poet Drax..

- 12
An analysis of how book advances are calculated, how much you might receive. More about margins in the publishing industry including legacy, self publishing and EBooks.

- 225
How to do Standard Deviation manually in six straightforward steps, includes a step by step of how to do this using Excel, with screenshots and a link to a sample Excel sheet.

## 2 comments

You are so cool, Drax.

It's very easy to follow your instruction. You help me a lot, I was stuck with this home works over a week and asked instructor but I could not understand what he said.

I wish you are my Statistic Instructor.

Thank you very much, Drax