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)


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 by this Author


2 comments

WhiteSnow 5 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


Drax profile image

Drax 5 years ago from NYC.... Author

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...

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working