Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Please solve the probelm below using excel or the formula below with a finance calculator thank you
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions