Page 318 - Microsoft Word - 00 ACCA F2 Prelims.docx

Chapter 17

Statistical functions

The basic commands for statistical functions that operate on lists of values are also
very similar throughout the range of spreadsheet packages. Examples of these are:

 SUM – the total of the values in the list

 AVG – the average of the values in the list

 MAX – the highest value in the list

 MIN – the lowest value in the list.

312