Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

12th Edition

978-0030243998, 30243998, 324422695, 978-0324422696

Students also viewed these Finance questions