physic i vectors and projectile motion

Please see attached.

Need excel spreadsheet with graph and problems worked out on excel.

Lab 2

Excel Data Table: (To be supplied by student)

Θ _{= __________}

R (at v₀ = 10 m/s & g = 10m/s²) = __________

Graph of R (y-axis) vs. Θ: (To be supplied by student)

For Lab 2,  This lab involves 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, that will result in the greatest downrange distance, R.  Assume v = 10 m/s and g is approximated as g = 10 m/s².  Fill in the data table, and answers for the blanks and complete the graph (properly labeled and θ_max annotated) in the Lab Answer Sheet at the end of this lab.  {Hint:  watch out for conversion problems from radians to degrees in Excel}.

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^o 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, R_max and the angle, θ_max where this occurs.  Be sure that your graph is properly labeled.  For Lab 2 return your Lab Answer Sheet with:  (1) completed Excel spreadsheet, and (2) graph of R vs. θ.

                                 Range, R

(degrees)                   (m)

0

2

4

6

8

.

.

.

90