• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Make a Histogram in Excel 2010

How to Make a Histogram in Excel 2010

By: Lawrence Adams
  • Share
  • Share on Facebook

Histograms visually represent the frequency distribution of a data set in a graph form, allowing you to understand its statistical properties. Unlike traditional bar graphs, which often represent mean values, a histogram represents the frequency of a particular event. To make a histogram, you must have a data set that can be divided into classes, with each class having a specific frequency of responses. Microsoft Excel 2010 allows you to generate histograms from a data set, if you have the classes of data and frequency information for each class.

...
Histograms visually represent your data.

Step

Download the Excel 2010 Analysis ToolPak. Click "File," and then "Options." From the Add-Ins category, select "Excel Add-Ins," which display in the Manage box. Click "Go." Check the "Analysis ToolPak" box from the list of add-ins and click "OK."

Step

Choose an appropriate bin size for your data set. The bin size refers to the range of values that fall into a specific class. For example, if your data set is ages of people in the United States, set your bin size to 10 years. This makes the bins correspond to ages 0-10, 11-20, 21-30 and so on, with a maximum bin of 101-110. Select a bin width that creates five to 20 groups of data.

Video of the Day

Step

Type the bin widths in column A of a blank worksheet, beginning with the lowest number. For the age range example, type 0, 10, 20, 30 and so on.

Step

Type the data points in column B of the worksheet. Keep the data points as raw numbers, rather than converting them to frequencies. List the entire set of numbers in any order.

Step

Look in the Analysis section of the Data tab. Click "Data Analysis" and highlight the "Histogram" tool from the Analysis Tools box. Click "OK."

Step

Enter the Input Range in the box provided, and highlight the contents of column B. In the Bin Range field, highlight the contents of column A. This tells the software what data to use to make the histogram.

Step

Select "Chart Output" in the output options section to generate a histogram graph. Click "OK."

Step

Modify your histogram to include custom labels. Double-click on the x- and y-axis labels to change the text. Use the "Chart Tools" section to modify the design, layout and format of your histogram.

Show Comments

Related Articles

How to Do a Weighted Regression in Excel

How to Do a Weighted Regression in Excel

Around The Home
Productivity
By: Emily Ediger
How to Figure Frequency Percentages in Microsoft Excel

How to Figure Frequency Percentages in Microsoft Excel

Around The Home
Productivity
By: Bennett Gavrish
How to Create a Histogram in Excel

How to Create a Histogram in Excel

Around The Home
Productivity
By: Catie Watson
How to Calculate Incremental Growth in Excel

How to Calculate Incremental Growth in Excel

Around The Home
Productivity
By: Emily Ediger
How to Plot Autocorrelation in SPSS

How to Plot Autocorrelation in SPSS

Around The Home
Productivity
By: Amy Ess
How Do I Make an Ogive in Excel?

How Do I Make an Ogive in Excel?

Around The Home
Productivity
By: Lee Johnson
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.