Excel 2010
1
Các hàm trong excel
a. Nhóm hàm về thống kê
 lch tuym d
li s bii ca tp
s liu
ng
ng c, bao gm
c nh logic
ng c trong mt mng
theo mu kin
ng c
trong mt mng theo nhiu kin
COUNT (value1, value2, ...) m s 
m s  ng) trong danh

Excel 2010
2
ng trong m
m s a mu kit

COUNTIFS m s a nhiu kin
c
 lm d liu t

m t  ca tp d lic
 li p h
 hng ca mt s 
SKEW (number1, number2, ...) : Tr v  lch c  i
xng ca i quanh tr 
SMALL (array, k) : Tr v  nh nht th k trong mt tp s
 lch chu mu
 lch chu mu, bao gm
c nh logic
 lch chu tp hp
 lch chu tp hp, k c
ch  logic
VAR (number1, number2, ...) : Tr v  mu
Excel 2010
4
VARA (value1, value2, ...) : Tr v u, bao gm c 

VARP (number1, number2, ...) : Tr v  tp hp
VARPA (value1, value2, ...) : Tr v  tp hp, bao
gm c  
n trong ca mt tp d liu,
bi t l phm d liu   cui tp d liu.
b. Nhóm hàm về phân phối xác suất
BETADIST (x, alpha, beta, A, B) : Tr v  c 
su
BETAINV (probability, alpha, beta, A, B) : Tr v ngho c


GAMMADIST (x, alpha, beta, cumulative) : Tr v gamma
th   lch
GAMMAINV (probability, alpha, beta) : Tr v ngho c
gamma.
 
HYPGEOMDIST (number1, number2, ...) : Tr v t ca
mt s l