Business Statistics

Chapter 3 | Measures of Central Tendency 85

In order to compute the different values in Table 3.18, four digits after the deci-

mal point are taken. Due to this fact the total row in Table 3.18 will slightly vary

from the MS Excel output shown in Figure 3.17.

3.5.14 Using MS Excel for Harmonic Mean Computation

The process of computing harmonic mean is the same as the process of computing arithmetic mean and

geometric mean in MS Excel (Figure 3.17). The rst method is to type the formula “=HARMEAN

(A2:A11)” and press Enter (Figure 3.18). MS Excel will compute the harmonic mean of the given val-

ues which will appear in the concerned cell (Figure ...