< Previous | Next | Contents >

Data Science using Excel

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

=FLOOR to compute floor function

< Previous | Next | Contents >

Rate this tutorial or give your comments about this tutorial

This tutorial is copyrighted .

Preferable reference for this tutorial is

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