If you’re working with large datasets in excel, getting Descriptive Statistics for this data set could be helpful too.
Descriptive Statistics quickly summarizes your data and gives you a few data points that you can use to understand the entire data set quickly.
While you can also calculate each of these statistical values individually, using the descriptive statistics option in Excel quickly gives you all this data in one place (and it’s a lot faster than utilizing different formulas to calculate different values).
In this short tutorial, Excel VBA show you how to get Descriptive Statistics in Excel.
Descriptive Statistics in Excel
To get the Descriptive Statistics in Excel, you must have the Data Analysis Toolpak enabled.
You can check whether you already have it allowed by going to the Data tab.
If you see the Data Analysis option in the Analysis group, you already have it enabled (and you can ignore the next section and go directly to the ‘Getting Descriptive Analysis’ section).
If you do not see the data analysis option in the data tab, follow the steps in the next section to enable it.
Enabling Data Analysis Toolpak
Below are the steps to enable the Data Analysis Toolpak in MS Excel:
- Open any Excel document
- Click the File tab
3 Click on Options. will open the Excel Options dialog box
4 In the Excel Options dialog box, click on Add-ins in the left pane.
5 . Select’ Excel Add-ins’ from the Manage drop-down (which is at the bottom of the dialog box).
- Click on the Go button
- In the Add-ins dialog box that shows up, check the Analysis Toolpak option.
The other steps would enable the Data Analysis toolpak, and you will be competent to use it on all your Excel Workbooks.
Getting the Descriptive Analysis
Now that the Data Analysis Toolpak is enabled, let’s see how to get the descriptive statistics.
Suppose you have a data set as shown below where I have the sales data of a company’s particular products. For this data, I want to get descriptive statistics.
Below are the steps to do this:
- Click the Data tab
- In the Analysis group, click on Data Analysis
In the Data Analysis dialog box that extends, click on Descriptive Statistics.
In the Descriptive Statistics dialog box, specify the input range that has the data. Note that I have only used Column B as the data origin (as you can only use numeric data as the input here).
- If your data has headers, check the ‘Labels in first row’ option
- Select the statistics options you want (you need to select at least one and can select all four)
The above steps would insert a new sheet, and you will get the statistics as shown below:
I believe you have remarked some very interesting points, thank you for the post. Freddie Wiltsey
This program has been used by thousands of people with bad credit worldwide to get loans instantly. Jamaal Lucic
I am sure this post has touched all the internet people, its really really fastidious article on building up new website. Garret Moghadam
Very good article. I am experiencing many of these issues as well.. Ralph Strayer
Very good article. I will be experiencing some of these issues as well.. Osvaldo Spadea
This is my first time go to see at here and i am in fact impressed to read everthing at single place. Lanny Chapp
I appreciate you sharing this blog post. Thanks Again. Awesome. Rolland Millhouse
Real nice design and style and wonderful content material , very little else we need : D. Dwain Bregantini
Hi to all, since I am really eager of reading this blog’s post
to be updated daily. It consists of nice stuff.
I need to to thank you for this very good read!! I definitely enjoyed every little bit of it. George Liming
Hello colleagues, its great post regarding tutoringand fully defined, keep it up all the time. Warren Fedie
For hottest information you have to visit web and on the web I found this web site as a most excellent website for most up-to-date updates. Fritz Mullee
Really appreciate you sharing this article. Awesome. Errol Wienert
Mahina!! I love your new blog layout!! Congrats on moving back home! I hope you all settled in easily!! Must be wonderful to be back home. Millard Gira
The Cyprus Turkish Football Association (Turkish: Kıbrıs Türk
Futbol Federasyonu, KTFF) is the governing body of football in the Turkish Republic of Northern Cyprus.
Founded on 29 October 1955, during United kingdom colonial rule in Cyprus, it seemed to be
related with the N.F.-Board from 2003 until the board’s dissolution in 2013.
Since 2013 the KTFF possesses happen to be joined with the Confederation of Independent Basketball
Interactions.
Birinci Lig is the top division of the TRNC Basketball Federation.
PRESIDENT KTFF of is usually Hasan SERTOĞLU.
Hi there, after reading this awesome post i am as well glad to share my knowledge here with mates. Edgardo Ezdebski
There is apparently a bundle to know about this. I suppose you made certain good points in features also. Nickolas Duldulao
Pretty! This was an extremely wonderful article. Thanks for supplying this information. Rudolf Yerly
Well I definitely liked reading it. This article offered by you is very useful for proper planning. Riley Krzesinski
Thank you for sharing your info. I truly appreciate your efforts and I am waiting for your next write ups thanks once again. Lupe Brueggemann
Thanks for sharing, this is a fantastic post. Awesome. Mary Rothhaupt
Thanks again for the article post. Thanks Again. Cool. Theodore Spurlin
Looking forward to reading more. Great article post. Thanks Again. Really Cool. Felipe Dierkes
I have been reading out a few of your articles and i can claim clever stuff. I will definitely bookmark your website. Dana Randolph
I laughed all the way through this list. I have experienced ruined days with two already. Marco Kassner
Appreciation to my father who informed me regarding this webpage, this web site is genuinely awesome. Mohammed Curt
Hi there mates, how is tthe whole thing, and what you want to say concerning this paragraph, in my view its really remarkable in support oof me. Milan Longchamps
Hi there, just wanted to say, I enjoyed this blog post. Carmine Theunissen
Good post. I will be going through solme of these isues as well.. Brooks Raya
Hay que aumentarle la dosis de Cialis pa que se ponga feliz. Stacey Volper
There is visibly a bundle to find out about this. I assume you made certain nice points in functions additionally. Cornelius Kowallis
Thankyou my dear cousin. You have always been a support. Lots of love. Cristobal Braver
In order to become the best soccer player, you must practice as much as possible. Jarrod Pumphrey
Subheads utilize them. Why? Since readers are scanners. Carlos Depa
This is a very weighty post. Thanks quest of posting this. Reynaldo Scrivener
I go to see daily a few sites and blogs to read posts, except this blog provides quality based posts. Ross Sievertsen
Yes! Finally something about verificacion morelos 2020. Emery Lents
We are will swiftly and effectively produce a guarantee Premium restoration manhattan. Humberto Heninger
I do believe all of the ideas you have offered in your post. Spencer Beehler
Here is a superb Weblog You may Find Intriguing that we encourage you to visit. Alphonse Michie
Muchos Gracias for your blog article. Really looking forward to read more. Hayden Diedricks
A round of applause for your article post. Thanks Again. Much obliged. Patrick Ruggero
I think that is one of the such a lot vital info for me. Cornelius Kisor
This design is wicked! You certainly know how to keep a reader amused. Tommy Biggerstaff
Pretty! This was an extremely wonderful article. Thank you for supplying this info. Jospeh Mclaurine
Hi there, I enjoy reading through your post. I like to write a little comment to support you. Jarred Hesselbach