Excel sheet

Part I. A. Perfectly inelastic collision - equal masses. Choose 0% elasticity for perfectly inelastic collisions by moving the cursor in the Settings box to 0%. 1. In the data table, set (by typing) the masses of both balls to the same value in the range of 0.450-0.550 kg 2. Choose the initial velocity of Ball 1 (Cyan) (0.50-5.00 m/s), type the value in the Velocity box (e.g. type "1.50"; do not enter the units, as those are listed in the column heading, m/s). Keep the velocity of Ball 2 (Magenta) at 0. Open the Linear Momentum Workbook (Excel spreadsheet), and enter the masses and velocities on page 1. 3. Press Play, observe the collision, then press Pause, and record the velocities of the balls. 4. Fill in the appropriate section in the Excel workbook, page 1. Do not enter any data into the cells marked with "x". Calculate the total momentum of the system and kinetic energy of the system before and after the collision. State your conclusion: Is the linear momentum conserved? Is Kinetic energy conserved? 5. If needed, repeat the experiment by pressing Restart; this will bring your initial settings back on screen. Part I. B. Perfectly inelastic collision - unequal masses. 1. Click Restart button. 2. Increase the mass of Ball 2 (Magenta) by 0.50 - 0.70 kg. 3. Set the initial velocity of Ball 1 (Cyan) to any desired value in the range of 0.50-5.00 m/s; make sure the initial velocity of Ball 2 (Magenta) is set to zero. 4. Press Play, observe the collision, then press Pause, and record the velocities of the balls. 5. Fill in the appropriate section in the Excel workbook, page 1. Calculate the total momentum of the system and kinetic energy of the system before and after the collision. You may calculate these values manually or enter the appropriate formulas in the spreadsheet. State your conclusion: Is the linear momentum conserved? Is Kinetic energy conserved? Part II. A. Elastic collision - equal masses. B. Elastic collision - unequal masses. Change the Elasticity Setting to 100%, and repeat the steps 1-5 in the Procedure Part I, A and B. Part III. A. Inelastic collision - equal masses. B. Inelastic collision - unequal masses. Part I, A and B. Change the Elasticity Setting to 40-60%%, and repeat the steps 1-5 in the Procedure