| How to Create
Histograms in Excel 1. Open the data file and calculate the borders of the cell The example below assumes that your excel file contains 2 columns of data. At column A: the data which you will use to create the histogram and at column B: the cell upper boudaries. 1.1 Calculate cell upper boundaries To calculate the frequencies, Excel requires you to pre-determine the cell boundaries of the histogram. First calculate the range of data that each cells will contain as follows : (Maximum - minimum) / (number of cells) If you don't already know the maximum and minimum level of your data, you can type the following formula (The formula below assumes that your data is at column A and you will create 10 cells for your histogram): = (max(a:a)-min(a:a))/10 Add this number to the minimum level of your data to find out first upper boundary. You can keep adding the same number to calculate other boundaries. 2. Using Analysis Tool Pack to create histogram In order to create histograms in Excel we use the Analysis Tool Pack.To activate Analysis Tool Pack click Data Analysis option from Tools menu.
If Data Analysis option doesn't appear under Tools menu, you must install it first. Click here to find out how to install Analysis Tool Pack . Once the installation is completed, run Data Analysis as indicated above. From upcoming menu click on Histogram and OK button respectively.
Next window lead you to define the data and cell boundaries of the histogram . To determine the data range click once on the Input range toolbox and then select the column which contains your data. Again, to determine the upper boundaries of the histogram click on the Bin Range toolbox and select the cells where upper boundaries placed.
Once you click OK button in the above menu, Excel will calculate the frequencies required for your histogram and will list the bins in column A and frequencies in column B. (If New Worksheet Ply is checked the table will store in a new excel sheet)
|
