Statistics - Function AVERAGE-MEDIAN

Page visited 10434 times

 
1. With Excel, make statistics is very easy with the internal functions. In this section, we will see most of the common statistics functions Here are the pluviometry result for a city
Excel-Exercise-Tutorial-1
 
 
2. The AVERAGE function returns the average of range of cells
Excel-Exercise-Tutorial-2
Formule de la cellule
=AVERAGE(B3:B14)
 
 
3.
Excel-Exercise-Tutorial-3
Formule de la cellule
=MEDIAN(B3:B14)
 
 
4.
Excel-Exercise-Tutorial-4
Formule de la cellule
=MODE(B3:B14)
 
 
5.
Excel-Exercise-Tutorial-5
Formule de la cellule
=COUNTIF(B3:B14;MODE(B3:B14))
 
 
 
6.
Excel-Exercise-Tutorial-6
 
 
7.
Excel-Exercise-Tutorial-7
Formule de la cellule
=QUARTILE(B3:B14;1)
 
 
 
8.
Excel-Exercise-Tutorial-8
 
 
 
9.
Excel-Exercise-Tutorial-9