I am trying to do a histogram in excel with the bins starting at 0 and each Bin being 0.2 in width. However when i set the bin width at 0.2 it starts the first bin at 0.11 because that is the lowest number in the dataset. how do i get the bin to start at 0 so that that the bins are
0-0.2,0.2-0.4, 0.4-0.6,0.6-0.8, 0.8-1.0
thanks for your help.
0-0.2,0.2-0.4, 0.4-0.6,0.6-0.8, 0.8-1.0
thanks for your help.