What is the method for determining the variance between rows in Excel?

asked 2021-08-16 11:00:00 +0000

bukephalos
21 ●4 ●3

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2021-07-19 10:00:00 +0000

lakamha
21 ●3 ●3

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).

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools

Stats

Asked: 2021-08-16 11:00:00 +0000

Seen: 8 times

Last updated: Jul 19 '21

What is the method for determining the variance between rows in Excel? edit

1 Answer