The bin width Excel's automatic histogram uses: Scott's normal reference rule, 3.5 * s / n^(1/3) with s the sample standard deviation.
3.5 * s / n^(1/3)
s
The values binned.
The width; 0 when the values do not spread.
The bin width Excel's automatic histogram uses: Scott's normal reference rule,
3.5 * s / n^(1/3)withsthe sample standard deviation.