How to Calculate a Model in Excel. Mathematical models are a way to attempt to predict the probable outcome of a complex situation. From climate, stock market and physics models, you can use ...

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