Please refrane from answering if you are unfamiliar with MS Excel and inputing f

Question

Please refrane from answering if you are unfamiliar with MS Excel and inputing formulas for Cells. Thanks.

NOTE, you may need to save images to desktop to view in a larger scale.

Part b: Collision in Two-Dimensions

The law of conservation of momentum is true for any and every direction. So, for an isolated system, the momentum in the x, y and z directions or any other direction does not change.

Consider two objects colliding in deep space. Since the two objects together can be considered an isolated system, the total momentum of the system (the sum of the momenta of the two objects) is conserved in both the x and y directions. That is

pi-x-total=pf-x-total or pix1+pix2=pfx1+pfx2

pi-y-total=pf-y-total or piy1+piy2=pfy1+pfy2

If we assume object one is moving in the x-direction, object two is moving in the y-direction and the collision is perfectly inelastic,
we can rewrite these equations as

m1*vix1=(m1+m2)vfx

m2*viy2=(m1+m2)vfy

These equations can be solved to find the x and y components of the object's velocity after the collision. The magnitude of vf can be found using the Pythagorean Theorem. The direction of the objects after the collision can be found using the inverse cosine function

=cos-1(vfx/|vf|)

Since cos-1 outputs an angle between 0 and radians, we must use new=2-old if vfy is negative to get a correct value. Use the built in function 'if' to find the true value of . Afterwards, convert the angle into degrees using the built in function 'degrees' .

i) Fill in the missing values in the table on the bottom using formulas to find each value

This is the half of the table that is full so far

A = Mass1

B = Velocity initial 1

C = Mass2

D = Velocity intial 2

E = M2/M1

F = Vi2/Vi1

This is the rest of the chart that needs formulas

G = Pi-x

H = Pi-y

I = |Pf|

J = Vf-x

K = Vf-y

L = |Vf|

M =

N = if Vi2 < 0

O = (degrees)

Explanation / Answer

Get all your solution manuals here ! 4student.com@gmail.com

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

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