Results 1 to 4 of 4

Thread: Topic 32: Guide to creating Histogram with Excel 2007

  1. #1
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10

    Topic 32: Guide to creating Histogram with Excel 2007

    Advertisement

    With Excel 2007, you can make a histogram to group a list of values into categories and compare the categories. Excel calls these categories bins.

    Advertisement
    To better illustrate on how to create a histogram, create a worksheet as below:


    This worksheet is to display the test scores for a group of students, for example, your first bin might be <=50, representing scores of 50 mark or under; your second bin might be 75; and last bin fortest scores up to100 mark. Excel counts the number of occurrences in each bin.

  2. #2
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    When creating a histogram, you must provide three pieces of information:

    • Firstly, define the raw data you want to sort.
    • Secondly, define the bins (must be in lowest to highest order).
    • Finally, specify the cell in which you want the result to appear.

    The results can appear in the current worksheet, in a new worksheet, or in a new workbook.

    As you make changes to your data, Excel does not automatically make changes to your histogram. You must regenerate your histogram when you make changes to your data.

    Note: The histogram tool is part of the Analysis Toolpak, which you may need to install the add-ins first as explain in the Excel 2007 add-in article.

  3. #3
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    To create or make a histogram
    • Type the values that define the bins ordered from lowest to highest (cells D6 to D8 in our case).
    • From the Data tab, in the Analysis group, click Data Analysis icon.

    • From the Data Analysis dialog box displayed, click Histogram.
    • Click OK.
    • From the Histogram dialog box displayed, under the Input section:

  4. #4
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    Click on Input Range:, then click and drag the range of numbers to categorize (cells B2 to B13 in our case).

    Click on Bin Range:, then click and drag the range of bins (cells D6 to D9 in our case).

    • Under the Output options section, click or select options as needed:
    • Click on Output Range: and select the cell where you want the results to start, or type the cell address (such as cell F2).
      Pareto (sorted histogram) - sorts data from highest to lowest.
      Cumulative Percentage - shows cumulative percentage.
      Chart Output - check this to displays a chart in the worksheet.
    • Click OK. If you see some pop-up, just click OK.
    • You will see the results as follow:


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
  •