Question: Produce an 100 pt method Excel spread sheet that has variable inputs for the initial velocity in m/s at an angle relative to the horizontal.

Produce an 100 pt method Excel spread sheet that has variable inputs for the initial velocity in m/s at an angle relative to the horizontal. Your start and stop values should be the range x and your graph should show the parabolic path. In a text box on the excel sheet describe how you used this spread sheet to determine the minimum velocity a batter can hit a home run in the new Yankee stadium if the ball leaves the bat at an angle of 35 degrees from the horizon. Your answer should have a precision of 1 decimal. Like:( Hit at xx4 is a home run and xx.3 is not. A couple of hints and some data: Assume the ball is hit right off the dirt (ie yo 0) and there is no drag force restricting the ball in flight. Yankee stadium short porch is 314 feet from home base and the wall is 8 feet tall. Lastly, excel only works trig in radians so you'll have some conversions to consider. Set up the excel such that you can vary the magnitude of the initial velocity and view the parabolic path very close to the location of the wall. As a bonus what would the minimum be if Yankee stadium was on the moon? Produce an 100 pt method Excel spread sheet that has variable inputs for the initial velocity in m/s at an angle relative to the horizontal. Your start and stop values should be the range x and your graph should show the parabolic path. In a text box on the excel sheet describe how you used this spread sheet to determine the minimum velocity a batter can hit a home run in the new Yankee stadium if the ball leaves the bat at an angle of 35 degrees from the horizon. Your answer should have a precision of 1 decimal. Like:( Hit at xx4 is a home run and xx.3 is not. A couple of hints and some data: Assume the ball is hit right off the dirt (ie yo 0) and there is no drag force restricting the ball in flight. Yankee stadium short porch is 314 feet from home base and the wall is 8 feet tall. Lastly, excel only works trig in radians so you'll have some conversions to consider. Set up the excel such that you can vary the magnitude of the initial velocity and view the parabolic path very close to the location of the wall. As a bonus what would the minimum be if Yankee stadium was on the moon
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
