Using the 2014 financial statements from your stocks above and the equations fro

Question

Using the 2014 financial statements from your stocks above and the equations from your textbook, prepare the Historical Average and Standard Deviation for each stock.

So I need to find the historical average of the stock prices listed and the standard deviation for each company using the stock prices listed.

Verizon's Monthly Stock Prices:

1/1/2015 45.71

1-Feb 49.45

1-Mar 48.63

1-Apr 50.44

1-May 49.44

1-Jun 46.61

1-Jul 46.79

1-Aug 46.01

1-Sep 43.51

1/1/2016 49.97

1-Feb 50.73

1-Mar 54.08

1-Apr 50.94

1-May 50.9

1-Jun 55.84

1-Jul 55.41

1-Aug 52.33

1-Sep 51.98

Google's Monthly Stock Prices

1/1/2015 531.5946

1-Feb 555.3439

1-Mar 545.0009

1-Apr 537.34

1-May 532.11

1-Jun 520.51

1-Jul 625.61

1-Aug 637.61

1-Sep 608.42

1/1/2016 742.95

1-Feb 697.77

1-Mar 744.95

1-Apr 693.01

1-May 735.72

1-Jun 692.1

1-Jul 768.79

1-Aug 767.05

1-Sep 777.29

Explanation / Answer

Verizone Monthly stock price

Day

Monthly stock price (closing)

(monthly stock price-average monthly price)

square of (monthly stock price-historical average monthly price

1/1/2015

45.71

-4.22167

17.82247

2/1/2015

49.45

-0.48167

0.232003

3/1/2015

48.63

-1.3016

1.694163

4/1/2015

50.44

0.5084

0.258471

5/1/2015

49.44

-0.4916

0.241671

6/1/2015

46.61

-3.3216

11.03303

7/1/2015

46.79

-3.1416

9.869651

8/1/2015

46.01

-3.9216

15.37895

9/1/2015

43.51

-6.4216

41.23695

1/1/2016

49.97

0.0384

0.001475

2/1/2016

50.73

0.7984

0.637443

3/1/2016

54.08

4.1484

17.20922

4/1/2016

50.94

1.0084

1.016871

5/1/2016

50.9

0.9684

0.937799

6/1/2016

55.84

5.9084

34.90919

7/1/2016

55.41

5.4784

30.01287

8/1/2016

52.33

2.3984

5.752323

9/1/2016

51.98

2.0484

4.195943

Historial average monthly price = USING AVERAGE FUNCTION IN ms EXCEL

49.93167

square root of sum of (monthly stock price-historial average monthly price)

192.4405

Standard deviation

square root of sum of (monthly price-historial average monthly price)

13.87229

google stock price

Day

Monthly stock price (closing)

(monthly stock price-average monthly price)

square of (monthly stock price-historial average monthly price

1/1/2015

531.5946

-119.137

14193.63

2/1/2015

555.3439

-95.3877

9098.82

3/1/2015

545.0009

495.0693

245093.6

4/1/2015

537.34

487.4084

237566.9

5/1/2015

532.11

482.1784

232496

6/1/2015

520.51

470.5784

221444

7/1/2015

625.61

575.6784

331405.6

8/1/2015

637.61

587.6784

345365.9

9/1/2015

608.42

558.4884

311909.3

1/1/2016

742.95

693.0184

480274.5

2/1/2016

744.95

647.8384

419694.6

3/1/2016

697.77

643.0784

413549.8

4/1/2016

693.01

685.7884

470305.7

5/1/2016

735.72

642.1684

412380.3

6/1/2016

692.1

718.8584

516757.4

7/1/2016

768.79

717.1184

514258.8

8/1/2016

767.05

-116.318

13529.96

9/1/2016

777.29

727.3584

529050.2

Historial average monthly price = USING AVERAGE FUNCTION IN ms EXCEL

650.7316

square root of sum of (monthly stock price-historial average monthly price)

5718375

Standard deviation

square root of sum of (monthly price-historial average monthly price)

2391.312

Verizone Monthly stock price

Day

Monthly stock price (closing)

(monthly stock price-average monthly price)

square of (monthly stock price-historical average monthly price

1/1/2015

45.71

-4.22167

17.82247

2/1/2015

49.45

-0.48167

0.232003

3/1/2015

48.63

-1.3016

1.694163

4/1/2015

50.44

0.5084

0.258471

5/1/2015

49.44

-0.4916

0.241671

6/1/2015

46.61

-3.3216

11.03303

7/1/2015

46.79

-3.1416

9.869651

8/1/2015

46.01

-3.9216

15.37895

9/1/2015

43.51

-6.4216

41.23695

1/1/2016

49.97

0.0384

0.001475

2/1/2016

50.73

0.7984

0.637443

3/1/2016

54.08

4.1484

17.20922

4/1/2016

50.94

1.0084

1.016871

5/1/2016

50.9

0.9684

0.937799

6/1/2016

55.84

5.9084

34.90919

7/1/2016

55.41

5.4784

30.01287

8/1/2016

52.33

2.3984

5.752323

9/1/2016

51.98

2.0484

4.195943

Historial average monthly price = USING AVERAGE FUNCTION IN ms EXCEL

49.93167

square root of sum of (monthly stock price-historial average monthly price)

192.4405

Standard deviation

square root of sum of (monthly price-historial average monthly price)

13.87229

google stock price

Day

Monthly stock price (closing)

(monthly stock price-average monthly price)

square of (monthly stock price-historial average monthly price

1/1/2015

531.5946

-119.137

14193.63

2/1/2015

555.3439

-95.3877

9098.82

3/1/2015

545.0009

495.0693

245093.6

4/1/2015

537.34

487.4084

237566.9

5/1/2015

532.11

482.1784

232496

6/1/2015

520.51

470.5784

221444

7/1/2015

625.61

575.6784

331405.6

8/1/2015

637.61

587.6784

345365.9

9/1/2015

608.42

558.4884

311909.3

1/1/2016

742.95

693.0184

480274.5

2/1/2016

744.95

647.8384

419694.6

3/1/2016

697.77

643.0784

413549.8

4/1/2016

693.01

685.7884

470305.7

5/1/2016

735.72

642.1684

412380.3

6/1/2016

692.1

718.8584

516757.4

7/1/2016

768.79

717.1184

514258.8

8/1/2016

767.05

-116.318

13529.96

9/1/2016

777.29

727.3584

529050.2

Historial average monthly price = USING AVERAGE FUNCTION IN ms EXCEL

650.7316

square root of sum of (monthly stock price-historial average monthly price)

5718375

Standard deviation

square root of sum of (monthly price-historial average monthly price)

2391.312

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.