The following data sets are annual growth rates for two products Calculate Statistics with Excel Y...

Question

Question

The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2

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

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

A C D X 00 1 Year х Y 2 2013 5.35% 7.25% 3 2014 6.25% 4.35% 4 2015 3.06% 6.95% 5 2016 12.05% -13.50% 6 2017 14.25% - 14.50% 7

Population Standard Deviation = X 6.17%; Y 11.77% (Option a)

Sample Standard Deviation = X 6.60%; Y 12.58% (Option c)

Add a comment

Answer 2

Similar Homework Help Questions

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% 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...

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...

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% 17 Calculate the geomtric 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%

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...

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...

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...

Homework Answers