Author Message
Admin
Site Admin

Joined: 25 Sep 2007
Posts: 272

 Posted: Sun Jan 15, 2017 5:20 pm    Post subject: Simple & Easy: Descriptive Statistics in Excel 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 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 *Recommended: Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena. For comments of suggestions, please contact us: info@shamskm.com
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT + 2 Hours Page 1 of 1

 Jump to: Select a forum Forum Rules----------------General Rules Learn German Easily----------------German as a Foreign Language (Deutsch als Fremdsprache) Category----------------General ForumPolitics - commentsJokesScienceTechnology & How-To ForumEnvironmental Issues forumGeographic Information System (GIS) forumWebsites Related ForumPublic Health & Yoga forum Cappuccino & Espresso----------------Cappuccino & Espresso Job Posting----------------Job offerThe Space travellers
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