icon
of Reporter ToolBox.
It is function to calculate the average of absolute value(always positive value), between specific start and end cell location.
If you select the 'Insert | Function' after selecting the cell (one or several), Insert Function dialogue box comes up.
After inserting the '@AbsAve(A0:B2)' at Insert Function dialogue box, you can
modify this function by using the Cell Text
Edit dialogue box. This dialogue box comes up by selecting the 'Form | Cell
| Cell Text' or
icon
of Reporter ToolBox.
Also, you can insert this function by using the Cell Text Edit dialogue box, without Insert Function dialogue box.
Function for average of absolute value uses following format.
-Function definition : double AbsAve(cell 1 : cell 2)
-Function parameter : Specific number of cell. (start / end location)
-Result : The calculated absolute value.
Average of absolute value is same with setting method for Average Value function, except that this function is absolute value.
Example of written function) =@AbsAve(A0:B2);
Function description : It displays the average of absolute value for A0, A1, A2, B0, B1, B2 cell ( (|A0|+|A1|+ ...|B2|) / 8 value ).
Reference) ¡®|¡¯ is indication of absolute value.
Relate items)