"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."														
												Column1		
														
14	12	28	18	20				Number of cases	60			Mean	20	
18	15	20	14	16				Minimum	10			Standard Error	0.661277654	
25	27	22	17	15				Maximum	30			Median	19.5	
21	10	25	25	24				Range	20			Mode	25	
20	11	16	25	20				Sum	1200			Standard Deviation	5.122234682	
13	20	18	29	30				Average value	20			Sample Variance	26.23728814	
18	17	19	11	14				Mode	20			Kurtosis	-0.970885509	
27	19	26	27	19				Median	19.5			Skewness	0.026614787	
15	17	24	26	26				Variance	26.24			Range	20	
19	22	16	22	27				Standard deviation	5.12			Minimum	10	
20	25	19	25	13				Variance coefficient	0.26			Maximum	30	
24	18	26	14	17				Skewness	0.03			Sum	1200	
12								Kurtoses	-0.97			Count	60	
15														
27														
10														
11														
20														
17														
19														
17														
22														
25														
18														
28														
20														
22														
25														
16														
18														
19														
26														
24														
16														
19														
26														
18														
14														
17														
25														
25														
29														
11														
27														
26														
22														
25														
14														
20														
16														
15														
24														
20														
30														
14														
19														
26														
27														
13														
17														
##### 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 #####
Measures of central tendency:						Excel 2013
						
Mode:		most frequent value				=MODE.SNGL
						
Median:		middle value				 =MEDIAN
						
p-% quantil 						
						
Mean:						
						
						
Sample average value:						 =AVERAGE
						
						
Geometricmean:						 =GEOMEAN
						
						
Measures of variability:						
						
Range:		R=max xi - min xi				
						
Population variance:						 =VAR.P
						
						
Sample variance:						 =VAR.S
						
						
Population standard deviation:						 =STDEV.P
						
						
Sample standard deviation:						 =STDEV.S
						
						
Coefficient of skewness:						 =SKEW
						
						
Coefficient of kurtoses						 =KURT
						
Varianceí coefficient:						
						
Data → Data Analysis  → Descriptive Statistics						
						
						
Histogram						
						
Sturgers rule:						
						
Data → Data Analysis  → Histogram						
						
						
Weighted characteristics						
						
						
Weighted average value:						
						
						
						
						
						
						
						
Weighted variance:						
						
						
						
						
Weighted standard deviation: