How do you Normalize the frequency after finding the frequency and bin using
the Histogram.

Hi,

Divide the frequency of each bin by the sum of all the frequencies (the
latter is the same as the number of values in your original data).

So, if the bins are in B2:B11, and frequencies are in C2:C11, in D2 enter
the formula, and drag the formula down to D11.

=C2/SUM($C$2:$C$11)

D2:D11 contains the normalized frequencies. If you want to express the
normalized frequencies as percentages, modify the above formula as

=100*C2/SUM($C$2:$C$11)

Regards,
B. R. Ramachandran


"Knowledge001" wrote:

How do you Normalize the frequency after finding the frequency and bin using
the Histogram.