Each observation indicates the primary position played by the Hall of Famers: pitcher (P), catcher (H), 1st base (1), 2nd base (2), 3rd base (3), shortstop (S), left field (L), center field (C), and right field (R). a. Construct frequency and percent frequency distributions to summarize the data. Position Frequency Percent Frequency (to one decimal) Pitcher % Catcher % 1st base % 2nd base % 3rd base % Shortstop % Left field % Center field % Right field % b. What position provides the most Hall of Famers? c. What position provides the fewest Hall of Famers? d. What outfield position (L, C, or R) provides the most Hall of Famers? e. Compare infielders (1, 2, 3, and S) to outfielders (L, C, and R). Which group has more Hall of Famers?

X Excel Online Student Work X X CA https:/g.cengage.com/spreadsheet/wac_frame.jsp ... eCampus E eConnect Menu Microsoft Office Ho... Mail - Nguyen, Tuye... E Google Docs M Inbox - schoolingnt... W Workday dallascolle.. Other favorites X template - Saved Search for tools, help, and more (Alt + Q) 16nn6qi File Home Insert Share Page Layout Formulas Data Review View Help Draw Comments Editing v v D VF Arial 10 A" A" B I U ab Dvd. AV Aa = Wrap Merge v General G30 XVfx A B C G H M N 0 P Q R S T U W . Member of the Baseball Hall of Fame Frequency Percent Frequency Formulas for Column D Formulas for Column E P Pitcher .349206349 =COUNTIF(A:A,"P" =D2/SD$12*100 Catche 19.04761905 =COUNTIF(A:A,"C" =D3/SD$12*100 1st base 11.11111111 =COUNTIF(A:A,"1") =D4/SD$12*100 2nd base 10 15.87301587 =COUNTIF(A:A,"2") =D5/SD$12*100 6 6 DO NO M A W N 3rd base 4.761904762 =COUNTIF(A:A,"3") =D6/SD$12*100 O Shortstop 11.11111111 =COUNTIF(A:A,"'S") =D7/SD$12*100 Left field 6 9.523809524 =COUNTIF(A:A,"L") =D8/SD$12*100 INNOI- IFNOOW Center field 12 19.04761905 =COUNTIF(A:A,"C") =D9/SD$12*100 Right field 3.174603175 =COUNTIF(A:A,"R") =D10/SD$12*100 11 Total number of members 63 Maximal Frequency 12 =MAX(D2:D10) What position provides the most =INDEX(C2:C10, MATCH(D14, D2:D10)) Hall of Famers? Center field + - OU - Minimal Frequency =MIN(D2:D10) What position provides the fewest =INDEX(C2:C10,MATCH(D18,D2:D10,0)) Hall of Famers? Right field DOFN Maximal Frequency (L,C, and R). 12 =MAX(D8:D9) What outfield position (L, C, or R) =INDEX(C8:C10,MATCH(MAX(D8:D10),D8:D10,0)) provides the most Hall of Famers? Center field Number of infielders (1, 2, 3, and S 27 =SUM(D4:D7) Number of outfielders (L, C, and R) 20 =SUM(D8:D10) =IF(D26=D28, "There is the same number of infielders and outfielders",IF(D26