Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: USING EXCEL FOR DECISION SUPPORT
Did the strike zone change appear to decrease offensive performance this year?
Use the Totals rows in the data tables to determine the average number of plate appearances, strikeouts, total
bases, batting average, and OPS for each year. Open a new worksheet and name it Offensive Comparison.
Copy the Totals rows to the new worksheet. Delete columns that you do not need, and format the numbers
appropriately. Enter a note below the data that describes the change in year-to-year offensive performance.
The data shown in Figure 11-6 is for illustrative purposes only; your data will look slightly different.
Yearly offensive data comparison
The data indicates that offensive performance declined. If this year
s values had been the same or better
than last year
s, you could have concluded that the strike zone change did not lead to worse offensive
Who were the league leaders this year and last year in batting average, OPS, and on-base percentage?
Sort the relevant data table columns from largest to smallest. Summarize the data in a new worksheet called
League Leaders. Format values appropriately. The data shown in Figure 11-7 is for illustrative purposes only;
your data will look slightly different.
League-leading performances in each year
Did the OPS and batting average leaders form similar all-star teams this year?
Clicking the arrow in a column heading displays a drop-down menu with a Search option at the bottom. You
can use search values to create subsets of the data. In this case, you can use the Position column to show
data for players at a particular position. Then you can sort the OPS column to find the best OPS performer at
that position during the year. Repeat the procedure in the batting average column for the same position. Use
these steps at each remaining position to develop OPS and Batting Average all-star teams for this year.
Summarize data in a new worksheet with appropriate formatting. Your data should look like that in Figure 11-8.
OPS and Batting Average all-star teams
In Figure 11-8, data for only two positions are shown. Enter a note below the all-star team data that states
your conclusion. Do the two performance measures essentially lead to the same teams or not?