Question: 1. Below you will find annual return data for six furniture companies for the years 1982 1992. Use these data to calculate the variance-covariance matrix
1. Below you will find annual return data for six furniture companies for the years 1982 1992. Use these data to calculate the variance-covariance matrix of the returns. The remaining exercises refer to the data in the tab Price data on the exercise spreadsheet that accompanies this book. This tab gives three years of price data for six stocks and the S\&P 500 as a surrogate for the market. 1. Beloe wow aill find ammual noen data for aic farsitare ecenpanies for the yan 19621992. Uie the data to calculate the raranse covaiance andris of the metares. that accoeptries this beok. This iab gives thece grar of jospe dain for aik aboks and the SAE 500 an a uunterate for the market. 2. Checpule the nemis of the data and the uatistics for rak of the awets facen melum variasce and itandant deriaice of relien. Wetal 3. Compaie the ampile yariance coyariabce mairie atal the cortiaion eadris for the six iseckix 4. Uie the fanction SIM deftert in the dhapter to ceeppone the sigele-inder variancevova ginace matrix. 5. Corepan the global misimim variance porifolio (GMVP) aiceg the smple variabce: conariance matric. 6. Conpotie the GMVP waing the coestat eorrolaise covaniance eatrix
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
