Hi I have a column A from row 1 to 500 containing some values. I need to calcula

Question

Hi

I have a column A from row 1 to 500 containing some values.

I need to calculate the difference between average of whole data points (cells A1 : A500) and deduct the average of the same data set excluding the associated value in each row.

for instance

Row Column A Column B

1 23 Average (full date points)- Average of (all data minus value in row 1)

2 24     Average (full date points)- Average of (all data minus value in row 2)

3 25 Average (full date points)- Average of (all data minus value in row 3)

4 22 Average (full date points)- Average of (all data minus value in row 4)

5 28 Average (full date points)- Average of (all data minus value in row 5)

.

.

.

500 21 Average (full date points)- Average of (all data minus value in row 500)

Thanks!!

Any suggestion???

Explanation / Answer

In B1:

=AVERAGE($A$1:$A$500)-(SUM($A$1:$A$500)-$A1)/(COUNT($A$1:$A$500)-1)

Fill down to B500.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects