I need help with this, thank you.

. Go to https:/ /finance.yahoo.com/ and type the ticker AAPL on the Quote Lookup (top-right of the webpage . Click on Historical Data: Apple Inc. (AAPL) Add to watchlist NasdaqGS - NasdaqGS Real Time Price. Currency in USD 112.33 -1.62 (-1.42%) As of 2:28 PM EDT. Market open. Summary Conversations Statistics Profile Financials Holders Historical Data Analysts Open 113.20 Market Cap 04.53B 1D 5D 1M 6M YTD 1Y 2Y 5Y 10Y MAX " Interactive chart Prev Close 113.95 P/E Ratio (ttm) 13.08 115.00 Bid 112.05 x 400 Beta 1.52 114.00 ASK 112.06 x 200 Volume 26,250,167 113.95 113.00 Day's Range 111.80 - 113.80 Avg Vol (3m) 35,687,276 112.32 2wk Range 89.47 - 123.82 Dividend & Yield 2.28 (2.02%) y Target Est 125.64 Earnings Date Oct 27, 2016 111.00 3:59PM . Set the dates from January 01, 2000 until August 31, 2017 and set the frequency to monthly; then, download the data: Time Period: Jan 01, 2000 - Aug 31, 2017 Show: Historical Prices v Frequency: Monthly Apply Currency in USD & Download Data Date Open High Low Adj Close" Aug 10, 2017 0.63 Dividend Aug 01, 2017 149.10 164.52 148.41 164.00 163.36 660,974,500 Jul 01, 2017 144.88 153.99 142.41 148.73 148.15 421,393,100 Jun 01, 2017 153.17 155.98 142.20 144.02 143.46 684,178,100 May 11, 2017 0.63 Dividend May 01, 2017 145.10 156.65 144.27 152.76 151.54 653,755,300 Apr 01, 2017 143.71 145.46 140.06 143.65 142.50 373,304,100 Mar 01, 2017 137.89 144.50 137.05 143.66 142.51 561,628,400 . Open the file in a spreadsheet (eg, Excel) and 1. Delete all columns except Date and Adj Close 2. Sort the column by Date and order Oldest to Newest if they are not already sorted from the oldest to the newest date3. Calculate the monthly percentage stock return given by 100 times the difference between the current price minus the previous month price and divided by the previous month price; if Pt is the price of AAPL in month t then the return Rt is equal to 100 * (Pt - Pt-1) /Pt-1. The first and last 3 monthly percentage returns are: Adjusted. price Adjusted. ret 2000-01-01 0. 800486 NA 2000-02-01 0. 884392 10. 48188 2000-03-01 1. 047865 18. 48422 Adjusted. price Adjusted. ret 2017-06-01 34. 44832 -5.332240 2017-07-01 35. 57491 3.270378 2017-08-01 39 .22735 10. 266920 Answer the following questions (in parenthesis the correct answer): 1. Calculate the sample mean or average (R) of the stock return: [2.63] 2. Calculate the sample standard deviation of the stock return: [11.99] 3. Calculate the sample skewness of the stock return: [-0.64] 4. Calculate the sample kurtosis of the stock return: [3.54] 5. Calculate teh standard error of the sample average [0.82] . !!! For the questions below, use the values for the mean and std. dev. that you typed above ! Assuming that the returns follow a normal distribution: 6. Calculate the P(Rt > 2.67): [0.49] 7. Calculate the P(-21 x) = 0.9018: [-12.85] 10. Calculate the P(R > 0): [0.99] 11. Calculate the lower limit of a 99% confidence interval for the population mean: [0.51] 12. Calculate the test statistic for the null hypothesis that the population mean is equal to 0 : [3.20] 13. Calculate the two-sided pvalue of the test statistic: [0.00] 14. Do you reject the null hypothesis that the population mean is equal to 0 against the alternative that it is different from zero at 10% significance level? (type DO NOT REJECT or REJECT in capital letters) [REJECT] 15. Do you reject the null hypothesis that the population mean is larger or equal to 0 against the alternative that it is smaller than zero at 5% significance level? (type DO NOT REJECT or REJECT in capital letters) [DO NOT REJECT]Functions in Excel: . X ~ N(u, 02), given x calculate p in P(X