One student has asked for the procedure for making a histogram.
1. decide on the number of bins and bin width. A rough equation is:
#bins * bin width = range = max-min+1
So for instance if your min is 31 and your max is 150, then your range is 120. If you want 8 bins, then your bin width should be 120/8=15
2. Decide on your right boundaries. For the same example, they would be 45, 60,…,120 and put them in a column “bins”
3. Label the next column to the right of the bins_array with “frequencies”
4. Select the cells to the right of your bins and type “=frequency(data_array, bin_array)” where you click on the first element in each array and then shift-click on the last element in your array. Be sure to put a comma in between each input. If at any point, the target cells are not all selected then you need to start step 4 again.
5. Do not press enter, instead press shift-ctl + enter. As a check that you have done step 4 correctly, the frequencies should sum to number of data points.
6. With the frequencies selected, create a column graph going to the insert tab, adjust the horizontal axis in “select data”
and double click on a column to reduce the gap between the columns to a few percent.
