+ Reply to Thread
Results 1 to 2 of 2

Histogram cumulative 20% of the distribution

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2010
    Posts
    1

    Histogram cumulative 20% of the distribution

    Hi all,

    I am working with the Analysis ToolPak in Excel 2010. I need to make some histograms that include the following "bin" categories - 25, 50, 75, 100 - but unlike the default setting in Excel, I don't need the bin categories based on the values in the histogram, I need them based on the percentage of the distribution. For example, if my values are 5, 20. 30, 50, 70, 70, 80, 90, 100, I need to know the value at the cumulative 20% of the distribution - what's the value at 20% of the distribution, not the % of cases that have a value of 20 on a scale of 100. Any help would be appreciated - thanks!
    Last edited by pike; 02-03-2012 at 03:45 PM. Reason: change Title for newbie

  2. #2
    Registered User
    Join Date
    01-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Histogram

    Hello aekrohm!

    Good to see you here

    Please take a look a this tutorial: histogram. I think it could help you. Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1