The files P18_09 AL.txt and P18_09 NL.txt contain lists of all American League and National League baseball
Question:
The files P18_09 AL.txt and P18_09 NL.txt contain lists of all American League and National League baseball batters who had at least 250 at-bats during the 1990 season. The heading at the top of each text file describes the variables. Import these text files into Excel, and then arrange the data into a single sheet in a single file with five variables: League (AL or NL), Last Name, First Name, At-Bats, and Handedness. Finally, create a pivot table to find the percentages of batters for either league or for both leagues combined who are right-handed hitters, left-handed hitters, or switch-hitters. Save the results as an Excel (.xlsx) file. (This data came from a research project on batting streaks performed by one of the authors in the 1990s.)
Step by Step Answer:
Business Analytics Data Analysis and Decision Making
ISBN: 978-1305947542
6th edition
Authors: S. Christian Albright, Wayne L. Winston