1. Business
  2. Economics
  3. western university has only one womens softball scholarship remaining for...

Question: western university has only one womens softball scholarship remaining for...

Question details

Western University has only one womens softball scholarship remaining for the coming year. The final two players that Western is considering are Allison Fealey and Emily Janson. The coaching staff has concluded that the speed and defensive skills are virtually identical for the two players, and that the final decision will be based on which player has the best batting average.Crosstabulations of each players batting performance In thelr junlor and senlor years of hlgh school are as follows: Excel File: data02-51.xlsx Allison Fealey Junior Senior Emily Janson Junior Senior Outcome Hit No Hit Total At-Bats 15 25 40 Outcome Hit No Hit Total At-Bats 75 175 70 130 200 35 85 120 A players batting average is computed by dividing the number of hits a player has by the total number of at-bats. Batting averages are represented as a decimal number with three places after the decimal a. Calculate the batting average for each player in her junior year Allison Fealey Emily Janson Calculate the batting average of each player In her senior year. Junior 0.37 0.35 Allison Fealey Emily Janson Whlch player should be awarded the scholarshlp? Senior 0.30 0.29 Allison Fealey Explain The input in the box below will not be graded, but may be reviewed and considered by your instructor Allison Fealey should be awarded scholarship since her batting average in both years is higher than Emily Janson.b. Combine or aggregate the data for the junior and senior years into one crosstabulation as follows: Combined 2-Year Batting Outcome Hit No Hit A. Fealey 85 155 E. Janson 110 260 Total At Bats 240 370 Calculate each players batting average for the combined two years Junior/Senior Years Allison Fealey 0.35 Emily Janson 0.34 Which player should be awarded the scholarship? Allison Fealey Explain The input in the box below will not be graded, but may be reviewed and considered by your instructor. Allison Fealey should be awarded scholarship since her batting average in combined years is higher than Emily Janson. c. Are the recommendations you made in parts (a) and (b) consistent? Yes Explain any apparent inconsistencies The input in the box below will not be graded, but may be reviewed and considered by your instructon Allison Fealey received scholarship in both cases so the recommendations in parts (a) and (b) is same

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution