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)
Average95.6541.17
Sum (SSx)(SSy)19475.1782666.7074357.370
12/3/201467.3834.97-28.266-6.195798.95838.380175.1111056
12/2/201466.8834.53-28.766-6.635827.47344.025190.8656489
12/1/201469.0033.98-26.646-7.185710.00151.626191.4543408
11/28/201466.1535.73-29.496-5.435870.00429.541160.3143043
11/26/201473.6937.59-21.956-3.575482.05912.78278.49541504
11/25/201474.0937.64-21.556-3.525464.65412.42775.98756311
11/24/201475.7837.91-19.866-3.255394.65110.59664.66628328
11/21/201476.5137.89-19.136-3.275366.18010.72762.67274036
11/20/201475.8536.87-19.796-4.295391.87518.44885.02609315
11/19/201474.5036.47-21.146-4.695447.14622.04499.28288071
11/18/201474.6436.33-21.006-4.835441.24523.379101.5663768
11/17/201475.6634.61-19.986-6.555399.43442.970131.0101631
11/14/201475.8234.95-19.826-6.215393.06438.628123.2205545
11/13/201474.1634.24-21.486-6.925461.64147.958148.7926481
11/12/201477.1534.85-18.496-6.315342.09639.881116.8039884
11/11/201477.8735.64-17.776-5.525315.98030.52798.21416912
11/10/201477.3835.79-18.266-5.375333.64128.89298.18161719
11/7/201478.6536.27-16.996-4.895288.85823.96283.1971747
11/6/201477.9136.88-17.736-4.285314.56018.36376.00072534
11/5/201478.6836.77-16.966-4.395287.84019.31774.56740174
11/4/201477.1937.67-18.456-3.495340.61812.21664.50592234
11/3/201478.7838.16-16.866-3.005284.4569.03150.68437341
10/31/201480.5438.35-15.106-2.815228.1867.92542.52520002
10/30/201481.1237.29-14.526-3.875211.00015.01756.28980002
10/29/201482.2037.33-13.446-3.835180.79114.70851.56680431
10/28/201481.4237.81-14.226-3.355202.37411.25747.72981976
10/27/201481.0036.59-14.646-4.575214.50120.93267.00690388
10/24/201481.0137.44-14.636-3.725214.20813.87754.52069101
10/23/201482.0937.50-13.556-3.665183.76113.43349.68417856
10/22/201480.5237.06-15.126-4.105228.79116.85262.09383264
10/21/201482.4938.17-13.156-2.995173.0768.97139.40370774
10/20/201481.9137.14-13.736-4.025188.67316.20255.28880689
10/17/201482.0635.89-13.586-5.275184.57527.82771.66733049
10/16/201481.9535.31-13.696-5.855187.57634.28380.19118242
10/15/201480.9433.93-14.706-7.235216.26252.347106.3989391
10/14/201481.2033.84-14.446-7.325208.68253.658105.8179253
10/13/201484.9833.37-10.666-7.795113.76060.76483.14180088
10/10/201485.8234.96-9.826-6.20596.54738.50460.97079401
10/9/201485.7736.12-9.876-5.04597.53225.45449.82508071
10/8/201487.3138.31-8.336-2.85569.4868.15223.80006654
10/7/201488.8537.79-6.796-3.37546.18311.39222.9369704
10/6/201490.3438.25-5.306-2.91528.1528.49815.46731161
10/3/201489.7440.04-5.906-1.12534.8791.2666.644953666
10/2/201491.0139.36-4.636-1.80521.4913.2598.368381993
10/1/201490.7339.41-4.916-1.75524.1653.0818.628032207
9/30/201491.1640.65-4.486-0.51520.1230.2652.310879847
9/29/201494.5741.55-1.0760.3851.1570.148-0.414035604
9/26/201493.5442.20-2.1061.0354.4351.071-2.179224874
9/25/201492.5341.81-3.1160.6459.7080.416-2.009246763
9/24/201492.8043.08-2.8461.9158.0993.667-5.449350196
9/23/201491.5642.29-4.0861.12516.6941.265-4.595952771
9/22/201490.8742.29-4.7761.12522.8091.265-5.372099123
9/19/201491.6543.62-3.9962.45515.9676.026-9.809179381
9/18/201491.9844.38-3.6663.21513.43810.335-11.785115
9/17/201493.2043.97-2.4462.8055.9827.867-6.860205132
9/16/201493.8143.52-1.8362.3553.3705.545-4.323120153
9/15/201491.9943.54-3.6562.37513.3655.640-8.682063501
9/12/201491.3745.41-4.2764.24518.28318.019-18.15028539
9/11/201491.8645.27-3.7864.10514.33316.850-15.54029183
9/10/201490.8445.16-4.8063.99523.09615.959-19.19859655
9/9/201491.8944.36-3.7563.19514.10610.207-11.99933475
9/8/201492.0545.68-3.5964.51512.93020.384-16.2346635
9/5/201493.2945.36-2.3564.1955.55017.597-9.882381956
9/4/201494.4544.63-1.1963.4651.43012.005-4.143395261
9/3/201495.5443.88-0.1062.7150.0117.370-0.287331312
9/2/201492.8843.32-2.7662.1557.6504.643-5.959963072
8/29/201495.9643.390.3142.2250.0994.9500.698965684
8/28/201494.5543.05-1.0961.8851.2013.553-2.065487964
8/27/201493.8843.74-1.7662.5753.1186.630-4.546764788
8/26/201493.8644.11-1.7862.9453.1898.672-5.259021441
8/25/201493.3544.14-2.2962.9755.2718.850-6.829769939
8/22/201493.6543.78-1.9962.6153.9836.837-5.218813715
8/21/201493.9643.67-1.6862.5052.8426.274-4.222768222
8/20/201493.4543.58-2.1962.4154.8225.831-5.302616291
8/19/201492.8643.53-2.7862.3657.7615.593-6.588085818
8/18/201493.7542.90-1.8961.7353.5943.010-3.288992256
8/15/201495.3242.24-0.3261.0750.1061.155-0.350225733
8/14/201494.0841.98-1.5660.8152.4520.664-1.27592187
8/13/201496.7441.741.0940.5751.1970.3300.628979418
8/12/201496.4840.710.834-0.4550.6960.207-0.379669509
8/11/201497.2141.411.5640.2452.4470.0600.382984997
8/8/201497.6540.372.004-0.7954.0170.632-1.593610711
8/7/201497.3440.501.694-0.6652.8700.442-1.126872943
8/6/201496.9239.641.274-1.5251.6232.326-1.94329011
8/5/201497.3839.501.734-1.6653.0072.773-2.887642042
8/4/201498.2938.662.644-2.5056.9926.276-6.624025733
8/1/201497.8838.612.234-2.5554.9916.529-5.708622299
7/31/201498.1739.422.524-1.7456.3713.046-4.405043758
7/30/2014100.2740.584.624-0.58521.3830.342-2.705830024
7/29/2014100.9740.955.324-0.21528.3470.046-1.145494831
7/28/2014101.6741.336.0240.16536.2910.0270.993081993
7/25/2014102.0941.236.4440.06541.5270.0040.417902594
7/24/2014102.0741.396.4240.22541.2700.0511.444471692
7/23/2014103.1241.597.4740.42555.8630.1803.175396585
7/22/2014102.3942.516.7441.34545.4841.8099.069886285
7/21/2014102.8641.867.2140.69552.0440.4835.012759675
7/18/2014101.9541.746.3040.57539.7420.3303.6239468
7/17/2014102.2040.486.554-0.68542.9570.469-4.490586248
7/16/2014100.6041.984.9540.81524.5440.6644.036898731
7/15/201499.5342.073.8840.90515.0870.8193.514584139
7/14/2014100.4842.374.8341.20523.3691.4525.824440362
7/11/2014100.8342.155.1840.98526.8760.9705.105621907
7/10/2014102.9341.807.2840.63553.0590.4034.624349375
7/9/2014102.2942.286.6441.11544.1451.2437.407243795
7/8/2014103.4041.637.7540.46560.1270.2163.604521048
7/7/2014103.5343.187.8842.01562.1604.06015.88540431
7/3/2014104.0644.708.4143.53570.79812.49529.74280259
7/2/2014104.4844.228.8343.05578.0429.33226.98704122
7/1/2014105.3444.379.6943.20593.97710.27131.0683365
6/30/2014105.3744.579.7243.40594.55911.59333.10931461
6/27/2014105.7444.4110.0943.245101.89210.52932.75404294
6/26/2014105.8444.3010.1943.135103.9219.82731.95716998
6/25/2014106.5043.7510.8542.585117.8136.68128.05638113
6/24/2014106.0342.8610.3841.695107.8312.87317.59959658
6/23/2014106.1744.2610.5243.095110.7589.57832.57070388
6/20/2014106.8344.7711.1843.605125.08612.99540.31722792
6/19/2014106.0544.1010.4042.935108.2478.61330.53465581
6/18/2014105.5944.489.9443.31598.88610.98832.96340689
6/17/2014105.8744.2810.2243.115104.5349.70231.84673221
6/16/2014106.3042.7510.6541.585113.5112.51216.88524809
6/13/2014106.1742.0010.5240.835110.7580.6978.786095297
6/12/2014105.7841.0110.134-0.155102.7010.024-1.572317578
6/11/2014103.6240.437.974-0.73563.5870.540-5.862207707
6/10/2014103.4940.067.844-1.10561.5311.221-8.668978522
6/9/2014103.5940.137.944-1.03563.1101.072-8.223402128
6/6/2014102.6639.847.014-1.32549.1981.756-9.294819724
6/5/2014102.4840.246.834-0.92546.7060.856-6.322627449
6/4/2014102.6440.136.994-1.03548.9181.072-7.240009424
6/3/2014102.6639.937.014-1.23549.1981.526-8.663545046
6/2/2014102.4740.756.824-0.41546.5690.172-2.833052771
5/30/2014102.7140.797.064-0.37549.9020.141-2.650122299
5/29/2014103.5841.887.9340.71562.9510.5115.671734782
5/28/2014102.7240.727.074-0.44550.0440.198-3.149065218
5/27/2014104.1140.768.464-0.40571.6420.164-3.429257492
5/26/2014104.2840.488.634-0.68574.5490.469-5.915698694
5/23/2014104.3539.828.704-1.34575.7621.809-11.70840685
5/22/2014103.7438.858.094-2.31565.5155.360-18.73920342
5/21/2014104.0736.938.424-4.23570.96717.936-35.67759612
5/20/2014102.3337.696.684-3.47544.67812.077-23.2284708
5/19/2014102.1137.676.464-3.49541.78512.216-22.59322101
5/16/2014102.0238.176.374-2.99540.6308.971-19.09157595
5/15/2014101.5039.525.854-1.64534.2712.707-9.630977664
5/14/2014102.3739.816.724-1.35545.2141.836-9.112251055
5/13/2014101.7040.186.054-0.98536.6530.971-5.964260067
5/12/2014100.5938.204.944-2.96524.4458.792-14.66018625
5/9/201499.9938.184.344-2.98518.8728.911-12.96797938
5/8/2014100.2638.964.614-2.20521.2914.863-10.17492273
5/7/2014100.7740.165.124-1.00526.2571.010-5.15055363
5/6/201499.5040.803.854-0.36514.8550.133-1.407348479
5/5/201499.4841.063.834-0.10514.7010.011-0.403163072
5/2/201499.7641.364.1140.19516.9260.0380.801643795
5/1/201499.4240.883.774-0.28514.2440.081-1.076203415
4/30/201499.7440.564.094-0.60516.7620.366-2.477583673
4/29/2014101.2840.505.634-0.66531.7440.442-3.747564788
4/28/2014100.8442.345.1941.17526.9791.3806.102361392
4/25/2014100.6043.664.9542.49524.5446.22412.35989272
4/24/2014101.9443.016.2941.84539.6163.40311.61178543
4/23/2014101.4443.335.7942.16533.5724.68712.54349272
4/22/2014102.1341.166.484-0.00542.0440.000-0.033394831
4/21/2014104.3740.538.724-0.63576.1110.403-5.541154059
4/17/2014104.3040.858.654-0.31574.8950.099-2.727361355
4/16/2014103.7638.848.114-2.32565.8405.406-18.86664805
4/15/2014103.7539.668.104-1.50565.6772.265-12.19798281
4/14/2014104.0540.068.404-1.10570.6301.221-9.287862643
4/11/2014103.7441.228.0940.05565.5150.0030.443963109
4/10/2014103.4043.727.7542.55560.1276.52719.81072191
4/9/2014103.6042.447.9541.27563.2691.62510.14036311
4/8/2014102.5641.626.9140.45547.8060.2073.144905598
4/7/2014100.4443.934.7942.76522.9847.64413.25514079
4/4/2014101.1444.685.4943.51530.18612.35419.31115796
4/3/2014100.2945.854.6444.68521.56821.94821.75720646
4/2/201499.6245.323.9744.15515.79417.26316.51205066
4/1/201499.7444.214.0943.04516.7629.27112.46611161
3/31/2014101.5844.035.9342.86535.2148.20717.00048586
3/28/2014101.6743.506.0242.33536.2915.45214.0655159
3/27/2014101.2843.295.6342.12531.7444.51511.97175023
3/26/2014100.2644.634.6143.46521.29112.00515.98738199
3/25/201499.1945.273.5444.10512.56116.85014.5482571
3/24/201499.6046.053.9544.88515.63523.86219.31549272
3/21/201499.4648.103.8146.93514.54848.09226.45064809
3/20/201499.4349.063.7847.89514.32062.32929.87539916
3/19/2014100.3748.844.7247.67522.31858.90336.25724208
3/18/201499.7047.534.0546.36516.43640.51125.80413907
3/17/201498.0846.032.4344.8655.92523.66711.84183779
3/14/201498.8946.043.2444.87510.52523.76415.81480774
3/13/201498.2047.652.5546.4856.52442.05316.56336397
3/12/201497.9947.512.3446.3455.49540.25714.87336268
3/11/2014100.0348.504.3847.33519.22153.80032.1571777
3/10/2014101.1249.925.4748.75529.96676.64747.92547555
3/7/2014102.5850.246.9349.07548.08382.35362.92648843
3/6/2014101.5648.605.9147.43534.97755.27743.97091418
3/5/2014101.4548.715.8047.54533.68856.92543.79153865
3/4/2014103.3345.687.6844.51559.04620.38434.69284208
3/3/2014104.9246.709.2745.53586.01030.63551.33109959
2/28/2014102.5947.266.9446.09548.22137.14742.32363092
2/27/2014102.4046.006.7544.83545.61923.37632.65536397
2/26/2014102.5944.566.9443.39548.22111.52523.57439058
2/25/2014101.8344.836.1843.66538.24413.43122.66402877
2/24/2014102.8243.297.1742.12551.4694.51515.2440189
2/21/2014102.2043.516.5542.34542.9575.49815.36852792
2/20/2014102.9242.987.2741.81552.9133.29413.20151332
2/19/2014103.3143.767.6642.59558.7396.73319.88735195
2/18/2014102.4341.516.7840.34546.0250.1192.339517186
2/17/2014100.5841.964.9340.79524.3460.6323.921918473
2/14/2014100.3040.214.654-0.95521.6610.912-4.445424874
2/13/2014100.3539.754.704-1.41522.1292.003-6.657097406
2/12/2014100.3740.364.724-0.80522.3180.648-3.803660926
2/11/201499.9439.724.294-1.44518.4402.088-6.205710711
2/10/2014100.0637.974.414-3.19519.48510.209-14.10391414
2/7/201499.8837.804.234-3.36517.92811.324-14.24859483
2/6/201497.8438.212.194-2.9554.8148.733-6.484081527
2/5/201497.3837.501.734-3.6653.00713.433-6.355968222
2/4/201497.1939.331.544-1.8352.3843.368-2.833771226
2/3/201496.4340.170.784-0.9950.6150.990-0.780360067
1/31/201497.4938.831.844-2.3353.4015.453-4.306397836
1/30/201498.2339.852.584-1.3156.6781.730-3.398562643
1/29/201497.3638.121.714-3.0452.9389.273-5.219884102
1/28/201497.4137.461.764-3.7053.11213.728-6.536489252
1/27/201495.7240.350.074-0.8150.0060.664-0.060454059
1/24/201496.6441.690.9940.5250.9880.2750.521786285
1/23/201497.3241.181.6740.0152.8030.0000.024860963
1/22/201496.7341.771.0840.6051.1750.3660.655755812
1/21/201494.9942.68-0.6561.5150.4302.295-0.993494402
1/20/201493.9441.54-1.7060.3752.9100.141-0.6394326
1/17/201494.3741.09-1.276-0.0751.6280.0060.095879418
1/16/201493.9639.02-1.686-2.1452.8424.6023.616373409
1/15/201494.1740.31-1.476-0.8552.1780.7311.26206225
1/14/201492.5939.63-3.056-1.5359.3382.3574.691168688
1/13/201491.8039.97-3.846-1.19514.7901.4284.596352808
1/10/201492.7239.55-2.926-1.6158.5612.6094.725666113
1/9/201491.6638.32-3.986-2.84515.8878.09511.34030474
1/8/201492.3338.24-3.316-2.92510.9958.5579.699321048
1/7/201493.6737.86-1.976-3.3053.90410.9246.530437787