The set of projections for estimated cash flow is: $350, $400, $675, $725, $850, and $900. Calculate the coefficient of variation

FIGURE 7.1 Calculating the Standard Deviation and Coefficient of Variation 1. The standard deviation formula in Excel, using data set, is: = STDEV(250, 400, 675, 725, 850,875) = 252 2. The calculation of the mean of all data is: = (sum of all data items) (number of data items) = (250 + 400 + 675 + 725 +850 +875)/6 = 629 3. The calculation of the coefficient of variation is: = (standard deviation)/(mean) = 252/629 = 40%