Two Ways to Create a Frequency Distribution Report in Excel

With a Frequency Distribution Report, you can quickly see how often certain results occur. For example, how frequently are daily sales "under $75.00?

In this lesson, I demonstrate two ways to produce a Frequency Distribution:
1) Use the =FREQUENCY() Function - an Array Function
2) Group Row Labels by interval in an Excel Pivot Table


An "Array" Formula requires that you enter the forumula with the Ctrl + Shift + Enter keyboard combination. There are several other "Got'chas" when it comes to using Array formulas. This short video will show you how to successfully enter an Array Formula.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com -
to view all of my resources and to shop for my DVDs in "The Best Best Tips for ..." series.

Category:

Education

Tags:

• Array Function
• Frequency
• Pivot Tables
• Bin
• Data Analysis
• Microsoft Excel
• Lessons
• Tutorial
• Array Data Type
• Software
• Array Data Structure
• Office
• Microsoft Office
• Management
• Training
• Business
• Technology
• Information

[cindyloOoouuUu]

thank you !!!



[DannyRocksExcels]

@cindyloOoouuUu

My pleasure. Glad that you enjoyed this tutorial.

Danny Rocks

The Company Rocks

[cindyloOoouuUu]

i really liked the tutorial but im not sure if you have videos on statistics ...would love to see some

[DannyRocksExcels]

@cindyloOoouuUu

Thanks! I am pleased that you enjoyed this tutorial.

Re: Tutorial on Statistics. At this point, I do not have one available. I will add this to my "to-complete" list.

Danny Rocks

The Company Rocks

[aligh761]

thak u very much 

[DannyRocksExcels]

@aligh761

My pleasure. Glad you liked my tutorial.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@ubulumko85

My pleasure! Glad that you found my tutorial helpful.

Danny Rocks

The Company Rocks

[ubulumko85]

very helpful thanks!

[DannyRocksExcels]

@rajivnaithani

Thank you for your feedback. I am pleased that I could help you with this.

Danny Rocks

The Company Rocks

[rajivnaithani]

wonderful..You made it so easy to understand this..was struggling to understand it this way in Levine's book without steps to use it in excel..thanks once again:)