Vajad kellegagi rääkida?
Küsi julgelt abi LasteAbi
Logi sisse

Statistika ÜL 08 Korrelatsioon (0)

1 Hindamata
Punktid

Overview

A.8.1
A.8.2
A.8.3
A.8.4
A.8.5
A.8.6
A.8.7
A.8.8
A.8.9

Sheet 1: A.8.1


RKT ja
SÜND SURM IM.SURM IGA M IGA N RKT GRUPP RIIK
SÜND SURM IM.SURM IGA M IGA N 24.7 5.7 30.8 69.6 75.5 600 1 Albania
CORREL -0.629 -0.303 -0.602 0.643 0.650 12.5 11.9 14.4 68.3 74.7 2250 1 Bulgaria
13.4 11.7 11.3 71.8 77.7 2980 1 Czechoslovakia
Grupp 3 0.184 0.102 -0.686 0.561 0.646 11.6 13.4 14.8 65.4 73.8 2780 1 Hungary
Grupp5 -0.701 -0.480 -0.538 0.585 0.610 14.3 10.2 16 67.2 75.7 1690 1 Poland
13.6 10.7 26.9 66.5 72.4 1640 1 Romania
17.7 10 23 64.6 74 2242 1 USSR
positiivselt seotud meeste ja naiste keskmine eluiga, negatiivselt ülejäänud
15.2 9.5 13.1 66.4 75.9 1880 1 Byelorussian SSR
kõige tugevamini seotud sündide arv, kõige nõrgemini surmade arv
13.4 11.6 13 66.4 74.8 1320 1 Ukrainian SSR
20.7 8.4 25.7 65.5 72.7 2370 2 Argentina
Aasia riikides on negatiivne korrelatsioon , grupp 3 on nõrk positiivne korrelatsioon
46.6 18 111 51 55.4 630 2 Bolivia
28.6 7.9 63 62.3 67.6 2680 2 Brazil
23.4 5.8 17.1 68.1 75.1 1940 2 Chile
27.4 6.1 40 63.4 69.2 1260 2 Columbia
32.9 7.4 63 63.4 67.6 980 2 Ecuador
28.3 7.3 56 60.4 66.1 330 2 Guyana
34.8 6.6 42 64.4 68.5 1110 2 Paraguay
32.9 8.3 109.9 56.8 66.5 1160 2 Peru
18 9.6 21.9 68.4 74.9 2560 2 Uruguay
27.5 4.4 23.3 66.7 72.8 2560 2 Venezuela
29 23.2 43 62.1 66 2490 2 Mexico
12 10.6 7.9 70 76.8 15540 3 Belgium
13.2 10.1 5.8 70.7 78.7 26040 3 Finland
12.4 11.9 7.5 71.8 77.7 22080 3 Denmark
13.6 9.4 7.4 72.3 80.5 19490 3 France
11.4 11.2 7.4 71.8 78.4 22320 3 Germany
10.1 9.2 11 65.4 74 5990 3 Greece
15.1 9.1 7.5 71 76.7 9550 3 Ireland
9.7 9.1 8.8 72 78.6 16830 3 Italy
13.2 8.6 7.1 73.3 79.9 17320 3 Netherlands
14.3 10.7 7.8 67.2 75.7 23120 3 Norway
11.9 9.5 13.1 66.5 72.4 7600 3 Portugal
10.7 8.2 8.1 72.5 78.6 11020 3 Spain
14.5 11.1 5.6 74.2 80 23660 3 Sweden
12.5 9.5 7.1 73.9 80 34064 3 Switzerland
13.6 11.5 8.4 72.2 77.9 16100 3 U.K.
14.9 7.4 8 73.3 79.6 17000 3 Austria
9.9 6.7 4.5 75.9 81.8 25430 3 Japan
14.5 7.3 7.2 73 79.8 20470 3 Canada
16.7 8.1 9.1 71.5 78.3 21790 3 USA
28.4 3.8 16 66.8 69.4 6340 4 Bahrain
42.5 11.5 108.1 55.8 55 2490 4 Iran
42.6 7.8 69 63 64.8 3020 4 Iraq
22.3 6.3 9.7 73.9 77.4 10920 4 Israel
38.9 6.4 44 64.2 67.8 1240 4 Jordan
26.8 2.2 15.6 71.2 75.4 16150 4 Kuwait
45.6 7.8 40 62.2 65.8 5220 4 Oman
42.1 7.6 71 61.7 65.2 7050 4 Saudi_Arabia
29.2 8.4 76 62.5 65.8 1630 4 Turkey
22.8 3.8 26 68.6 72.9 19860 4 United Arab Emirates
40.4 18.7 181.6 41 42 168 5 Afghanistan
42.2 15.5 119 56.9 56 210 5 Bangladesh
21.2 6.7 32 68 70.9 380 5 China
11.7 4.9 6.1 74.3 80.1 14210 5 Hong Kong
30.5 10.2 91 52.5 52.1 350 5 India
28.6 9.4 75 58.5 62 570 5 Indonesia
31.6 5.6 24 67.5 71.6 2320 5 Malaysia
36.1 8.8 68 60 62.5 110 5 Mongolia
39.6 14.8 128 50.9 48.1 170 5 Nepal
30.3 8.1 107.7 59 59.2 380 5 Pakistan
33.2 7.7 45 62.5 66.1 730 5 Philippines
17.8 5.2 7.5 68.7 74 11160 5 Singapore
21.3 6.2 19.4 67.8 71.7 470 5 Sri Lanka
22.3 7.7 28 63.8 68.9 1420 5 Thailand
35.5 8.3 74 61.6 63.3 2060 6 Algeria
47.2 20.2 137 42.9 46.1 610 6 Angola
48.5 11.6 67 52.3 59.7 2040 6 Botswana
46.1 14.6 73 50.1 55.3 1010 6 Congo
38.8 9.5 49.4 57.8 60.3 600 6 Egypt
48.6 20.7 137 42.4 45.6 120 6 Ethiopia
39.4 16.8 103 49.9 53.2 390 6 Gabon
47.4 21.4 143 41.4 44.6 260 6 Gambia
44.4 13.1 90 52.2 55.8 390 6 Ghana
47 11.3 72 56.5 60.5 370 6 Kenya
44 9.4 82 59.1 62.56 5310 6 Libya
48.3 25 130 38.1 41.2 200 6 Malawi
35.5 9.8 82 59.1 62.5 960 6 Morocco
45 18.5 141 44.9 48.1 80 6 Mozambique
44 12.1 135 55 57.5 1030 6 Namibia
48.5 15.6 105 48.8 52.2 360 6 Nigeria
48.2 23.4 154 39.4 42.6 240 6 Sierra_Leone
50.1 20.2 132 43.4 46.6 120 6 Somalia
32.1 9.9 72 57.5 63.5 2530 6 South_Africa
44.6 15.8 108 48.6 51 480 6 Sudan
46.8 12.5 118 42.9 49.5 810 6 Swaziland
31.1 7.3 52 64.9 66.4 1440 6 Tunisia
52.2 15.6 103 49.9 52.7 220 6 Uganda
50.5 14 106 51.3 54.7 110 6 Tanzania
45.6 14.2 83 50.3 53.7 220 6 Zaire
51.1 13.7 80 50.4 52.5 420 6 Zambia
41.7 10.3 66 56.5 60.1 640 6 Zimbabwe

Sheet 2: A.8.2


Kuup S&P 500 DJIA Nasdaq 100 FTSE 100 OMXS Nikkei 225

S&P 500 DJIA Nasdaq 100 FTSE 100 OMXS Nikkei 225 1/2/2013 1462.42 13412.55 2746.47 6027.4 1129.96
S&P 500 1
1/3/2013 1459.37 13391.36 2732.26 6047.3 1130 .4
DJIA 0.9899 1.0000
1/4/2013 1466.47 13435.21 2724.49 6089.8 1136.77 10688.11
Nasdaq 100 0.9897 0.9709 1.0000
1/7/2013 1461.89 13384.29 2724.22 6064.6 1130.13 10599.01
FTSE 100 0.689 0.703 0.630 1.000
1/8/2013 1457.15 13328.85 2718.72 6053.6 1125.39 10508.06
OMXS 0.926 0.924 0.927 0.719 1.000
1/9/2013 1461.02 13390.51 2727.65 6098.7 1127.67 10578.57
Nikkei 225 0.896 0.925 0.894 0.643 0.869 1.000 1/10/2013 1472.12 13471.22 2744.18 6101.5 1126.87 10652.64
1/11/2013 1472.05 13488.43 2748.26 6121.6 1132.28 10801.57
1/14/2013 1470.68 13507.32 2735.7 6107.9 1132.84
2.
1/15/2013 1472.34 13534.89 2722.98 6117.3 1127.51 10879.08
3.
1/16/2013 1472.63 13511.23 2734.73 6104 1130.62 10600.44
1/17/2013 1480 .94 13596.02 2747.15 6132.4 1136.2 10609.64
4.
1/18/2013 1485.98 13649.70 2743.24 6154.4 1135.02 10913.3
5.
1/21/2013
6181 1143 .09 10747.74
1/22/2013 1492.56 13712.21 2746.19 6179.2 1139.15 10709.93
1/23/2013 1494 .81 13779.33 2762.17 6197.6 1140.82 10486.99
1/24/2013 1494.82 13825.33 2723.53 6264.9 1146.93 10620.87
1/25/2013 1502 .96 13895.98 2736.73 6284.5 1158.5 10926.65
1/28/2013 1500.18 13881.93 2742.43 6294.4 1160.25 10824.31
1/29/2013 1507 .84 13954.42 2743.58 6339.2 1161.97 10866.72
1/30/2013 1501.96 13910.42 2738.71 6323.1 1173 .38 11113.95
1/31/2013 1498 .11 13860.58 2731.53 6276.9 1169.17 11138.66
2/1/2013 1513.17 14009.79 2763.96 6347.2 1176.11 11191.34
2/4/2013 1495.71 13880.08 2715.68 6246.8 1161.19 11260.35
2/5/2013 1511 .29 13979.30 2754.99 6282.8 1175.54 11046.92
2/6/2013 1512.12 13986.52 2746.35 6295.3 1174.79 11463.75
2/7/2013 1509.39 13944.05 2746.5 6228.4 1165.71 11357.07
2/8/2013 1517.93 13992.97 2775.56 6263.9 1175.05 11153.16
2/11/2013 1517.01 13971.24 2774.64 6277.1 1171.01
2/12/2013 1519.43 14018.70 2762.62 6338.4 1175.98 11369.12
2/13/2013 1520 .33 13982.91 2773.77 6359.1 1185 .46 11251.41
2/14/2013 1521.38 13973.39 2771.43 6327.4 1182.91 11307.28
2/15/2013 1519.79 13981.76 2764.67 6328.3 1183 .43 11173.83
2/18/2013
6318.2 1185.98 11407.87
2/19/2013 1530 .94 14035.67 2782.86 6379.1 1193 .77 11372.34
2/20/2013 1511.95 13927.54 2739.99 6395.4 1200.54 11468.28
2/21/2013 1502.42 13880.62 2711.51 6291.5 1188.95 11309.13
2/22/2013 1515 .60 14000.57 2737.28 6335.7 1205 .1 11385.94
2/25/2013 1487 .85 13784.17 2700.97 6355.4 1199 .44 11662.52
2/26/2013 1496.94 13900.13 2713.02 6270.4 1180.9 11398.81
2/27/2013 1515.99 14075.37 2741.26 6325.9 1194 .07 11253.97
2/28/2013 1514.68 14054.49 2738.58 6360.8 1199.4 11559.36
3/1/2013 1518 .20 14089.66 2747.75 6378.6 1199.21 11606.38
3/4/2013 1525 .20 14127.82 2759.53 6345.6 1203 .47 11652.29
3/5/2013 1539 .79 14253.77 2799.25 6432 1217 .41 11683.45
3/6/2013 1541 .46 14296.24 2792.56 6427.6 1208.39 11932.27
3/7/2013 1544.26 14329.49 2799.49 6439.2 1208.09 11968.08
3/8/2013 1551.18 14397.07 2804.11 6483.6 1215 .14 12283.62
3/11/2013 1556 .22 14447.29 2811.86 6503.6 1218 .08 12349.05
3/12/2013 1552.48 14450.06 2800.81 6510.6 1208.52 12314.81
3/13/2013 1554 .52 14455.28 2798.68 6481.5 1210.89 12239.66
3/14/2013 1563 .23 14539.14 2807.3 6529.4 1221.85 12381.19
3/15/2013 1560 .70 14514.11 2799.41 6489.7 1217 .35 12560.95
3/18/2013 1552.10 14452.06 2792.3 6457.9 1209.67 12220.63
3/19/2013 1548.34 14455.82 2787.27 6441.3 1195.98 12468.23
3/20/2013 1558.71 14511.73 2805.91 6432.7 1203.1
3/21/2013 1545.80 14421.49 2774.85 6388.6 1187.72 12635.69
3/22/2013 1556.89 14512.03 2800.81 6392.8 1196 .43 12338.53
3/25/2013 1551.69 14447.75 2789.45 6378.4 1195.58 12546.46
3/26/2013 1563.77 14559.65 2806.5 6399.4 1194.99 12471.62
3/27/2013 1562 .85 14526.16 2809.98 6387.6 1194.49 12493.79
3/28/2013 1569.19 14578.54 2818.69 6411.7 1201.19 12335.96
3/29/2013
6411.7
12397.91
4/1/2013 1562.17 14572.85 2797.07 6411.7
12135.02
4/2/2013 1570 .25 14662.01 2820.62 6490.7 1210.08 12003.43
4/3/2013 1553 .69 14550.35 2795.04 6420.3 1203.38 12362.2
4/4/2013 1559 .98 14606.11 2794.92 6344.1 1183.01 12634.54
4/5/2013 1553.28 14565.25 2771.75 6249.8 1168 .79 12833.64
4/8/2013 1563.07 14613.48 2786.13 6276.9 1164.85 13192.59
4/9/2013 1568.61 14673.46 2804.67 6313.2 1175.62 13192.35
4/10/2013 1587.73 14802.24 2859.21 6387.4 1193.66 13288.13
4/11/2013 1593 .37 14865.14 2859.07 6416.1 1195.53 13549.16
4/12/2013 1588.85 14865.06 2856.48 6384.4 1185.33 13485.14
4/15/2013 1552.36 14599.20 2797.47 6343.6 1177.61 13275.66
4/16/2013 1574 .57 14756.78 2838.41 6304.6 1167 .48 13221.44
4/17/2013 1552.01 14618.59 2781.98 6244.2 1147.48 13382.89
4/18/2013 1541.61 14537.14 2741.95 6243.7 1146.65 13220.07
4/19/2013 1555 .25 14547.51 2780.46 6286.6 1147.31 13316.48
4/22/2013 1562.50 14567.17 2810.07 6280 .6 1143.3 13568.37
4/23/2013 1578 .78 14719.46 2835.37 6406.1 1172.79 13529.65
4/24/2013 1578.79 14676.30 2834.12 6431.8 1176.91 13843.46
4/25/2013 1585.16 14700.80 2848.66 6442.6 1194.86 13926.08
4/26/2013 1582.24 14712.55 2840.55 6426.4 1194.66 13884.13
4/29/2013 1593.61 14818.75 2866 .95 6458 1198.11
4/30/2013 1597.57 14839.80 2887.44 6430.1 1198.99 13860.86
5/1/2013 1582.70 14700.95 2873.35 6451.3
13799.35
5/2/2013 1597.59 14831.58 2911.14 6460.7 1194.42 13694.04
5/3/2013 1614.42 14973.96 2944.59 6521.5 1203.34
5/6/2013 1617.50 14968.89 2955.36 6521.5 1205.17
5/7/2013 1625.96 15056.20 2952.88 6557.3 1208.1 14180.24
5/8/2013 1632.69 15105.12 2968.24 6583.5 1221.83 14285.69
5/9/2013 1626.67 15082.62 2961.12 6592.7
14191.48
5/10/2013 1633.70 15118.49 2981.02 6625 1227.31 14607.54
5/13/2013 1633.77 15091.68 2982.09 6631.8 1223 .89 14782.21
5/14/2013 1650 .34 15215.25 2996.05 6686.1 1224.85 14758.42
5/15/2013 1658 .78 15275.69 3002.62 6693.6 1230 .12 15096.03
5/16/2013 1650.47 15233.22 2999.34 6687.8 1235 15037.24
5/17/2013 1667.47 15354.40 3028.96 6723.1 1244.25 15138.12
5/20/2013 1666 .29 15335.28 3020.97 6755.6 1243.37 15360.81
5/21/2013 1669 .16 15387.58 3026.45 6803.9 1248 .14 15381.02
5/22/2013 1655.35 15307.17 2999.13 6840.3 1254.57 15627.26
5/23/2013 1650.51 15294.50 2991.45 6696.8 1224.45 14483.98
5/24/2013 1649 .60 15303.10 2991.02 6654 .3 1217.06 14612.45
5/27/2013
6654.3 1231.68 14142.65
5/28/2013 1660.06 15409.39 3011.94 6762 1244.04 14311.98
5/29/2013 1648.36 15302.80 2994.82 6627.2 1222 .37 14326.46
5/30/2013 1654.41 15324.53 3011.83 6657 1225.18 13589.03
5/31/2013 1630.74 15115.57 2981.76 6583.1 1214 .77 13774.54
6/3/2013 1640.42 15254.03 2990.79 6525.1 1209.71 13261.82
6/4/2013 1631.38 15177.54 2973.69 6558.6 1207.56 13533.76
6/5/2013 1608.90 14960.59 2937.14 6419.3 1185.04 13014.87
6/6/2013 1622.56 15040.62 2950.3 6336.1
12904.02
6/7/2013 1643 .38 15248.12 2990.87 6412 1192 .98 12877.53
6/10/2013 1642.81 15238.59 2990.49 6400.5 1192.86 13514.2
6/11/2013 1626.13 15122.02 2959.84 6340.1 1184 .62 13317.62
6/12/2013 1612.52 14995.23 2926.14 6299.5 1177.26 13289.32
6/13/2013 1636 .36 15176.08 2962.9 6304.6 1173.57 12445.38
6/14/2013 1626.73 15070.18 2943.86 6308.3 1177.59 12686.52
6/17/2013 1639.04 15179.85 2971.26 6330.5 1191.39 13033.12
6/18/2013 1651 .81 15318.23 2996.09 6374.2 1193.95 13007.28
6/19/2013 1628.93 15112.19 2959.5 6348.8 1174.84 13245.22
6/20/2013 1588.19 14758.32 2890.33 6159.5 1138.6 13014.58
6/21/2013 1592 .43 14799.40 2877.94 6116.2
13230.13
6/24/2013 1573 .09 14659.56 2848.2 6029.1 1112.14 13062.78
6/25/2013 1588.03 14760.31 2866.5 6101.9 1129.25 12969.34
6/26/2013 1603 .26 14910.14 2893.85 6165.5 1144.78 12834.01
6/27/2013 1613 .20 15024.49 2906.84 6243.4 1161 13213.55
6/28/2013 1606.28 14909.60 2909.6 6215.5 1151 13677.32
7/1/2013 1614.96 14974.96 2927.35 6307.8 1165.64 13852.5
7/2/2013 1614.08 14932.41 2929.63 6303.9 1161.38 14098.74
7/3/2013 1615.41 14988 .55 2941.41 6229.9 1154.55 14055.56
7/4/2013
6421.7 1175.22 14018.93
7/5/2013 1631.89 15135.84 2963.22 6375.5 1167.52 14309.97
7/8/2013 1640.46 15224.69 2966.13 6450.1 1182.64 14109.34
7/9/2013 1652 .32 15300.34 2984.32 6513.1 1194.76 14472.9
7/10/2013 1652.62 15291.66 3000.66 6505 1195.31 14416.6
7/11/2013 1675 .02 15460.92 3059.46 6543.4 1211 .37 14472.58
7/12/2013 1680.19 15464.30 3079.07 6544.9 1210.73 14506.25
7/15/2013 1682.50 15484.26 3079.85 6586.1 1215.23
7/16/2013 1676.26 15451.85 3077.47 6556.4 1212 .62 14599.12
7/17/2013 1680.91 15470.52 3085 .28 6571.9 1211.1 14615.04
7/18/2013 1689.37 15548.54 3077.82 6634.4 1217.57 14808.5
7/19/2013 1692.09 15543.74 3044.93 6630.7 1221.21 14589.91
7/22/2013 1695 .53 15545.55 3055.23 6623.2 1213.38 14658.04
7/23/2013 1692.39 15567.74 3031.4 6597.4 1216.68 14778.51
7/24/2013 1685 .94 15542.24 3041.16 6620.4 1230.34 14731.28
7/25/2013 1690.25 15555.61 3061.67 6588 1232.95 14562.93
7/26/2013 1691.65 15558.83 3076.23 6554.8 1227.86 14129.98
7/29/2013 1685.33 15521.97 3068.95 6560.3 1226.98 13661.13
7/30/2013 1685.96 15520.59 3085.33 6571 1236 .86 13869.82
7/31/2013 1685.73 15499.54 3090.19 6621.1 1234.07 13668.32
8/1/2013 1706.87 15628.02 3126 .3 6682 1248.38 14005.77
8/2/2013 1709.67 15658.36 3143.52 6647.9 1250 .54 14466.16
8/5/2013 1707.14 15612.13 3143.19 6619.6 1251.77 14258.04
8/6/2013 1697.37 15518.74 3122.2 6604.2 1242 .12 14401.06
8/7/2013 1690.91 15470.67 3118.69 6511.2 1240.41 13824.94
8/8/2013 1697.48 15498.32 3130.13 6529.7 1249 .22 13605.56
8/9/2013 1691.42 15425.51 3118.57 6583.4 1253.79 13615.19
8/12/2013 1689.47 15419.68 3125.93 6574.3 1253.69 13519.43
8/13/2013 1694.16 15451.01 3141.06 6611.9 1260.44 13867
8/14/2013 1685.39 15337.66 3129.45 6587.4 1262.48 14050.16
8/15/2013 1661.32 15112.19 3076.23 6483.3 1245.35 13752.94
8/16/2013 1655.83 15081.47 3073.91 6500 1255.02 13650.11
8/19/2013 1646 .06 15010.74 3069.76 6465.7 1250.84 13758.13
8/20/2013 1652.35 15002.99 3082.17 6453.5 1247.15 13396.38
8/21/2013 1642.80 14897.55 3071.47 6390.8 1226.05 13424.33
8/22/2013 1656.96 14963.74 3101.82 6446 .9 1237.14 13365.17
8/23/2013 1663.50 15010.51 3124.27 6492 .1 1243.82 13660.55
8/26/2013 1656.78 14946.46 3122.67 6492.1 1245.99 13636.28
8/27/2013 1630.48 14776.13 3059.58 6441 1224.85 13542.37
8/28/2013 1634.96 14824.51 3072.17 6430.1 1218.15 13338.46
8/29/2013 1638 .17 14840.95 3093.36 6483.1 1224.31 13459.71
8/30/2013 1632.97 14810.31 3073.81 6412.9 1214.35 13388.86
9/2/2013
6506.2 1230.88 13572.92
9/3/2013 1639.77 14833.96 3091.76 6468.4 1238.64 13978.44
9/4/2013 1653.08 14930.87 3124.54 6474.7 1242.52 14053.87
9/5/2013 1655.08 14937.48 3129.94 6532.4 1243.9 14064.82
9/6/2013 1655.17 14922.50 3133.38 6547.3 1249.05 13860.81
9/9/2013 1671.71 15063.12 3169.93 6530.7 1249.11 14205.23
9/10/2013 1683 .99 15191.06 3185.07 6584 1268 .22 14423.36
9/11/2013 1689.13 15326.60 3179.86 6588.4 1270.66 14425.07
9/12/2013 1683.42 15300.64 3175.57 6589 1268.3 14387.27
9/13/2013 1687 .99 15376.06 3178 .28 6583.8 1265.97 14404.67
9/16/2013 1697.60 15494.78 3168.69 6622.9 1278 .41
9/17/2013 1704.76 15529.73 3190.83 6570.2 1274.22 14311.67
9/18/2013 1725.52 15676.94 3231.31 6558.8 1276.74 14505.36
9/19/2013 1722 .34 15636.55 3237.61 6625.4 1286.49 14766.18
9/20/2013 1709.91 15451.09 3224.73 6596.4 1285.78 14742.42
9/23/2013 1701.84 15401.38 3219.34 6557.4 1274.77 14742.42
9/24/2013 1697.42 15334.59 3218.66 6571.5 1282.73 14732.61
9/25/2013 1692.77 15273.26 3208.55 6551.5 1265.69 14620.53
9/26/2013 1698 .67 15328.30 3234.04 6565.6 1275.23 14799.12
9/27/2013 1691.75 15258.24 3230.3 6512.7 1269.48 14760.07
9/30/2013 1681 .55 15129.67 3218.2 6462.2 1259.6 14455.8
10/1/2013 1695.00 15191.70 3253.05 6460 1268.35 14484.72
10/2/2013 1693.87 15133.14 3253.26 6437.5 1260.24 14170.49
10/3/2013 1678.66 14996.48 3213.83 6449 1256.27 14157.25
10/4/2013 1690.50 15072.58 3242 .57 6453.9 1251.39 14024.31
10/7/2013 1676.12 14936.24 3215.69 6437.3 1246.86 13853.32
10/8/2013 1655.45 14776.53 3153.87 6365.8 1241.82 13894.61
10/9/2013 1656.40 14802.98 3142.54 6337.9 1235.36 14037.84
10/10/2013 1692.56 15126.07 3210.84 6430.5 1260.52 14194.71
10/11/2013 1703.20 15237.11 3233.83 6487.2 1266.39 14404.74
10/14/2013 1710.14 15301.26 3256.02 6507.7 1258.72 14404.74
10/15/2013 1698.06 15168 .01 3244.66 6549.1 1265.46 14441.54
10/16/2013 1721.54 15373.83 3281.67 6571.6 1266.01 14467.14
10/17/2013 1733.15 15371.65 3301.28 6576.2 1266.91 14586.51
10/18/2013 1744.50 15399.65 3353.88 6622.6 1283 .9 14561.54
10/21/2013 1744.66 15392.20 3361 .18 6654.2 1288.55 14693.57
10/22/2013 1754 .67 15467.66 3366.93 6695.7 1300.23 14713.25
10/23/2013 1746.38 15413.33 3346.05 6674.5 1291 .62 14426 .05
10/24/2013 1752.07 15509.21 3362.38 6713.2 1298 .6 14486.41
10/25/2013 1759.77 15570.28 3383.83 6721.3 1290 .63 14088.19
10/28/2013 1762.11 15568.93 3382.68 6725.8 1288.42 14396.04
10/29/2013 1771 .95 15680.35 3391.75 6774.7 1290.78 14325.98
10/30/2013 1763 .31 15618.76 3385.38 6777.7 1291.14 14502.35
10/31/2013 1756.54 15545.75 3377.73 6731.4 1283.52 14327.94
11/1/2013 1761 .64 15615.55 3379.76 6734.7 1278.42 14201.57
11/4/2013 1767.93 15639.12 3384.75 6763.6 1281.41
11/5/2013 1762.97 15618.22 3388.82 6746.8 1274.07 14225.37
11/6/2013 1770.49 15746.88 3385.38 6741.7 1283.48 14337.31
11/7/2013 1747.15 15593.98 3321.41 6697.2 1284.69 14228.44
11/8/2013 1770.61 15761.78 3366.84 6708.4 1281.86 14086.8
11/11/2013 1771.89 15783.10 3362.98 6728.4 1287.71 14269.84
11/12/2013 1767.69 15750.67 3365.23 6726.8 1279 .86 14588.68
11/13/2013 1782 .00 15821.63 3405.56 6630 1274.7 14567.16
11/14/2013 1790.62 15876.22 3415.14 6666.1 1289.17 14876.41
11/15/2013 1798 .18 15961.70 3422.58 6693.4 1295.93 15165.92
11/18/2013 1791.53 15976.02 3388.87 6723.5 1304 .8 15164.3
11/19/2013 1787.87 15967.03 3378.13 6698 1299.51 15126.56
11/20/2013 1781 .37 15900.82 3367.17 6681.1 1294.7 15076.08
11/21/2013 1795.85 16009.99 3402.74 6681.3 1290.5 15365.6
11/22/2013 1804.76 16064.77 3422.02 6674.3 1297 .87 15381.72
11/25/2013 1802.48 16072.54 3427.49 6694.6 1306.13 15619.13
11/26/2013 1802.75 16072.80 3445.76 6636.2 1305 .78 15515.24
11/27/2013 1807.23 16097.33 3470.48 6649.5 1310.13 15449.63
11/28/2013
6654.5 1315.21 15727.12
11/29/2013 1805.81 16086.41 3487.82 6650.6 1307.71 15661.87
12/2/2013 1800.90 16008.77 3481.15 6595.3 1304.58 15655.07
12/3/2013 1795.15 15914.62 3479.34 6532.4 1281.32 15749.66
12/4/2013 1792.81 15889.77 3483.01 6510 1279.03 15407.94
12/5/2013 1785 .03 15821.51 3477.73 6498.3 1269.51 15177.49
12/6/2013 1805.09 16020.20 3504.26 6552 1274.63 15299.86
12/9/2013 1808.37 16025.53 3516.17 6559.5 1283.35 15650.21
12/10/2013 1802.62 15973.13 3514.2 6523.3 1270.2 15611.31
12/11/2013 1782.22 15843.53 3468.99 6507.7 1268.05 15515.06
12/12/2013 1775.50 15739.43 3460.29 6445.3 1255 15341.82
12/13/2013 1775.32 15755.36 3456.4 6440 1255.71 15403.11
12/16/2013 1786 .54 15884.57 3475.79 6522.2 1269.08 15152.91
12/17/2013 1781.00 15875.26 3469.32 6486.2 1263.26 15278.63
12/18/2013 1810.65 16167.97 3509.63 6492.1 1275.12 15587.8
12/19/2013 1809.60 16179.08 3498.63 6584.7 1300.89 15859.22
12/20/2013 1818.32 16221.14 3531.19 6606.6 1309.92 15870.42
12/23/2013 1827.99 16294.61 3569.4 6678 .6 1320.56 15870.42
12/24/2013 1833.32 16357.55 3572.8 6694.2
15889.33
12/25/2013
6694.2
16009.99
12/26/2013 1842.02 16479.88 3584.58 6694.2
16174.44
12/27/2013 1841 .40 16478.41 3574.02 6750.9 1334.42 16178.94
12/30/2013 1841.07 16504.29 3570.08 6731.3 1332.95 16291.31
12/31/2013 1848.36 16576.66 3592 6749.1
1/1/2014
6749.1
1/2/2014 1831 .98 16441.35 3563.57 6717.9 1324.35
1/3/2014 1831.37 16469.99 3538 .73 6730.7 1325.12
1/6/2014 1826 .77 16425.10 3526.96 6730.7
15908.88
1/7/2014 1837 .88 16530.94 3557.85 6755.5 1326.24 15814.37
1/8/2014 1837.49 16462.74 3567.54 6721.8 1324.83 16121.45
1/9/2014 1838.13 16444.76 3552.58 6691.3 1323.58 15880.33
1/10/2014 1842.37 16437.05 3565.08 6739.9 1329.84 15912.06
1/13/2014 1819.20 16257.94 3512.8 6757.2 1328.65 15912.06
1/14/2014 1838.88 16373.86 3580.65 6766.9 1323.89 15422.4
1/15/2014 1848.38 16481.94 3609.84 6819.9 1342.99 15808.73
1/16/2014 1845.89 16417.01 3611.29 6815.4 1342.65 15747.2
1/17/2014 1838.70 16458.56 3591.25 6829.3 1350.1 15734.46
1/20/2014
6836.7 1350.98 15641.68
1/21/2014 1843.80 16414.44 3617.7 6834.3 1350.02 15795.96
1/22/2014 1844 .86 16373.34 3627.72 6826.3 1355.24 15820.96
1/23/2014 1828.46 16197.35 3613.76 6773.3 1339.8 15695.89
1/24/2014 1790.29 15879.11 3541.48 6663.7 1318.53 15391.56
1/27/2014 1781.56 15837.88 3509.02 6550.7 1317.24 15005.73
1/28/2014 1792.50 15928.56 3505.72 6572.3 1318.41 14980.16
1/29/2014 1774 .20 15738.79 3467.82 6544.3 1310.13 15383.91
1/30/2014 1794.19 15848.61 3532.41 6538.5 1302.83 15007.06
1/31/2014 1782.59 15698.85 3521.92 6510.4 1304.45 14914.53
2/3/2014 1741 .89 15372.80 3440.5 6465.7 1285.91 14619.13
2/4/2014 1755 .20 15445.24 3470.2 6449.3 1280 .99 14008.47
2/5/2014 1751.64 15440.23 3454.9 6457.9 1292 .46 14180.38
2/6/2014 1773.43 15628.53 3497.6 6558.3 1308.14 14155.12
2/7/2014 1797.02 15794.08 3561.91 6571.7 1313.2 14462.41
2/10/2014 1799.84 15801.79 3582.11 6591.6 1318.65 14718.34
2/11/2014 1819.75 15994.77 3621.72 6672.7 1335.12
2/12/2014 1819.26 15963.94 3627.36 6675 1330 .02 14800.06
2/13/2014 1829.83 16027.59 3659.56 6659.4 1330.38 14534.74
2/14/2014 1838.63 16154.39 3663.88 6663.6 1335.89 14313.03
2/17/2014
6736 1342.2 14393.11
2/18/2014 1840.76 16130.40 3679 .43 6796.4 1329.04 14843.24
2/19/2014 1828.75 16040.56 3652.85 6796.7 1338 14766.53
2/20/2014 1839.78 16133.23 3671.93 6813 1341.85 14449.18
2/21/2014 1836.25 16103.30 3662.6 6838.1 1349.12 14865.67
2/24/2014 1847.61 16207.14 3685.81 6865.9 1370.11 14837.68
2/25/2014 1845.12 16179.66 3679.14 6830 .5 1371.94 15051.6
2/26/2014 1845.16 16198.41 3676.6 6799.2 1373.36 14970.97
2/27/2014 1854.29 16272.65 3699.8 6810.3 1368.83 14923.11
2/28/2014 1859 .45 16321.71 3696.1 6809.7 1369 .13 14841.07
3/3/2014 1845.73 16168.03 3668.37 6708.4 1335.56 14652.23
3/4/2014 1873.91 16395.88 3719.93 6823.8 1363.44 14721.48
3/5/2014 1873.81 16360.18 3727.19 6775.4 1364.92 14897.63
3/6/2014 1877 .03 16421.89 3720.93 6788.5 1374.32 15134.75
3/7/2014 1878.04 16452.72 3703.4 6712.7 1358 .36 15274.07
3/10/2014 1877.17 16418.68 3706.34 6689.5 1359.93 15120.14
3/11/2014 1867.63 16351.25 3691.5 6685.5 1359.18 15224.11
3/12/2014 1868.20 16340.08 3707.06 6620.9 1346.36 14830.39
3/13/2014 1846.34 16108.89 3651.49 6553.8 1337 .23 14815.98
3/14/2014 1841.13 16065.67 3627.87 6527.9 1326.82 14327.66
3/17/2014 1858.83 16247.22 3662.51 6568.4 1349.39 14277.67
3/18/2014 1872.25 16336.19 3706.62 6605.3 1359.07 14411.27
3/19/2014 1860.77 16222.17 3682.74 6573.1 1360.48 14463
3/20/2014 1872.01 16331.05 3693.97 6542.4 1352.47 14224.23
3/21/2014 1866.52 16302.77 3653.07 6557.2 1351.43
3/24/2014 1857.44 16276.69 3617.39 6520.4 1335.5 14475.3
3/25/2014 1865.62 16367.88 3629.73 6604.9 1350.67 14423.19
3/26/2014 1852.56 16268.99 3582.89 6605.3 1351.48 14477.16
3/27/2014 1849.04 16264.23 3563.13 6588.3 1341.69 14622.89
3/28/2014 1857.62 16323.06 3571.49 6615.6 1346.48 14696.03
3/31/2014 1872.34 16457.66 3595.74 6598.4 1364.97 14827.83
4/1/2014 1885.52 16532.61 3658.4 6652.6 1375.01 14791.99
4/2/2014 1890.90 16573.00 3665.99 6659 1377.5 14946.32
4/3/2014 1888.77 16572.55 3637.58 6649.1 1368.88 15071.88
4/4/2014 1865.09 16412.71 3539.38 6695.6 1369.69 15063.77
4/7/2014 1845.04 16245.87 3507.75 6622.8 1357.31 14808.85
4/8/2014 1851 .96 16256.14 3538.23 6590.7 1361.53 14606.88
4/9/2014 1872.18 16437.18 3600 .44 6635.6 1366.53 14299.69
4/10/2014 1833.08 16170.22 3487.76 6642 1354.99 14300.12
4/11/2014 1815.69 16026.75 3446.85 6561.7 1344.12 13960.05
4/14/2014 1830.61 16173.24 3474.63 6583.8 1348 .22 13910.16
4/15/2014 1842.98 16262.56 3487.85 6541.6 1329.28 13996.81
4/16/2014 1862 .31 16424.85 3533.09 6584.2 1342.55 14417.68
4/17/2014 1864.85 16408.54 3534.53 6625.3 1341.56 14417.53
4/18/2014
14516.27
4/21/2014 1871.89 16449.25 3559.95
14512.38
4/22/2014 1879 .55 16514.37 3588.81 6681.8 1369.45 14388.77
4/23/2014 1875.39 16501.65 3557.04 6674.7 1353.06 14546.27
4/24/2014 1878.61 16501.65 3591.03 6703 1365.27 14404.99
4/25/2014 1863.40 16361.46 3533.1 6685.7 1360.35 14429.26
4/28/2014 1869.43 16448.74 3545.03 6700.2 1357.56 14288.23
4/29/2014 1878.33 16535.37 3573.99 6769.9 1371.65 14288.23
4/30/2014 1883.95 16580.84 3582.02 6780 1364.39 14304.11
5/1/2014 1883.68 16558.87 3594.36 6808.9
14485.13
5/2/2014 1881.14 16512.89 3587.64 6822.4 1360.19 14457.51
5/5/2014 1884.66 16530.55 3605.09
1358.59
5/6/2014 1867.72 16401.02 3556.51 6798.6 1352.98 14457.51
5/7/2014 1878.21 16518.54 3546.47 6796.4 1343.13 14033.45
5/8/2014 1875.63 16550.97 3540.42 6839.3 1359.13 14163.78
5/9/2014 1878.48 16583.34 3555.7 6814.6 1354.34 14199.59
5/12/2014 1896.65 16695.47 3612.73 6851.8 1364.78 14149.52
5/13/2014 1897 .45 16715.44 3611.13 6873.1 1373.62 14425.44
5/14/2014 1888.53 16613.97 3593.25 6878.5 1375.93 14405.76
5/15/2014 1870.85 16446.81 3565.17 6840.9 1385 .84 14298.21
5/16/2014 1877.86 16491.31 3587.2 6855.8 1382 .14 14096.59
5/19/2014 1885.08 16511.86 3615.62 6844.6 1379.92 14006.44
5/20/2014 1872.83 16374.31 3600.31 6802 1381 .27 14075.25
5/21/2014 1888.03 16533.06 3635.61 6821 1385.86 14042.17
5/22/2014 1892.49 16543.08 3650.86 6820.6 1388.52 14337.79
5/23/2014 1900.53 16606.27 3677.33 6815.8 1392.28 14462.17
5/26/2014
1394 .15 14602.52
5/27/2014 1911.91 16675.50 3723.07 6844.9 1395.39 14636.52
5/28/2014 1909.78 16633.18 3712.26 6851.2 1392.85 14670.95
5/29/2014 1920.03 16698.74 3735.72 6871.3
14681.72
5/30/2014 1923.57 16717.17 3736.82 6844.5 1402.08 14632.38
6/2/2014 1924.97 16743.63 3732.96 6864.1 1399.4 14935.92
6/3/2014 1924.24 16722.34 3730.07 6836.3 1395.77 15034.25
6/4/2014 1927.88 16737.53 3743.59 6818.6 1397.47 15067.96
6/5/2014 1940.46 16836.11 3776.95 6813.5 1391.2 15079.37
6/6/2014 1949.44 16924.28 3794.57 6858.2
15077.24
6/9/2014 1951.27 16943.10 3795.74 6875 1406 .44 15124
6/10/2014 1950.79 16945.92 3800.86 6873.6 1406.22 14994.8
6/11/2014 1943.89 16843.88 3797.85 6838.9 1400 .35 15069.48
6/12/2014 1930.11 16734.19 3763.8 6843.1 1397.67 14973.53
6/13/2014 1936.16 16775.74 3775.56 6777.9 1390 .15 15097.84
6/16/2014 1937.78 16781.01 3779.93 6754.6 1382.98 14933.29
6/17/2014 1941.99 16808.49 3781 .32 6766.8 1384.27 14975.97
6/18/2014 1956.98 16906.62 3804.61 6778.6 1378.42 15115.8
6/19/2014 1959 .48 16921.46 3800.8 6808.1 1386.04 15361.16
6/20/2014 1962.87 16947.08 3802.64 6825.2
15349.42
6/23/2014 1962.61 16937.26 3805.31 6800.6 1396 .08 15369.28
6/24/2014 1949.98 16818.13 3799.53 6787.1 1400.37 15376.24
6/25/2014 1959.53 16867.51 3827.33 6733.6 1380 .5 15266.61
6/26/2014 1957.22 16846.13 3826.91 6735.1 1372.38 15308.49
6/27/2014 1960.96 16851.84 3844.44 6757.8 1379.02 15095
6/30/2014 1960.23 16826.60 3849.48 6743.9 1376 .81 15162.1
7/1/2014 1973.32 16956.07 3894.33 6802.9 1384.36 15326.2
7/2/2014 1974.62 16976.24 3899.27 6816.4 1388.11 15369.97
7/3/2014 1985.44 17068.26 3923.01 6865.2 1409.44 15348.29
7/4/2014
6866.1 1399.94 15437.13
7/7/2014 1977.65 17024.21 3910.71 6823.5 1397.11 15379.44
7/8/2014 1963.71 16906.62 3864.07 6738.5 1381.59 15314.41
7/9/2014 1972.83 16985.61 3892.91 6718 1379.77 15302.65
7/10/2014 1964.68 16915.07 3880.04 6672.4 1357.82 15216.47
7/11/2014 1967.57 16943.81 3904.58 6690.2 1362.35 15164.04
7/14/2014 1977.10 17055.42 3929.46 6746.1 1382.55 15296.82
7/15/2014 1973.28 17060.68 3914.46 6710.5 1372.25 15395.16
7/16/2014 1981.57 17138.20 3932.33 6784.7 1393.12 15379.3
7/17/2014 1958.12 16976.81 3878.01 6738.3 1376.36 15370.26
7/18/2014 1978.22 17100.18 3939.89 6749.5 1387.37 15215.71
7/21/2014 1973.63 17051.73 3934.14 6728.4 1383 .53 15215.71
7/22/2014 1983.53 17113.54 3961.62 6795.3 1399.09 15343.28
7/23/2014 1987.01 17086.63 3986.19 6798.2 1398.13 15328.56
7/24/2014 1987.98 17083.80 3983.19 6821.5 1405 .7 15284.42
7/25/2014 1978.34 16960.57 3965.17 6791.6 1404.12 15457.87
7/28/2014 1978.91 16982.59 3967.24 6788.1 1400.87 15529.4
7/29/2014 1969.95 16912.11 3959.03 6807.8 1397.89 15618.07
7/30/2014 1970.07 16880.36 3976.07 6773.4 1398.23 15646.23
7/31/2014 1930.67 16563.30 3892.5 6730.1 1379.87 15620.77
8/1/2014 1925.15 16493.37 3879.67 6679.2 1361.44 15523.11
8/4/2014 1938.99 16569.28 3908.77 6677.5 1361.03 15474.5
8/5/2014 1920.21 16429.47 3874.94 6682.5 1366.13 15320.31
8/6/2014 1920.24 16443.34 3874.27 6636.2 1344.3 15159.79
8/7/2014 1909.57 16368.27 3857.94 6597.4 1334.4 15232.37
8/8/2014 1931 .59 16553.93 3888 .09 6567 .4 1331 .56 14778.37
8/11/2014 1936.92 16569.98 3910.46 6632.8 1357.36 15130.52
8/12/2014 1933.75 16560.54 3905.23 6632.4 1349.96 15161.31
8/13/2014 1946.72 16651.80 3949.2 6656.7 1361.82 15213.63
8/14/2014 1955.18 16713.58 3969.11 6685.3 1353.94 15314.57
8/15/2014 1955.06 16662.91 3987.51 6689.1 1352.98 15318.34
8/18/2014 1971 .74 16838.74 4020.5 6741.3 1369.32 15322.6
8/19/2014 1981.60 16919.59 4040.13 6779.3 1376.61 15449.79
8/20/2014 1986.51 16979.13 4040.71 6755.5 1373.5 15454.45
8/21/2014 1992.37 17039.49 4047.03 6777.7 1385.03 15586.2
8/22/2014 1988.40 17001.22 4052.75 6775.3 1382.72 15539.19
8/25/2014 1997.92 17076.87 4067.48
1394.69 15613.25
8/26/2014 2000.02 17106.70 4071.67 6822.8 1397.54 15521.22
8/27/2014 2000.12 17122.01 4073.18 6830.7 1397.41 15534.82
8/28/2014 1996.74 17079.57 4066.27 6805.8 1383.03 15459.86
8/29/2014 2003.37 17098.45 4082.56 6819.8 1388.89 15424.59
9/1/2014
6825.3 1386.97 15476.6
9/2/2014 2002.28 17067.56 4095.81 6829.2 1387.94 15668.6
9/3/2014 2000.72 17078.28 4070.96 6873.6 1398.48 15728.35
9/4/2014 1997.65 17069.58 4066.13 6878 1397.99 15676.18
9/5/2014 2007.71 17137.36 4089.92 6855.1 1388.39 15668.68
9/8/2014 2001.54 17111.42 4095.47 6834.8 1392.73 15705.11
9/9/2014 1988.44 17013.87 4061.88 6829 1382.78 15749.15
9/10/2014 1995.69 17068.71 4094.97 6830.1 1387.38 15788.78
9/11/2014 1997.45 17049.00 4092.65 6799.6 1382.85 15909.2
9/12/2014 1985.54 16987.51 4069.23 6807 1388.59 15948.29
9/15/2014 1984.13 17031.14 4029.89 6804.2 1393.22 15948.29
9/16/2014 1998.98 17131.97 4067.27 6792.2 1395.29 15911.53
9/17/2014 2001.57 17156.85 4073.57 6780.9 1407 .04 15888.67
9/18/2014 2011.36 17265.99 4103.08 6819.3 1416.79 16067.57
9/19/2014 2010.40 17279.74 4100.09 6837.9 1421 .48 16321.17
9/22/2014 1994.29 17172.68 4061.23 6773.6 1418.29 16205.9
9/23/2014 1982.77 17055.87 4051.57 6676.1 1405.32
9/24/2014 1998.30 17210.06 4094.31 6706.3 1411.23 16167.45
9/25/2014 1965.99 16945.80 4007.82 6639.7 1393.09 16374.14
9/26/2014 1982.85 17113.15 4053.72 6649.4 1396.2 16229.86
9/29/2014 1977.80 17071.22 4047.18 6646.6 1392.39 16310.64
9/30/2014 1972.29 17042.90 4049.45 6622.7 1403 16173.52
10/1/2014 1946.16 16804.71 3984.74 6557.5 1381.59 16082.25
10/2/2014 1946.17 16801.05 3985.87 6446.4 1353.93 15661.99
10/3/2014 1967.90 17009.69 4027.31 6527.9 1369.52 15708.65
10/6/2014 1964.82 16991.91 4016.27 6563.7 1365.71 15890.95
10/7/2014 1935.10 16719.39 3958.59 6495.6 1337.63 15783.83
10/8/2014 1968.89 16994.22 4041.12 6482.2 1331.83 15595.98
10/9/2014 1928.21 16659.25 3969.32 6431.9 1322.31 15478.93
10/10/2014 1906.13 16544.10 3870.86 6340 1302.34 15300.55
10/13/2014 1874.74 16321.07 3808 6366.2 1294.64 15300.55
10/14/2014 1877.70 16315.19 3810.45 6392.7 1307.86 14936.51
10/15/2014 1862.49 16141.74 3785.97 6211.6 1269.91 15073.52
10/16/2014 1862.76 16117.24 3765.28 6195.9 1271 .01 14738.38
10/17/2014 1886 .76 16380.41 3815.47 6310.3 1310.46 14532.51
10/20/2014 1904 .01 16399.67 3870.08 6267.1 1306.44 15111.23
10/21/2014 1941.28 16614.81 3971.39 6372.3 1338.12 14804.28
10/22/2014 1927.11 16461.32 3949.59 6399.7 1344.34 15195.77
10/23/2014 1950.82 16677.90 4012.27 6419.2 1361.88 15138.96
10/24/2014 1964.58 16805.41 4042.02 6388.7 1358.57 15291.64
10/27/2014 1961.63 16817.94 4046.02 6363.5 1360.33 15388.72
10/28/2014 1985.05 17005.75 4106.63 6402.2 1380.83 15329.91
10/29/2014 1982.30 16974.31 4090.55 6453.9 1389.95 15553.91
10/30/2014 1994.65 17195.42 4100.64 6463.6 1397.18 15658.2
10/31/2014 2018 .05 17390.52 4158.21 6546.5 1412.84 16413.76
11/3/2014 2017 .81 17366.24 4169.28 6488 1399.05
11/4/2014 2012.10 17383.84 4156.23 6454 1399.87 16862.47
11/5/2014 2023.57 17484.53 4153.27 6539.1 1414.09 16937.32
11/6/2014 2031 .21 17554.47 4164.08 6551.2 1415.3 16792.48
11/7/2014 2031.92 17573.93 4160.5 6567.2 1410 .88 16880.38
11/10/2014 2038.26 17613.74 4175.95 6611.3 1417.82 16780.53
11/11/2014 2039.68 17614.90 4187.16 6627.4 1424 .93 17124.11
11/12/2014 2038.25 17612.20 4195.4 6611 1408.86 17197.05
11/13/2014 2039.33 17652.79 4213.48 6635.5 1422.76 17392.79
11/14/2014 2039.82 17634.74 4224.99 6654.4 1415.6 17490.83
11/17/2014 2041.32 17647.75 4213.79 6672 1419.92 16973.8
11/18/2014 2051.80 17687.82 4242.19 6709.1 1432 .38 17344.06
11/19/2014 2048.72 17685.73 4222.66 6696.6 1428 .01 17288.75
11/20/2014 2052.75 17719.00 4242.09 6678.9 1423.71 17300.86
11/21/2014 2063.50 17810.06 4251.32 6750.8 1447 .53 17357.51
11/24/2014 2069.41 17817.90 4284.32 6729.8 1456.59 17357.51
11/25/2014 2067.03 17814.94 4288.23 6731.1 1467.36 17407.62
11/26/2014 2072.83 17827.75 4317.99 6729.2 1457.81 17383.58
11/27/2014
6723.4 1465.96 17248.5
11/28/2014 2067.56 17828.24 4337.79 6722.6 1461.34 17459.85
12/1/2014 2053.44 17776.80 4287.81 6656.4 1450 .03 17590.1
12/2/2014 2066.55 17879.55 4305.96 6742.1 1450.07 17663.22
12/3/2014 2074.33 17912.62 4312.93 6716.6 1464.84 17720.43
12/4/2014 2071.92 17900.10 4311.93 6679.4 1447.82 17887.21
12/5/2014 2075.37 17958.79 4311.57 6742.8 1474.7 17920.45
12/8/2014 2060.31 17852.48 4278.34 6672.2 1467.88 17935.64
12/9/2014 2059.82 17801.20 4294.67 6529.5 1452 .24 17813.38
12/10/2014 2026 .14 17533.15 4224.87 6500 1452.8 17412.58
12/11/2014 2035 .33 17596.34 4246.48 6461.7 1454.45 17257.4
12/12/2014 2002.33 17280.83 4199.28 6300.6 1425.86 17371.58
12/15/2014 1989.63 17180.84 4157.41 6182.7 1408.75 17099.4
12/16/2014 1972.74 17068.87 4089.6 6331.8 1413.58 16755.32
12/17/2014 2012.89 17356.87 4165.1 6336.5 1405.35 16819.73
12/18/2014 2061.23 17778.15 4267.77 6466 1441.85 17210.05
12/19/2014 2070.65 17804.80 4281.78 6545.3 1452.36 17621.4
12/22/2014 2078.54 17959.44 4293.67 6576.7 1461.75 17635.14
12/23/2014 2082.17 18024.17 4279.3 6598.2 1470.49
12/24/2014 2081.88 18030.21 4283.1 6609.9
17854.23
12/25/2014
17808 .75
12/26/2014 2088.77 18053.71 4314.09
17818.96
12/29/2014 2090.57 18038.23 4312.64 6633.5 1478.93 17729.84
12/30/2014 2080 .35 17983.07 4282.35 6547 1464.55 17450.77
12/31/2014 2058.90 17823.07 4236.28 6566.1
17450.77
1/1/2015
1/2/2015 2058.20 17832.99 4230.24 6547.8 1463.78 17450.77
1/5/2015 2020.58 17501.65 4160.96 6417.2 1454.81 17408.71
1/6/2015 2002.61 17371.64 4110.83 6366.5
16883.19
1/7/2015 2025.90 17584.52 4160 6419.8 1421.34 16885.33
1/8/2015 2062.14 17907.87 4240.55 6570 1456.72 17167.1
1/9/2015 2044.81 17737.37 4213.28 6501.1 1444.46 17197.73
1/12/2015 2028.26 17640.84 4169.97 6501.4 1453.64
1/13/2015 2023.03 17613.68 4166.2 6542.2 1465.66 17087.71
1/14/2015 2011.27 17427.09 4145.84 6388.5 1434 .79 16795.96
1/15/2015 1992.67 17320.71 4089.65 6498.8 1457.36 17108.7
1/16/2015 2019 .42
4142.14 6550.3 1468.9 16864.16
1/19/2015
6585.5 1476.31 17014.29
1/20/2015 2022 .55 17515.23 4171.21 6620.1 1491.59 17366.3
1/21/2015 2032.12 17554.28 4192.09 6728 1501.22 17280.48
1/22/2015 2063.15 17813.98 4270.36 6796.6 1523.8 17329.02
1/23/2015 2051.82 17672.60 4278.14 6832.8 1536 .39 17511.75
1/26/2015 2057.09 17678.70 4275.72 6852.4 1554.7 17468.52
1/27/2015 2029.55 17387.21 4165.5 6811.6 1533.37 17768.3
1/28/2015 2002.16 17191.37 4140.38 6825.9 1562.54 17795.73
1/29/2015 2021.25 17416.85 4181.35 6810.6 1570.39 17606.22
1/30/2015 1994.99 17164.95 4148.43 6749.4 1573.62 17674.39
2/2/2015 2020.85 17361.04 4188.59 6782.6 1575.95 17558.04
2/3/2015 2050 .03 17666.40 4229.15 6871.8 1593.42 17335.85
2/4/2015 2041.51 17673.02 4221.2 6860 1579.31 17678.74
2/5/2015 2062.52 17884.88 4256.18 6865.9 1586.13 17504.62
2/6/2015 2055.47 17824.29 4228.68 6853.4 1599.55 17648.5
2/9/2015 2046.74 17729.21 4216.09 6837.2 1591.4 17711.93
2/10/2015 2068.59 17868.76 4281.16 6829.1 1602.74 17652.68
2/11/2015 2068.53 17862.14 4297.28 6818.2 1593.03 17652.68
2/12/2015 2088.48 17972.38 4347.97 6828.1 1624 .35 17979.72
2/13/2015 2096.99 18019.35 4384.03 6873.5 1642.04 17913.36
2/16/2015
6857.1 1644 .29 18004.77
2/17/2015 2100.34 18047.58 4385.34 6898.1 1630.99 17987.09
2/18/2015 2099.68 18029.85 4390.91 6898.1 1652.15 18199.17
2/19/2015 2097.45 17985.77 4411.86 6888.9 1662.24 18264.79
2/20/2015 2110.30 18140.44 4443.05 6915.2 1664 .33 18332.3
2/23/2015 2109 .66 18116.84 4449.49 6912.2 1679 .48 18466.92
2/24/2015 2115.48 18209.19 4451.03 6949.6 1683.92 18603.48
2/25/2015 2113.86 18224.57 4440.59 6935.4 1678.73 18585.2
2/26/2015 2110.74 18214.42 4462.27 6949.7 1684 .83 18785.79
2/27/2015 2104.50 18132.70 4440.67 6946.7 1691.03 18797.94
3/2/2015 2117.39 18288.63 4483.05 6940.6 1686.64 18826.88
3/3/2015 2107.78 18203.37 4458.78 6889.1 1661.87 18815.16
3/4/2015 2098.53 18096.90 4445.36 6919.2 1664.5 18703.6
3/5/2015 2101.04 18135.72 4452.06 6961.1
18751.84
3/6/2015 2071.26 17856.78 4399.23 6911.8
18971
3/9/2015 2079.43 17995.72 4412.99 6876.5
18790.55
3/10/2015 2044.16 17662.94 4329.08 6702.8
18665.11
3/11/2015 2040.24 17635.39 4305.38 6721.5
18723.52
3/12/2015 2065.95 17895.22 4336.23 6761.1
18991.11
3/13/2015 2053.40 17749.31 4314.9 6740.6
19254.25

Sheet 3: A.8.3


Maakond Töötuse määr Keskmine brutokuupalk Sündinud ettevõtted Sekundaar - sektor Tertsiaar-sektor
Harjumaa 12.6 883 3878 26.8 72.2
Hiiu maakond 11.1 606.59 26 23.3 65.7
Ida-Viru maakond 18.1 636.82 246 45.3 52.5
Jõgeva maakond 20.1 578.34 52 28.2 60.8
Järva maakond 11.9 625.44 64 42.4 46
Lääne maakond 15.5 619.37 81 32.4 60.3
Lääne-Viru maakond 16.4 623.78 168 33 59
Põlva maakond 12 640.65 60 41.1 54.4
Pärnu maakond 10.6 658.55 318 34.6 59.2
Rapla maakond 15.5 641.16 115 34.3 60.2
Saare maakond 10.4 651.96 100 33.7 54.8
Tartu maakond 11.9 749.36 676 25.4 68.7
Valga maakond 17.8 573.86 66 40.2 54.6
Viljandi maakond 11.9 643.14 145 37.8 52.7
Võru maakond 16 646.66 94 40.1 53.1

Sheet 4: A.8.4


Kuupäev Arco Vara
Harju Elekter
Olympic Entertainment Group
Arco Vara Harju Elekter Olympic Entertainment Group 12/18/2014 -2.35%
0.00%
1.80%
autokorrelatsiooni kordaja -0.2365398891 -0.381619187 -0.0757374379 12/19/2014 2.53% -2.35% 0.00% 0.00% 0.00% 1.80%
kõige juhuslikum 12/22/2014 0.00% 2.53% -0.36% 0.00% 1.18% 0.00%
12/23/2014 0.00% 0.00% -2.88% -0.36% -1.16% 1.18%
12/29/2014 -3.29% 0.00% 2.96% -2.88% 0.00% -1.16%
12/30/2014 0.61% -3.29% 0.36% 2.96% 0.00% 0.00%
1/2/2015 0.00% 0.61% -1.43% 0.36% 0.59% 0.00%
1/5/2015 3.74% 0.00% -1.45% -1.43% 0.58% 0.59%
1/6/2015 0.00% 3.74% 0.00% -1.45% -1.74% 0.58%
1/7/2015 -2.79% 0.00% 1.48% 0.00% 0.59% -1.74%
1/8/2015 0.00% -2.79% -1.82% 1.48% 0.00% 0.59%
1/9/2015 5.39% 0.00% 0.00% -1.82% 0.00% 0.00%
1/12/2015 0.00% 5.39% 0.00% 0.00% -0.59% 0.00%
1/13/2015 0.00% 0.00% 0.74% 0.00% -0.59% -0.59%
1/14/2015 -1.70% 0.00% -0.74% 0.74% 0.00% -0.59%
1/15/2015 4.05% -1.70% 2.22% -0.74% 0.00% 0.00%
1/16/2015 -2.11% 4.05% -0.36% 2.22% 0.00% 0.00%
1/19/2015 -3.18% -2.11% -1.82% -0.36% 2.98% 0.00%
1/20/2015 5.51% -3.18% 1.85% -1.82% 2.31% 2.98%
1/21/2015 1.22% 5.51% 0.00% 1.85% 1.13% 2.31%
1/22/2015 4.28% 1.22% 2.55% 0.00% 5.03% 1.13%
1/23/2015 0.00% 4.28% -2.48% 2.55% -2.13% 5.03%
1/26/2015 2.00% 0.00% 0.00% -2.48% -1.63% -2.13%
1/27/2015 -6.91% 2.00% 0.00% 0.00% 0.55% -1.63%
1/28/2015 5.88% -6.91% -0.36% 0.00% -0.55% 0.55%
1/29/2015 -0.52% 5.88% 1.46% -0.36% -0.55% -0.55%
1/30/2015 6.32% -0.52% -1.44% 1.46% 0.00% -0.55%
2/2/2015 0.99% 6.32% 0.00% -1.44% 1.11% 0.00%
2/3/2015 0.00% 0.99% 1.09% 0.00% 0.55% 1.11%
2/4/2015 0.00% 0.00% -1.44% 1.09% -0.55% 0.55%
2/5/2015 -3.92% 0.00% 0.73% -1.44% 0.55% -0.55%
2/6/2015 4.08% -3.92% 1.09% 0.73% 0.55% 0.55%
2/9/2015 -5.88% 4.08% 0.00% 1.09% 1.09% 0.55%
2/10/2015 0.00% -5.88% 0.72% 0.00% 0.00% 1.09%
2/11/2015 7.29% 0.00% 0.00% 0.72% 2.69% 0.00%
2/12/2015 2.91% 7.29% -0.71% 0.00% 2.09% 2.69%
2/13/2015 3.77% 2.91% -0.36% -0.71% -1.03% 2.09%
2/16/2015 -4.55% 3.77% 1.08% -0.36% 0.00% -1.03%
2/17/2015 0.95% -4.55% 0.00% 1.08% -0.52% 0.00%
2/18/2015 -3.77% 0.95% 1.07% 0.00% -0.52% -0.52%
2/19/2015 0.00% -3.77% -1.06% 1.07% 1.57% -0.52%
2/20/2015 -1.96% 0.00% 0.00% -1.06% 0.00% 1.57%
2/23/2015 0.00% -1.96% 0.00% 0.00% 1.03% 0.00%
2/24/2015 0.00% 0.00% 0.00% 0.00% 0.00% 1.03%
2/25/2015 2.00% 0.00% 0.00% 0.00% 0.51% 0.00%
2/26/2015 0.00% 2.00% 0.00% 0.00% -2.54% 0.51%
2/27/2015 3.92% 0.00% 0.00% 0.00% 1.04% -2.54%
3/2/2015 -1.89% 3.92% -0.36% 0.00% -0.52% 1.04%
3/3/2015 0.00% -1.89% 0.36% -0.36% -0.52% -0.52%
3/4/2015 0.96% 0.00% -0.36% 0.36% 0.00% -0.52%
3/5/2015 0.00% 0.96% 1.79% -0.36% 0.52% 0.00%
3/6/2015 0.95% 0.00% 0.00% 1.79% 0.00% 0.52%
3/9/2015 0.00% 0.95% -1.06% 0.00% -0.52% 0.00%
3/10/2015 2.83% 0.00% 1.07% -1.06% 0.00% -0.52%
3/11/2015 0.00% 2.83% 0.00% 1.07% 0.00% 0.00%
3/12/2015 0.00% 0.00% 0.35% 0.00% 0.00% 0.00%
3/13/2015 0.00% 0.00% -0.70% 0.35% 1.04% 0.00%
3/16/2015 0.92% 0.00% 2.47% -0.70% 0.00% 1.04%
3/17/2015 9.09% 0.92% 0.69% 2.47% -1.03% 0.00%
3/18/2015 4.17% 9.09% 0.00% 0.69% 0.00% -1.03%
3/19/2015 3.20% 4.17% 1.03% 0.00% 0.00% 0.00%
3/20/2015 -8.53% 3.20% -0.34% 1.03% 0.00% 0.00%
3/23/2015 1.69% -8.53% -1.02% -0.34% 0.52% 0.00%
3/24/2015 0.00% 1.69% 1.37% -1.02% 0.00% 0.52%
3/25/2015 -3.33% 0.00% -0.34% 1.37% 0.00% 0.00%
3/26/2015 -0.86% -3.33% -0.68% -0.34% 0.52% 0.00%
3/27/2015 0.87% -0.86% 0.68% -0.68% -0.52% 0.52%
3/30/2015 0.00% 0.87% -0.68% 0.68% 0.00% -0.52%
3/31/2015 0.00% 0.00% -0.34% -0.68% 0.00% 0.00%
4/1/2015 0.00% 0.00% 0.34% -0.34% 0.52% 0.00%
4/2/2015 1.72% 0.00% 0.34% 0.34% 0.52% 0.52%
4/7/2015 -2.54% 1.72% 0.00% 0.34% 1.54% 0.52%
4/8/2015 7.83% -2.54% 1.02% 0.00% 0.51% 1.54%
4/9/2015 -3.23% 7.83% 0.00% 1.02% 0.00% 0.51%
4/10/2015 0.00% -3.23% 1.01% 0.00% 0.50% 0.00%
4/13/2015 -5.00% 0.00% 1.00% 1.01% -1.50% 0.50%
4/14/2015 4.39% -5.00% 0.33% 1.00% 1.52% -1.50%
4/15/2015 -1.68% 4.39% 1.32% 0.33% 0.50% 1.52%
4/16/2015 0.00% -1.68% -0.33% 1.32% -0.50% 0.50%
4/17/2015 -0.85% 0.00% -0.33% -0.33% 0.00% -0.50%
4/20/2015 -0.86% -0.85% -0.33% -0.33% 0.00% 0.00%
4/21/2015 -2.61% -0.86% 0.00% -0.33% 0.00% 0.00%
4/22/2015 1.79% -2.61% 0.00% 0.00% 0.00% 0.00%
4/23/2015 0.00% 1.79% 0.00% 0.00% -1.00% 0.00%
4/24/2015 3.51% 0.00% 1.32% 0.00% 1.01% -1.00%
4/27/2015 0.85% 3.51% 0.32% 1.32% 1.00% 1.01%
4/28/2015 0.00% 0.85% -0.97% 0.32% 0.00% 1.00%
4/29/2015 0.00% 0.00% -2.29% -0.97% -4.95% 0.00%
4/30/2015 0.00% 0.00% 0.33% -2.29% 0.00% -4.95%
5/4/2015 -3.36% 0.00% 0.00% 0.33% -1.04% 0.00%
5/5/2015 0.00% -3.36% 0.00% 0.00% -0.53% -1.04%
5/6/2015 2.61% 0.00% -1.67% 0.00% -1.06% -0.53%
5/7/2015 4.24% 2.61% -1.02% -1.67% -1.60% -1.06%
5/8/2015 0.81% 4.24% 0.68% -1.02% -1.09% -1.60%
5/11/2015 -5.65% 0.81% 0.34% 0.68% 0.00% -1.09%
5/12/2015 5.98% -5.65% 1.02% 0.34% -0.55% 0.00%
5/13/2015 -2.42% 5.98% -2.35% 1.02% 0.55% -0.55%
5/15/2015 1.65% -2.42% 3.09% -2.35% 0.00% 0.55%
5/18/2015 1.63% 1.65% -1.33% 3.09% 0.00% 0.00%
5/19/2015 -2.40% 1.63% 0.00% -1.33% 1.65% 0.00%
5/20/2015 0.00% -2.40% 0.00% 0.00% 0.00% 1.65%
5/21/2015 0.00% 0.00% -1.69% 0.00% 0.00% 0.00%
5/22/2015 2.46% 0.00% 3.09% -1.69% 2.16% 0.00%
5/25/2015 0.00% 2.46% -1.67% 3.09% -1.06% 2.16%
5/26/2015 -2.40% 0.00% 0.34% -1.67% 0.53% -1.06%
5/27/2015 1.64% -2.40% -4.05% 0.34% 0.53% 0.53%
5/28/2015 -1.61% 1.64% 0.70% -4.05% -0.53% 0.53%
5/29/2015 0.00% -1.61% -1.05% 0.70% 0.53% -0.53%
6/1/2015 -0.82% 0.00% 1.77% -1.05% 0.00% 0.53%
6/2/2015 0.00% -0.82% -1.39% 1.77% -0.53% 0.00%
6/3/2015 0.00% 0.00% 1.06% -1.39% 0.53% -0.53%
6/4/2015 -1.65% 0.00% -0.35% 1.06% -0.53% 0.53%
6/5/2015 5.04% -1.65% 0.70% -0.35% 0.00% -0.53%
6/8/2015 -0.80% 5.04% -3.13% 0.70% 0.00% 0.00%
6/9/2015 0.81% -0.80% 2.15% -3.13% 0.00% 0.00%
6/10/2015 -2.40% 0.81% -1.75% 2.15% -1.06% 0.00%
6/11/2015 1.64% -2.40% 4.29% -1.75% 1.08% -1.06%
6/12/2015 -2.42% 1.64% -1.37% 4.29% -1.06% 1.08%
6/15/2015 3.31% -2.42% 0.69% -1.37% -0.54% -1.06%
6/16/2015 0.00% 3.31% -0.69% 0.69% 0.54% -0.54%
6/17/2015 0.00% 0.00% -1.04% -0.69% 0.00% 0.54%
6/18/2015 0.00% 0.00% -1.05% -1.04% 0.00% 0.00%
6/19/2015 0.00% 0.00% -0.35% -1.05% -0.54% 0.00%
6/22/2015 0.00% 0.00% 1.07% -0.35% 0.54% -0.54%
6/23/2015 0.00% 0.00% 0.00% 1.07% 0.00% 0.54%
6/25/2015 -0.80% 0.00% -0.35% 0.00% 0.54% 0.00%
6/26/2015 0.00% -0.80% -0.35% -0.35% -0.53% 0.54%
6/29/2015 -4.03% 0.00% -2.13% -0.35% -0.54% -0.53%
6/30/2015 0.00% -4.03% 2.17% -2.13% 0.00% -0.54%
7/1/2015 1.68% 0.00% -0.35% 2.17% 0.54% 0.00%
7/2/2015 0.00% 1.68% 0.00% -0.35% 0.54% 0.54%
7/3/2015 0.00% 0.00% 0.00% 0.00% -0.53% 0.54%
7/6/2015 -0.83% 0.00% -0.71% 0.00% -1.08% -0.53%
7/7/2015 0.00% -0.83% 0.00% -0.71% 1.09% -1.08%
7/8/2015 0.00% 0.00% 1.08% 0.00% -1.08% 1.09%
7/9/2015 0.00% 0.00% -0.71% 1.08% 0.54% -1.08%
7/10/2015 -6.67% 0.00% 0.71% -0.71% 0.54% 0.54%
7/13/2015 8.04% -6.67% 1.06% 0.71% 0.54% 0.54%
7/14/2015 1.65% 8.04% -1.75% 1.06% 1.60% 0.54%
7/15/2015 0.00% 1.65% 0.36% -1.75% -0.53% 1.60%
7/16/2015 -2.44% 0.00% 1.07% 0.36% -0.53% -0.53%
7/17/2015 0.00% -2.44% 0.00% 1.07% 0.53% -0.53%
7/20/2015 0.00% 0.00% -0.70% 0.00% -0.53% 0.53%
7/21/2015 -2.50% 0.00% 0.00% -0.70% -0.53% -0.53%
7/22/2015 0.00% -2.50% 1.06% 0.00% 1.07% -0.53%
7/23/2015 0.00% 0.00% -0.70% 1.06% -0.53% 1.07%
7/24/2015 0.00% 0.00% 0.00% -0.70% 0.00% -0.53%
7/27/2015 -1.71% 0.00% 0.00% 0.00% 1.60% 0.00%
7/28/2015 0.87% -1.71% 0.35% 0.00% 0.00% 1.60%
7/29/2015 3.45% 0.87% -0.70% 0.35% 1.05% 0.00%
7/30/2015 0.00% 3.45% -0.71% -0.70% -0.52% 1.05%
7/31/2015 0.00% 0.00% 0.71% -0.71% 0.00% -0.52%
8/3/2015 0.00% 0.00% 0.35% 0.71% 0.00% 0.00%
8/4/2015 0.00% 0.00% 0.00% 0.35% 0.00% 0.00%
8/5/2015 0.83% 0.00% -1.06% 0.00% 0.52% 0.00%
8/6/2015 0.83% 0.83% 0.00% -1.06% 0.52% 0.52%
8/7/2015 0.00% 0.83% 0.36% 0.00% -0.52% 0.52%
8/10/2015 -1.64% 0.00% 0.71% 0.36% 0.52% -0.52%
8/11/2015 1.67% -1.64% 0.35% 0.71% -0.52% 0.52%
8/12/2015 0.00% 1.67% -1.41% 0.35% 0.00% -0.52%
8/13/2015 0.00% 0.00% 0.00% -1.41% -0.52% 0.00%
8/14/2015 0.00% 0.00% 0.00% 0.00% 0.00% -0.52%
8/17/2015 0.00% 0.00% 0.00% 0.00% 0.52% 0.00%
8/18/2015 -4.92% 0.00% 0.00% 0.00% -1.04% 0.52%
8/19/2015 -1.72% -4.92% 0.00% 0.00% 0.52% -1.04%
8/20/2015 0.00% -1.72% 0.00% 0.00% 0.00% 0.52%
8/21/2015 0.00% 0.00% -0.71% 0.00% -1.56% 0.00%
8/24/2015 -6.14% 0.00% -2.88% -0.71% -5.29% -1.56%
8/25/2015 5.61% -6.14% 0.74% -2.88% 3.35% -5.29%
8/26/2015 0.00% 5.61% -0.74% 0.74% 0.00% 3.35%
8/27/2015 0.00% 0.00% 1.11% -0.74% 1.08% 0.00%
8/28/2015 0.00% 0.00% 0.73% 1.11% 0.00% 1.08%
8/31/2015 0.00% 0.00% 0.00% 0.73% 0.53% 0.00%
9/1/2015 -7.08% 0.00% -1.82% 0.00% -1.60% 0.53%
9/2/2015 0.00% -7.08% 1.11% -1.82% 0.00% -1.60%
9/3/2015 0.00% 0.00% 0.00% 1.11% 1.08% 0.00%
9/4/2015 5.71% 0.00% 0.37% 0.00% -0.53% 1.08%
9/7/2015 0.00% 5.71% 0.00% 0.37% 0.00% -0.53%
9/8/2015 0.00% 0.00% 0.36% 0.00% 0.00% 0.00%
9/9/2015 0.00% 0.00% 0.73% 0.36% -0.54% 0.00%
9/10/2015 0.00% 0.00% 0.00% 0.73% 0.00% -0.54%
9/11/2015 5.41% 0.00% -0.72% 0.00% 0.00% 0.00%
9/14/2015 0.00% 5.41% -0.36% -0.72% 0.54% 0.00%
9/15/2015 0.00% 0.00% -0.36% -0.36% -0.54% 0.54%
9/16/2015 0.00% 0.00% -0.73% -0.36% 0.00% -0.54%
9/17/2015 0.00% 0.00% -0.37% -0.73% 0.00% 0.00%
9/18/2015 -8.55% 0.00% 0.74% -0.37% 0.00% 0.00%
9/21/2015 0.00% -8.55% 0.00% 0.74% 0.54% 0.00%
9/22/2015 0.00% 0.00% 0.00% 0.00% -1.61% 0.54%
9/23/2015 0.93% 0.00% -0.37% 0.00% 0.00% -1.61%
9/24/2015 0.93% 0.93% -0.37% -0.37% -1.64% 0.00%
9/25/2015 0.00% 0.93% 0.00% -0.37% 0.00% -1.64%
9/28/2015 -0.92% 0.00% -1.48% 0.00% -1.11% 0.00%
9/29/2015 -1.85% -0.92% -0.38% -1.48% 0.00% -1.11%
9/30/2015 0.00% -1.85% 0.38% -0.38% 0.00% 0.00%
10/1/2015 0.00% 0.00% 1.13% 0.38% 0.56% 0.00%
10/2/2015 0.00% 0.00% 0.00% 1.13% -0.56% 0.56%
10/5/2015 0.00% 0.00% -0.37% 0.00% 1.12% -0.56%
10/6/2015 0.00% 0.00% -0.37% -0.37% -1.11% 1.12%
10/7/2015 0.00% 0.00% -1.50% -0.37% -0.56% -1.11%
10/8/2015 0.00% 0.00% -1.90% -1.50% -1.13% -0.56%
10/9/2015 0.00% 0.00% 0.39% -1.90% 1.71% -1.13%
10/12/2015 0.00% 0.00% -3.09% 0.39% 1.12% 1.71%
10/13/2015 0.00% 0.00% 1.59% -3.09% -0.56% 1.12%
10/14/2015 -0.94% 0.00% -1.18% 1.59% -0.56% -0.56%
10/15/2015 0.00% -0.94% 0.79% -1.18% 0.00% -0.56%
10/16/2015 0.00% 0.00% -0.79% 0.79% -0.56% 0.00%
10/19/2015 0.00% 0.00% 0.40% -0.79% 0.00% -0.56%
10/20/2015 4.76% 0.00% 0.00% 0.40% -0.56% 0.00%
10/21/2015 -5.45% 4.76% -0.40% 0.00% 1.14% -0.56%
10/22/2015 0.00% -5.45% 0.40% -0.40% 0.00% 1.14%
10/23/2015 4.81% 0.00% -0.40% 0.40% -0.56% 0.00%
10/26/2015 0.00% 4.81% 0.00% -0.40% 0.00% -0.56%
10/27/2015 -6.42% 0.00% -0.40% 0.00% 2.26% 0.00%
10/28/2015 0.00% -6.42% 0.80% -0.40% -0.55% 2.26%
10/29/2015 -0.98% 0.00% -0.40% 0.80% 0.00% -0.55%
10/30/2015 3.96% -0.98% -0.40% -0.40% 0.56% 0.00%
11/2/2015 0.00% 3.96% 0.00% -0.40% -0.55% 0.56%
11/3/2015 0.00% 0.00% 0.00% 0.00% 0.00% -0.55%
11/4/2015 7.62% 0.00% 0.80% 0.00% 0.00% 0.00%
11/5/2015 0.00% 7.62% 0.00% 0.80% 0.00% 0.00%
11/6/2015 3.54% 0.00% 0.40% 0.00% -0.56% 0.00%
11/9/2015 -2.56% 3.54% -0.39% 0.40% 0.56% -0.56%
11/10/2015 0.00% -2.56% 0.79% -0.39% -0.56% 0.56%
11/11/2015 -2.63% 0.00% 0.00% 0.79% -0.56% -0.56%
11/12/2015 0.00% -2.63% -0.78% 0.00% 0.56% -0.56%
11/13/2015 0.00% 0.00% 0.00% -0.78% -0.56% 0.56%
11/16/2015 -0.90% 0.00% -0.40% 0.00% -0.56% -0.56%
11/17/2015 0.00% -0.90% 1.59% -0.40% -0.56% -0.56%
11/18/2015 0.00% 0.00% -0.39% 1.59% 0.57% -0.56%
11/19/2015 0.91% 0.00% 0.00% -0.39% 0.00% 0.57%
11/20/2015 3.60% 0.91% 0.39% 0.00% 1.13% 0.00%
11/23/2015 2.61% 3.60% 0.78% 0.39% 0.00% 1.13%
11/24/2015 -2.54% 2.61% 2.71% 0.78% -0.56% 0.00%
11/25/2015 2.61% -2.54% -1.13% 2.71% 0.56% -0.56%
11/26/2015 -0.85% 2.61% 0.38% -1.13% 0.00% 0.56%
11/27/2015 0.00% -0.85% -0.38% 0.38% 0.00% 0.00%
11/30/2015 -2.56% 0.00% 1.91% -0.38% 1.12% 0.00%
12/1/2015 0.00% -2.56% -1.87% 1.91% 0.00% 1.12%
12/2/2015 -3.51% 0.00% 1.15% -1.87% 0.00% 0.00%
12/3/2015 0.91% -3.51% -1.13% 1.15% 0.55% 0.00%
12/4/2015 2.70% 0.91% 0.38% -1.13% 0.55% 0.55%
12/7/2015 -3.51% 2.70% 0.00% 0.38% 2.19% 0.55%
12/8/2015 6.36% -3.51% 0.00% 0.00% -1.60% 2.19%
12/9/2015 -4.27% 6.36% -0.38% 0.00% -1.63% -1.60%
12/10/2015 0.00% -4.27% 0.38% -0.38% 0.00% -1.63%
12/11/2015 0.00% 0.00% 0.38% 0.38% 0.00% 0.00%
12/14/2015 1.79% 0.00% 0.00% 0.38% -0.55% 0.00%
12/15/2015 0.00% 1.79% 0.00% 0.00% -1.11% -0.55%
12/16/2015 0.00% 0.00% 0.38% 0.00% 0.00% -1.11%
12/17/2015 -2.63% 0.00% -0.38% 0.38% 0.56% 0.00%
12/18/2015 5.41% -2.63% -0.76% -0.38% -0.56% 0.56%

Sheet 5: A.8.5


Erakond Kulud, tuh eurot Häälte arv
Reformierakond 805.1 110263
Keskerakond 702.9 207565
IRL 517.6 92068
Rahvaliit 37.6 12683
SDE 195.5 49540
Rohelised 99.7 7774
korrelatsioonikordaja r 0.857
korrelatsioon puudub, r=0
korrelatsioon olemas, r ei võrdu 0
n 6
v=n-2 4
t statistik 3.32 parameetri empiiriline väärtus
olulisuse nivoo 5% 1%
t kriitiline 2.776 4.604 T.INV.2T
H1 H0

Sheet 6: A.8.6


Mitme tüki hinda reklaamis näidati Müügimaht nädalas, tk
1 270
2 360
3 340
4 630
5 520
H0: r=0 korrelatsioon puudub
ühepoolne hüpotees
H1: r/=0 korrelatsioon esineb
korrelatsioonikordaja r 0.828
empiiriline parameetri väärtus t 2.56
valimi maht n 5
vabadusastmete arv v 3
olulisuse nivoo 0.05
parameetri kriitilised väärtused -2.35 2.35
2.56 > 2.35
eksperiment kinnitab hüpoteesi, et mitme tüki hinna reklaamimisel müügimaht suureneb

Sheet 7: A.8.7


ETTEVÕTE MÜÜGITULU , tuh kr PUHAS-KASUM, tuh kr OMAKAPITALI TOOTLIKKUS , % TÖÖJÕUKULU 1 TÖÖTAJA KOHTA, kr kuus TOOTLIKKUS 1 TÖÖTAJA KOHTA, tuh kr INVESTEE-RINGUD, tuh kr
MÜÜGITULU, tuh kr PUHAS-KASUM, tuh kr OMAKAPITALI TOOTLIKKUS, % TÖÖJÕUKULU 1 TÖÖTAJA KOHTA, kr kuus TOOTLIKKUS 1 TÖÖTAJA KOHTA, tuh kr INVESTEE-RINGUD, tuh kr TALLINNA KAUBAMAJA AS 2877784 91776 11 11088 1512 421000.00
MÜÜGITULU, tuh kr 1
BALTI EHITUSMASIN - BALTEM AS 209710.614 9431.422 46 21551 8388 550.75
PUHAS-KASUM, tuh kr 0.8685237557 1
AMSERV GRUPI AS (kontsern) 1264346 40362 44 19831 4771 13882.00
OMAKAPITALI TOOTLIKKUS, % -0.1539463903 -0.128302176 1
VIVAREC AS 52998.296 4512.394 125 29852 2944 286.33
TÖÖJÕUKULU 1 TÖÖTAJA KOHTA, kr kuus 0.0687906561 0.0678335265 0.0415045499 1
ELKE GRUPI AS 1074200 49100 39 15032 3454 34100.00
TOOTLIKKUS 1 TÖÖTAJA KOHTA, tuh kr 0.0369173031 0.0762739922 -0.1246753373 0.3900119932 1
ATLAS HOLDING OÜ 148642.318 7979.464 31 19291 24774 2936.29
INVESTEE-RINGUD, tuh kr 0.8808503512 0.7164123977 -0.1171114746 -0.0681511676 -0.0714024208 1 ELKE AUTO AS 490920.583 28521.466 44 22382 6818 3371.43
BALTIKA AS (kontsern) 680906 72664 42 6948 412 36200.00
n 52
TAMREX OHUTUSE OÜ 43043.564 763.351 130 19165 1196 893.11
olulisuse nivoo 5%
TATOLI AS 178763.513 10418.872 39 19515 8513 1977.33
t kriitiline 2.01
REGINETT OÜ 10138.131 486.688 118 5202 1690 500.95
AARDEMAA OÜ 81318 262 328 6503 830 835.00
AUTORI AS 268899.163 9324.019 73 19253 4482 678.73
v 50
ABC GRUPI AS 834129.754 19483.22 27 10396 1636 72246.02
r kriitiline 0.273
DOMUS GROUP OÜ 7168.838 899.115 71 7888 1558 94.17
INFOTARK AS 247655.556 18179.472 27 20903 2553 497.96
INBIO OÜ 9521.446 529.597 33 10011 732 791.03
UHTNA TALUTEHNIKA AS 58360.644 2430.844 33 10666 1716 10266.44
RGR METALL OÜ 246400.593 32409.024 25 10112 9856 7338.63
JAPAUTO AS 253526.232 14337.866 35 18244 4024 4628.31
FLINT KAUBANDUS OÜ 39866 7566 51 7938 4430 778.52
Järeldus: investeeringud suurendavad müügitulu ja kasumit
SIGARI MAJA OÜ 17961.737 2946.93 63 8683 945 455.50
VALOOR AS 87839.907 4343.114 46 20808 4623 117.79
INDOOR GROUP AS 275676.475 21946.101 40 15185 5514 511.10
SUNOREK AS 112940.335 9015.792 111 14592 706 7889.70
AJ TOOTED AS 19212.482 3695.616 55 14049 3842 141.13
IV PLUSS AS 81649.591 2590.482 12 22289 2634 449.44
KUSTUTAJA OÜ 3696.225 524.476 106 16058 1848 50.00
KEMIFLORA AS 86226 5131 21 20478 2536 1530.00
VÄRVIKESKUSTE GRUPP OÜ 101595.482 5283.117 44 16436 2363 4747.00
DIO OIL EST AS 337355.648 969.371 3 9887 6365 6512.00
ANGAAR AS 918.954 7.267 1 8098 459 368.88
ORDI AS 377335.399 4387.126 13 14332 4057 1027 .72
LPP RETAIL ESTONIA OÜ 61121.958 3159.449 63 8734 657 8100.00
BALTI FONOLUKK OÜ 6891.505 72.519 55 14129 861 52.61
RADEMAR AS 158417.368 12126.431 37 13939 1453 4270.46
HAT-AUTO AS 58988.703 1980.696 27 14803 2949 2180.00
TEVO KAUP AS 83219.818 3790.228 34 11490 2448 5131.23
DECORA AS 213060.819 6180.553 20 9489 2477 1666.19
ÜHENDUS HUMANA ESTONIA 0 57388.467 3712.567 57 7463 393 461.68
MOKTER AS 147046.179 1012.274 4 10952 5446 354.76
FASHION GARDEN AS 14782.184 1337.441 22 9113 1056 453.35
ISOGREEN AS 10174.204 604.86 24 13185 1130 382.64
NITTIS OÜ 78154.538 11740.032 32 5082 1166 625.38
SAAREMAA TARBIJATE ÜHISTU TUÜ 435485.363 3179.02 6 8163 1057 11470.71
RAKTOOM AS 80296.984 2741.862 18 7806 1255 2661.53
PT MIKRO AS 110773.357 2651.701 15 9941 1477 4232.18
KRK MÕIGU OÜ 13073.355 280.021 19 9733 1307 7.80
VARSTA TARVIKUTE OÜ 10352.132 1355.78 47 7172 2070 396.25
ESPAK PÄRNU AS 33066.808 1222.447 14 6988 1067 4731.64
LÄÄNE AGROVARU OÜ 3539.652 210.95 32 9166 885 5.80
PERFETTO STUUDIO OÜ 9158.899 89.528 7 6647 1308 87.50

Sheet 8: A.8.8


Vajadus Eesti Läti Soome
T 5 4 1
S 2 5 3
F 1 1 2
H 3 2 4
E 4 3 5
Vajadus Eesti Läti di di2 Spearmani korrelatsioonikordaja
T 5 4 1 1 0.4
töötajate vajaduste järjestus landeb kokku rohkem Eesti ja Läti väikeettevõttetes kui Eesti ja Soome omades S 2 5 -3 9
F 1 1 0 0
H 3 2 1 1
E 4 3 1 1
12
Vajadus Eesti Soome di di2 Spearmani korrelatsioonikordaja
T 5 1 4 16 0
S 2 3 -1 1
F 1 2 -1 1
H 3 4 -1 1
E 4 5 -1 1
20
5
kui tunnuste vahel on kasvav rangelt monotoonne seos, on Spearmani korrelatsioonikordaja väärtus 1
kui kahanev, siis -1

Sheet 9: A.8.9


Maakond Tunnitootlikkus müügitulu alusel, eurot Keskmine brutotunnipalk, eurot tunnitootlikuse astak tunnipalga astak astakute vahe di vahe ruut di2 Harju maakond 78.8 6.435 1 1 0 0 Hiiu maakond 49.5 4.980 #NAME? #NAME? #NAME? #NAME? Ida-Viru maakond 66.0 4.698 #NAME? #NAME? #NAME? #NAME? Jõgeva maakond 53.4 4.325 #NAME? #NAME? #NAME? #NAME? Järva maakond 53.4 4.503 #NAME? #NAME? #NAME? #NAME? Lääne maakond 41.2 4.943 #NAME? #NAME? #NAME? #NAME? Lääne-Viru maakond 57.0 4.933 #NAME? #NAME? #NAME? #NAME? Põlva maakond 46.8 4.478 #NAME? #NAME? #NAME? #NAME? Pärnu maakond 47.9 4.748 #NAME? #NAME? #NAME? #NAME? Rapla maakond 49.9 4.483 #NAME? #NAME? #NAME? #NAME? Saare maakond 48.7 4.578 #NAME? #NAME? #NAME? #NAME? Tartu maakond 62.6 5.483 #NAME? #NAME? #NAME? #NAME? Valga maakond 49.0 4.420 #NAME? #NAME? #NAME? #NAME? Viljandi maakond 58.2 4.503 #NAME? #NAME? #NAME? #NAME? Võru maakond 46.7 4.553 #NAME? #NAME? #NAME? #NAME?
413.5
lineaarne korrelatsioonikordaja r 0.712 seos on oluline, kuna vastav kriitiline korrelatsioonikordaja nivool 5% on 0,514
Spearmani korrelatsioonikordaja rs 0.262 224 3360
2481
valimi maht n 15
vabadusastmete arv v 13
olulisuse nivoo
0.05
parameetri kriitilised väärtused
-1.770933396 1.770933396 see peab tulema 0,514
hajumisdiagrammilt selgub , et on üks erind : Harjumaa
Vasakule Paremale
Statistika ÜL 08 Korrelatsioon #1 Statistika ÜL 08 Korrelatsioon #2 Statistika ÜL 08 Korrelatsioon #3 Statistika ÜL 08 Korrelatsioon #4 Statistika ÜL 08 Korrelatsioon #5 Statistika ÜL 08 Korrelatsioon #6 Statistika ÜL 08 Korrelatsioon #7 Statistika ÜL 08 Korrelatsioon #8 Statistika ÜL 08 Korrelatsioon #9 Statistika ÜL 08 Korrelatsioon #10 Statistika ÜL 08 Korrelatsioon #11 Statistika ÜL 08 Korrelatsioon #12 Statistika ÜL 08 Korrelatsioon #13 Statistika ÜL 08 Korrelatsioon #14 Statistika ÜL 08 Korrelatsioon #15 Statistika ÜL 08 Korrelatsioon #16 Statistika ÜL 08 Korrelatsioon #17 Statistika ÜL 08 Korrelatsioon #18 Statistika ÜL 08 Korrelatsioon #19 Statistika ÜL 08 Korrelatsioon #20 Statistika ÜL 08 Korrelatsioon #21 Statistika ÜL 08 Korrelatsioon #22 Statistika ÜL 08 Korrelatsioon #23 Statistika ÜL 08 Korrelatsioon #24 Statistika ÜL 08 Korrelatsioon #25 Statistika ÜL 08 Korrelatsioon #26 Statistika ÜL 08 Korrelatsioon #27 Statistika ÜL 08 Korrelatsioon #28 Statistika ÜL 08 Korrelatsioon #29 Statistika ÜL 08 Korrelatsioon #30 Statistika ÜL 08 Korrelatsioon #31 Statistika ÜL 08 Korrelatsioon #32 Statistika ÜL 08 Korrelatsioon #33 Statistika ÜL 08 Korrelatsioon #34 Statistika ÜL 08 Korrelatsioon #35 Statistika ÜL 08 Korrelatsioon #36 Statistika ÜL 08 Korrelatsioon #37 Statistika ÜL 08 Korrelatsioon #38 Statistika ÜL 08 Korrelatsioon #39 Statistika ÜL 08 Korrelatsioon #40 Statistika ÜL 08 Korrelatsioon #41 Statistika ÜL 08 Korrelatsioon #42 Statistika ÜL 08 Korrelatsioon #43 Statistika ÜL 08 Korrelatsioon #44 Statistika ÜL 08 Korrelatsioon #45 Statistika ÜL 08 Korrelatsioon #46 Statistika ÜL 08 Korrelatsioon #47 Statistika ÜL 08 Korrelatsioon #48 Statistika ÜL 08 Korrelatsioon #49 Statistika ÜL 08 Korrelatsioon #50 Statistika ÜL 08 Korrelatsioon #51 Statistika ÜL 08 Korrelatsioon #52 Statistika ÜL 08 Korrelatsioon #53 Statistika ÜL 08 Korrelatsioon #54 Statistika ÜL 08 Korrelatsioon #55 Statistika ÜL 08 Korrelatsioon #56 Statistika ÜL 08 Korrelatsioon #57 Statistika ÜL 08 Korrelatsioon #58 Statistika ÜL 08 Korrelatsioon #59 Statistika ÜL 08 Korrelatsioon #60 Statistika ÜL 08 Korrelatsioon #61 Statistika ÜL 08 Korrelatsioon #62 Statistika ÜL 08 Korrelatsioon #63 Statistika ÜL 08 Korrelatsioon #64
Punktid 50 punkti Autor soovib selle materjali allalaadimise eest saada 50 punkti.
Leheküljed ~ 64 lehte Lehekülgede arv dokumendis
Aeg2016-09-28 Kuupäev, millal dokument üles laeti
Allalaadimisi 17 laadimist Kokku alla laetud
Kommentaarid 0 arvamust Teiste kasutajate poolt lisatud kommentaarid
Autor Getu15 Õppematerjali autor

Sarnased õppematerjalid

Praktikumi lahendused Rahanduse alused
50
xls

Praktikumi lahendused Rahanduse alused

Juku vanus 18 Pensioniiga 65 Marlboro hind 3.8 deposiidi intressimäär 3% Aktsiaturu tootlus 12% Deposiidil iga aasta lõpus 1,407.96 € Aktsiaportfelli väärtus 65ndaks eluaastaks 2,401,809.07 € inflatsioon 2% maksumäär 20% Aktsiaportfelli soetusmaksumus 66,173.93 € Maksude-järgne nominaalrikkus 1,934,682.04 € Maksudejärgne reaalrikkus 762,783.92 € YTM 29.24% Kuupäev laekuv rahavood Ostukuupäev 2/1/2012 2/1/2012 0 Nimiväärtus 1,000.00 € 9/5/2012 60.00 € Lunastusku

Rahanduse alused
IK-Portfellihaldur
251
xlsx

IK-Portfellihaldur

PORTFELLIHALDUR PORTFELL JAOTUS VARAKLASS SOETUS HIND 1% Väärtpaberid 600.0 € 0% ETF'id 80.0 € 13% Iduettevõtted 6,033.0 € 1% Laenud 1,000.0 € 1% Ühisrahastus 1,000.0 € 0% Kinnisvara ühisrahastus 300.0 € 83% Kinnisvara 30,800.0 € 0% Raha ja muu 300.0 € 100% 40,113.00 € Kopeeri all oleva rea väärtused (copy+paste values) igal kuul all olev 8/6/2021 € 40,113.0 SINU PORTFELLI AJALOOLINE VAADE kommentaar Kuupäev Ostuhind

Maksundus
Statistika töö-binoomjaotus-intervallid
136
xlsx

Statistika töö: binoomjaotus, intervallid

Kehakaal Sugu Tähtkuju Pikkus (cm) (kg) Jalanumber (binaarne) (järjestustunnus) (pidev) (pidev) (diskreetne) naine Neitsi 172 63 39 mees Vähk 182 64 41 naine Sõnn 155 62 38 naine Kalad 171 55 38 naine Kaksikud 170 58 38 naine Neitsi 179 58 41 naine Veevalaja 173 55 38 naine Jäär 173 55 38 naine Kaljukits 170 58 40 naine Neitsi 173 65 41 naine Kaksikud 170 64 40 mees Kaalud 178

Statistika
Statistika ülesanded
52
xlsx

Statistika ülesanded

9 11 12 15 k 17 t0,95(24) 27 X2+ 33 X2- 33 34 38 39 41 44 46 48 52 56 59 66 83 88 97 98 98 99 1 4 N 25 24 xx 49.72 1.710882 σ 868.7933 13.84843 s 29.4753 7 36.41503 M 44 Haare 90 8 2 Δμ 10.08575 Alumine piir 39.63425 9 Ülemine piir 59.80575 σ al piir 572.5944 σ ül piir 1505.661 3 10 t-statistik 0.047497 X -statistik 2 26.0638 N(μ,σ) X2-statistik U(0,100) X2-statistik DN-statistik 0.13 F-statistik 0.142 Seerijate ar

Statistika
Ülesanne 5-Andmetabeli toomine varundusfailist-erinevad päringud
12
docx

Ülesanne 5-Andmetabeli toomine varundusfailist-erinevad päringud

1. Kopeeri fail ABSynnid.sql oma peakausta ikt.khk.ee serveris. 2. Tee aktiivseks oma andmebaas AB ja anna käsk source ABSynnid.sql . Mis toimus? 3. Millised tabelid tekkisid juurde? Kirjelda tekkinud tabeli välju ja andmetüüpe (kasuta sobivat käsku). Missugune väli on primaarvõtme väli, võõrvõtmeväli? Uuri lisaks ER-mudelit. mis on lisatud ülesande juhendile. mysql> SHOW TABLES; +-----------------------+ | Tables_in_eensaara_AB | +-----------------------+ | EMAD | | LAENUTUS | | LUGEJA | | RAAMAT | | SYNNID | +-----------------------+ 5 rows in set (0.00 sec) mysql> DESCRIBE EMAD; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Ema_id | int(2) | NO | PRI | 0 | | | Ema_nimi | varchar(20) | YES | | NULL | | | Va

Andmebaasid
ANDMETÖÖTLUS EXCELIS
36
xlsx

ANDMETÖÖTLUS EXCELIS

Tellimuse Toote Kuupäev Tellija Toode Kogus summa ühiku hind 2/22/2013 MegaMart Leib 58 42.98 € 0.78 € 3/17/2013 FoodMart Leib 101 74.84 € 0.78 € 4/10/2013 SuperMart Leib 127 90.14 € 0.78 € 3/28/2013 SuperMart Pasta 56 119.78 € 2.30 € 4/25/2013 FoodMart Küpsised 66 128.04 € 2.00 € 3/31/2013 SuperMart Piim 122 133.22 € 1.20 € 4/11/2013 SuperMart Piim 144 157.25 € 1.20 € 2/4/2013 MiniMart Piim 147 167.58 € 1.20 € 3/29/2013 MiniMart Leib 228 168.24 € 0.78 € 1/3/2013 FoodMart Pasta 77 171.79 € 2.30 € 3/6/2013 SuperMart Küpsised 112 201.60 ?

Sissejuhatus infotöötlusesse
Ülesanne 8-Alampäringud
5
docx

Ülesanne 8-Alampäringud

1*. Leia vanima raamatu väljaandmisaasta (väljasta aastaarv). mysql> SELECT MIN(aasta) AS 'vanima raamatu valjastamisaasta' FROM RAAMAT; +---------------------------------+ | vanima raamatu valjastamisaasta | +---------------------------------+ | 1920 | +---------------------------------+ 1 row in set (0.00 sec) 2. Leia vanima raamatu pealkiri, väljaandmise aasta ja autor. mysql> SELECT pealkiri, autor, aasta FROM RAAMAT WHERE aasta=(SELECT MIN(aasta) 'vanima raamatu valjastamisaasta' FROM RAAMAT); +---------------+---------------+-------+ | pealkiri | autor | aasta | +---------------+---------------+-------+ | Tde ja igus | A.H.Tammsaare | 1920 | +---------------+---------------+-------+ 1 row in set (0.00 sec) 3*. Leia kõige uuema raamatu väljaandmisaasta (väljasta aastaarv). mysql> SELECT MAX(aasta) AS 'koige uuema raamatu valjastamisaasta' FROM RAAMAT; +--------------------------------------+ | koige uuema raam

Andmebaasid
Töötasu mediaanvahemikud
60
xlsx

Töötasu mediaanvahemikud

STATISTIKA Kodutöö 1. Arvkarakteristikud (max 10 punkti) Arvutused tehke KIRJALIKULT (vt. loengu slaidid), Excel'i statistika funktsioonid k Ül. 1. Viimase nädala jooksul kahekümne inimese krediitkaardi kasutamiste arv oli vasta (4 punkti) Jnr 1 2 3 4 Kaardi kasutamistearv 8 2 6 1 a) Määrake tunnuse krediitkaardi kasutamise arv tüüp ning koostage jaotustab b) Moodustage tunnuse variatsioonirida, leidke keskväärtus, mediaan, mood,

Statistika




Meedia

Kommentaarid (0)

Kommentaarid sellele materjalile puuduvad. Ole esimene ja kommenteeri



Sellel veebilehel kasutatakse küpsiseid. Kasutamist jätkates nõustute küpsiste ja veebilehe üldtingimustega Nõustun