CaseQuiz#7 Example.docxDownload CaseQuiz#7 Example.docx

Case Quiz Normal Distribution Instructions.pdfDownload Case Quiz Normal Distribution Instructions.pdf

Moneyball.xlsxDownload Moneyball.xlsx

Instructions - DSCI 2710 Case Quiz Normal Distribution

Introduction

For this case quiz you will be required to make a written response to one of the questions and you will need to write at least two paragraphs explaining the analysis that you conducted and the conclusions that you made from the results. You are allowed to use the spreadsheet during the quiz and will need it to answer the questions in the quiz. The purpose of this case study is to explain the analysis that you conducted and the conclusions that you made based on the results of your analysis.



Data and Data Analysis
This dataset is a collection of season recaps of Major League Baseball seasons from 1962-2012. This dataset comes from baseball-reference.com which claims to be the ‘complete source for current and historical baseball players, teams, scores, and leaders’. This collection of statistics contains variables like Runs Scored, Runs Allowed, On Base Percentage, etc.

Instructions

You will have the option to choose one of the scenarios related to the for your case study. You are asked to pick a baseball team or year in accordance with the scenario that you choose of the options below. There are two options and you only need to formulate a response for one of the scenarios to receive full points on the assignment. You must submit original work for your submission to be accepted for a grade. Choose only ONE scenario to write on as you will only receive credit for one scenario and no extra credit will be rewarded for answering more than one. To receive full credit for your response, you must:

Provide a well-written response to the prompt that is at least two paragraphs in length and no more than one page. This must be your original submission and reflect your understanding of the course material and the analysis that you performed.
(30 pts) A detailed explanation of the calculations (equations, statistics tables/distributions, and excel functions) that you did.
Use Excel functions =AVERAGE() and =STDEV(), S.DIST(), etc. to compute the needed components for the equations in your analysis. You may also use filtering, pivot tables and the DATA > DATA ANALYSIS > DESCRIPTIVE STATISTICS macro in Excel to obtain these statistics.
(25 pts) A clear and concise recommendation regarding the scenario that displays your ability to conduct data analysis and apply it to realworld applications.
Select a team based on your last name (surname):
If the first letter of your last name is A-F, then you will choose one team from the ‘League’: AL and ‘Team’: with a city starting with the letters A-L
If the first letter of your last name is G-L, then you will choose one team from the ‘League’: AL and ‘Team’: starting with the letters M-Z
If the first letter of your last name is M-R, then you will choose one team from the ‘League’: NL and ‘Team’: starting with the letters A-L
If the first letter of your last name is S-Z, then you will choose one team from the ‘League’: NL and ‘Team’: starting with the letters M-Z
EXAMPLE: Hamilton ‘League’: AL “Team”: TEX



Scenarios : Only choose ONE of the following options:

S1: You are asked to advise a baseball team that is exploring the idea of a rebuild through draft picks. To conduct this type of rebuild, the team needs to look at their standings compared to the rest of the league and be in the bottom 10 percent of teams in number of wins in order to be in the lottery for the first pick in the next season’s draft. Use the year that you were born and calculate where your team falls on the normal distribution of wins (percentage or area under the curve, not ranking) and determine the number of wins that would have made them in the bottom 10%. Give an argument for why or why not ‘tanking’ would be a good strategy for the team if you were asked about this at the beginning of the season.



S2: You are a baseball statistician/analyst looking at your team and you want to determine if historically Runs Scored, Runs Allowed or On Base Percentage contribute more to the number of wins in the season for your team. Present your calculations and make an argument for one of the variables (RS, RA,OBP) to be the focus for the team in the coming season.