Forum Index Home
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Simple & Easy: Descriptive Statistics in Excel

Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Site Admin

Joined: 25 Sep 2007
Posts: 284

PostPosted: Sun Jan 15, 2017 5:20 pm    Post subject: Simple & Easy: Descriptive Statistics in Excel Reply with quote

If you want a quick summary of key statistical parameters (like mean, standard deviation, sum etc.) for your data set, the best and easiest way is to use Excel's data analysis tool called Descriptive Statistics.

Where do you find this tool? Go to Data tab > here you should find the Data Analysis button. There you will find this tool - Descriptive Statistics.

In many cases, if it's not already installed with Excel, you have to activate this from the Analysis ToolPak under Add-Ins from the Option. Very easy. Don't worry!! At the end of this tutorial, I have explained it thoroughly how to activate Analysis ToolPak Add-In for statistical and engineering purposes.

Now, we assume, you have this tool active under Data tab Smile

Here I have an example of oil prices from January 2001 to January 2002. I want to generate a summary statistics for my data.

Go to Data tab > click Data Analysis > select Descriptive Statistics > click OK.

Descriptive Statistics dialog box opens.

Here under Input Range highlight your range or cells (B3:B15). But if you want to include the heading Oil Price, then highlight the range from B2:B15 and check Labels in first row (otherwise you will get an error message - ' Descriptive Statistics Input range contains non-numeric data.').

Under Output Range > select cell D4.

Click Summary statistics > then OK.

So the output of your work is:

Well, here you see Mode #N/A. Why?

Mode is the number that is repeated more often than any other in your data. So let me change the oil price for Jun 01 to 65 and do the analysis again. So what you see? This time Mode is 65 (it's repeated more than any other values in my data).

Extra: How to activate Analysis ToolPak Add-In

The Analysis ToolPak is an Excel Add-In for data analysis. So let's activate this add-in:

In Excel 2003 and earlier versions, you get it from the Tools menu > click Add-Ins... > click Analysis ToolPak from the Add-Ins dialog box.

In Excel 2007 > click on the Office Button > click on Excel Options (In Excel 2010 > Green File > Options)

Now under Add-ins > select Analysis ToolPak > click on the Go button. The Add-Ins window opens.

Here check Analysis ToolPak > click OK.

Now click on the Data tab > click on Data Analysis.

The Data Analysis window opens.

Select Descriptive Statistics > click OK.

The Descriptive Statistics dialog box opens (second image in this tutorial). Now you can start analyzing your data.

Remember working with Excel is always a fun, so don't sit stressed in your chair. Just play with Excel. Do these things, I mean like trial-and-error, several times, it will make you a real expert. Keep in mind: 'Practise makes a man perfect!!'

So, have fun Smile


Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

For comments of suggestions, please contact us:
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group