Guggenheim Solar ETF and Crude Oil’s Correlation

explanation

 

Date  X Values  Y Values  X – Mx  Y – My  (X – Mx)2 (Y – My)2 (X – Mx)(Y – My)
Average 95.65 41.17
Sum (SSx)(SSy) 19475.178 2666.707 4357.370
12/3/2014 67.38 34.97 -28.266 -6.195 798.958 38.380 175.1111056
12/2/2014 66.88 34.53 -28.766 -6.635 827.473 44.025 190.8656489
12/1/2014 69.00 33.98 -26.646 -7.185 710.001 51.626 191.4543408
11/28/2014 66.15 35.73 -29.496 -5.435 870.004 29.541 160.3143043
11/26/2014 73.69 37.59 -21.956 -3.575 482.059 12.782 78.49541504
11/25/2014 74.09 37.64 -21.556 -3.525 464.654 12.427 75.98756311
11/24/2014 75.78 37.91 -19.866 -3.255 394.651 10.596 64.66628328
11/21/2014 76.51 37.89 -19.136 -3.275 366.180 10.727 62.67274036
11/20/2014 75.85 36.87 -19.796 -4.295 391.875 18.448 85.02609315
11/19/2014 74.50 36.47 -21.146 -4.695 447.146 22.044 99.28288071
11/18/2014 74.64 36.33 -21.006 -4.835 441.245 23.379 101.5663768
11/17/2014 75.66 34.61 -19.986 -6.555 399.434 42.970 131.0101631
11/14/2014 75.82 34.95 -19.826 -6.215 393.064 38.628 123.2205545
11/13/2014 74.16 34.24 -21.486 -6.925 461.641 47.958 148.7926481
11/12/2014 77.15 34.85 -18.496 -6.315 342.096 39.881 116.8039884
11/11/2014 77.87 35.64 -17.776 -5.525 315.980 30.527 98.21416912
11/10/2014 77.38 35.79 -18.266 -5.375 333.641 28.892 98.18161719
11/7/2014 78.65 36.27 -16.996 -4.895 288.858 23.962 83.1971747
11/6/2014 77.91 36.88 -17.736 -4.285 314.560 18.363 76.00072534
11/5/2014 78.68 36.77 -16.966 -4.395 287.840 19.317 74.56740174
11/4/2014 77.19 37.67 -18.456 -3.495 340.618 12.216 64.50592234
11/3/2014 78.78 38.16 -16.866 -3.005 284.456 9.031 50.68437341
10/31/2014 80.54 38.35 -15.106 -2.815 228.186 7.925 42.52520002
10/30/2014 81.12 37.29 -14.526 -3.875 211.000 15.017 56.28980002
10/29/2014 82.20 37.33 -13.446 -3.835 180.791 14.708 51.56680431
10/28/2014 81.42 37.81 -14.226 -3.355 202.374 11.257 47.72981976
10/27/2014 81.00 36.59 -14.646 -4.575 214.501 20.932 67.00690388
10/24/2014 81.01 37.44 -14.636 -3.725 214.208 13.877 54.52069101
10/23/2014 82.09 37.50 -13.556 -3.665 183.761 13.433 49.68417856
10/22/2014 80.52 37.06 -15.126 -4.105 228.791 16.852 62.09383264
10/21/2014 82.49 38.17 -13.156 -2.995 173.076 8.971 39.40370774
10/20/2014 81.91 37.14 -13.736 -4.025 188.673 16.202 55.28880689
10/17/2014 82.06 35.89 -13.586 -5.275 184.575 27.827 71.66733049
10/16/2014 81.95 35.31 -13.696 -5.855 187.576 34.283 80.19118242
10/15/2014 80.94 33.93 -14.706 -7.235 216.262 52.347 106.3989391
10/14/2014 81.20 33.84 -14.446 -7.325 208.682 53.658 105.8179253
10/13/2014 84.98 33.37 -10.666 -7.795 113.760 60.764 83.14180088
10/10/2014 85.82 34.96 -9.826 -6.205 96.547 38.504 60.97079401
10/9/2014 85.77 36.12 -9.876 -5.045 97.532 25.454 49.82508071
10/8/2014 87.31 38.31 -8.336 -2.855 69.486 8.152 23.80006654
10/7/2014 88.85 37.79 -6.796 -3.375 46.183 11.392 22.9369704
10/6/2014 90.34 38.25 -5.306 -2.915 28.152 8.498 15.46731161
10/3/2014 89.74 40.04 -5.906 -1.125 34.879 1.266 6.644953666
10/2/2014 91.01 39.36 -4.636 -1.805 21.491 3.259 8.368381993
10/1/2014 90.73 39.41 -4.916 -1.755 24.165 3.081 8.628032207
9/30/2014 91.16 40.65 -4.486 -0.515 20.123 0.265 2.310879847
9/29/2014 94.57 41.55 -1.076 0.385 1.157 0.148 -0.414035604
9/26/2014 93.54 42.20 -2.106 1.035 4.435 1.071 -2.179224874
9/25/2014 92.53 41.81 -3.116 0.645 9.708 0.416 -2.009246763
9/24/2014 92.80 43.08 -2.846 1.915 8.099 3.667 -5.449350196
9/23/2014 91.56 42.29 -4.086 1.125 16.694 1.265 -4.595952771
9/22/2014 90.87 42.29 -4.776 1.125 22.809 1.265 -5.372099123
9/19/2014 91.65 43.62 -3.996 2.455 15.967 6.026 -9.809179381
9/18/2014 91.98 44.38 -3.666 3.215 13.438 10.335 -11.785115
9/17/2014 93.20 43.97 -2.446 2.805 5.982 7.867 -6.860205132
9/16/2014 93.81 43.52 -1.836 2.355 3.370 5.545 -4.323120153
9/15/2014 91.99 43.54 -3.656 2.375 13.365 5.640 -8.682063501
9/12/2014 91.37 45.41 -4.276 4.245 18.283 18.019 -18.15028539
9/11/2014 91.86 45.27 -3.786 4.105 14.333 16.850 -15.54029183
9/10/2014 90.84 45.16 -4.806 3.995 23.096 15.959 -19.19859655
9/9/2014 91.89 44.36 -3.756 3.195 14.106 10.207 -11.99933475
9/8/2014 92.05 45.68 -3.596 4.515 12.930 20.384 -16.2346635
9/5/2014 93.29 45.36 -2.356 4.195 5.550 17.597 -9.882381956
9/4/2014 94.45 44.63 -1.196 3.465 1.430 12.005 -4.143395261
9/3/2014 95.54 43.88 -0.106 2.715 0.011 7.370 -0.287331312
9/2/2014 92.88 43.32 -2.766 2.155 7.650 4.643 -5.959963072
8/29/2014 95.96 43.39 0.314 2.225 0.099 4.950 0.698965684
8/28/2014 94.55 43.05 -1.096 1.885 1.201 3.553 -2.065487964
8/27/2014 93.88 43.74 -1.766 2.575 3.118 6.630 -4.546764788
8/26/2014 93.86 44.11 -1.786 2.945 3.189 8.672 -5.259021441
8/25/2014 93.35 44.14 -2.296 2.975 5.271 8.850 -6.829769939
8/22/2014 93.65 43.78 -1.996 2.615 3.983 6.837 -5.218813715
8/21/2014 93.96 43.67 -1.686 2.505 2.842 6.274 -4.222768222
8/20/2014 93.45 43.58 -2.196 2.415 4.822 5.831 -5.302616291
8/19/2014 92.86 43.53 -2.786 2.365 7.761 5.593 -6.588085818
8/18/2014 93.75 42.90 -1.896 1.735 3.594 3.010 -3.288992256
8/15/2014 95.32 42.24 -0.326 1.075 0.106 1.155 -0.350225733
8/14/2014 94.08 41.98 -1.566 0.815 2.452 0.664 -1.27592187
8/13/2014 96.74 41.74 1.094 0.575 1.197 0.330 0.628979418
8/12/2014 96.48 40.71 0.834 -0.455 0.696 0.207 -0.379669509
8/11/2014 97.21 41.41 1.564 0.245 2.447 0.060 0.382984997
8/8/2014 97.65 40.37 2.004 -0.795 4.017 0.632 -1.593610711
8/7/2014 97.34 40.50 1.694 -0.665 2.870 0.442 -1.126872943
8/6/2014 96.92 39.64 1.274 -1.525 1.623 2.326 -1.94329011
8/5/2014 97.38 39.50 1.734 -1.665 3.007 2.773 -2.887642042
8/4/2014 98.29 38.66 2.644 -2.505 6.992 6.276 -6.624025733
8/1/2014 97.88 38.61 2.234 -2.555 4.991 6.529 -5.708622299
7/31/2014 98.17 39.42 2.524 -1.745 6.371 3.046 -4.405043758
7/30/2014 100.27 40.58 4.624 -0.585 21.383 0.342 -2.705830024
7/29/2014 100.97 40.95 5.324 -0.215 28.347 0.046 -1.145494831
7/28/2014 101.67 41.33 6.024 0.165 36.291 0.027 0.993081993
7/25/2014 102.09 41.23 6.444 0.065 41.527 0.004 0.417902594
7/24/2014 102.07 41.39 6.424 0.225 41.270 0.051 1.444471692
7/23/2014 103.12 41.59 7.474 0.425 55.863 0.180 3.175396585
7/22/2014 102.39 42.51 6.744 1.345 45.484 1.809 9.069886285
7/21/2014 102.86 41.86 7.214 0.695 52.044 0.483 5.012759675
7/18/2014 101.95 41.74 6.304 0.575 39.742 0.330 3.6239468
7/17/2014 102.20 40.48 6.554 -0.685 42.957 0.469 -4.490586248
7/16/2014 100.60 41.98 4.954 0.815 24.544 0.664 4.036898731
7/15/2014 99.53 42.07 3.884 0.905 15.087 0.819 3.514584139
7/14/2014 100.48 42.37 4.834 1.205 23.369 1.452 5.824440362
7/11/2014 100.83 42.15 5.184 0.985 26.876 0.970 5.105621907
7/10/2014 102.93 41.80 7.284 0.635 53.059 0.403 4.624349375
7/9/2014 102.29 42.28 6.644 1.115 44.145 1.243 7.407243795
7/8/2014 103.40 41.63 7.754 0.465 60.127 0.216 3.604521048
7/7/2014 103.53 43.18 7.884 2.015 62.160 4.060 15.88540431
7/3/2014 104.06 44.70 8.414 3.535 70.798 12.495 29.74280259
7/2/2014 104.48 44.22 8.834 3.055 78.042 9.332 26.98704122
7/1/2014 105.34 44.37 9.694 3.205 93.977 10.271 31.0683365
6/30/2014 105.37 44.57 9.724 3.405 94.559 11.593 33.10931461
6/27/2014 105.74 44.41 10.094 3.245 101.892 10.529 32.75404294
6/26/2014 105.84 44.30 10.194 3.135 103.921 9.827 31.95716998
6/25/2014 106.50 43.75 10.854 2.585 117.813 6.681 28.05638113
6/24/2014 106.03 42.86 10.384 1.695 107.831 2.873 17.59959658
6/23/2014 106.17 44.26 10.524 3.095 110.758 9.578 32.57070388
6/20/2014 106.83 44.77 11.184 3.605 125.086 12.995 40.31722792
6/19/2014 106.05 44.10 10.404 2.935 108.247 8.613 30.53465581
6/18/2014 105.59 44.48 9.944 3.315 98.886 10.988 32.96340689
6/17/2014 105.87 44.28 10.224 3.115 104.534 9.702 31.84673221
6/16/2014 106.30 42.75 10.654 1.585 113.511 2.512 16.88524809
6/13/2014 106.17 42.00 10.524 0.835 110.758 0.697 8.786095297
6/12/2014 105.78 41.01 10.134 -0.155 102.701 0.024 -1.572317578
6/11/2014 103.62 40.43 7.974 -0.735 63.587 0.540 -5.862207707
6/10/2014 103.49 40.06 7.844 -1.105 61.531 1.221 -8.668978522
6/9/2014 103.59 40.13 7.944 -1.035 63.110 1.072 -8.223402128
6/6/2014 102.66 39.84 7.014 -1.325 49.198 1.756 -9.294819724
6/5/2014 102.48 40.24 6.834 -0.925 46.706 0.856 -6.322627449
6/4/2014 102.64 40.13 6.994 -1.035 48.918 1.072 -7.240009424
6/3/2014 102.66 39.93 7.014 -1.235 49.198 1.526 -8.663545046
6/2/2014 102.47 40.75 6.824 -0.415 46.569 0.172 -2.833052771
5/30/2014 102.71 40.79 7.064 -0.375 49.902 0.141 -2.650122299
5/29/2014 103.58 41.88 7.934 0.715 62.951 0.511 5.671734782
5/28/2014 102.72 40.72 7.074 -0.445 50.044 0.198 -3.149065218
5/27/2014 104.11 40.76 8.464 -0.405 71.642 0.164 -3.429257492
5/26/2014 104.28 40.48 8.634 -0.685 74.549 0.469 -5.915698694
5/23/2014 104.35 39.82 8.704 -1.345 75.762 1.809 -11.70840685
5/22/2014 103.74 38.85 8.094 -2.315 65.515 5.360 -18.73920342
5/21/2014 104.07 36.93 8.424 -4.235 70.967 17.936 -35.67759612
5/20/2014 102.33 37.69 6.684 -3.475 44.678 12.077 -23.2284708
5/19/2014 102.11 37.67 6.464 -3.495 41.785 12.216 -22.59322101
5/16/2014 102.02 38.17 6.374 -2.995 40.630 8.971 -19.09157595
5/15/2014 101.50 39.52 5.854 -1.645 34.271 2.707 -9.630977664
5/14/2014 102.37 39.81 6.724 -1.355 45.214 1.836 -9.112251055
5/13/2014 101.70 40.18 6.054 -0.985 36.653 0.971 -5.964260067
5/12/2014 100.59 38.20 4.944 -2.965 24.445 8.792 -14.66018625
5/9/2014 99.99 38.18 4.344 -2.985 18.872 8.911 -12.96797938
5/8/2014 100.26 38.96 4.614 -2.205 21.291 4.863 -10.17492273
5/7/2014 100.77 40.16 5.124 -1.005 26.257 1.010 -5.15055363
5/6/2014 99.50 40.80 3.854 -0.365 14.855 0.133 -1.407348479
5/5/2014 99.48 41.06 3.834 -0.105 14.701 0.011 -0.403163072
5/2/2014 99.76 41.36 4.114 0.195 16.926 0.038 0.801643795
5/1/2014 99.42 40.88 3.774 -0.285 14.244 0.081 -1.076203415
4/30/2014 99.74 40.56 4.094 -0.605 16.762 0.366 -2.477583673
4/29/2014 101.28 40.50 5.634 -0.665 31.744 0.442 -3.747564788
4/28/2014 100.84 42.34 5.194 1.175 26.979 1.380 6.102361392
4/25/2014 100.60 43.66 4.954 2.495 24.544 6.224 12.35989272
4/24/2014 101.94 43.01 6.294 1.845 39.616 3.403 11.61178543
4/23/2014 101.44 43.33 5.794 2.165 33.572 4.687 12.54349272
4/22/2014 102.13 41.16 6.484 -0.005 42.044 0.000 -0.033394831
4/21/2014 104.37 40.53 8.724 -0.635 76.111 0.403 -5.541154059
4/17/2014 104.30 40.85 8.654 -0.315 74.895 0.099 -2.727361355
4/16/2014 103.76 38.84 8.114 -2.325 65.840 5.406 -18.86664805
4/15/2014 103.75 39.66 8.104 -1.505 65.677 2.265 -12.19798281
4/14/2014 104.05 40.06 8.404 -1.105 70.630 1.221 -9.287862643
4/11/2014 103.74 41.22 8.094 0.055 65.515 0.003 0.443963109
4/10/2014 103.40 43.72 7.754 2.555 60.127 6.527 19.81072191
4/9/2014 103.60 42.44 7.954 1.275 63.269 1.625 10.14036311
4/8/2014 102.56 41.62 6.914 0.455 47.806 0.207 3.144905598
4/7/2014 100.44 43.93 4.794 2.765 22.984 7.644 13.25514079
4/4/2014 101.14 44.68 5.494 3.515 30.186 12.354 19.31115796
4/3/2014 100.29 45.85 4.644 4.685 21.568 21.948 21.75720646
4/2/2014 99.62 45.32 3.974 4.155 15.794 17.263 16.51205066
4/1/2014 99.74 44.21 4.094 3.045 16.762 9.271 12.46611161
3/31/2014 101.58 44.03 5.934 2.865 35.214 8.207 17.00048586
3/28/2014 101.67 43.50 6.024 2.335 36.291 5.452 14.0655159
3/27/2014 101.28 43.29 5.634 2.125 31.744 4.515 11.97175023
3/26/2014 100.26 44.63 4.614 3.465 21.291 12.005 15.98738199
3/25/2014 99.19 45.27 3.544 4.105 12.561 16.850 14.5482571
3/24/2014 99.60 46.05 3.954 4.885 15.635 23.862 19.31549272
3/21/2014 99.46 48.10 3.814 6.935 14.548 48.092 26.45064809
3/20/2014 99.43 49.06 3.784 7.895 14.320 62.329 29.87539916
3/19/2014 100.37 48.84 4.724 7.675 22.318 58.903 36.25724208
3/18/2014 99.70 47.53 4.054 6.365 16.436 40.511 25.80413907
3/17/2014 98.08 46.03 2.434 4.865 5.925 23.667 11.84183779
3/14/2014 98.89 46.04 3.244 4.875 10.525 23.764 15.81480774
3/13/2014 98.20 47.65 2.554 6.485 6.524 42.053 16.56336397
3/12/2014 97.99 47.51 2.344 6.345 5.495 40.257 14.87336268
3/11/2014 100.03 48.50 4.384 7.335 19.221 53.800 32.1571777
3/10/2014 101.12 49.92 5.474 8.755 29.966 76.647 47.92547555
3/7/2014 102.58 50.24 6.934 9.075 48.083 82.353 62.92648843
3/6/2014 101.56 48.60 5.914 7.435 34.977 55.277 43.97091418
3/5/2014 101.45 48.71 5.804 7.545 33.688 56.925 43.79153865
3/4/2014 103.33 45.68 7.684 4.515 59.046 20.384 34.69284208
3/3/2014 104.92 46.70 9.274 5.535 86.010 30.635 51.33109959
2/28/2014 102.59 47.26 6.944 6.095 48.221 37.147 42.32363092
2/27/2014 102.40 46.00 6.754 4.835 45.619 23.376 32.65536397
2/26/2014 102.59 44.56 6.944 3.395 48.221 11.525 23.57439058
2/25/2014 101.83 44.83 6.184 3.665 38.244 13.431 22.66402877
2/24/2014 102.82 43.29 7.174 2.125 51.469 4.515 15.2440189
2/21/2014 102.20 43.51 6.554 2.345 42.957 5.498 15.36852792
2/20/2014 102.92 42.98 7.274 1.815 52.913 3.294 13.20151332
2/19/2014 103.31 43.76 7.664 2.595 58.739 6.733 19.88735195
2/18/2014 102.43 41.51 6.784 0.345 46.025 0.119 2.339517186
2/17/2014 100.58 41.96 4.934 0.795 24.346 0.632 3.921918473
2/14/2014 100.30 40.21 4.654 -0.955 21.661 0.912 -4.445424874
2/13/2014 100.35 39.75 4.704 -1.415 22.129 2.003 -6.657097406
2/12/2014 100.37 40.36 4.724 -0.805 22.318 0.648 -3.803660926
2/11/2014 99.94 39.72 4.294 -1.445 18.440 2.088 -6.205710711
2/10/2014 100.06 37.97 4.414 -3.195 19.485 10.209 -14.10391414
2/7/2014 99.88 37.80 4.234 -3.365 17.928 11.324 -14.24859483
2/6/2014 97.84 38.21 2.194 -2.955 4.814 8.733 -6.484081527
2/5/2014 97.38 37.50 1.734 -3.665 3.007 13.433 -6.355968222
2/4/2014 97.19 39.33 1.544 -1.835 2.384 3.368 -2.833771226
2/3/2014 96.43 40.17 0.784 -0.995 0.615 0.990 -0.780360067
1/31/2014 97.49 38.83 1.844 -2.335 3.401 5.453 -4.306397836
1/30/2014 98.23 39.85 2.584 -1.315 6.678 1.730 -3.398562643
1/29/2014 97.36 38.12 1.714 -3.045 2.938 9.273 -5.219884102
1/28/2014 97.41 37.46 1.764 -3.705 3.112 13.728 -6.536489252
1/27/2014 95.72 40.35 0.074 -0.815 0.006 0.664 -0.060454059
1/24/2014 96.64 41.69 0.994 0.525 0.988 0.275 0.521786285
1/23/2014 97.32 41.18 1.674 0.015 2.803 0.000 0.024860963
1/22/2014 96.73 41.77 1.084 0.605 1.175 0.366 0.655755812
1/21/2014 94.99 42.68 -0.656 1.515 0.430 2.295 -0.993494402
1/20/2014 93.94 41.54 -1.706 0.375 2.910 0.141 -0.6394326
1/17/2014 94.37 41.09 -1.276 -0.075 1.628 0.006 0.095879418
1/16/2014 93.96 39.02 -1.686 -2.145 2.842 4.602 3.616373409
1/15/2014 94.17 40.31 -1.476 -0.855 2.178 0.731 1.26206225
1/14/2014 92.59 39.63 -3.056 -1.535 9.338 2.357 4.691168688
1/13/2014 91.80 39.97 -3.846 -1.195 14.790 1.428 4.596352808
1/10/2014 92.72 39.55 -2.926 -1.615 8.561 2.609 4.725666113
1/9/2014 91.66 38.32 -3.986 -2.845 15.887 8.095 11.34030474
1/8/2014 92.33 38.24 -3.316 -2.925 10.995 8.557 9.699321048
1/7/2014 93.67 37.86 -1.976 -3.305 3.904 10.924 6.530437787