Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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.89Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started