Question: Calculate the Average Return, Variance and Standard Deviation for the Stock Date Open High Low Close Adj Close Aug 01, 2020 3,180.51 3,495.00 3,073.00 3,450.96

Calculate the Average Return, Variance and Standard Deviation for the Stock Date Open High Low Close Adj Close Aug 01, 2020 3,180.51 3,495.00 3,073.00 3,450.96 3,450.96 Jul 01, 2020 2,757.99 3,344.29 2,754.00 3,164.68 3,164.68 Jun 01, 2020 2,448.00 2,796.00 2,437.13 2,758.82 2,758.82 May 01, 2020 2,336.80 2,525.45

Calculate the Average Return, Variance and Standard Deviation for the Stock

Date Open High Low Close Adj Close Aug 01, 2020 3,180.51 3,495.00 3,073.00 3,450.96 3,450.96 Jul 01, 2020 2,757.99 3,344.29 2,754.00 3,164.68 3,164.68 Jun 01, 2020 2,448.00 2,796.00 2,437.13 2,758.82 2,758.82 May 01, 2020 2,336.80 2,525.45 2,256.38 2,442.37 2,442.37 Apr 01, 2020 1,932.97 2,475.00 1,889.15 2,474.00 2,474.00 Mar 01, 2020 1,906.49 1,996.33 1,626.03 1,949.72 1,949.72 Feb 01, 2020 2,010.60 2,185.95 1,811.13 1,883.75 1,883.75 Jan 01, 2020 1,875.00 2,055.72 1,815.34 2,008.72 2,008.72 Dec 01, 2019 1,804.40 1,901.40 1,735.00 1,847.84 1,847.84 Nov 01, 2019 1,788.01 1,824.69 1,722.71 1,800.80 1,800.80 Oct 01, 2019 1,746.00 1,798.85 1,685.06 1,776.66 1,776.66 Sep 01, 2019 1,770.00 1,853.66 1,709.22 1,735.91 1,735.91 Aug 01, 2019 1,871.72 1,897.92 1,743.51 1,776.29 1,776.29 Jul 01, 2019 1,922.98 2,035.80 1,849.44 1,866.78 1,866.78 Jun 01, 2019 1,760.01 1,935.20 1,672.00 1,893.63 1,893.63 May 01, 2019 1,933.09 1,964.40 1,772.70 1,775.07 1,775.07 Apr 01, 2019 1,800.11 1,956.34 1,798.73 1,926.52 1,926.52 Mar 01, 2019 1,655.13 1,823.75 1,586.57 1,780.75 1,780.75 Feb 01, 2019 1,638.88 1,673.06 1,566.76 1,639.83 1,639.83 Jan 01, 2019 1,465.20 1,736.41 1,460.93 1,718.73 1,718.73 Dec 01, 2018 1,769.46 1,778.34 1,307.00 1,501.97 1,501.97 Nov 01, 2018 1,623.53 1,784.00 1,420.00 1,690.17 1,690.17 Oct 01, 2018 2,021.99 2,033.19 1,476.36 1,598.01 1,598.01 Sep 01, 2018 2,026.50 2,050.50 1,865.00 2,003.00 2,003.00 Aug 01, 2018 1,784.00 2,025.57 1,776.02 2,012.71 2,012.71 Jul 01, 2018 1,682.70 1,880.05 1,678.06 1,777.44 1,777.44 Jun 01, 2018 1,637.03 1,763.10 1,635.09 1,699.80 1,699.80 May 01, 2018 1,563.22 1,635.00 1,546.02 1,629.62 1,629.62 Apr 01, 2018 1,417.62 1,638.10 1,352.88 1,566.13 1,566.13 Mar 01, 2018 1,513.60 1,617.54 1,365.20 1,447.34 1,447.34 Feb 01, 2018 1,445.00 1,528.70 1,265.93 1,512.45 1,512.45 Jan 01, 2018 1,172.00 1,472.58 1,170.51 1,450.89 1,450.89 Dec 01, 2017 1,172.05 1,194.78 1,124.74 1,169.47 1,169.47 57,760,200 Nov 01, 2017 1,105.40 1,213.41 1,086.87 1,176.75 1,176.75 77,165,000 Oct 01, 2017 964.00 1,122.79 950.37 1,105.28 1,105.28 83,334,100 Sep 01, 2017 984.20 1,000.00 931.75 961.35 961.35 59,291,800 Aug 01, 2017 996.11 1,006.40 936.33 980.60 980.60 77,391,800 Jul 01, 2017 972.79 1,083.31 951.00 987.78 987.78 78,812,400 Jun 01, 2017 998.59 1,017.00 927.00 968.00 968.00 96,135,400 May 01, 2017 927.80 1,001,20 927.80 994.62 994.62 76,202,000 Apr 01, 2017 888.00 949.59 884.49 924.99 924.99 73,539,700 Mar 01, 2017 853.05 890.35 833.50 886.54 886.54 60,710,700 Feb 01, 2017 829.21 860.86 803.00 845.04 845.04 71,748,300 Jan 01, 2017 757.92 843.84 747.70 823.48 823.48 70,614,000 Dec 01, 2016 752.41 782.46 736.70 749.87 749.87 73,660,200 Nov 01, 2016 799.00 800.84 710.10 750.57 750.57 110,085,900 Oct 01, 2016 836.00 847.21 774.61 789.82 789.82 77,063,800 Sep 01, 2016 770.90 839.95 756.00 837.31 837.31 67,335,700 Aug 01, 2016 759.87 774.98 750.35 769.16 769.16 50,000,400 Jul 01, 2016 717.32 766.00 716.54 758.81 758.81 Jun 01, 2016 720.90 731.50 682.12 715.62 715.62 May 01, 2016 663.92 724.23 656.00 722.79 722.79 Apr 01, 2016 590.49 669.98 585.25 659.59 659.59 Mar 01, 2016 556.29 603.24 538.58 593.64 593.64 Feb 01, 2016 578.15 581.80 474.00 552.52 552.52 Jan 01, 2016 656.29 657.72 547.18 587.00 587.00 Dec 01, 2015 673.75 696.44 635.27 675.89 675.89 Nov 01, 2015 627.13 682.77 620.41 664.80 664.80 Oct 01, 2015 511.00 630.72 506.00 625.90 625.90 Sep 01, 2015 499.14 549.78 490.50 511.89 511.89 Aug 01, 2015 537.45 542.74 451.00 512.89 512.89 Date Open High Low Close Adj Close Aug 01, 2020 3,180.51 3,495.00 3,073.00 3,450.96 3,450.96 Jul 01, 2020 2,757.99 3,344.29 2,754.00 3,164.68 3,164.68 Jun 01, 2020 2,448.00 2,796.00 2,437.13 2,758.82 2,758.82 May 01, 2020 2,336.80 2,525.45 2,256.38 2,442.37 2,442.37 Apr 01, 2020 1,932.97 2,475.00 1,889.15 2,474.00 2,474.00 Mar 01, 2020 1,906.49 1,996.33 1,626.03 1,949.72 1,949.72 Feb 01, 2020 2,010.60 2,185.95 1,811.13 1,883.75 1,883.75 Jan 01, 2020 1,875.00 2,055.72 1,815.34 2,008.72 2,008.72 Dec 01, 2019 1,804.40 1,901.40 1,735.00 1,847.84 1,847.84 Nov 01, 2019 1,788.01 1,824.69 1,722.71 1,800.80 1,800.80 Oct 01, 2019 1,746.00 1,798.85 1,685.06 1,776.66 1,776.66 Sep 01, 2019 1,770.00 1,853.66 1,709.22 1,735.91 1,735.91 Aug 01, 2019 1,871.72 1,897.92 1,743.51 1,776.29 1,776.29 Jul 01, 2019 1,922.98 2,035.80 1,849.44 1,866.78 1,866.78 Jun 01, 2019 1,760.01 1,935.20 1,672.00 1,893.63 1,893.63 May 01, 2019 1,933.09 1,964.40 1,772.70 1,775.07 1,775.07 Apr 01, 2019 1,800.11 1,956.34 1,798.73 1,926.52 1,926.52 Mar 01, 2019 1,655.13 1,823.75 1,586.57 1,780.75 1,780.75 Feb 01, 2019 1,638.88 1,673.06 1,566.76 1,639.83 1,639.83 Jan 01, 2019 1,465.20 1,736.41 1,460.93 1,718.73 1,718.73 Dec 01, 2018 1,769.46 1,778.34 1,307.00 1,501.97 1,501.97 Nov 01, 2018 1,623.53 1,784.00 1,420.00 1,690.17 1,690.17 Oct 01, 2018 2,021.99 2,033.19 1,476.36 1,598.01 1,598.01 Sep 01, 2018 2,026.50 2,050.50 1,865.00 2,003.00 2,003.00 Aug 01, 2018 1,784.00 2,025.57 1,776.02 2,012.71 2,012.71 Jul 01, 2018 1,682.70 1,880.05 1,678.06 1,777.44 1,777.44 Jun 01, 2018 1,637.03 1,763.10 1,635.09 1,699.80 1,699.80 May 01, 2018 1,563.22 1,635.00 1,546.02 1,629.62 1,629.62 Apr 01, 2018 1,417.62 1,638.10 1,352.88 1,566.13 1,566.13 Mar 01, 2018 1,513.60 1,617.54 1,365.20 1,447.34 1,447.34 Feb 01, 2018 1,445.00 1,528.70 1,265.93 1,512.45 1,512.45 Jan 01, 2018 1,172.00 1,472.58 1,170.51 1,450.89 1,450.89 Dec 01, 2017 1,172.05 1,194.78 1,124.74 1,169.47 1,169.47 57,760,200 Nov 01, 2017 1,105.40 1,213.41 1,086.87 1,176.75 1,176.75 77,165,000 Oct 01, 2017 964.00 1,122.79 950.37 1,105.28 1,105.28 83,334,100 Sep 01, 2017 984.20 1,000.00 931.75 961.35 961.35 59,291,800 Aug 01, 2017 996.11 1,006.40 936.33 980.60 980.60 77,391,800 Jul 01, 2017 972.79 1,083.31 951.00 987.78 987.78 78,812,400 Jun 01, 2017 998.59 1,017.00 927.00 968.00 968.00 96,135,400 May 01, 2017 927.80 1,001,20 927.80 994.62 994.62 76,202,000 Apr 01, 2017 888.00 949.59 884.49 924.99 924.99 73,539,700 Mar 01, 2017 853.05 890.35 833.50 886.54 886.54 60,710,700 Feb 01, 2017 829.21 860.86 803.00 845.04 845.04 71,748,300 Jan 01, 2017 757.92 843.84 747.70 823.48 823.48 70,614,000 Dec 01, 2016 752.41 782.46 736.70 749.87 749.87 73,660,200 Nov 01, 2016 799.00 800.84 710.10 750.57 750.57 110,085,900 Oct 01, 2016 836.00 847.21 774.61 789.82 789.82 77,063,800 Sep 01, 2016 770.90 839.95 756.00 837.31 837.31 67,335,700 Aug 01, 2016 759.87 774.98 750.35 769.16 769.16 50,000,400 Jul 01, 2016 717.32 766.00 716.54 758.81 758.81 Jun 01, 2016 720.90 731.50 682.12 715.62 715.62 May 01, 2016 663.92 724.23 656.00 722.79 722.79 Apr 01, 2016 590.49 669.98 585.25 659.59 659.59 Mar 01, 2016 556.29 603.24 538.58 593.64 593.64 Feb 01, 2016 578.15 581.80 474.00 552.52 552.52 Jan 01, 2016 656.29 657.72 547.18 587.00 587.00 Dec 01, 2015 673.75 696.44 635.27 675.89 675.89 Nov 01, 2015 627.13 682.77 620.41 664.80 664.80 Oct 01, 2015 511.00 630.72 506.00 625.90 625.90 Sep 01, 2015 499.14 549.78 490.50 511.89 511.89 Aug 01, 2015 537.45 542.74 451.00 512.89 512.89

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Who Question 1. (27 martes) You have been following the prices of Stock A and recording the following information Date Open High Low close Adj Close Dividend Volume 1-Jul-20 62.50 62.50 61.95 61.75...

Date Open High Low Close Adj Close Volume 6/30/16 null null null null null null 7/31/16 75.669998 80.690002 71.809998 75.690002 71.212059 6606842 8/31/16 75.089996 75.580002 69.5 70.32 66.497955...

I need help putting the below assignment together in excel. I the solutions to be in excel so that I can cross reference with my notes. Thanks FIN 5620-EVT: Jack De Jong: Quantitative Problem Set #3:...

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...

Amazon (AMZN) Bank of America (BAC) Verizon (VZ) Risk, return, and diversification. Using the Diversification worksheet, compute the monthly returns for each company. The first monthly return for...

Refer to the Excel Projects Guidelines file in the Group Corner folder. CAPM & Stock Valuation Project The estimation of company betas is normally brushed over in many introductory finance texts....

Collect the daily stock prices over the past year from Yahoo! Finance for SPY, which is the symbol for the exchange traded fund that attempts to mimic the S&P 500 index, which is often used as the...

The question is in the word document, please help me with it. 1. Use the following information to answer the following. Cash Holdings ($) Unused Credit Line ($) Next Expected Cash Inflow ($) Stand....

Refer to the ?Caterpillar? file in Moodle and answer the following. Calculate the Addition Funds Needed for Working Capital for Caterpillar for the calendar year 2016. What does your result in ?Part...

Hi Can you assist with the attached assignment? Thanks Bayerische Motoren Werke Aktiengesellschaft (DB:BMW) > Financials > Key Stats In Millions of the trading currency, except per share items....

What are the different mechanisms for transferring energy to or from a control volume?

Metlock, Inc. was founded in January 2017. Presented below are adjusted and unadjusted trial balances as at December 31, 2020. Metlock, Inc. Trial Balance December 31, 2020 Cash Accounts receivable...

Which of the following option is true with reference to an operational system? A system that runs business in real time and is based on the current data A system that runs business in real time and...

solve and provide final

LO8.2 Discuss the evidence for the brain being modular, computationally restricted, reliant on heuristics, and prone to various forms of cognitive error.

11. Do people playing the dictator game show only self-interested behavior? How much divergence is there in the splits given by dictators to the other player? LO8.5

LO8.5 Define fairness and give examples of how it affects behavior in the economy and in the dictator and ultimatum games.