Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Return of Asset 1 and 2 Date Asset 1 31-Dec-2006 12.56% 31-Dec-2007 13.50% 31-Dec-2008 14.23% 31-Dec-2009 15.23% 31-Dec-2010 14.23% 31-Dec-2011 12.23% 31-Dec-2012 10.23% 31-Dec-2013 5.26%
Return of Asset 1 and 2 Date Asset 1 31-Dec-2006 12.56% 31-Dec-2007 13.50% 31-Dec-2008 14.23% 31-Dec-2009 15.23% 31-Dec-2010 14.23% 31-Dec-2011 12.23% 31-Dec-2012 10.23% 31-Dec-2013 5.26% 31-Dec-2014 4.25% 31-Dec-2015 2.23% Q1.1 Average return Return variance Covariance Asset 2 7.56% 8.56% 4.56% 2.12% 1.23% 0.26% 3.25% 4.89% 5.56% 6.45% 10.40% 4.44% 0.00224 0.00074
write the excel function to find the covariance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started