Physics 12

Excel & Graphing Practice

Question 1: a) Table 1. Height (distance) a mass was dropped on the surface of an asteroid versus timesquared taken for it to fall. d (m)

t (s)

t2 (s2)

0.0 0.5 0.7 0.9 1.2 1.3

0.00 1.31 1.56 1.77 2.05 2.15

0 1.72 2.43 3.13 4.20 4.62

Figure 1. Height (distance) a mass was dropped on the surface of an asteroid versus time-squared taken for it to fall. 1.4

height (m)

1.2 1 0.8 0.6

y = 0.2823x + 0.0088

0.4

R² = 0.9997

0.2 0 0

1

2

3

time-squared (s2) b) slope = 0.28 m/s2 c) From the data provided, we know: V1 = 0 m/s

t2 = known

d = known

The kinematic equation you would use is:

a=? d = v1t + ½ at2

The linear equation is: y = mx + b Acceleration due to gravity = 2 x m = 2 x 0.282 m/s2 = 0.56 m/s2

4

5