Bin numbers
3. Click on the Tools menu and select Data Analysis. If there is not a Data Analysis option under the Tools menu, you may need to install the add-in. You can install the add-in by selecting the Add-Ins option under the Tools menu. Check the box next to Analysis ToolPak and click OK. A window will open.  You can analyze your data and display it in a histogram (a column chart that displays frequency data) by using the Histogram tool of the Analysis ToolPak in Microsoft Office Excel. To create a histogram, you must organize the data in two columns on the worksheet. These columns must contain input data and bin numbers. Input data is the data that you want to analyze by using the Histogram tool. Bin numbers are the numbers that represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis. When you use the Histogram tool, Excel counts the number of data points in each data bin. A data point is included in a particular data bin if the number is greater than the lowest bound and equal to or less than the largest bound for the data bin It uses two columns of data to create a histogram -- one for data you want to analyze and one for bin numbers that represent the intervals by which you want to measure the frequency. Make sure you load the Analysis ToolPak to add the Data Analysis command to the Data tab. Then you’ll be ready to create a histogram. Here’s how: On a worksheet, type the input data in one column, adding a label in the first cell if you want. Be sure to use quantitative numeric data, like item amounts or test scores. If you want to create a histogram in Excel, you can use this sample input data. This embedded workbook shows the finished histogram. You can create the histogram yourself by copying cells A1:B11 and pasting them into cell A1 in a new worksheet. Make sure you load the Analysis ToolPak to add the Data Analysis command to the Data tab. Then you’ll be ready to create a histogram. Here’s how: On a worksheet, type the input data in one column, adding a label in the first cell if you want. Be sure to use quantitative numeric data, like item amounts or test scores. Input data This is the data that you want to analyze by using the Histogram tool. Bin numbers These numbers represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis. When you use the Histogram tool, Excel counts the number of data points in each data bin. Create a histogram. To enter the data that you want to analyze in a histogram, do one of the following: Copy the example worksheet data to your worksheet. How to copy the example worksheet data. Create a blank workbook or worksheet. Select the example in the Help topic. Note Do not select the row or column headers A frequency distribution table is a table that shows how often a data point or a group of data points appears in a given data set. To make a frequency distribution table, first divide the numbers over which the data ranges into intervals of equal length. Making a Histogram Using a Frequency Distribution Table. A histogram is a bar graph which shows frequency distribution. To make a histogram, follow these steps: Example: Make a histogram showing the frequency distribution of the price of birthday cards. 1  On the vertical axis, place frequencies. A Histogram is a vertical bar chart that depicts the distribution of a set of data. UnlikeRun Charts or Control Charts, which are discussed in other modules, a Histogramdoes not reflect process performance over time.  A histogram or Pareto (sorted histogram) is a column chart that shows frequency data. Here’s a typical example: To create a histogram in Excel, you use the Histogram tool of the Analysis ToolPak. Make sure you load the Analysis ToolPak to add the Data Analysis command to the Data tab. Then you’ll be ready to create a histogram. Here’s how: On a worksheet, type the input data in one column, adding a label in the first cell if you want. Be sure to use quantitative numeric data, like item amounts or test scores.
http://www.wikihow.com/Create-a-Histogram-in-Excel https://support.microsoft.com/en-us/kb/214269 https://support.office.com/en-us/article/Create-a-histogram-B6814E9E-5860-4113-BA51-E3A1B9EE1BBE https://support.office.com/en-us/article/Create-a-histogram-B6814E9E-5860-4113-BA51-E3A1B9EE1BBE https://support.office.com/en-us/article/Present-your-data-in-a-histogram-CCC0FC1A-2CCD-490F-A346-87F3084CC26E http://www.sparknotes.com/math/algebra1/graphingdata/section2.rhtml http://www.saferpak.com/histogram_articles/howto_histogram.pdf https://support.office.com/en-us/article/Create-a-histogram-B6814E9E-5860-4113-BA51-E3A1B9EE1BBE
name the intervals you would use to create a histogram of the data given