Brother International PDP350CJ Owner's Manual - English - Page 397

Statistical Functions The arguments for statistical functions consist of either numbers, field names, or addresses of cells than contain numbers. The results of these calculations are always numbers. Function Description Example AVG (value1, value2,...) Average of the values in a list. You can use as many arguments as you want, including values, addresses, ranges, named cells, named ranges, and field names for arguments. AVG treats empty cells as zero values. You cannot average cells or fields containing text. =AVG(A15:A24) returns 74. =AVG(Grades) returns 85. =AVG(89,94,91,98) returns 93. MAX (value1, value2,... ) Largestnumber in a list. List can include values or addresses, separated by commas. MAX ignores empty cells and treats text as a zero. =MAX(2,4,6,8) returns 8. =MAX(-2,-4,-6,-8) returns -2. =MAX(B3:B13) returns the largest number in the range B3:B13. MIN (value1, value2,... ) Smallestnumber value in a list. List can include values or addresses, separated by commas. MIN ignores empty cells and treats text as a zero. =MIN(2,4,6,8) returns 2. =MIN(-2,-4,-6-,8) returns -8. =MIN(B3:B13) returns the smallest number in the range B3:B13. RANDOM ( ) Randomnumber between 0 and 1. RANDOM returns a new random number with every recalculation. RANDOM() returns a decimal value. RANDOMN (value) Randomnumber between 0 and value-1, a number you specify. RANDOMN returns a new random number with every recalculation. RANDOMN(100) returns a number between 0 and 99. STD (value1, value2,...) Standarddeviation of the values in a list. You =STD(254,255,253,248,257,255,256) returns can use as many values as you want. 2.944. The formula used by the STD function: p n∑x2 - (∑x)2 n (n-1) STDP (value1, value2,...) Standard deviation of a population. You can use as many values as you want. You can use values, addresses, ranges, named cells, and field names for arguments. =STDP(254,255,253,248,257,255,256) returns 2.726. The formula used by the STDP function: p n∑x2 - (∑x)2 n2 Appendix 370