An analyst has collected 2007 data including salary and batting average for major league players….

An analyst has collected 2007 data including salary and batting average for major league players. Examine the data that have been collected. a. Open the Baseball workbook from the Chapter02 folder and save it as Baseball Salary Analysis. b. Create range names for all of the columns in the workbook. c. Sort the data values in descending order of batting average. d. Display only those players whose career batting average is 0.310 or greater. List these players. e. Remove the fi lter, displaying all values in the workbook again. f. Add a new column to the worksheet, displaying the batting

View complete question »An analyst has collected 2007 data including salary and batting average for major league players. Examine the data that have been collected. a. Open the Baseball workbook from the Chapter02 folder and save it as Baseball Salary Analysis. b. Create range names for all of the columns in the workbook. c. Sort the data values in descending order of batting average. d. Display only those players whose career batting average is 0.310 or greater. List these players. e. Remove the fi lter, displaying all values in the workbook again. f. Add a new column to the worksheet, displaying the batting average divided by the player’s salary and multiplied by 1,000,000. g. Sort the worksheet in descending order of the new column you created. Who are the top-ten players in terms of batting average per dollar? Print your results. h. Examine the number of years played in your sorted list. Where does it appear that most of the first-year players lie? What would account for that? (Hint: What are some of the other factors besides batting average that may account for a player’s high salary?) i. Save your workbook and write a report summarizing your observations.

View less »