Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the Average Returns, Variance and Standard Deviation Date Open High Low Close* Adj Close** Aug 01, 2020 100.07 119.48 99.75 110.91 109.06 Jul 01,
Calculate the Average Returns, Variance and Standard Deviation
Date Open High Low Close* Adj Close** Aug 01, 2020 100.07 119.48 99.75 110.91 109.06 Jul 01, 2020 87.42 100.68 84.07 99.59 97.93 Jun 10, 2020 0.55 Dividend Jun 01, 2020 77.02 88.22 75.27 87.27 85.24 May 01, 2020 74.84 87.69 70.71 78.09 76.27 Apr 01, 2020 54.70 80.89 51.71 76.73 74.94 Mar 18, 2020 0.55 Dividend Mar 01, 2020 76.25 81.43 48.11 57.00 55.16 Feb 01, 2020 85.39 91.99 73.34 75.65 73.21 Jan 01, 2020 88.39 91.83 84.53 84.69 81.96 Dec 16, 2019 0.5 Dividend Dec 01, 2019 81.00 89.50 77.05 87.80 84.47 Nov 01, 2019 72.40 83.63 71.89 80.64 77.58 Oct 01, 2019 69.20 75.40 63.52 71.83 69.11 Sep 18, 2019 0.5 Dividend Sep 01, 2019 63.03 69.90 62.48 68.99 65.89 Aug 01, 2019 76.71 77.23 62.04 63.65 60.79 Jul 01, 2019 71.24 78.53 70.91 76.53 73.09 Jun 12, 2019 0.5 Dividend Jun 01, 2019 62.39 69.82 61.58 69.73 66.09 May 01, 2019 74.41 75.53 62.37 62.67 59.40 Apr 01, 2019 71.36 75.91 71.09 74.41 70.52 Mar 19, 2019 0.5 Dividend Mar 01, 2019 69.64 73.34 66.36 71.06 66.87 Feb 01, 2019 59.24 70.73 57.78 68.84 64.78 Jan 01, 2019 52.19 59.54 50.94 59.24 55.75 Dec 10, 2018 0.45 Dividend Dec 01, 2018 66.09 67.56 47.72 52.96 49.47 Nov 01, 2018 70.07 75.11 60.07 64.59 60.33 Oct 01, 2018 79.57 79.82 66.08 70.16 65.53 Sep 17, 2018 0.45 Dividend Sep 01, 2018 79.51 81.66 76.44 79.36 73.70 Aug 01, 2018 75.19 84.37 74.31 79.56 73.88 Jul 01, 2018 74.33 78.79 72.84 75.03 69.68 Jun 13, 2018 0.45 Dividend Jun 01, 2018 68.50 77.97 67.91 74.58 68.84 May 01, 2018 76.21 79.90 67.55 68.25 63.00 Apr 01, 2018 69.87 78.22 67.99 76.53 70.64 Mar 21, 2018 0.45 Dividend Mar 01, 2018 74.45 77.32 66.65 69.99 64.19 Feb 01, 2018 72.57 74.36 65.05 72.44 66.43 Jan 01, 2018 68.26 78.59 66.11 73.06 67.00 Dec 06, 2017 0.34 Dividend Dec 01, 2017 59.75 68.98 58.82 68.47 62.45 Nov 01, 2017 56.18 60.52 52.92 59.61 54.37 Oct 01, 2017 57.11 59.46 54.02 55.98 51.06 Sep 18, 2017 0.34 Dividend Sep 01, 2017 54.44 58.76 51.61 56.96 51.65 Aug 01, 2017 58.60 63.32 53.45 54.26 49.20 Aug 01, 2017 58.60 63.32 53.45 54.26 49.20 Jul 01, 2017 57.87 59.69 52.97 58.34 52.90 Jun 13, 2017 0.34 Dividend Jun 01, 2017 59.36 60.35 54.65 57.33 51.68 May 01, 2017 51.99 61.95 50.29 59.39 53.53 Apr 01, 2017 49.15 52.67 47.68 51.81 46.70 Mar 20, 2017 0.34 Dividend Mar 01, 2017 42.55 49.35 41.67 49.15 43.97 Feb 01, 2017 44.58 46.45 43.27 44.13 39.48 Jan 01, 2017 43.05 45.83 41.79 44.52 39.83 Dec 06, 2016 0.28 Dividend Dec 01, 2016 45.55 49.40 42.34 42.67 37.95 Nov 01, 2016 38.93 47.29 37.10 45.70 40.64 Oct 01, 2016 38.15 40.21 37.62 38.91 34.60 Sep 09, 2016 0.28 Dividend Sep 01, 2016 38.56 39.26 36.51 38.18 33.70 Aug 01, 2016 33.41 40.58 32.02 38.48 33.97 Jul 01, 2016 30.66 33,63 29.79 33.60 29.66 Jun 10, 2016 0.28 Dividend Jun 01, 2016 32.17 32.68 28.76 30.60 26.76 May 01, 2016 32.29 33.22 30.05 32.17 28.13 Apr 01, 2016 32.17 33.66 29.81 32.08 28.06 Mar 15, 2016 0.73 Dividend Mar 01, 2016 32.75 34.95 31.01 32.44 27.75 Feb 01, 2016 27.84 32.83 26.10 32.39 27.71 Jan 01, 2016 29.84 31.20 25.31 27.93 23.89 Dec 08, 2015 0.23 Dividend Dec 01, 2015 31.83 31.89 28.88 30.45 25.85 Nov 01, 2015 35.14 36.51 28.65 31.78 26.98 Oct 01, 2015 37.25 38.12 34.07 35.03 29.74 Sep 11, 2015 0.23 Dividend Sep 01, 2015 35.94 39.10 35.19 37.12 31.32 Aug 01, 2015 32.21 36.94 28.32 36.74 31.00 Date Open High Low Close* Adj Close** Aug 01, 2020 100.07 119.48 99.75 110.91 109.06 Jul 01, 2020 87.42 100.68 84.07 99.59 97.93 Jun 10, 2020 0.55 Dividend Jun 01, 2020 77.02 88.22 75.27 87.27 85.24 May 01, 2020 74.84 87.69 70.71 78.09 76.27 Apr 01, 2020 54.70 80.89 51.71 76.73 74.94 Mar 18, 2020 0.55 Dividend Mar 01, 2020 76.25 81.43 48.11 57.00 55.16 Feb 01, 2020 85.39 91.99 73.34 75.65 73.21 Jan 01, 2020 88.39 91.83 84.53 84.69 81.96 Dec 16, 2019 0.5 Dividend Dec 01, 2019 81.00 89.50 77.05 87.80 84.47 Nov 01, 2019 72.40 83.63 71.89 80.64 77.58 Oct 01, 2019 69.20 75.40 63.52 71.83 69.11 Sep 18, 2019 0.5 Dividend Sep 01, 2019 63.03 69.90 62.48 68.99 65.89 Aug 01, 2019 76.71 77.23 62.04 63.65 60.79 Jul 01, 2019 71.24 78.53 70.91 76.53 73.09 Jun 12, 2019 0.5 Dividend Jun 01, 2019 62.39 69.82 61.58 69.73 66.09 May 01, 2019 74.41 75.53 62.37 62.67 59.40 Apr 01, 2019 71.36 75.91 71.09 74.41 70.52 Mar 19, 2019 0.5 Dividend Mar 01, 2019 69.64 73.34 66.36 71.06 66.87 Feb 01, 2019 59.24 70.73 57.78 68.84 64.78 Jan 01, 2019 52.19 59.54 50.94 59.24 55.75 Dec 10, 2018 0.45 Dividend Dec 01, 2018 66.09 67.56 47.72 52.96 49.47 Nov 01, 2018 70.07 75.11 60.07 64.59 60.33 Oct 01, 2018 79.57 79.82 66.08 70.16 65.53 Sep 17, 2018 0.45 Dividend Sep 01, 2018 79.51 81.66 76.44 79.36 73.70 Aug 01, 2018 75.19 84.37 74.31 79.56 73.88 Jul 01, 2018 74.33 78.79 72.84 75.03 69.68 Jun 13, 2018 0.45 Dividend Jun 01, 2018 68.50 77.97 67.91 74.58 68.84 May 01, 2018 76.21 79.90 67.55 68.25 63.00 Apr 01, 2018 69.87 78.22 67.99 76.53 70.64 Mar 21, 2018 0.45 Dividend Mar 01, 2018 74.45 77.32 66.65 69.99 64.19 Feb 01, 2018 72.57 74.36 65.05 72.44 66.43 Jan 01, 2018 68.26 78.59 66.11 73.06 67.00 Dec 06, 2017 0.34 Dividend Dec 01, 2017 59.75 68.98 58.82 68.47 62.45 Nov 01, 2017 56.18 60.52 52.92 59.61 54.37 Oct 01, 2017 57.11 59.46 54.02 55.98 51.06 Sep 18, 2017 0.34 Dividend Sep 01, 2017 54.44 58.76 51.61 56.96 51.65 Aug 01, 2017 58.60 63.32 53.45 54.26 49.20 Aug 01, 2017 58.60 63.32 53.45 54.26 49.20 Jul 01, 2017 57.87 59.69 52.97 58.34 52.90 Jun 13, 2017 0.34 Dividend Jun 01, 2017 59.36 60.35 54.65 57.33 51.68 May 01, 2017 51.99 61.95 50.29 59.39 53.53 Apr 01, 2017 49.15 52.67 47.68 51.81 46.70 Mar 20, 2017 0.34 Dividend Mar 01, 2017 42.55 49.35 41.67 49.15 43.97 Feb 01, 2017 44.58 46.45 43.27 44.13 39.48 Jan 01, 2017 43.05 45.83 41.79 44.52 39.83 Dec 06, 2016 0.28 Dividend Dec 01, 2016 45.55 49.40 42.34 42.67 37.95 Nov 01, 2016 38.93 47.29 37.10 45.70 40.64 Oct 01, 2016 38.15 40.21 37.62 38.91 34.60 Sep 09, 2016 0.28 Dividend Sep 01, 2016 38.56 39.26 36.51 38.18 33.70 Aug 01, 2016 33.41 40.58 32.02 38.48 33.97 Jul 01, 2016 30.66 33,63 29.79 33.60 29.66 Jun 10, 2016 0.28 Dividend Jun 01, 2016 32.17 32.68 28.76 30.60 26.76 May 01, 2016 32.29 33.22 30.05 32.17 28.13 Apr 01, 2016 32.17 33.66 29.81 32.08 28.06 Mar 15, 2016 0.73 Dividend Mar 01, 2016 32.75 34.95 31.01 32.44 27.75 Feb 01, 2016 27.84 32.83 26.10 32.39 27.71 Jan 01, 2016 29.84 31.20 25.31 27.93 23.89 Dec 08, 2015 0.23 Dividend Dec 01, 2015 31.83 31.89 28.88 30.45 25.85 Nov 01, 2015 35.14 36.51 28.65 31.78 26.98 Oct 01, 2015 37.25 38.12 34.07 35.03 29.74 Sep 11, 2015 0.23 Dividend Sep 01, 2015 35.94 39.10 35.19 37.12 31.32 Aug 01, 2015 32.21 36.94 28.32 36.74 31.00Step 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