Question: Please solve the probelm below using excel or the formula below with a finance calculator thank you A stock has monthly returns of 15.11%,5.71%,14.59%, and

A stock has monthly returns of 15.11%,5.71%,14.59%, and 29.92%. What is the stock's geometric average return? If you want to use formulas, listed below are some formulas for commonly used Statistics: 1) The Average (or expected value) of data x1,x2,x3,xn is given by: Average==n1i=1nxi 2) The Variance of data x1,x2,x3,,xn is given by: Var=2=n11i=1n(xi)2 Note: the above formula represents a sample from a population. If the whole population is sampled, then the we use n instead of (n-1). The difference is subtle. Uniess otherwise stated, use the formula for a sample from a population 3) The standard deviation is the square root of the Variance. 4) The geometric avarage retum is calculated as: GeomAvg(RA)=i=1n(1+Ri)1=[(1+R1)(1+R2)(1+Rn)]1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
