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...

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)
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
Show entire document

### 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.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents