Question

1 Approved Answer

Posted on Jul 10, 2024

Please use excel formulas and statistics to back up answers if needed. Thank you! For stock investors, do Treasury bills, gold, or bitcoin provide the

Please use excel formulas and statistics to back up answers if needed. Thank you!

For stock investors, do Treasury bills, gold, or bitcoin provide the best diversification benefits? Rank these assets based on their diversification benefits to stock investors.

image text in transcribed

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