A projectile being fired upward at an angle to the horizontal, θ. You are to program the spreadsheet Excel (a similar substitute software program is permissible) to determine the maximum injection angle, θmax , that will result in the greatest downrange distance, R. Assume vo = 10 m/s and g is approximated as g = 10 m/s2. Fill in the data table, and answers for the blanks and complete the graph (properly labeled and annotated) {Hint: watch out for conversion problems from radians to degrees in Excel} .
q Access Excel. Your data table will look similar to that found for Lab 2 below. The injection angle, θ will go from 0 degrees to 90 degrees in steps of two (2) degrees. Once you have the range formula programmed for θ = 0°, use the "fill down" option in Excel to "distribute" the solutions to the other cells for the other angles. Include your completed full Excel data table with your Lab Answer Sheet. Then graph the data in order to construct a R vs. θ graph. Denote on this graph, the maximum range, Rmax, and the angle, θmax where this occurs. Be sure that your graph is properly labeled. For Lab 2 return with your Lab Answer Sheet: (1) completed Excel spreadsheet, and (2) graph of R vs θ
°
(degrees ) Range, R
(m)
0
2
4
6
8
.
.
.
90

θ=
R(at V0= 10m/s &g=10m/s^2) =
Graph of R9y-axis) vs θ:

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.

Physics Problems: Velocity, Impact, Speed. ... Which gives: (1.11) By the same argument as before, the maximum elevation on earth is: (1.12) The ... Horizontal range: ...

Physics: Universal law of gravitation, Kepler's 3 laws of planetary motion, satellite speed. ...Range of projectile is given by. ...Maximum value of sine function is 1 ...

... conceptual questions are from chapter 3 of "Physics, 7th edition ... To achieve the claimed range at the given angle ... which is more than the maximum achievable speed ...

... Find a) the time to reach the maximum height, b) the maximum height, c) the total time in the air, d) the horizontal range and e ...Physics 101 Practice questions. ...

... calculations with diagrams for various physics questions involving ... And 2.5 seconds after reaching this maximum height, the ... journey, ie covers the range in time ...

... Some details about the underlying physics for generating Bremstrahlung and ... to reduce the radiation of to a maximum level of ... ray tube is set in the range of 100 ...

... Questions involve a broad range of topics covered in ... who are looking to improve their proficiency in Physics. ... to a spring and moves with maximum speed 7.62 m/s ...

... 5. Estimate the minimum range of the momentum of a ... 246 07/09/2011 PHYS255: Quantum & Atomic Physics - ES Paul ... Potential Well & Wave Packet Maximum T occurs ...