<
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\