K
Knowledge001
How do you Normalize the frequency after finding the frequency and bin using
the Histogram.
the Histogram.
B
B. R.Ramachandran
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
11 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
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
11 contains the normalized frequencies. If you want to express thenormalized frequencies as percentages, modify the above formula as
=100*C2/SUM($C$2:$C$11)
Regards,
B. R. Ramachandran