bin
 

How do you select Bin values when using the Histogran?

bin
 

Hi,

You don't have to specify the Bin values for the HISTOGRAM function. If you
omit them, Excel will use an appropriate set of bins based on the minimum and
maximum of your data.

You can also make up a column of bin values of your choice (it should be IN
ASCENDING ORDER). For example, if the minimum and maximum of your data are
0.48 and 9.52, you could create bin values 0.0, 1.0, 2.0, ...... 10.0 (or
something like that). Then, you have to specify the bin range in the
HISTOGRAM function.

Regards,
B. R. Ramachandran


"Knowledge001" wrote:

How do you select Bin values when using the Histogran?