Moneyball project instructions | Economics homework help

  The paper should be typed, 12 pt. font, double spaced, and the whole assignment in one single PDF file, including copies of all supporting material identified below. Do not ask me to accept assignments that are not combined, and please do not exceed the space limit of four written pages–my grading will stop there. 

 

This project does not require an intimate knowledge of baseball or even econometrics, but you should be familiar with many aspects of the game. The project below will ANALYZE the most recent season and how it impacts player pay for this upcoming season. You will assume the role of General Manager trying to decide which players to select for the 2018 season using their performance in the 2017 season. Your analysis will be based on a simplified version of the methods described in the article “An Economic Evaluation of the Moneyball Hypothesis.” 

Your analysis will use statistics from the previous season to predict salaries/performance for the current regular season. Be very careful that you are using the correct seasons on the website below. Once the MLB season begins, the websites will update based on current performance. Ensure that the pages below show you the right season for analysis. Do not use data from Spring Training or Postseason. You’ll want to use the regular season statistics only.

Six web sites will be of use in doing so. I have included the data years you will need to analyze. Be sure the data source is correctly visible:

1. https://www.spotrac.com/mlb/free-agents/batters/signed/

2.http://www.baseball-almanac.com/players/ballplayer.shtml

3. http://www.espn.com/mlb/stats/team/_/stat/batting

4. http://www.espn.com/mlb/attendance/_/year/

5. http://www.espn.com/mlb/standings/_/year/

6.  2017 doc.

Here is what to do: 

Read the Hakes & Sauer (2006) paper and focus on the process of valuing baseball players. You should also read the FiveThirtyEight article to understand why this process was so revolutionary. You will be asked to summarize both of these articles in your final write-up. Afterward, begin collecting data using Microsoft Excel. Collecting your data in a single Excel file with different tabs for the Teams Sheet and Players Sheet. If you do not read the articles, it will be obvious when you try writing your paper.

Teams Sheet Tab:

The first sheet will relate the teams’ effectiveness to winning and revenue. We will use this information to determine the value of winning for a team. This performance analysis should be conducted for the 2017 season

  1. Obtain team OBP and SLG from the team batting database above, along with total home attendance, winning percentage, and the average team ticket price from the appropriate links.
  2. Put the team name in the first column of the sheet, their regular season winning percentage in the second column, OBP in the third column, SLG in the fourth, and leave the fifth column blank for now. Then put total home attendance in the sixth column, ticket price in the seventh column, and calculate total team ticket revenue and put that in the eighth column.
  3. The “Economic Evaluation” article indicated that OBP was twice as important as SLG in producing runs and wins. Thus, create a simple “index” of offensive production, 100*(2*OBP + SLG), and put that in your fifth column. Multiplying by 100 just makes the numbers easier to read and interpret.
  4. Create a scatterplot that relates the index you have just created, on the x-axis, to the team’s revenue, on the y-axis. Include the Excel trendline and display the equation of the trendline (this is an option in the chart design / layout tab). There is a visual “outlier” in your data, remove that team from your charts, but not your data table. Leave the outlying team out of all your team analyses. The slope of the trendline tells you how much each additional point of the index would be worth in revenue, in dollars. Use the coefficient estimate on the trendline as your estimate the value of increases in the index of team offensive production. What is the impact of a one-unit increase in team index on total revenue?
  5. Create another scatterplot that relates the index you have just created, on the x-axis, to the team’s winning percentage, on the y-axis. Include the Excel trendline and the equation, as before. If the index increases by 1, how much does the team’s winning percentage increase by?
  6. Create another scatterplot of win percentage (x-axis) and revenue (y-axis), and include the Excel trendline and the equation, as before. If the team’s winning percentage increases by 0.01, how much does the team’s revenue increase by?

Player Sheet Tab:

The second sheet of your spreadsheet will have you calculate an individual player’s marginal product and then relate salaries to player effectiveness. 

  1. Download the list of free agentsPreview the document for the start of the 2018 season and choose 20 players at random. (All pitchers should have been taken off the list.) Work out a process you will use to pick your players it should be a random process and use it to choose your 20. Please describe this process in your write-up. The list shows all players eligible for free agency (Links to an external site.)Links to an external site.. Make sure your 20 players have at 1 year of MLB experience and are signed for the 2018 season. The list includes everyone eligible to play, but it doesn’t mean all of them will be “hired” for the 2018 season.
  2. Put the player name in the first column, their 2016 on-base percentage in the second column, their 2016 slugging percentage in the third column, their 2017 on-base percentage in the fourth column, their 2017 slugging percentage in the fifth column, and their 2018 average salary in the sixth column.
  3. In the seventh and eighth columns, calculate the player’s index of offensive production for 2016 and 2017, just as you did above for the team. In the ninth and tenth column, calculate the player’s “marginal product” for the 2016 and 2017 season. The marginal product of a player will be the amount that they increase the team’s offensive index, instead of a player at the “Mendoza Line” of a .250 OBP and .300 SLG. Recognizing that the average starter takes about 1/10 of all of the team’s at-bats, calculate the difference between each player’s index and the index of the Mendoza Line player, and then divide this by ten. 
  4. Now, in the last column, compute that player’s marginal revenue product (MRP), the extra revenue the player brings in for the team, but only for the 2017 season. MRP is the value of the player’s marginal product and the value of increases in that marginal product, which you calculated on the previous sheet, plus the league minimum of $550,000, for which we assume any team can get a player at the Mendoza Line. Hint: A Mendoza Player would have an MRP of $550,000. 
  5. First, make a scatterplot relating a players 2016 index (x-axis) to their 2017 index (y-axis). Use the correlation function in Excel (CORREL) to compute the correlation between all players’ performance leading up to their free agency year. Based on the calculation, how closely are the two connected? Summarize the Scorecasting excerpt related to batting averages and player effort. Do your results seem to indicate a similar pattern happened for your player in regards to “strategic effort”?
  6. Make a scatterplot of your player’s 2017 MRP (their predicted salary) and the players’ actual salary for 2018. Again, use the correlation function in Excel (CORREL) to compute the correlation between all of the players’ MRP and their salaries. Based on your calculation, how closely are the two related? Why might MRP calculations not be perfect predictors of future salaries?

Your Write Up:

Write out, in four double-spaced, typewritten pages, 1) what you did, including writing out any formulas you utilized in your spreadsheets; 2) why you did the items that you did, including an explanation and justification of the formulas you used; and 3) answer questions above and 4) summarize with a conclusion on the correlation between estimated MRP and salary. For an introduction, you should summarize the FiveThirtyEight article. 

To write out the formulas, you may use traditional algebraic notation or copy the Excel formulas out of your spreadsheet. Include a References page (APA or MLA) for any material that is referenced in the paper, including data sources provided above. Include an Appendix after your references that has your data and graphs nicely presented. The work in your Reerences and Appendix does not count against your four-page limit.

Everything should be combined together into a single PDF file and follow the formatting specified at the top of this assignment. Take care to make your data & graphs clear and visually pleasing: in business, presentation matters. Screenshots of data and graphs will be considered unprofessional.

As with all assignments, you are invited to come see me during office hours with questions. Please get started early, that gives you time to work through any complications you may run into.

Essay Help
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.