Revision history [back]
 | 1 | initial version |
To determine the variance between rows in Excel, you can use the formula =VAR.P(A1:A10,B1:B10). This will give you the population variance between two rows of data (A1:A10 and B1:B10 in this example). You can adjust the range of cells to fit your specific data set. If you want the sample variance, use the formula =VAR.S(A1:A10,B1:B10).