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

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Data Analysis and Decision Making

ISBN: 978-1305947542

6th edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: