Please do all of the required questions in the white box on the excel sheet. Please show all formulas and answer all questions, I will not accept an answer without all questions answered with formulas. Thanks. I have already calculated returns.

Date 1/2/2015 1/5/2015 1/12/2015 1/20/2015 1/26/2015 2/2/2015 2/9/2015 2/17/2015 2/23/2015 3/2/2015 3/9/2015 3/16/2015 3/23/2015 3/30/2015 4/6/2015 4/13/2015 4/20/2015 4/27/2015 5/4/2015 5/11/2015 5/18/2015 5/26/2015 6/1/2015 6/8/2015 6/15/2015 6/22/2015 6/29/2015 7/6/2015 7/13/2015 7/20/2015 7/27/2015 8/3/2015 8/10/2015 8/17/2015 8/24/2015 8/31/2015 9/8/2015 9/14/2015 9/21/2015 9/28/2015 10/5/2015 10/12/2015 10/19/2015 10/26/2015 11/2/2015 11/9/2015 11/16/2015 CVX OIL 104.1373 100.095 97.23677 98.83703 94.841 101.39 105.3473 101.4427 99.64927 96.72556 94.92275 99.9762 97.40744 98.34154 99.86411 101.9191 102.629 101.8537 101.4894 101.9158 98.95354 97.17051 95.84031 94.21766 93.8403 93.01953 90.44405 89.06668 87.87799 85.47231 83.4723 79.01 81.12322 72.37277 76.83398 73.24208 72.40143 74.26424 74.22603 77.90391 85.56533 87.20843 87.16066 86.81676 89.82592 84.71512 86.06886 12.21 11.12 11.09 10.16 10.68 11.88 12.01 11.33 10.95 11.03 10.03 9.79 10.25 10.51 11.03 12.01 11.91 12.39 12.4 12.48 12.28 12.35 12.07 12.31 12.15 12.11 11.41 10.55 10.11 9.48 9.17 8.46 8.05 7.5 8.56 8.62 8.35 8.49 8.44 8.5 9.3 8.82 8.44 8.59 8.41 7.64 7.54 SP500 Returns 2058.2 CVX OIL SP500 2044.81 -0.03959 -0.09351 -0.006527 2019.42 -0.028971 -0.002701 -0.012495 2051.82 0.016323 -0.087585 0.015917 1994.99 -0.041271 0.049914 -0.028088 2055.47 0.066773 0.106483 0.029865 2096.99 0.038287 0.010883 0.019998 2110.3 -0.037768 -0.058286 0.006327 2104.5 -0.017838 -0.034115 -0.002752 2071.26 -0.029779 0.007279 -0.015921 2053.4 -0.018814 -0.095038 -0.00866 2108.1 0.051869 -0.024219 0.02629 2061.02 -0.02603 0.045916 -0.022586 2066.96 0.009544 0.025049 0.002878 2102.06 0.015364 0.048292 0.016839 2081.18 0.020369 0.085121 -0.009983 2117.69 0.006941 -0.008361 0.017391 2108.29 -0.007583 0.039511 -0.004449 2116.1 -0.003583 0.000807 0.003698 2122.73 0.004192 0.006431 0.003128 2126.06 -0.029497 -0.016155 0.001568 2107.39 -0.018183 0.005684 -0.00882 2092.83 -0.013784 -0.022933 -0.006933 2094.11 -0.017076 0.019689 0.000611 2109.99 -0.004013 -0.013083 0.007555 2101.49 -0.008785 -0.003298 -0.004037 2076.78 -0.028078 -0.059541 -0.011828 2076.62 -0.015346 -0.078364 -7.7E-005 2126.64 -0.013436 -0.042601 0.023802 2079.65 -0.027757 -0.064341 -0.022344 2103.84 -0.023678 -0.033247 0.011565 2077.57 -0.05494 -0.080588 -0.012565 2091.54 0.026395 -0.049677 0.006702 1970.89 -0.114139 -0.070769 -0.059415 1988.87 0.059817 0.132197 0.009081 1921.22 -0.047877 0.006985 -0.034606 1961.05 -0.011544 -0.031824 0.02052 1958.03 0.025404 0.016627 -0.001541 1931.34 -0.000515 -0.005907 -0.013725 1951.36 0.048361 0.007084 0.010313 2014.89 0.093804 0.089948 0.032038 2033.11 0.019021 -0.052993 0.009002 2075.15 -0.000548 -0.04404 0.020467 2079.36 -0.003953 0.017616 0.002027 2099.2 0.034074 -0.021177 0.009496 2023.04 -0.05858 -0.096024 -0.036955 2089.17 0.015854 -0.013175 0.032165 Regression of CVZ on SP500 and Summary Output 11/23/2015 87.38392 11/30/2015 86.74573 12/7/2015 83.58378 12/14/2015 86.84242 12/21/2015 89.00841 12/28/2015 86.98747 Forecast period Date CVX OIL 1/4/2016 79.41619 1/11/2016 80.9053 1/19/2016 80.7796 1/25/2016 83.61279 2/1/2016 80.1414 2/8/2016 82.60715 2/16/2016 84.70269 2/22/2016 82.59736 2/29/2016 86.10297 3/7/2016 92.6148 3/14/2016 95.66018 3/21/2016 92.87919 3/28/2016 92.30145 4/4/2016 94.32844 4/11/2016 95.20974 4/18/2016 99.89042 4/25/2016 100.0569 5/2/2016 99.74354 5/9/2016 98.64681 5/16/2016 98.74951 5/23/2016 100.9563 5/31/2016 99.61044 6/6/2016 100.9167 6/13/2016 100.5109 6/20/2016 100.8375 6/27/2016 103.064 7/5/2016 103.6776 7/11/2016 105.914 7/18/2016 104.5583 7/25/2016 101.4115 8/1/2016 99.46201 8/8/2016 101.0948 8/15/2016 102.32 7.63 7.22 6.4 6.12 6.51 6.23 2090.11 2091.69 2012.37 2005.55 2060.99 2043.94 0.015164 -0.00733 -0.037132 0.038246 0.024636 -0.022967 0.011866 -0.055233 -0.120557 -0.044736 0.061777 -0.043963 0.00045 0.000756 -0.038659 -0.003395 0.027268 -0.008307 SP500 Returns 5.67 1922.03 CVX OIL SP500 CVX-b*Oil 5.61 1880.33 0.018577 -0.010638 -0.021935 4.83 1906.9 -0.001555 -0.149704 0.014032 5.12 1940.24 0.034472 0.058308 0.017333 4.81 1880.05 -0.042404 -0.062457 -0.031513 4.54 1864.78 0.030304 -0.05777 -0.008155 4.63 1917.78 0.025051 0.01963 0.028025 4.74 1948.05 -0.02517 0.02348 0.015661 5.17 1999.99 0.041566 0.086836 0.026313 5.48 2022.19 0.072905 0.058232 0.011039 5.66 2049.58 0.032353 0.032319 0.013454 5.3 2035.94 -0.029503 -0.065717 -0.006677 4.95 2072.78 -0.00624 -0.068319 0.017933 5.3 2047.6 0.021723 0.068319 -0.012222 5.47 2080.73 0.0093 0.031572 0.01605 5.73 2091.58 0.047992 0.046437 0.005201 6.05 2065.3 0.001665 0.054343 -0.012644 5.8 2057.14 -0.003137 -0.0422 -0.003959 6.09 2046.61 -0.011056 0.04879 -0.005132 6.32 2052.32 0.001041 0.037071 0.002786 6.52 2099.06 0.022101 0.031155 0.022519 6.43 2099.13 -0.01342 -0.0139 3.33E-005 6.46 2096.07 0.013028 0.004655 -0.001459 6.3 2071.22 -0.004029 -0.02508 -0.011926 6.16 2037.41 0.003244 -0.022473 -0.016458 6.38 2102.95 0.02184 0.035091 0.031662 5.86 2129.9 0.005935 -0.085018 0.012734 5.93 2161.74 0.021342 0.011875 0.014838 5.65 2175.03 -0.012883 -0.048369 0.006129 5.23 2173.6 -0.030559 -0.077244 -0.000658 5.3 2182.87 -0.01941 0.013296 0.004256 5.62 2184.05 0.016283 0.058625 0.00054 6.08 2183.87 0.012046 0.078673 -8.2E-005 Regression of CVZ on SP500 and OIL output. Summary Output Assignment due by Create returns for Regress the return Create the returns return minus b*Oi Calculate the avera ratio (assume Rf=0 period 1/11/2016 series with SP500 Place the output in groups of up to 3 p Forecast Period Statistics CVX OIL Average StDev Sharpe Corr with Oil Corr with SP500 SP500 CVX-b*Oil 1 1 Team Member Names 1 2 3 Assignment due by the end of the day Saturday Feb. 18. Create returns for periods 1/5/2015 to 12/28/2015 Regress the returns of CVX on SP500 and OIL. Create the returns for 1/11/2016 to 8/15/2016 and a new series CVX return minus b*Oil return. Calculate the average return, standard deviation of return and Sharpe ratio (assume Rf=0) of each of the four series over the second sample period 1/11/2016 to 8/15/2016. Calculate the correlations of each series with SP500 and Oil Place the output in the indicated shaded spaces. You may work in groups of up to 3 people