Question
Month(yy/mm/dd) Price Market price 2003/12/31 43.73 1111.92 2004/1/2 42.43 1131.13 2004/2/2 43.05 1144.94 2004/3/1 43.56 1126.21 2004/4/1 43.80 1107.30 2004/5/3 44.47 1120.68 2004/6/1 43.93 1140.84
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Datas are shared above. Please help me its very urgent. I am posting it for 4th time
Please use the spreadsheet labeled "HW3Prob4Data-new.xls". There are three columns of data: a monthly date, a closing price for an individual stock, and the market close. 4. a) Calculate a monthly retum series from the closing monthly prices of both the market and the individual security b) Calculate the arithmetic mean return and the standard deviation of the monthly returm for both series. monthly retum for both serie:s c) Calculate the geometric mean return for both series. d) Calculate the beta of the individual security WE have the following DatasStep 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