Excel Functions related to this tutorial

<Contents | Previous | Next >

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

Central tendency

=AVERAGE to compute arithmetic mean

= MEDIAN to compute median

= MODE to compute mode

Spread

=MAX – MIN to compute range

=QUARTILE (array, 3) – QUARTILE (array, 1) to compute Inter quartile range (IQR)

= VAR to calculate variance of sample

=VARPA to calculate variance of population

= STDEV to calculate standard deviation of sample

= STDEVPA to calculate standard deviation of population

Other related functions (that mentioned in this tutorial)

=SUM to compute the total summation of data

=CEILING to compute ceiling function

Rate this tutorial or give your comments about this tutorial

<Contents | Previous | Next >

This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi. Learning from Data. http:\\people.revoledu.com\kardi\ tutorial\BasicMath\Average\