Solution:
Calculation of geometric average
Geometric Average=[(1+R1)*(1+R2)*....*(1+Rn)]^1/n-1
Here,
N=total number of year
R1,R2 and Rn =sub period returns for year 1,2 and n
Thus,Geometric Average of
X=[(1+0.0535)*(1+0.0625)*(1+0.0306)*(1+0.1205)*(1+0.1425)*(1+0.0525)*(1-0.0735)+(1+0.095)]^1/8-1
=1.05858-1
=0.05858 or 5.858%
Y=[(1+0.0725)*(1+0.0435)*(1+0.0695)*(1-0.1350)*(1-.1450)*(1+0.18)*(1+0.1950)*(1+0.02)]^1/8-1
=1.03065-1
=0.03065 or 3.065%
Thus correct answer is option C
The following data sets are annual growth rates for two products Calculate Statistics with Excel Y...
The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2018 2019 2020 5.35% 6.25% 3.06% 12.05% 14.25% 5.25% -7.35% 9.50% 7.25% 4.35% 6.95% -13.50% -14.50% 18.00% 19.50% 2.00% 16 Calculate the arithmetic mean average of X and Y a. X 6.05% Y 3.76% b X 5.782% Y 3.245% c X 5.858% Y 3.065% d X 5.425% Y 3.0465% 17 Calculate the geomtric average of X and Y a....
The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2018 2019 2020 5.35% 6.25% 3.06% 12.05% 14.25% 5.25% -7.35% 9.50% 7.25% 4.35% 6.95% -13.50% -14.50% 18.00% 19.50% 2.00% 16 Calculate the arithmetic mean average of X and Y a. X 6.05% Y 3.76% b X 5.782% Y 3.245% C x 5.858% Y 3.065% d X 5.425% Y 3.0465% 17 Calculate the geomtric average of X and Y a....
The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2018 2019 2020 5.35% 6.25% 3.06% 12.05% 14.25% 5.25% -7.35% 9.50% 7.25% 4.35% 6.95% -13.50% -14.50% 18.00% 19.50% 2.00% 20 Calculate the correlation coefficient of X and Y a (1.00000) b (0.08490) Try this Excel Formula c (0.62500) =CORREL(1127:1134,J127:J134) (0.25200)
The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2018 2019 2020 5.35% 6.25% 3.06% 12.05% 14.25% 5.25% -7.35% 9.50% 7.25% 4.35% 6.95% -13.50% -14.50% 18.00% 19.50% 2.00% a 20 Calculate the correlation coefficient of X and Y (1.00000) b (0.08490) Try this Excel Formula с (0.62500) =CORREL(1127:1134,J127:J134) d (0.25200) 21 This type of float causes a decrease in the firm's book balance but no change in its...
The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2018 2019 2020 5.35% 6.25% 3.06% 12.05% 14.25% 5.25% -7.35% 9.50% 7.25% 4.35% 6.95% -13.50% -14.50% 18.00% 19.50% 2.00% 18 Calculate the population standard deviation of X and Y a. X 6.17% Y 11.77% b X 6.36% Y 11.95% C X 6.60% Y 12.58% d x 6.72% Y 12.934% 19 Calculate the sample standard deviation of X and Y...
The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2018 2019 2020 5.35% 6.25% 3.06% 12.05% 14.25% 5.25% -7.35% 9.50% 7.25% 4.35% 6.95% -13.50% -14.50% 18.00% 19.50% 2.00% 18 Calculate the population standard deviation of X and Y a. X 6.17% Y 11.77% b X 6.36% Y 11.95% X 6.60% Y 12.58% d X 6.72% Y 12.934% C 19 Calculate the sample standard deviation of X and Y...