Please use the monthly price data to solve question a. Please use Microsoft Excel with formulas and steps to determine all of the relevant statistics.

HW 4 Portfolio (1) - Excel HOME INSERT PAGE LAYOUT FORMULAS DATAREVIEW VIEW Foxit PDF Sign in Garamond ,Wrap Text u .b-A, 40 00 Conditional Farmat as Cell nsert Delete Fomat Sort & Find & Filter Select B 1 .E Merge & Center. $. % , . Clear. Formatting Table Styles Edting H64 6 Question a: Below is a table of monthly prices for 6 assets. Please calculate relevant statistics (assuming that what you have is only a sample, i.e. use S when nee Monthly Price Data GLD 12/1/2016 3 164.00 Instructions Problem 1 Problem 2 Prablem 3 READY +90% 10:24 AM Type here to search 11/11/2018 2 HW 4 Portfolio (1) - Excel HOME INSERT PAGE LAYOUT FORMULAS DATAREVIEW VIEW Foxit PDF Sign in Garamond ,Wrap Text u .b-A, 40 00 Conditional Farmat as Cell nsert Delete Fomat Sort & Find & Filter Select B 1 .E Merge & Center. $. % , . Clear. Formatting Table Styles Edting H64 6 Question a: Below is a table of monthly prices for 6 assets. Please calculate relevant statistics (assuming that what you have is only a sample, i.e. use S when nee Monthly Price Data GLD 12/1/2016 3 164.00 Instructions Problem 1 Problem 2 Prablem 3 READY +90% 10:24 AM Type here to search 11/11/2018 2