The Mode function in Microsoft Excel is classified as a compatibility function and recommends using the MODE.MULT and MODE.SNGL instead.

This tutorial will show you how to remove disable or turn off the Compatibility Mode in Microsoft Excel. Without Compatibility Mode, some documents may display incorrectly.

To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR.