There are a few different options for the formula to calculate variance in Excel: =VAR.S(select data) ... In this instance, if we had all returns in the history of the SPY ETF in our table, ...

The standard deviation is smaller than the variance when the variance is more than one (e.g., 1.2 or 120%). The table below summarizes some of the key differences between standard deviation and ...