Quickly gather statistics for your data using Excels Descriptive Statistics

in hive-102332 •  2 months ago 

Excels Descriptive Statistics will quickly allow you calculate a number of statistics from multiple columns of data at a time.

The statistics include

  1. Mean
  2. Standard Error
  3. Median
  4. Mode
  5. Standard Deviation
  6. Sample Variance
  7. Kurtosis
  8. Skewness
  9. Range
  10. Minimum
  11. Maximum
  12. Sum
  13. Count
In this video you will learn how to activate the Data Analysis tool pac in Excel and how to quick run descriptive statistics. You can download the data set at the bottom of the article.


Sign up for my newsletter. Don’t worry, I wont spam. Just useful Excel and Power BI tips and tricks to your inbox



Sign Up

Excels descriptive statistics can be found in the data analysis tool pak. This is an add in, and to turn it on, got to file, then options then go to add in’s. In Excel Add in’s, select Analysis tool pack.

correlation in excel

Once you have turned on the Analysis Tool pak in Excel, you will find a new option in your data ribbon.

data analysis toolpac in excel

Selecting Descriptive Statistics will open a new window

excel analysis tool pac

Now you can select the range that contains your data, if it is grouped by columns or rows and if your data has headers in the first row.

statistics in excel

After this you then select the Output options. Make sure you tick the box for summary statistics. Once all of the selections are made, it is as simple as pressing OK and your table of descriptive statics will be returned.

Quickly gather statistics for your data using Excels Descriptive Statistics


DOWNLOAD DATA SET USED IN THIS EXAMPLE

In return for this Tip -Quickly gather statistics for your data using Excels Descriptive Statistics - I ask that you share this post or the video with your friends and colleagues



Cross posted from my blog with SteemPress : https://theexcelclub.com/excels-descriptive-statistics/

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Congratulations @theexcelclub! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You distributed more than 29000 upvotes. Your next target is to reach 30000 upvotes.

You can view your badges on your board And compare to others on the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Support the HiveBuzz project. Vote for our proposal!