Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Two Ways to Create a Frequency Distribution Report in Excel

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
15,590
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Sep 17, 2010

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.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (DannyRocksExcels)

  • thank you !!!

    

  • @cindyloOoouuUu

    My pleasure. Glad that you enjoyed this tutorial.

    Danny Rocks

    The Company Rocks

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

  • @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

  • thak u very much 

  • @aligh761

    My pleasure. Glad you liked my tutorial.

    Danny Rocks

    The Company Rocks

see all

All Comments (23)

Sign In or Sign Up now to post a comment!
  • @ubulumko85

    My pleasure! Glad that you found my tutorial helpful.

    Danny Rocks

    The Company Rocks

  • very helpful thanks!

  • @rajivnaithani

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

    Danny Rocks

    The Company Rocks

  • 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:)

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more