Normalize frequency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel(Bin and Frequency) 1
histograms - frequency and relative frequency? 2
how to make a histogram with frequency 1
histogram is counting input data wrong 2
Wrong Frequency for Histograms 2
How do I create a Histogram for relative frequency distributions? 1
frequency table 4
Frequency Question -- Please Help 2

Back
Top