Statistics을 위한 중요한 Excel 용어 정리

 

 

 

Mean	=average(data전체선택)
Median (=Q2)	=median(data전체선택)
Mode	=mode(data전체선택)
Sample deviation (or variance)	=var.s(data전체선택)
Sample standard deviation	=stdev.s(data전체선택)
Q1	=quartile(data전체선택,1)
Q2 (=median)	=quartile(data전체선택,2)
Q3	=quartile(data전체선택,3)
IQR	=q3의답-q1의답
Count (몇개인지 세기) for frequency	=countif(data전체선택,원하는숫자입력)
Relative frequency	=frequency숫자/N

to be continued...