Part of the calculation of the coefficient of dispersion (COD) involves finding the absolute difference between every ratio and the median. The Median ratio has been calculated and is found in cell D103. Because we want every calculation to reference that cell, we will make that reference in the formula absolute ($D$103). The reference to each cell containing the ratios can be relative.
