Lab 2 Maximum Range of a Projectil Week 2

Lab 2Maximum Range of a Projectile: Due at the end of Week 2All simulations can be downloaded here, this week’s file name is “ATWOOD MACHINE.ip”.For
Lab 2, please review Chapter 3 in your textbook. 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/s2. 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}.Fill in the blanks in the Lab Answer Sheet at the end of this lab.Submit this Lab Answer Sheet when all of the labs are completed.These
can be scanned and sent as pdf or picture files (e.g. tif, gif, etc.)
or by any other method of your choice as long as the Answer Sheets are
legible and translatable by Grantham University faculty.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 ? = 0o
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 your Lab Answer Sheet with: (1)
completed Excel spreadsheet, and (2) graph of R vs. ?.