|
<Previous | Next | Contents >
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. Mean and Average. http:\\people.revoledu.com\kardi\ tutorial\BasicMath\Average\
|
