For example you calculate the relative frequency of prices between 350 and 374 as 620 to get 030 30 percent. This is one of the most popular features used by millions of Excel users in the world. The cumulative relative frequency is equal to the some of the relative frequencies of all the previous intervals including the current interval.
Let consider a randomly carried out experiment is repeated N times and the total number of outcomes that are observed are f times.
The number of classes can be estimated using the rounded output of Sturges rule N 13322logn N 1 3322 log n where N N is the number of classes and n n is the number of items in the data set. The will become the denominator in the fraction that you use for calculating. The formula for the relative frequency is given as. Similarly the relative frequency of prices between 375 and 399 equals 420 020 20 percent.