x	27	31	87	93	114	124	190	193	250	254	264	272	308	324	371	372	440	442	502	503	506	522	556	620	624
y	28	21	71	36	30	43	54	54	59	25	82	22	38	22	56	63	46	24	33	40	41	28	53	38	66
																									
																									
																									
Rozsah=																									
Průměr x=												Kovariance=													
Rozptyl x=																									
Sm. odch. x=																									
																									
Průměr y=																									
Rozptyl y=																									
Sm. odch. y=																									
##### Sheet/List 2 #####
x\y	20	30	40	50	60	70	80
250	19	5					
350	23	116	11				
450	1	41	98	9			
550		4	32	65	7		
650		1	4	21	46	3	
750			1	2	11	13	1
850					1	3	2
							
							
							
Rozsah=							
Průměr x=							
Rozptyl x=							
Sm. odch. y=							
							
Průměr y=							
Rozptyl y=							
Sm. odch. y=							
##### Sheet/List 3 #####
Prodeje produktu A	100	105	110	95	115	90	120	85	125	80
Prodeje produktu B	200	180	205	185	190	185	190	195	200	190
										
										
Bodový graf										
										
										
										
										
										
Korelační koeficient										
##### Sheet/List 4 #####
Tyden	Prodej_zmrzliny_KC	Pocet_nehod_voda
1	2533	53
2	1706	31
3	2267	54
4	2220	45
5	2234	45
6	1856	36
7	2010	41
8	2513	38
9	2510	47
10	2084	48
11	2488	53
12	2170	43
13	3002	49
14	2487	43
15	2247	53
16	3307	59
17	2470	50
18	2642	64
19	2701	56
20	2545	46
21	3120	54
22	2873	60
23	2821	54
24	2934	55
25	3101	57
26	3310	68
27	2703	65
28	3071	56
29	3018	67
30	3069	67
31	3056	64
32	2908	54
33	2932	58
34	3615	68
35	3404	65
36	3279	70
37	3283	78
38	3393	75
39	3578	73
40	3409	62
##### Sheet/List 5 #####
Cena_produktu	Celkove_trzby
10	959
11.84	1057
13.67	1224
15.51	1224
17.35	1298
19.18	1444
21.02	1446
22.86	1420
24.69	1506
26.53	1572
28.37	1707
30.2	1711
32.04	1756
33.88	1782
35.71	1786
37.55	1937
39.39	1903
41.22	1807
43.06	1964
44.9	1925
46.73	1912
48.57	1968
50.41	1938
52.24	1960
54.08	1968
55.92	1915
57.76	2038
59.59	1997
61.43	1922
63.27	2029
65.1	1970
66.94	1914
68.78	1950
70.61	1922
72.45	1889
74.29	1848
76.12	1805
77.96	1733
79.8	1677
81.63	1626
83.47	1560
85.31	1530
87.14	1420
88.98	1531
90.82	1419
92.65	1235
94.49	1200
96.33	1123
98.16	1107
100	983
##### Sheet/List 6 #####
Spokojenost	Produktivita
52.5	39.7
49.7	42.9
49.6	52.6
63.7	47.5
47.7	46.5
65.2	40.5
34.5	49.5
55.8	42.2
51.2	33.3
52.2	46.2
53.8	59.2
45	44.2
46.7	56.1
39.8	33.8
39.3	49.4
53	55.2
54.5	53
50.5	51.1
59.2	43.6
70.5	41.5
45.1	39.8
26.9	51.2
60.1	40.5
42.9	45.1
43.1	47.4
60.3	68.4
47.2	43.5
37.8	52.4
51.8	50.8
48.6	40.4
50.1	49.3
53.9	64.4
46.3	54.5
56.4	50.4
47.8	45.8
53.3	29.5
61	61.3
54.4	35.4
46.7	57.4
61.5	69.1
59.9	35.6
55.5	57
52.4	47.4
43.7	34.3
63.6	34.9
44	34
71.9	44.7
65.3	35.4
47.6	56.9
150	150
##### Sheet/List 7 #####
eruptions	waiting
3.6	79
1.8	54
3.333	74
2.283	62
4.533	85
2.883	55
4.7	88
3.6	85
1.95	51
4.35	85
1.833	54
3.917	84
4.2	78
1.75	47
4.7	83
2.167	52
1.75	62
4.8	84
1.6	52
4.25	79
1.8	51
1.75	47
3.45	78
3.067	69
4.533	74
3.6	83
1.967	55
4.083	76
3.85	78
4.433	79
4.3	73
4.467	77
3.367	66
4.033	80
3.833	74
2.017	52
1.867	48
4.833	80
1.833	59
4.783	90
4.35	80
1.883	58
4.567	84
1.75	58
4.533	73
3.317	83
3.833	64
2.1	53
4.633	82
2	59
4.8	75
4.716	90
1.833	54
4.833	80
1.733	54
4.883	83
3.717	71
1.667	64
4.567	77
4.317	81
2.233	59
4.5	84
1.75	48
4.8	82
1.817	60
4.4	92
4.167	78
4.7	78
2.067	65
4.7	73
4.033	82
1.967	56
4.5	79
4	71
1.983	62
5.067	76
2.017	60
4.567	78
3.883	76
3.6	83
4.133	75
4.333	82
4.1	70
2.633	65
4.067	73
4.933	88
3.95	76
4.517	80
2.167	48
4	86
2.2	60
4.333	90
1.867	50
4.817	78
1.833	63
4.3	72
4.667	84
3.75	75
1.867	51
4.9	82
2.483	62
4.367	88
2.1	49
4.5	83
4.05	81
1.867	47
4.7	84
1.783	52
4.85	86
3.683	81
4.733	75
2.3	59
4.9	89
4.417	79
1.7	59
4.633	81
2.317	50
4.6	85
1.817	59
4.417	87
2.617	53
4.067	69
4.25	77
1.967	56
4.6	88
3.767	81
1.917	45
4.5	82
2.267	55
4.65	90
1.867	45
4.167	83
2.8	56
4.333	89
1.833	46
4.383	82
1.883	51
4.933	86
2.033	53
3.733	79
4.233	81
2.233	60
4.533	82
4.817	77
4.333	76
1.983	59
4.633	80
2.017	49
5.1	96
1.8	53
5.033	77
4	77
2.4	65
4.6	81
3.567	71
4	70
4.5	81
4.083	93
1.8	53
3.967	89
2.2	45
4.15	86
2	58
3.833	78
3.5	66
4.583	76
2.367	63
5	88
1.933	52
4.617	93
1.917	49
2.083	57
4.583	77
3.333	68
4.167	81
4.333	81
4.5	73
2.417	50
4	85
4.167	74
1.883	55
4.583	77
4.25	83
3.767	83
2.033	51
4.433	78
4.083	84
1.833	46
4.417	83
2.183	55
4.8	81
1.833	57
4.8	76
4.1	84
3.966	77
4.233	81
3.5	87
4.366	77
2.25	51
4.667	78
2.1	60
4.35	82
4.133	91
1.867	53
4.6	78
1.783	46
4.367	77
3.85	84
1.933	49
4.5	83
2.383	71
4.7	80
1.867	49
3.833	75
3.417	64
4.233	76
2.4	53
4.8	94
2	55
4.15	76
1.867	50
4.267	82
1.75	54
4.483	75
4	78
4.117	79
4.083	78
4.267	78
3.917	70
4.55	79
4.083	70
2.417	54
4.183	86
2.217	50
4.45	90
1.883	54
1.85	54
4.283	77
3.95	79
2.333	64
4.15	75
2.35	47
4.933	86
2.9	63
4.583	85
3.833	82
2.083	57
4.367	82
2.133	67
4.35	74
2.2	54
4.45	83
3.567	73
4.5	73
4.15	88
3.817	80
3.917	71
4.45	83
2	56
4.283	79
4.767	78
4.533	84
1.85	58
4.25	83
1.983	43
2.25	60
4.75	75
4.117	81
2.15	46
4.417	90
1.817	46
4.467	74