< Previous | Next | Contents >

Excel Functions related to this tutorial

Use MS Excel function. Here are some function references for you. Click here to download the Microsoft Excel file examples companion of this tutorial .

=ABS to compute absolute value of numbers

=COUNT to compute number of data

=SUM to compute the total summation of data

=PRODUCT to compute total product or multiplications of data

= SQRT to compute square root of numbers

=AVERAGE to compute arithmetic mean

=GEOMEAN to compute geometric mean

= AVEDEV to compute absolute deviation mean

= DEVSQ to compute the sum of squares of deviations

= DEVSQ/COUNT to compute variance or average square deviation

= VARPA to compute variance directly

= HARMEAN to compute harmonic mean

= SUMSQ to compute sum of square

= SQRT ( SUMSQ/COUNT) to compute quadratic mean

< Previous | Next | Contents >

Preferable reference for this tutorial is

Teknomo, Kardi (2015) Mean and Average. http:\\people.revoledu.com\kardi\ tutorial\BasicMath\Average\