Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the stocks column use Microsoft not John Deere Only want the first question answered thank you! with excel formulas will thumbs up right away

image text in transcribedimage text in transcribed

For the stocks column use Microsoft not John Deere

Only want the first question answered thank you! with excel formulas

will thumbs up right away

Question 1 T-Bills T-bonds Stock Mean Std Dev (6) Question 2 T-bonds Stock Risk Premium Sharpe Ratio Question 3 The correlation between T-bonds and stock Year T-Bills T-bonds 1990 7.81 1991 5.6 1992 3.51 1993 2.9 1994 3.9 1995 5.6 1996 5.21 1997 5.26 1998 4.86 1999 4.68 2000 5.89 2001 3.7786 2002 1.6339 2003 1.0182 2004 1.2005 2005 2.9633 2006 4.7855 2007 4.6747 2008 1.4742 2009 0.0966 2010 0.1216 2011 0.0428 2012 0.0565 2013 0.0277 2014 0.0164 2015 0.0092 2016 0.1886 6.872 17.9336 9.0548 13.4198 -6.4083 23.9541 0.9946 11.312 13.094 -8.4734 14.4891 4.0302 14.6641 1.2778 5.1862 3.103 2.2713 9.6431 17.6664 -5.8278 7.4457 16.6015 3.5862 -6.9025 10.1512 1.0665 0.7039 Stock Microsoft Deere 72.98843 -21.2467376 121.7608 6.514506978 15.11233 -4.631781862 -5.563729 75.39714234 51.62806 -7.939947937 43.55822 78.47182299 88.31913 18.36868681 56.42965 46.25551397 114.6036 -42.4944685 68.36411 35.15105525 -62.84799 8.165293008 52.7378 -2.542284746 -21.96227 7.107994981 6.816497 44.60718032 9.128112 16.23089027 -0.938235 -6.780881536 15.83933 42.43671912 20.84288 99.02671827 -44.38561 -58.24889897 60.46717 45.18986474 -6.524608 56.46319907 -4.51569 -5.079742987 5.798868 14.27506291 44.29801 8.190922767 27.56459 -0.651351811 22.69186 -11.35428569 15.07774 39.20808187 1. Calculate the sample mean standard deviation for the following assets: 3-month Treasury bills (T-bills) 10-year Treasury bonds (T-bonds)

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

Finance And Sustainability Proceedings From The Finance And Sustainability Conference Wroclaw 2017

Authors: Agnieszka Bem, Karolina Daszy?ska-?ygad?o , Ta?ána Hajdíková, Péter Juhász

1st Edition

3319922270,3319922289

More Books

Students also viewed these Finance questions