Question: HELP ASAP I NEED THE FORMULAS!!!!! please in order step by step!! An infield fly in baseball is called to prevent the defense from recording

HELP ASAP I NEED THE FORMULAS!!!!! please in order step by step!!  HELP ASAP I NEED THE FORMULAS!!!!! please in order step by
step!! An infield fly in baseball is called to prevent the defense
from recording an easy double play. When an infield fly occurs, 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

An infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly occurs, 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. Boolean 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". [9 points] Boolean Copy your function in cell H11 and paste it down to complete the "Force @ Third" column of the table. [1 point] 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"). [7 points] Boolean Copy your function in cell I11 and paste it down to complete the "Fly Ball" column of the table. [1 point] Boolean Use the NOT function in cell J11 to determine if there are "Not 2 Outs". Use the "Outs" column in your determination. [ 7 points] Boolean Copy your function in cell J11 and paste it down to complete the "Not 2 Outs" column of the table. [1 point] Boolean Use the AND function in cell K11 to determine if all of 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 hit to the infield or shallow outfield (I11 = TRUE), and there must not be 2 outs ( J11 = TRUE). [ 3 points] Boolean 8 Copy your function in cell K11 and paste it down to complete the "Infield Fly" column of the table. [1 point]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!