Dispersion can be measured using alpha and beta, which calculate risk-adjusted returns and returns relative to a benchmark index, respectively. Generally speaking, the higher the dispersion, the ...

How to Find Dispersion on Excel. ... In statistics, the amount of data dispersion is measured as variance. ... " without quotes in cell "B1" to calculate the variance of a sample.