Question: 25 points - The question is to use Microsoft Excel Projectile motion is a form of motion experienced by an object or particle (a projectile)
25 points - The question is to use Microsoft Excel Projectile motion is a form of motion experienced by an object or particle (a projectile) that is thrown near the Earth's surface and moves along a curved path under the action of gravity only. Assume x axis is in horizontal direction, and y axis is in vertical upward direction, the formulas of projectile velocities and distances are: V = Vocos (0) 1 1 = 1, sin(0) -gt * = Votcos(0) y = votsin(0) 501? Here vois projectile initial velocity, in m/s, g is gravity constant, is 9.8 m/s, and t is time in seconds. The variables are: 16 = 60 m/s, and 0 = 50 degree. (10 points) Create an Excel spreadsheet that includes time t, x velocity, y velocity, distance x, and y. Time is from 0 to 3.5 seconds, with step site of o. 1 seconds. b. (10 points) Create two graphis: one a velocities (r, and ) vs, time, and the other is distance x vs. vivis yaxis, and xis x-axis). Please include title, axis labels, and legends (5 points) Assume the projectile is thrown from ground, what is the longest distance the projectile can travel in x direction? (Give an estimation from the data sheet)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
