Part 3
For the following questions, please prepare an Excel file (Document
3) showing how to calculate the answer.
Calculate the mean, median and mode for Worksheet 1 for each of
the following data series for home runs, strikeouts and batting
average:
2008 AL
2008 NL
2009 AL
2009 NL
2018 AL
2018 NL
2019 AL
2019 NL
Calculate the standard deviation for Worksheet 1 for each of
the following data series for home runs, strikeouts and batting
average:
2008 AL
2008 NL
2009 AL
2009 NL
2018 AL
2018 NL
2019 AL
2019 NL
Calculate the correlation coefficient for Worksheet 1 between
home runs and strikeouts for each of the following data
series
2008 AL
2008 NL
2009 AL
2009 NL
2018 AL
2018 NL
2019 AL
2019 NL
Calculate the correlation coefficient for Worksheet 1 between
home runs and batting average for each of the following data
series
2008 AL
2008 NL
2009 AL
2009 NL
2018 AL
2018 NL
2019 AL
2019 NL
Create a graph that shows average home runs in linear sequence
by league. There should be two lines. The vertical axis should show
average home runs and the horizontal axis should show year.
Create a graph that shows the standard deviation of home runs
in linear sequence by league. There should be two lines. The
vertical axis should show average standard deviation and the
horizontal axis should show year.
Create a graph that shows the correlation coefficient between
home runs and strikeouts in linear sequence by league. There should
be two lines. The vertical axis should show correlation coefficient
and the horizontal axis should show year.
For the following questions, please submit a word file (Document
4) that responds to each of the three questions.
In a brief paragraph or two, discuss your observations above in
answering the question of whether there has been an increase in
home runs as well as potential explanations as to why.
In a brief paragraph or two, explain how can data and data
analytics help in answering questions?
Can the same concepts be applied in a business setting? Can you
provide a potential business question within your own work sphere
where TVM principles and/or data analytics can be helpful?