Step 1 I was able to complete.I do not know how you would put step two in Excel.

Question

Step 1 I was able to complete.I do not know how you would put step two in Excel.

Watch Pre-lab Lecture for Experiment 1 This lecture involves solving the following 2-D kinematic problem A cannon with a muzzle speed of 1,000 m/s is used to start an avalanche on a mountain slope. The target is 3,000 m from the cannon horizontally and 800 m above the cannon. Determine the angle. above the horizontal, that the cannon should be fired. In the space provided below, write out the mathematical expression for the vertical displacement (y) based on the horizontal displacement (x), the angle (theta), and the acceleration in the vertical direction (ay provided in the pre-lab lecture. Provide the cell location for the value used for the independent variables Cell location of x = Cell location of v_i = Cell location of a_y Cell location of theta = the mathematical expression for y from above, determine the Excel equation necessary to determine y. Provide the two acceptable angles (in degrees) that were determined using Solver in Excel. theta = ___________ theta = ___________ Step 2: On a separate Excel worksheets, solve the following problem from scratch using the approach outlined in the previous steps. The acceleration of an object undergoing simple harmonic motion can be described by the equation a(t) = -A(2 pi/T)^2 cos(2 pi/T t) where a(t) is the acceleration of the object over time (in m/s^2), A is the amplitude of motion (in m), T is the period of oscillation (in s), and t is the time (in s). Given that the amplitude of the object is 2.34 m and the acceleration after 3.45 s is 1.89 m/s^2, determine the period of oscillation. Keep in mind that in using the function provided, a maximum feasible period exists and that as period of oscillation decreases, the acceleration range increases. This means that the periods that fit the criteria will become more difficult to find at lower values. Step 3: Determine six correct periods and submit the complete spreadsheet with six correct answers included to the instructor.

Explanation / Answer

Use the formula you have found in step 1 then put it in the excel sheet, insert the values and the corresponding column will list the outcome of the values you wish to obtain.

The whole sheet/table is the solution you wish to obtain from the Microsoft Excel i.e. listed in the problem you have sought.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.