Frequency distribution plot

**mmmd_yaseen** · 10-07-2010, 05:33 AM

Hi All,

I have to plot a frequency distribution for a given data ( inter packet arrival time). .I have selected some bin ranges from the data value and gave the frequency formula of =frequency (data array, bin range ) and then pressed ctrl + shift + enter I get "NA" value on the frequency column.

Please help me in selecting the bin range and to calculate the frequency distribution plot .
My data is someowhat similar to below data . It's basically a long file with 50000 entries in the excel sheet . I couldn't attach it here . please incase if you want ,i'll send to your email.

" 0.000048 "
" 0.000049 "
" 0.000049 "
" 0.000050 "
" 0.000052 "
" 0.000053 "
" 0.000054 "
" 0.000057 "
" 0.000058 "
" 0.000058 "
" 0.000058 "
" 0.000058 "
" 0.000058 "
" 0.000059 "
" 0.000059 "
" 0.000060 "
" 0.000061 "
" 0.000061 "
" 0.000062 "
" 0.000063 "
" 0.000063 "
" 0.000063 "
" 0.000063 "
" 0.000064 "
" 0.000065 "
" 0.000065 "
" 0.000065 "
" 0.000065 "
" 0.000065 "
" 0.000066 "
" 0.000066 "
" 0.000066 "
" 0.000067 "
" 0.000067 "
" 0.000067 "
" 0.000067 "
" 0.000068 "
" 0.000068 "
" 0.000069 "
" 0.000069 "
" 0.000074 "
" 0.000075 "
" 0.000075 "
" 0.000076 "
" 0.000076 "

Thanks
Yaseen

**sweep** · 10-07-2010, 06:53 AM

Hi,

A good starting point for the number of bins is the square root of the number of samples.

When you've decided on the bins, enter them in an unused column in excel (eg J1:J20). Next, select the cells in the next column to the bins (eg K1:K20).

Press F2 to edit the range, and type =FREQUENCY(data_array,J1:J20) and confirm with CTRL, SHIFT and ENTER.