Tuesday, December 24, 2013

How to Calculate Variance in Excel 2007


1. Enter your data into one row in Microsoft Excel.
2. Type '=VAR(' in a cell that does not have data. For example, if all of your data is in column A, then use cell B1 for the variance function.
3. Highlight your data by clicking on the top of the data and dragging the mouse down to the bottom of the data.
4. Type ')' in the cell with your variance function to close the function and then press Enter. The cell now displays the variance of your data.

Blogger news