iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here

Formula Functions: Averages

Functions: Flexaverage and Average, Maxaverage, Dropaverage

Description:
The mean functions calculate the arithmetic mean of a selection - unlimited - of columns.
Each function has its own peculiarity, but in most cases, FLEXAVERAGE is the one to be used.

FLEXAVERAGE

Arithmetic mean of all columns included. Skip empty cells

FLEXAVERAGE (column, column, column, column ...)
You must insert any value (p.e. 0) in one empty cell if you want it to be included in the calculation.

AVERAGE

Kept for legacy reasons, actually does exactly the same es Flexaverage.

MAXAVERAGE

It takes the N maximum values of a selection of columns and calculates their arithmetic mean.
Skip empty cells


MAXAVERAGE (Number of maximum columns to take into account, column, column, column ...)

DROPAVERAGE

Discard the minimum N values of a selection of columns and calculate their arithmetic mean. Skip empty cells

DROPAVERAGE (Number of minimum columns to drop, column, column, column ...)

Example

These are our sample data. In each cell the values that are taken into account with each function are shown.



Related articles

Rounding a Formula's result
Formulas: IF condition
Formulas, apply limits to results
Your first Formula
    21 AUG

    iDoceo 7 for iPad and Mac now available!

    A huge update with tons of new features and a new interface

    Read more

    6 JUN

    Create Multiple-choice tests with iDoceo Connect!

    In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

    Read more

    Cookies policy

    This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.