"In the table, there are given amounts of chocolate bars baught in particular  shops in   2 weeks."													
													
"Task: Find number of observations, minimum, maximum, range, sum, average value, mode, median, variance, standard deviation and variance coefficient, skewness, kurtoses."													
													
													
14	12	28	18	20				Number of cases					
18	15	20	14	16				Minimum					
25	27	22	17	15				Maximum					
21	10	25	25	24				Range					
20	11	16	25	20				Sum					
13	20	18	29	30				Average value					
18	17	19	11	14				Mode					
27	19	26	27	19				Median					
15	17	24	26	26				Variance					
19	22	16	22	27				Standard deviation					
20	25	19	25	13				Variance coefficient					
24	18	26	14	17				Skewness					
								Kurtoses					
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
													
##### Sheet/List 2 #####
Results are in table.	
Calculate weighted average of grades.	
	
Grade	Credits
2	6
1	6
1	6
2	3
3	5
1	6
1	5
1	3
2	6
3	2
1	6
2	3
1	6
3	6
2	5
2	3
1	6
3	6
3	3
3	6
1	5
2	6
##### Sheet/List 3 #####
				EXCEL (CZE)		EXCEL (ENG)
Measures of central tendency:						Excel 2013
						
Mode:		most frequent value		=MODE		=MODE.SNGL
						
Median:		middle value		 =MEDIAN		 =MEDIAN
						
p-% quantil 				 =PERCENTIL		
						
Mean:						
						
						
Sample average value:				 =PRŮMĚR		=AVERAGEA
						
						
Geometric mean:				 =GEOMEAN		 =GEOMEAN
						
						
Measures of variability:						
						
Range:		R=max xi - min xi				
						
Population variance:				 =VAR		 =VAR.P
						
						
Sample variance:				 =VAR.VÝBĚR		 =VAR.S
						
						
Population standard deviation:				 =SMODCH		=STDEVA
						
						
Sample standard deviation:				 =SMODCH.VÝBĚR		=STDEVA
						
						
Coefficient of skewness:				 =SKEW		 =SKEW
						
						
Coefficient of kurtoses				 =KURT		 =KURT
						
Varianceí coefficient:						
						
Nástroje → Analýza dat → Popisná statistika						
						
						
Histogram						
						
Sturgers rule:						
						
Nástroje → Analýza dat → Histogram						
						
						
Weighted characteristics						
						
						
Weighted average value:						
						
						
						
						
						
						
						
Weighted variance:						
						
						
						
						
Weighted standard deviation: