Steps: 1. Input the data in Excel 2. Find maximum and minimum values (2 and 87 respectively) 3. Calculate the range, that is, Range = (maximum -minimum)/Number of intervals. For 10 intervals; Range = (87-2)/10 = 8.5 4. Generate the Bin. That is, From minimum and adding range until the maximum value. Using Histogram tool in Excel, the histogram was generated as shown in the figures attached.
