1) Determine the average range of the projectile. Launch the projectile 10 times at a fixed firing angle of 30 degrees. Measure the range of the projectile each time and record the results in the table provided in decimal feet. Calculate the mean (average) range, x. Measured Trial Number Range (ft) 1 6.50 2 5.83 3 6.67 4 5.67 5 5.00 6 5.00 7 5.00 8 5.83 9 5.92 10 5.83 Mean Range 5.73 (x) = 4 5 2) Calculate the initial velocity (Vi) of the projectile. 6 7 8 9 Use the calculated value for the mean range in step 1 to calculate the initial velocity (Vi) in ft/sec of the projectile. Substitute the value of the average range for (x), the firing angle for (6), and -32.2 ft/sec for (g). Be sure to use Excel formula. 10 Initial Velocity (Vi): 11 12 V = 13 = -gx sin 20 #NUM! 14 15. 5 67 00 3) Calculate the X and Y components. Now that you know the initial velocity, use trigonometry functions to determine the initial horizontal and vertical velocity in ft/sec of the ping pong ball at the angle you just tested. Use an Excel formula to compute each (remember that trig functions in Excel need to have angles in radians). 9 10 11 12 V 13 14 15 16 17 18 19 20 21 22 23 ViY Viy = V + sin(0) Vix Vix = V + cos(0) 8 9 4567a 4) Calculate the ideal range of the projectile at various firing angles. Use the calculated value for initial velocity and specified firing angles to calculate the ideal range of the projectile at each angle. Record the values in the table provided as decimal feet. Be sure to use Excel formula. Angle Ideal Range (ft) 10 Range (x): 11 12 X= 13 V sin20 g 0 10 20 14 30 15 40 16 45 17 50 18 60 19 70 20 80 21 90 22 23 24