How do I calculate variance between numbers?

  • Thread starter Thread starter copitta
  • Start date Start date
C

copitta

I have two columns of scores. I need to calculate the variance (difference)
across the two columns, with the result in column three. Seems simple but I
cannot figure it out. Thank you.
 
I don't know what you mean by variance in this context.

The variance of A2:A100 is =VAR(A2:A100)
If you want the difference between A2 and B2 it is =B2-A2
 
Actually, the difference is correct. But how do I calculate each difference
of 2 numbers across for 2 columns of numbers down? For example, I have a
list of scores running down column A, and another list of scores running down
column B. I would like to calculate the differences between the two in
column C.
 
The difference between A2 and B2 is =B2-A2. The difference betwen A3 and B3
is =B2-A3.

If you want to copy the formula from C3 down column C there are at least 3
ways:
Copy C2, highlight the relevant remaining cells in column C and paste.
Click in the bottom right hand corner of C2 so that you see a square fill
handle, and drag that down.
Double click on the fill handle (see above) and it will fill dows as far as
there is data in column B.

If you want to add the values in column C, =SUM(C2:C100)
 
Thank you. This is exactly what I needed.

David Biddulph said:
The difference between A2 and B2 is =B2-A2. The difference betwen A3 and B3
is =B2-A3.

If you want to copy the formula from C3 down column C there are at least 3
ways:
Copy C2, highlight the relevant remaining cells in column C and paste.
Click in the bottom right hand corner of C2 so that you see a square fill
handle, and drag that down.
Double click on the fill handle (see above) and it will fill dows as far as
there is data in column B.

If you want to add the values in column C, =SUM(C2:C100)
Click to expand...
 
Back
Top