<
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
Rate this tutorial or give your comments about this tutorial
<
Previous

Next

Contents
>
This tutorial is copyrighted .
Preferable reference for this tutorial is
Teknomo, Kardi (2015) Mean and Average. https:\\people.revoledu.com\kardi\ tutorial\BasicMath\Average\