In statistics, the amount of data dispersion is measured as variance. The Excel function required for calculating variance depends on the data set.

A stock's historical variance measures the difference between the stock's returns for different periods and its average return. A stock with a lower.

To determine the variance in gross profit margin that these two types of adjustments create, calculate the margin for each price/cost scenario, and subtract the results.