keenwhe.blogg.se

since there are 8 elements in the data set in Figure 2, we see that the frequency function for the random variable x is as in Figure 3 where each frequency value is divided by 8:įigure 3 – Frequency function corresponding to frequency table

Note too that a frequency table is closely linked to a frequency function, as defined in Definition 1 of Discrete Distributions. When data is provided in the form of a frequency table, the calculation of the mean and standard deviation cannot be performed directly using the usual AVERAGE and STDEV Excel functions. The table in Figure 1 shows that the data element 2 occurs 4 times, the element 4 occurs 2 times and the element 3 and 5 occur 1 time. For example, the data in range A4:A11 of Figure 1 can be expressed by the frequency table in range C4:D7.

Often data is presented in the form of a frequency table.