Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel statistics to back the answers up and show the excel formula. thank you! During the past 9 years, what were the risk

Please use excel statistics to back the answers up and show the excel formula. thank you!

  1. During the past 9 years, what were the risk and return characteristics of stocks, Treasury bills, gold, and bitcoins?

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

1 Date Return 2 01/31/2011 0.0001 3 02/28/2011 0.0001 4 03/31/2011 0.0001 5 04/29/2011 0 6 05/31/2011 0 7 06/30/2011 0 8 07/29/2011 0 9 08/31/2011 0.0001 10 09/30/2011 0 11 10/31/2011 0 12 11/30/2011 0 13 12/30/2011 0 14 01/31/2012 0 15 02/29/2012 0 16 03/30/2012 0 17 04/30/2012 0 18 05/31/2012 0.0001 19 06/29/2012 0 20 07/31/2012 0 21 08/31/2012 0.0001 22 09/28/2012 0.0001 23 10/31/2012 0.0001 24. 11/20/2012 nn01 Notes Stock Market Returns Risk Free Return Ready 1 Date Return 1 Date Date Return 2 01/31/2011 01/31/2011 0.019137 3 02/28/2011 02/28/2011 0.038175 4 03/31/2011 03/31/2011 0.003353 5 04/29/2011 04/29/2011 0.028667 6 05/31/2011 05/31/2011 -0.0149 7 06/30/2011 06/30/2011 -0.018388 8 07/29/2011 07/29/2011 -0.022524 9 08/31/2011 08/31/2011 -0.057498 10 09/30/2011 09/30/2011 -0.084863 11 10/31/2011 10/31/2011 0.11403 12 11/30/2011 11/30/2011 -0.006207 13 12/30/2011 12/30/2011 0.003696 14 01/31/2012 01/31/2012 0.054095 15 02/29/2012 02/29/2012 0.041239 16 03/30/2012 03/30/2012 0.024004 17 04/30/2012 04/30/2012 -0.006806 18 05/31/2012 05/31/2012 -0.065574 19 06/29/2012 06/29/2012 0.038189 20 07/31/2012 07/31/2012 0.010284 21 08/31/2012 08/31/2012 0.026278 22 09/28/2012 09/28/2012 0.026554 22. 10/21/2012 10/31/2012 0011101 Notes Stock Market Returns Ris C E F G B D 1 Date - Return 2 1/31/2011 -0.06242 3 2/28/2011 0.059016 4 3/31/2011 0.014787 5 4/29/2011 0.091817 6 5/31/2011 -0.01789 7 6/30/2011 -0.02315 8 7/29/2011 0.08457 9 8/31/2011 0.122 10 9/30/2011 -0.11052 11 10/31/2011 0.055986 12 11/30/2011 0.018458 13 12/30/2011 -0.1039 14 1/31/2012 0.110454 15 2/29/2012 -0.02359 16 3/30/2012 -0.01686 17 4/30/2012 -0.00204 18 5/31/2012 -0.06262 19 6/29/2012 0.023672 20 7/31/2012 0.010723 21 8/31/2012 0.047858 22 9/28/2012 0.047522 23 10/31/2012 -0.02912 21. 11/30/2012 00022 Notes Stock Market Returns Risk Free Return Gold Returns D E F G I I A B C 1 Date 1 Return 2 1/31/2011 0.733333333 3 2/28/2011 0.653846154 4 3/31/2011 -0.093023256 5 4/30/2011 2.692307692 6 5/31/2011 2.034722222 7 6/30/2011 0.842105263 8 7/31/2011 -0.161490683 9 8/31/2011 -0.392592593 10 9/30/2011 -0.373170732 11 10/31/2011 -0.36770428 12 11/30/2011 -0.086153846 13 12/31/2011 0.430976431 14 1/31/2012 0.289411765 15 2/29/2012 -0.113138686 16 3/31/2012 0 17 4/30/2012 0.018518519 18 5/31/2012 0.046464646 19 6/30/2012 0.283783784 20 7/31/2012 0.406015038 21 8/31/2012 0.086631016 22 9/30/2012 0.219488189 23 10/31/2012 -0.096045198 21.111/20/2012/ 01223211291 Notes Stock Market Returns Risk Free Return Gold Returns Bitcoin Returns 1 Date Return 2 01/31/2011 0.0001 3 02/28/2011 0.0001 4 03/31/2011 0.0001 5 04/29/2011 0 6 05/31/2011 0 7 06/30/2011 0 8 07/29/2011 0 9 08/31/2011 0.0001 10 09/30/2011 0 11 10/31/2011 0 12 11/30/2011 0 13 12/30/2011 0 14 01/31/2012 0 15 02/29/2012 0 16 03/30/2012 0 17 04/30/2012 0 18 05/31/2012 0.0001 19 06/29/2012 0 20 07/31/2012 0 21 08/31/2012 0.0001 22 09/28/2012 0.0001 23 10/31/2012 0.0001 24. 11/20/2012 nn01 Notes Stock Market Returns Risk Free Return Ready 1 Date Return 1 Date Date Return 2 01/31/2011 01/31/2011 0.019137 3 02/28/2011 02/28/2011 0.038175 4 03/31/2011 03/31/2011 0.003353 5 04/29/2011 04/29/2011 0.028667 6 05/31/2011 05/31/2011 -0.0149 7 06/30/2011 06/30/2011 -0.018388 8 07/29/2011 07/29/2011 -0.022524 9 08/31/2011 08/31/2011 -0.057498 10 09/30/2011 09/30/2011 -0.084863 11 10/31/2011 10/31/2011 0.11403 12 11/30/2011 11/30/2011 -0.006207 13 12/30/2011 12/30/2011 0.003696 14 01/31/2012 01/31/2012 0.054095 15 02/29/2012 02/29/2012 0.041239 16 03/30/2012 03/30/2012 0.024004 17 04/30/2012 04/30/2012 -0.006806 18 05/31/2012 05/31/2012 -0.065574 19 06/29/2012 06/29/2012 0.038189 20 07/31/2012 07/31/2012 0.010284 21 08/31/2012 08/31/2012 0.026278 22 09/28/2012 09/28/2012 0.026554 22. 10/21/2012 10/31/2012 0011101 Notes Stock Market Returns Ris C E F G B D 1 Date - Return 2 1/31/2011 -0.06242 3 2/28/2011 0.059016 4 3/31/2011 0.014787 5 4/29/2011 0.091817 6 5/31/2011 -0.01789 7 6/30/2011 -0.02315 8 7/29/2011 0.08457 9 8/31/2011 0.122 10 9/30/2011 -0.11052 11 10/31/2011 0.055986 12 11/30/2011 0.018458 13 12/30/2011 -0.1039 14 1/31/2012 0.110454 15 2/29/2012 -0.02359 16 3/30/2012 -0.01686 17 4/30/2012 -0.00204 18 5/31/2012 -0.06262 19 6/29/2012 0.023672 20 7/31/2012 0.010723 21 8/31/2012 0.047858 22 9/28/2012 0.047522 23 10/31/2012 -0.02912 21. 11/30/2012 00022 Notes Stock Market Returns Risk Free Return Gold Returns D E F G I I A B C 1 Date 1 Return 2 1/31/2011 0.733333333 3 2/28/2011 0.653846154 4 3/31/2011 -0.093023256 5 4/30/2011 2.692307692 6 5/31/2011 2.034722222 7 6/30/2011 0.842105263 8 7/31/2011 -0.161490683 9 8/31/2011 -0.392592593 10 9/30/2011 -0.373170732 11 10/31/2011 -0.36770428 12 11/30/2011 -0.086153846 13 12/31/2011 0.430976431 14 1/31/2012 0.289411765 15 2/29/2012 -0.113138686 16 3/31/2012 0 17 4/30/2012 0.018518519 18 5/31/2012 0.046464646 19 6/30/2012 0.283783784 20 7/31/2012 0.406015038 21 8/31/2012 0.086631016 22 9/30/2012 0.219488189 23 10/31/2012 -0.096045198 21.111/20/2012/ 01223211291 Notes Stock Market Returns Risk Free Return Gold Returns Bitcoin Returns

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_2

Step: 3

blur-text-image_3

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

Personal Finance

Authors: E. Thomas Garman, Raymond Forgue

9th Edition

0618938737, 978-0618938735

More Books

Students also viewed these Finance questions