Variance

4 lessons in order

This article explores how to calculate variance in Excel including examples of VAR.S, VAR.P, VARA, and VARPA function.

This article explains and explores the budget vs actual variance formula in Excel, budget vs actual % variance, and plotting variance chart.

This article explores what is variance inflation factor and how to calculate variance inflation factor in Excel with Data Analysis ToolPak.

This article explores what is a minimum variance portfolio and how to make a minimum variance portfolio in Excel with the Solver Add-in.