How do you create a histogram in Excel?

Answer 1

= = First of all, you need to open an Excel spreadsheet. Then go to 'TOOLS' in the menu bar and select 'ADD INS.' Choose 'ANALYSIS TOOL PACK' and click okay. Now we're on to making the histogram~ On your excel spreadsheet (the one that contains the data) you're going to have to to create. a column for the number of bins needed. This 'bin' of which I spoke of is the grouping of data based on the range of data you have. Find the range of data by doing this~ First, go to 'DATA' in the menu bar and select 'SORT.' Then choose the column you would like to sort and choose ascending or descending order. Then choose a different column on your spreadsheet and simply add the bins Navigate to "TOOLS, DATA ANALYSIS" and then select Histogram. Click on the small box to the right for input range. Highlight the column on your spreadsheet containing the data that you choose to be binned. This will turn into your frequency value. After that, highlight the bins column for the bin range. Go to 'OUTPUT OPTIONS' and choose 'NEW WORKSHEET PLY:' and then choose a name for the worksheet. It will be set up with a brand new, titled spreadsheet with 2 columns (bin and frequency). Then you highlight the frequency column of data and go to 'CHART WIZARD' pick column graph. Click on 'SERIES TAB CATEGORY (X) LABELS' to make sure that your x axis is labeled 'BIN.' Then you just complete it like normal. Help from~ http://www.pas.rochester.edu/~pavone/particle-www/teachers/analysis/HISTOGRAMS.htm