Excel - Descriptive Statistics - Excel - Episode 1568
2,426 views · Published 29 June 2012 · 6:43 · Indexed 8 November 2026
Channel: MrExcel.com · 2012 · Education
Microsoft Excel Tutorial: Descriptive Statistics in Excel. Welcome back to another exciting episode of Dueling Excel, where we pit two Excel experts against each other to find the best solution to a given problem. In this episode, we'll be tackling the topic of Descriptive Statistics, and I'm joined by my good friend and fellow Excel guru, Mike Girvin from Excel Is Fun. After a brief hiatus due to my book writing commitments, we're back with a bang to bring you the best Excel tips and tricks. Today's question is about finding the SUM, AVERAGE, STANDARD DEVIATION, MIN, and MAX of a large data set in Excel. Mike suggested using a pivot table, but I had a different approach in mind. I discovered that by simply selecting the entire range and clicking on the bottom-right corner, I could easily find the desired statistics. However, I was disappointed to find that the Standard Deviation option was not available in the quick statistics menu. But fear not, I remembered a handy tool called the Analysis ToolPak, which can be enabled by going to Alt+TI and selecting the Data Analysis button. Although the Data Analysis tool can be a bit tricky to use, I found the Descriptive Statistics option to be the perfect solution for our problem. By selecting the input range and choosing the desired output options, we were able to get the SUM, AVERAGE, STANDARD DEVIATION, MIN, and MAX with just a few clicks. And just like that, our problem was solved. But Mike had another trick up his sleeve. He showed us how to use functions and define names to quickly find the desired statistics. By using the Text to Columns and Paste Special, Transpose options, he was able to avoid a lot of typing and save time. And with the help of the Define Names feature, he was able to create a defined name for each statistic, making it even easier to use in the future. In the end, we both had different approaches to finding the desired statistics, but both were equally effective. Whether you prefer using the Data Analysis tool or creating defined names, we hope you learned something new and useful in this episode. Thank you for tuning in, and don't forget to join us for our next Dueling Excel podcast from MrExcel and Excel Is Fun. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Topic: Descriptive Statistics (00:23) Question: Calculating SUM, AVERAGE, STANDARD DEVIATION, MIN, and MAX for a large data set (00:36) Option 1: Using the Analysis ToolPak (01:55) Option 2: Using a Pivot Table (03:00) Option 3: Using Functions and Defined Names (06:01) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Analysis ToolPak Average function Data analysis Descriptive Statistics Max function Min function Paste Special Transpose Pivot table Standard deviation Sum function Text to Columns Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153378/ Excel Tutorial: In our latest Dueling Excel Podcast, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen look at using =SUM, =AVERAGE, =STDEV, =MIN, =MAX with a Pivot Table and More to show a set of Descriptive Statistics from the current Data Set. Follow along with Mike and Bill in Episode #1568 to see a few very important Functions in action! Dueling Excel Podcast #108...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] http://www.mrexcel.com/slayingdragonsebook2011.html and "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920