A B C E F H K L M 1 An infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly the batter is automatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to their bases (though they may "tag up" if they wish). An infield fly occurs when the following conditions are met: (1) there is a force out at third base (this means that there are runners on first base and second base), (2) there are not two outs, and (3) the batter hits a catchable fly ball to the infield or the shallow outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire should declare an infield fly 2 occurs, 3 4 5 6 7 atchable Fly Ball Hit t 9 Scenaritunner on 1stunner on 2n Infield5hallov OutfielOuts orce Thin Fly Ball Not 2 Outslnfield Fly 10 Yes Yes 1 No No 0 11 Yes 2 Yes No No 0 12 3 Yes No No Yes 0 13 Yes 4 No No No 2 14 5 Yes Yes No No 0 15 6 No No No Yes 1 16 Yes Yes 7 No No 1 17 8 Yes Yes No Yes 2 18 Yes 9 Yes No No 1 19 10 Yes Yes No Yes 1 20 11 No No No No 21 12 Yes Yes Yes No 2 22 Yes 13 No Yes No 0 23 14 No Yes No No 7 24 Yes Yes 15 Yes No 1 25 16 No No Yes No 0 26 Yes 17 No Yes No 0 27 18 No No Yes No 0 28 19 No No No No 29 20 Yes Yes No Yes 30 21 Yes Yes Yes No 31 No 22 No Yes No 1 32 23 No Yes Yes No 1 33 Yes Yes 24 No No 34 25 No No No Yes 35 Yes Yes 26 No No 1 36 27 Yes Yes No Yes 0 37 Yes 28 No No No 1 38 29 No No No Yes 7 39 Yes 30 No No No 7 40 41 42 L Use the AND function with appropriate arguments in cell H11 to determine if there is a force out at third base. There is a force out at third base if "Runner on 1st" and "Runner on 2nd" are both "Yes". 1 Copy your function in cell H11 and paste it down to complete the "Force @ Third" column of the table. 2 Use the OR function with appropriate arguments in cell I11 to determine if there is a "Fly Ball". There is a "Fly Ball" if a "Catchable Fly Ball [is] Hit to" the "Infield" (cell E11 is "Yes") or "Shallow Outfield" (cell F11 is "Yes") 3 Copy your function in cell I11 and paste it down to complete the "Fly Ball" column of the table. 4 Use the NOT function in cell J11 to determine if there are "Not 2 Outs". Use the "Outs" column in your determination. 5 Copy your function in cell J11 and paste it down to complete the "Not 2 Outs" column of the table. 6 Use the AND function in cell K11 to determine if all fo the conditions are met for an infield fly to be declared. These conditions are: there must be a force out at third (H11 = TRUE), there must be a catchable fly ball it to the infield or shallow outfield (I11 = TRUE), and there must not be 2 outs (J11 TRUE) 7 Copy your function in cell K11 and paste it down to complete the "Infield Fly" colun of the table. 8 A B C E F H K L M 1 An infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly the batter is automatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to their bases (though they may "tag up" if they wish). An infield fly occurs when the following conditions are met: (1) there is a force out at third base (this means that there are runners on first base and second base), (2) there are not two outs, and (3) the batter hits a catchable fly ball to the infield or the shallow outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire should declare an infield fly 2 occurs, 3 4 5 6 7 atchable Fly Ball Hit t 9 Scenaritunner on 1stunner on 2n Infield5hallov OutfielOuts orce Thin Fly Ball Not 2 Outslnfield Fly 10 Yes Yes 1 No No 0 11 Yes 2 Yes No No 0 12 3 Yes No No Yes 0 13 Yes 4 No No No 2 14 5 Yes Yes No No 0 15 6 No No No Yes 1 16 Yes Yes 7 No No 1 17 8 Yes Yes No Yes 2 18 Yes 9 Yes No No 1 19 10 Yes Yes No Yes 1 20 11 No No No No 21 12 Yes Yes Yes No 2 22 Yes 13 No Yes No 0 23 14 No Yes No No 7 24 Yes Yes 15 Yes No 1 25 16 No No Yes No 0 26 Yes 17 No Yes No 0 27 18 No No Yes No 0 28 19 No No No No 29 20 Yes Yes No Yes 30 21 Yes Yes Yes No 31 No 22 No Yes No 1 32 23 No Yes Yes No 1 33 Yes Yes 24 No No 34 25 No No No Yes 35 Yes Yes 26 No No 1 36 27 Yes Yes No Yes 0 37 Yes 28 No No No 1 38 29 No No No Yes 7 39 Yes 30 No No No 7 40 41 42 L Use the AND function with appropriate arguments in cell H11 to determine if there is a force out at third base. There is a force out at third base if "Runner on 1st" and "Runner on 2nd" are both "Yes". 1 Copy your function in cell H11 and paste it down to complete the "Force @ Third" column of the table. 2 Use the OR function with appropriate arguments in cell I11 to determine if there is a "Fly Ball". There is a "Fly Ball" if a "Catchable Fly Ball [is] Hit to" the "Infield" (cell E11 is "Yes") or "Shallow Outfield" (cell F11 is "Yes") 3 Copy your function in cell I11 and paste it down to complete the "Fly Ball" column of the table. 4 Use the NOT function in cell J11 to determine if there are "Not 2 Outs". Use the "Outs" column in your determination. 5 Copy your function in cell J11 and paste it down to complete the "Not 2 Outs" column of the table. 6 Use the AND function in cell K11 to determine if all fo the conditions are met for an infield fly to be declared. These conditions are: there must be a force out at third (H11 = TRUE), there must be a catchable fly ball it to the infield or shallow outfield (I11 = TRUE), and there must not be 2 outs (J11 TRUE) 7 Copy your function in cell K11 and paste it down to complete the "Infield Fly" colun of the table. 8