| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date2 | Week | Oil | UAH.USD | Реальна | Oil.UAH | Ratio | "Справедлива" | Diff | UAH.USD.black | Oil.UAH.black | Ratio | "Справедлива"(чорний USD) | ||||||||||||
2 | 1/6/2014 | 1 | 92.72 | 7.99 | 10.99 | 4.659911939 | 7.99 | 4.659911939 | 1.375469337 | Джерела даних | |||||||||||||||
3 | 1/13/2014 | 2 | 94.37 | 7.99 | 10.69 | 4.742837464 | 2.294034767 | 10.72064765 | -0.03064765379 | 7.99 | 4.742837464 | 1.337922403 | Crude oil | http://www.investing.com/ | |||||||||||
4 | 1/20/2014 | 3 | 96.64 | 7.99 | 10.89 | 4.856922883 | 2.296093864 | 10.86410881 | 0.02589118757 | 7.99 | 4.856922883 | 1.362953692 | UAH/USD | http://www.bank.gov.ua/ | |||||||||||
5 | 1/28/2014 | 4 | 97.49 | 7.99 | 10.83 | 4.899642093 | 2.229806867 | 11.06147659 | -0.2314765883 | 7.99 | 4.899642093 | 1.355444305 | 1.355444305 | Fuel | http://finance.i.ua/ | ||||||||||
6 | 2/3/2014 | 5 | 99.88 | 7.99 | 10.85 | 5.01975846 | 2.214447462 | 11.13538082 | -0.2853808215 | 7.99 | 5.01975846 | 1.357947434 | 1.357947434 | ||||||||||||
7 | 2/11/2014 | 6 | 100.3 | 8.53 | 11.19 | 5.381551139 | 2.229190924 | 11.34318214 | -0.1531821361 | 8.53 | 5.381551139 | 1.311840563 | 1.311840563 | ||||||||||||
8 | 2/18/2014 | 7 | 102.2 | 8.64 | 11.34 | 5.554208076 | 2.107199153 | 11.96908347 | -0.6290834696 | 8.64 | 5.554208076 | 1.3125 | 1.3125 | Автокореляція, ціна на бензин від ціни на нафту | |||||||||||
9 | 2/26/2014 | 8 | 102.59 | 8.94 | 11.61 | 5.768993584 | 2.090306996 | 12.26777997 | -0.6577799723 | 8.94 | 5.768993584 | 1.298657718 | 1.298657718 | ||||||||||||
10 | 3/4/2014 | 9 | 102.58 | 9.7 | 12.56 | 6.258812429 | 2.177156174 | 12.6393589 | -0.07935890049 | 9.7 | 6.258812429 | 1.294845361 | 1.294845361 | lag | acf | ||||||||||
11 | 3/11/2014 | 10 | 98.89 | 9.24 | 12.54 | 5.747538055 | 2.003574982 | 13.4867455 | -0.9467455026 | 9.24 | 5.747538055 | 1.357142857 | 1.357142857 | -13 | 0.1245864049 | ||||||||||
12 | 3/18/2014 | 11 | 99.46 | 9.6 | 12.43 | 6.005887533 | 2.162665106 | 12.60224084 | -0.1722408353 | 9.6 | 6.005887533 | 1.294791667 | 1.294791667 | -12 | 0.1747008413 | ||||||||||
13 | 3/24/2014 | 12 | 101.67 | 10.2 | 12.65 | 6.523046924 | 2.106266548 | 13.04918543 | -0.3991854321 | 10.2 | 6.523046924 | 1.240196078 | 1.240196078 | -11 | 0.2420617042 | ||||||||||
14 | 4/1/2014 | 13 | 101.14 | 10.95 | 13.34 | 6.966178136 | 2.045056575 | 13.94387118 | -0.6038711788 | 10.95 | 6.966178136 | 1.21826484 | 1.21826484 | -10 | 0.3126899401 | ||||||||||
15 | 4/7/2014 | 14 | 103.74 | 11.65 | 13.7 | 7.602031702 | 1.966645086 | 14.71048817 | -1.010488175 | 11.65 | 7.602031702 | 1.175965665 | 1.175965665 | -9 | 0.3833672464 | ||||||||||
16 | 4/15/2014 | 15 | 104.3 | 12.98 | 15.16 | 8.515624607 | 1.994203733 | 15.81051484 | -0.6505148446 | 12.98 | 8.515624607 | 1.167950693 | 1.167950693 | -8 | 0.441427434 | ||||||||||
17 | 4/25/2014 | 16 | 100.6 | 11.25 | 15.4 | 7.118819977 | 1.80844045 | 17.39103057 | -1.99103057 | 11.25 | 7.118819977 | 1.368888889 | 1.368888889 | -7 | 0.5163404916 | ||||||||||
18 | 4/29/2014 | 17 | 99.76 | 11.36 | 15.39 | 7.128403573 | 2.161875149 | 14.97455856 | 0.4154414392 | 11.36 | 7.128403573 | 1.354753521 | 1.354753521 | -6 | 0.5861515984 | ||||||||||
19 | 5/5/2014 | 18 | 99.99 | 11.4 | 15.38 | 7.169996226 | 2.157565834 | 14.99113818 | 0.3888618191 | 11.4 | 7.169996226 | 1.349122807 | 1.349122807 | -5 | 0.6561863687 | ||||||||||
20 | 5/13/2014 | 19 | 102.02 | 11.61 | 15.37 | 7.450322053 | 2.143655243 | 15.06309347 | 0.3069065291 | 11.61 | 7.450322053 | 1.323858742 | 1.323858742 | -4 | 0.7313260612 | ||||||||||
21 | 5/19/2014 | 20 | 104.35 | 11.75 | 15.37 | 7.71236948 | 2.062998068 | 15.54805715 | -0.1780571518 | 11.75 | 7.71236948 | 1.308085106 | 1.308085106 | -3 | 0.7927661292 | ||||||||||
22 | 5/26/2014 | 21 | 102.71 | 11.66 | 15.37 | 7.533014216 | 1.992902446 | 16.0013992 | -0.6313992012 | 11.66 | 7.533014216 | 1.318181818 | 1.318181818 | -2 | 0.8349832551 | ||||||||||
23 | 6/3/2014 | 22 | 102.66 | 11.88 | 15.36 | 7.67141024 | 2.039024428 | 15.69111459 | -0.331114593 | 11.88 | 7.67141024 | 1.292929293 | 1.292929293 | -1 | 0.8643215004 | ||||||||||
24 | 6/10/2014 | 23 | 106.91 | 11.8 | 15.36 | 7.935199396 | 2.002239421 | 15.93053972 | -0.5705397157 | 11.8 | 7.935199396 | 1.301694915 | 1.301694915 | 0 | 0.8530095151 | ||||||||||
25 | 6/16/2014 | 24 | 107.26 | 11.75 | 15.35 | 7.927443704 | 1.934418939 | 16.38689496 | -1.036894955 | 11.75 | 7.927443704 | 1.306382979 | 1.306382979 | 1 | 0.7311986993 | ||||||||||
26 | 6/24/2014 | 25 | 105.74 | 11.88 | 15.36 | 7.901567493 | 1.937572889 | 16.37347761 | -1.013477607 | 11.88 | 7.901567493 | 1.292929293 | 1.292929293 | 2 | 0.6308706293 | ||||||||||
27 | 7/1/2014 | 26 | 104.06 | 11.79 | 15.41 | 7.717117876 | 1.95024595 | 16.32871176 | -0.9187117625 | 11.79 | 7.717117876 | 1.307039864 | 1.307039864 | 3 | 0.5350587563 | ||||||||||
28 | 7/7/2014 | 27 | 100.83 | 11.78 | 15.42 | 7.471237892 | 1.998155302 | 16.00961393 | -0.5896139263 | 11.78 | 7.471237892 | 1.308998302 | 1.308998302 | 4 | 0.4410567237 | ||||||||||
29 | 7/15/2014 | 28 | 103.13 | 11.7 | 15.43 | 7.589766008 | 2.065253473 | 15.58424155 | -0.1542415524 | 11.7 | 7.589766008 | 1.318803419 | 1.318803419 | 5 | 0.3482822222 | ||||||||||
30 | 7/21/2014 | 29 | 102.09 | 11.66 | 15.43 | 7.487541829 | 2.033000752 | 15.78929519 | -0.3592951944 | 11.66 | 7.487541829 | 1.323327616 | 1.323327616 | 6 | 0.2533667538 | ||||||||||
31 | 7/29/2014 | 30 | 97.88 | 11.86 | 15.54 | 7.301904642 | 2.075447504 | 15.61244736 | -0.07244736445 | 11.86 | 7.301904642 | 1.310286678 | 1.310286678 | 7 | 0.1547875924 | ||||||||||
32 | 8/6/2014 | 31 | 96.84 | 12.18 | 15.54 | 7.419242672 | 2.128211852 | 15.29129503 | 0.2487049692 | 12.18 | 7.419242672 | 1.275862069 | 1.275862069 | 8 | 0.076558872 | ||||||||||
33 | 8/12/2014 | 32 | 95.32 | 12.83 | 15.75 | 7.692512266 | 2.122858181 | 15.49428982 | 0.2557101774 | 12.83 | 7.692512266 | 1.227591582 | 1.227591582 | 9 | 0.0144914294 | ||||||||||
34 | 8/18/2014 | 33 | 93.65 | 13.07 | 16.44 | 7.699116241 | 2.137143164 | 15.96704622 | 0.4729537803 | 13.07 | 7.699116241 | 1.257842387 | 1.257842387 | 10 | -0.0701534825 | ||||||||||
35 | 8/27/2014 | 34 | 95.96 | 13.66 | 16.63 | 8.245147817 | 2.15998817 | 15.9784711 | 0.651528903 | 13.66 | 8.245147817 | 1.217423133 | 1.217423133 | 11 | -0.1427820329 | ||||||||||
36 | 9/2/2014 | 35 | 92.71 | 13.11 | 17.11 | 7.645163543 | 2.075159885 | 16.92310572 | 0.186894276 | 14 | 8.164171594 | 2.075159885 | 16.92310572 | 1.305110603 | 1.305110603 | 12 | -0.196120489 | ||||||||
37 | 9/9/2014 | 36 | 91.37 | 12.82 | 16.94 | 7.3679922 | 2.215779938 | 15.88513293 | 1.054867071 | 14.2 | 8.161114606 | 2.074919642 | 16.78301686 | 1.321372855 | 1.321372855 | 13 | -0.2282567736 | ||||||||
38 | 9/15/2014 | 37 | 91.65 | 12.9 | 16.8 | 7.43669015 | 2.280132707 | 15.40562651 | 1.394373494 | 14.5 | 8.359070323 | 2.058542345 | 16.77772827 | 1.302325581 | 1.302325581 | ||||||||||
39 | 9/22/2014 | 38 | 93.54 | 13.49 | 16.99 | 7.937190842 | 2.284618514 | 15.52447396 | 1.465526041 | 14.5 | 8.531450497 | 2.032522678 | 17.12019166 | 1.259451446 | 1.259451446 | ||||||||||
40 | 9/29/2014 | 39 | 89.74 | 12.91 | 17.01 | 7.287353126 | 2.143075597 | 16.39034016 | 0.619659844 | 14.5 | 8.184866021 | 1.993799297 | 17.41840936 | 1.317583269 | 1.317583269 | ||||||||||
41 | 10/7/2014 | 40 | 85.11 | 12.95 | 16.91 | 6.932787143 | 2.320458431 | 15.26612091 | 1.643879092 | 14.5 | 7.762580199 | 2.066008162 | 16.81881822 | 1.305791506 | 1.305791506 | ||||||||||
42 | 10/13/2014 | 41 | 82.06 | 12.95 | 16.78 | 6.684343943 | 2.420382979 | 14.65272176 | 2.127278243 | 14.5 | 7.484400554 | 2.161652385 | 16.08826374 | 1.295752896 | 1.295752896 | ||||||||||
43 | 10/21/2014 | 42 | 82.24 | 12.95 | 16.26 | 6.699006164 | 2.432549872 | 14.22291502 | 2.037084979 | 14.5 | 7.500817713 | 2.172518679 | 15.60701296 | 1.255598456 | 1.255598456 | ||||||||||
44 | 10/28/2014 | 43 | 81.85 | 12.95 | 15.89 | 6.667238017 | 2.371993638 | 14.24828066 | 1.641719336 | 14.5 | 7.465247201 | 2.118435697 | 15.63541464 | 1.227027027 | 1.227027027 | ||||||||||
45 | 11/4/2014 | 44 | 77.19 | 13.01 | 15.8 | 6.316781356 | 2.369796902 | 14.19332177 | 1.60667823 | 16 | 7.768524343 | 2.116473785 | 15.57387766 | 1.214450423 | 1.214450423 | ||||||||||
46 | 11/11/2014 | 45 | 77.87 | 15.32 | 16.27 | 7.503889797 | 2.575678828 | 13.58703175 | 2.682968254 | 17 | 8.326770663 | 2.094348847 | 16.09854711 | 1.062010444 | 1.062010444 | ||||||||||
47 | 11/18/2014 | 46 | 74.64 | 15.99 | 17.36 | 7.507193358 | 2.313466811 | 15.64072935 | 1.71927065 | 19 | 8.920367342 | 2.084841856 | 17.06431325 | 1.085678549 | 1.085678549 | ||||||||||
48 | 11/25/2014 | 47 | 74.09 | 15.71 | 17.31 | 7.321385709 | 2.305788485 | 15.64644451 | 1.663555491 | 19.17 | 8.933861492 | 1.940503046 | 18.0912355 | 1.101845958 | 1.101845958 | ||||||||||
49 | 12/2/2014 | 48 | 66.88 | 15.74 | 16.85 | 6.621532268 | 2.301476888 | 15.32499728 | 1.525002724 | 19 | 7.992955089 | 1.88608252 | 18.11458038 | 1.070520966 | 1.070520966 | ||||||||||
50 | 12/9/2014 | 49 | 63.98 | 16.13 | 16.82 | 6.49136621 | 2.540197543 | 14.11425082 | 2.705749176 | 19 | 7.646370613 | 2.104353123 | 16.4868123 | 1.042777433 | 1.042777433 | ||||||||||
51 | 12/16/2014 | 50 | 56.26 | 16.46 | 16.95 | 5.824881117 | 2.611160648 | 13.88906354 | 3.060936457 | 20 | 7.077619826 | 2.216737961 | 15.88722116 | 1.029769137 | 1.029769137 | ||||||||||
52 | 12/23/2014 | 51 | 57.12 | 16.52 | 17.55 | 5.935478677 | 3.012937028 | 12.73604433 | 4.813955667 | 19.5 | 7.006164297 | 2.479647174 | 14.9032823 | 1.062348668 | 1.062348668 | ||||||||||
53 | 12/30/2014 | 52 | 54.12 | 16.51 | 17.07 | 5.620337149 | 2.87592643 | 12.92737811 | 4.14262189 | 19.5 | 6.638193483 | 2.436425878 | 14.77966423 | 1.033918837 | 1.033918837 | ||||||||||
54 | 1/6/2015 | 53 | 47.93 | 16.5 | 17.07 | 4.974493647 | 3.037184344 | 12.38218327 | 4.687816732 | 19.5 | 5.878947037 | 2.571482745 | 14.14307473 | 1.034545455 | 1.034545455 | ||||||||||
55 | 1/13/2015 | 54 | 45.98 | 16.49 | 17.04 | 4.769217512 | 3.425474271 | 11.26487401 | 5.775125991 | 19.3 | 5.581922254 | 2.898478229 | 12.82957837 | 1.033353548 | 1.033353548 | ||||||||||
56 | 1/19/2015 | 45.59 | 15.807737 | 17.09 | 4.533115674 | 10.9097463 | 19.3 | 5.534576676 | 12.3157255 | ||||||||||||||||
57 | 1/26/2015 | 48.24 | 15.810005 | 17.14 | 4.79729929 | 10.50129012 | 19.3 | 5.856283809 | 12.23381765 | ||||||||||||||||
58 | 2/2/2015 | 51.69 | 16.146996 | 17.1367 | 5.249957374 | 10.95832777 | 19.3 | 6.275110077 | 12.79037099 | ||||||||||||||||
59 | 2/9/2015 | 52.78 | 24.956198 | 17.85 | 8.285244247 | 11.74142626 | 24.956198 | 8.285244247 | 13.51494043 | ||||||||||||||||
60 | 2/16/2015 | 50.34 | 26.049893 | 20.7533 | 8.248531976 | 16.99247255 | 26.049893 | 8.248531976 | 16.99247255 | ||||||||||||||||
61 | 2/23/2015 | 49.76 | 28.348066 | 21.4766 | 8.872812707 | 16.92896032 | 28.348066 | 8.872812707 | 16.92896032 | ||||||||||||||||
62 | 3/2/2015 | 49.61 | 26.858114 | 24.6467 | 8.381123635 | 18.00896598 | 26.858114 | 8.381123635 | 18.00896598 | ||||||||||||||||
63 | 3/10/2015 | 44.84 | 21.73571 | 22.6733 | 6.130514759 | 17.15834389 | 21.73571 | 6.130514759 | 17.15834389 | ||||||||||||||||
64 | 3/16/2015 | 45.72 | 21.770381 | 20.8567 | 6.260798964 | 13.26479053 | 21.770381 | 6.260798964 | 13.26479053 | ||||||||||||||||
65 | 3/23/2015 | 48.87 | 23.149873 | 20.5733 | 7.116205142 | 13.49018221 | 23.149873 | 7.116205142 | 13.49018221 | ||||||||||||||||
66 | 3/30/2015 | 49.14 | 23.442625 | 20.5533 | 7.246009514 | 14.9700349 | 23.442625 | 7.246009514 | 14.9700349 | ||||||||||||||||
67 | 4/6/2015 | 51.64 | 23.304799 | 20.53 | 7.569881874 | 15.19459646 | 23.304799 | 7.569881874 | 15.19459646 | ||||||||||||||||
68 | 4/14/2015 | 55.74 | 22.882033 | 20.52 | 8.022672785 | 15.75489564 | 22.882033 | 8.022672785 | 15.75489564 | ||||||||||||||||
69 | 4/20/2015 | 57.15 | 21.057654 | 20.52 | 7.569788188 | 16.53822392 | 21.057654 | 7.569788188 | 16.53822392 | ||||||||||||||||
70 | 4/27/2015 | 59.15 | 22.45163 | 20.52 | 8.353339505 | 15.75473356 | 22.45163 | 8.353339505 | 15.75473356 | ||||||||||||||||
71 | 5/5/2015 | 59.39 | 21.132395 | 20.52 | 7.894407718 | 17.11027734 | 21.132395 | 7.894407718 | 17.11027734 | ||||||||||||||||
72 | 5/12/2015 | 59.69 | 20.589862 | 20.76 | 7.73058789 | 16.31632535 | 20.589862 | 7.73058789 | 16.31632535 | ||||||||||||||||
73 | 5/18/2015 | 59.72 | 20.698242 | 20.78 | 7.775185635 | 16.03291705 | 20.698242 | 7.775185635 | 16.03291705 | ||||||||||||||||
74 | 5/25/2015 | 60.3 | 20.836853 | 20.78 | 7.903272336 | 16.11007115 | 20.836853 | 7.903272336 | 16.11007115 | ||||||||||||||||
75 | 6/2/2015 | 59.13 | 21.084888 | 20.75 | 7.842177805 | 16.33166114 | 21.084888 | 7.842177805 | 16.33166114 | ||||||||||||||||
76 | 6/8/2015 | 59.96 | 21.025806 | 20.76 | 7.929974385 | 16.2259676 | 21.025806 | 7.929974385 | 16.2259676 | ||||||||||||||||
77 | 6/15/2015 | 59.61 | 21.058829 | 20.75 | 7.896067409 | 16.37785569 | 21.058829 | 7.896067409 | 16.37785569 | ||||||||||||||||
78 | 6/22/2015 | 59.63 | 21.635428 | 20.76 | 8.114986612 | 16.31919662 | 21.635428 | 8.114986612 | 16.31919662 | ||||||||||||||||
79 | 6/30/2015 | 56.93 | 21.015358 | 20.79 | 7.525502145 | 16.69792684 | 21.015358 | 7.525502145 | 16.69792684 | ||||||||||||||||
80 | 7/6/2015 | 52.74 | 21.018248 | 20.83 | 6.97259026 | 15.67811871 | 21.018248 | 6.97259026 | 15.67811871 | ||||||||||||||||
81 | 7/13/2015 | 50.89 | 21.916483 | 20.83 | 7.015535412 | 14.72158115 | 21.916483 | 7.015535412 | 14.72158115 | ||||||||||||||||
82 | 7/20/2015 | 48.14 | 22.014924 | 20.84 | 6.666237523 | 14.79587626 | 22.014924 | 6.666237523 | 14.79587626 | ||||||||||||||||
83 | 7/27/2015 | 47.12 | 22.07352 | 20.84 | 6.54235918 | 14.19159091 | 22.07352 | 6.54235918 | 14.19159091 | ||||||||||||||||
84 | 8/3/2015 | 43.87 | 21.126666 | 20.77 | 5.829832919 | 13.97728138 | 21.126666 | 5.829832919 | 13.97728138 | ||||||||||||||||
85 | 8/10/2015 | 42.5 | 21.089882 | 20.77 | 5.637941785 | 12.74461095 | 21.089882 | 5.637941785 | 12.74461095 | ||||||||||||||||
86 | 8/17/2015 | 40.45 | 21.757665 | 20.77 | 5.535901052 | 12.41263929 | 21.757665 | 5.535901052 | 12.41263929 | ||||||||||||||||
87 | 8/25/2015 | 45.22 | 22.095544 | 20.7 | 6.284818843 | 12.23610882 | 22.095544 | 6.284818843 | 12.23610882 | ||||||||||||||||
88 | 8/31/2015 | 46.05 | 21.185441 | 20.19 | 6.136555278 | 13.5317366 | 21.185441 | 6.136555278 | 13.5317366 | ||||||||||||||||
89 | 9/7/2015 | 44.63 | 21.942791 | 19.94 | 6.159936862 | 13.27524063 | 21.942791 | 6.159936862 | 13.27524063 | ||||||||||||||||
90 | 9/14/2015 | 44.68 | 21.698655 | 19.96 | 6.098225597 | 13.31569077 | 21.698655 | 6.098225597 | 13.31569077 | ||||||||||||||||
91 | 9/21/2015 | 45.7 | 21.639391 | 19.9 | 6.220406144 | 13.20893028 | 21.639391 | 6.220406144 | 13.20893028 | ||||||||||||||||
92 | 9/28/2015 | 45.54 | 21.615991 | 19.93 | 6.19192496 | 13.42030263 | 21.615991 | 6.19192496 | 13.42030263 | ||||||||||||||||
93 | 10/5/2015 | 49.63 | 21.147443 | 19.74 | 6.601758687 | 13.37103018 | 21.147443 | 6.601758687 | 13.37103018 | ||||||||||||||||
94 | 10/12/2015 | 47.26 | 21.496208 | 19.62 | 6.390179834 | 14.08004253 | 21.496208 | 6.390179834 | 14.08004253 | ||||||||||||||||
95 | 10/19/2015 | 44.6 | 21.297699 | 19.62 | 5.974823093 | 13.71401111 | 21.297699 | 5.974823093 | 13.71401111 | ||||||||||||||||
96 | 10/26/2015 | 46.59 | 22.574677 | 19.6 | 6.615638454 | 12.99544395 | 22.574677 | 6.615638454 | 12.99544395 | ||||||||||||||||
97 | 11/2/2015 | 44.29 | 22.993727 | 19.62 | 6.405787953 | 14.10405453 | 22.993727 | 6.405787953 | 14.10405453 | ||||||||||||||||
98 | 11/9/2015 | 40.74 | 22.648966 | 19.57 | 5.803993426 | 13.74101316 | 22.648966 | 5.803993426 | 13.74101316 | ||||||||||||||||
99 | 11/16/2015 | 40.39 | 23.059785 | 19.48 | 5.858502429 | 12.69990863 | 23.059785 | 5.858502429 | 12.69990863 | ||||||||||||||||
100 | 11/23/2015 | 41.71 | 23.984576 | 19.5 | 6.292594446 | 12.7942092 | 23.984576 | 6.292594446 | 12.7942092 |