I have a dataset like this:
我有这样的数据集:
10, 23, 43, 45, 56;
12, 25, 21, 23, 40;
I want to know the average of the difference between the two rows like
我想知道两行之间差异的平均值
mean (10 - 12, 23 - 25, 43 -21 ...)
意思是(10 - 12,23 - 25,43-21 ......)
Of course, this is only an example and the actual rows are hundreds of element long. I would like to compute the average of the difference without having to compute somewhere the difference and then having the average. (The sheet is already pretty big)
当然,这只是一个例子,实际行数百个元素长。我想计算差异的平均值,而不必计算差异的某个地方然后得到平均值。 (表已经相当大了)
Thanks a lot
非常感谢
3 个解决方案
#1
2
Mathematically, what you are asking for is identical to:
在数学上,你要求的是:
=AVERAGE(A1:E1)-AVERAGE(A2:E2)
Regards
#2
1
Try,
=AVERAGE(INDEX((A1:E1)-(A2:E2), , ))
#3
0
If there were missing values in one range or the other, you would need something like
如果在一个范围或另一个范围内缺少值,则需要类似的东西
=AVERAGEIFS(A1:G1,A1:G1,"<>",A2:G2,"<>")-AVERAGEIFS(A2:G2,A1:G1,"<>",A2:G2,"<>")
(I have tested it with blanks in G1 and F2)
(我在G1和F2中用空格测试了它)
#1
2
Mathematically, what you are asking for is identical to:
在数学上,你要求的是:
=AVERAGE(A1:E1)-AVERAGE(A2:E2)
Regards
#2
1
Try,
=AVERAGE(INDEX((A1:E1)-(A2:E2), , ))
#3
0
If there were missing values in one range or the other, you would need something like
如果在一个范围或另一个范围内缺少值,则需要类似的东西
=AVERAGEIFS(A1:G1,A1:G1,"<>",A2:G2,"<>")-AVERAGEIFS(A2:G2,A1:G1,"<>",A2:G2,"<>")
(I have tested it with blanks in G1 and F2)
(我在G1和F2中用空格测试了它)