How do I subtract a constant from the argument of
=AVERAGE()
function :
=AVERAGE((A2:A21)-3)
doesn’t work.
What is it you are trying todo? Subtract the const value (3) from each element in the range?
Mathematically it is the same thing to subtract 3 from the average of values or to build the average of (values - 3):
but of course you could use:
[1] {=AVERAGE(A2:A21-3)} (enter =AVERAGE(A2:A21-3) and finalize with CTRL+SHIFT+ENTER, to get the array formula – or–
[2] =SUMPRODUCT(AVERAGE(A2:A21-3))
Thats one reason, why i ask what @max2 actually wants todo. I seemed a bit odd, so i suspected a
xy-problem XY problem - Wikipedia.
I wanted to compute the k-th central AND non-central moment of a given array of $X_i$'s for a given natural number k. I want a macro for this 2 moments. The X_i’s are A:37 to A56
I wanted to compute the k-th central AND non-central moment of a given array of $X_i$’
You asked that in another question here: Third central and non-central moment in LO. Don’t expect a question answered which is not asked here. This question here is: How do I subtract a constant from the argument of =AVERAGE() function and this question has been answered by @Hrbrgr.
