How to do Your Statistics Homework with Microsoft Excel

Updated on April 28, 2013

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.

The Descriptive Statistics dialog box will open

This box has two important things;-

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.

.

..

.

..

Popular

0 of 8192 characters used
• AUTHOR

des donnelly

8 years ago from NYC....

Hi WhiteSnow... that is great, thanks very much :-) it is often the case that the people teaching mean well but do not know how to put themselves in the shoes of the person that does not know... I think the internet solves that because it is possible to find a good answer to any question if one really looks...

• WhiteSnow

8 years ago

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

working