Homework Answers
20. The excel data and results are as given below
| year | X | Y |
| 2013 | 5.35% | 7.25% |
| 2014 | 6.25% | 4.35% |
| 2015 | 3.06% | 6.95% |
| 2016 | 12.05% | -13.50% |
| 2017 | 14.25% | -14.50% |
| 2018 | 5.25% | 18.00% |
| 2019 | -7.35% | 19.50% |
| 2020 | 9.50% | 2.00% |
| Correlation coefficient | -0.849372501 |
The correlation coefficient is -0.84937
Add Answer to:
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...
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% 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% 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...
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% 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 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% 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...
Most questions answered within 3 hours.
-
The average length of time between arrivals at a turnpike
toll-booth is 26 seconds. What is...
asked 45 minutes ago -
(a) A piston at 6.1 atm contains a gas that occupies a volume of
3.5 L....
asked 1 hour ago -
Please answer true or false. Words
cannot be changed or added in to make it true...
asked 1 hour ago -
An empty test tube weighs 15.923 grams. Then,
MgCl2•6H2O is added into the test tube. After...
asked 1 hour ago -
Assume memory access is 10 units of time and disk access is
10000 units of time....
asked 2 hours ago -
1. Are all good samples random?
2. Magazines often report surveys giving statistics such as “63%...
asked 2 hours ago -
Under all the various types of market structures, firms
must eventually earn some economic profits for...
asked 2 hours ago -
Consider the following fitness regime for a single locus trait
with two co-dominant alleles: w11 =...
asked 2 hours ago -
A large cable company reports the following.
80% of its customers subscribe to its cable TV...
asked 2 hours ago -
Please answer the question in brief.
Discuss the role of ERP in organizations. Are ERP tools...
asked 2 hours ago -
Discuss the pros and cons of collaborative software such
as SameTime. Does it increase productivity? What...
asked 2 hours ago -
Buying your in-laws a gift because it’s expected is
due to the ____________ motive of gift-giving....
asked 2 hours ago