Using the Kinematics Spreadsheet

Example 3

Question :

"A car is initially moving at 20 m/s when the driver applies her brakes. If the brakes can decelerate the car at 6 m/s2, how long will it take the car to stop, and how far will it travel in this time?"


To solve the problem, you need th set the initial velocity of the car (in cell B7) to 20 m/s and the acceleration of the car (in cell B3) to -6 m/s2.

preliminary results

Notice that the car stops sometime between 3 and 4 seconds after the brakes are applied. You can decrease the time interval (in cell B4) to get a more precise time. To extend the spreadsheet, use "Fill Down" from the Calculate menu.

problem solution


last update September 15, 2000 by JL Stanbrough