Algorithm to create a dynamic Histogram in Excel
The following procedure is done to create a dynamic histogram in Excel:
- Taking numerical data
- Determine Minimum and Maximum of data
- Subtract the Maximum from Minimum
- Set the number of bins which your final histogram should include (maybe sqare of n)
- Calculate: (Max - Min) / (NumberOfBins - 1)
- Create a table with all bins
- Determine the absolute frequency by using the function "Frequency" and the keys: Ctrl. and Shift
- Determine the relative frequency by calculating the frequency of one bin dividing by the number of all observations
- Create a graph of the relative frequency or the relative frequency
- Adjust the graph
Video with an Example