Monday, 20 February 2017

Frequency

               Frequency formula

We use this formula when we have to sapparate the data in Interval. Using this formula we can saprate the data into the part.
for Example we hav a data of the student weight and we have to find that how many student have weight is 0-15 and how many have 15-50 and how many have 50-100
=frequency(select data , then select interval )

 Data_ array   = Select the range of weight(Kg)
 bins_ array    = Weight interval column

First of all select the whole that is highted with red color
in that cell we will apply the formula of frequency.

(=frequency(select data , then select interval )
then press the three key together (ctrl shift enter)

here is the link

https://drive.google.com/drive/my-drive













No comments:

Post a Comment

Thank you for comment.

calculation of professional tax

Normally professional tax in not applicable all over the country but there are some state where the government take professional tax  Kar...