View the step-by-step solution to:

MGT150B - Spring 2013 - Homework #2 MGT150B - Spring 2013 Homework #2 A few important notes A. There are practice problems with solutions on...

This question was answered on Jan 29, 2013. View the Answer
looking for answers for part #2
MGT150B - Spring 2013 - Homework #2 [1] MGT150B – Spring 2013 Homework #2 A few important notes A. There are practice problems with solutions on Blackboard. Please work through those problems first, before tackling the homework assignment. B. Homework is graded for both correctness and neatness. Your spreadsheet should be easy to understand, well laid out, and presented in a professional manner. If there is anything you think might be ambiguous in your presentation or solution – explain it! C. Submit the spreadsheet with answers both on Blackboard, AND bring a hardcopy to class. However, the softcopy may not be evaluated. Part 1: The Pythagorean Expectation formula in Baseball In the past few years there is substantial interest in sabremetrics, the use of non-traditional metrics to evaluate the quality of a baseball players and teams. Among these measures, the Pythagorean Expectation formula was derived by Bill James (modified by baseball-refernce.com). The formula states that the number of wins for a team depends solely on the number of runs scored and the number of runs allowed. The formula is: 1.82 1.82 1.82 RS Wins RS RA = + Where: RS – Runs Scored RA – Runs Allowed The St. Louis Cardinals, in the 162 games of the regular 2012 season, scored 765 runs while allowing 648 runs. 1) For next year, the Cardinals plan on making changes to their pitching staff. Assuming that the number of runs scored stays the same, find the relationship between the number of Runs Allowed and expected number of wins, rounded to the nearest whole number. Use values of 500 – 900 for the numbers of runs allowed, in increments of 25. Solution: Setting up the spreadsheet: Make sure that you properly organize your cells with good labels. Using differently colored fills for the cells for inputs and outputs, i.e. yellow for parameters and blue for results, is common. Add a parameter for 1.82 in cell C7 (or move everything else)
Background image of page 1
MGT150B - Spring 2013 - Homework #2 [2] Please complete this solution in the same format. Please show the formula in each cell. You should use Named Ranges (cells) for the parameters of the model. Show those, too. 2) Using the Pythagorean Expectation formula, develop a table that shows the relationship between Runs Allowed, Runs Scored and the expected number of wins (rounded to the nearest whole number). Both Runs Allowed and Runs Scored should be between 500 – 900, in increments of 25. Vary Runs Allowed in the top row, and Runs Scored down the left column a. It is widely believed that winning 90 games in a season guarantees a spot in the playoffs. Use conditional formatting to identify those combinations that generate at least 90 wins. Highlight the relevant cells with bold and a blue background. Please show the formula in each cell. You should use Named Ranges (cells) for the parameters of the model. Show those, too. RA Fraction NumGames RS
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

If you are satisfied now, please... View the full answer

This question was asked on Jan 26, 2013 and answered on Jan 29, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards