A definition of variance with a chart and how to calculate variance in Excel, including =AVERAGE function, =SUM function and =SQRT. For investment and financial modeling of stocks and portfolios. Of course you can use the =VAR.P function or the =STDEV.P but to truly learn investment modeling knowing this calculation is vital. https://factorpad.com/fin/glossary/variance.html Topics covered in our investment glossary: Excel tutorial, Python examples, portfolio theory, portfolio return, portfolio risk, correlation, regression, linear algebra, alpha signal, risk models, performance attribution. Glossary: https://factorpad.com/fin/glossary/index.html Innovators: https://factorpad.com/fin/innovators/index.html https://factorpad.com/