Question

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%

Answer 1

Solution:

Solving question first as HOMEWORKLIB's guidelines:

1.Calculation of arithmatic mean

Arithmatic Mean=Sum of returns/No. of years

Arithmatic Mean of X

=5.35+6.25+3.06+12.05+14.25+5.25+(-7.35)+9.50/8

=6.045% or 6.05%

Aritmatic Mean of Y

=7.25+4.35+6.95+(-13.50)+(-14.50)+18+19.50+2/8

=3.75625% or 3.76%

Thus correct answer is option A