Physics 12 Warren—NKEC

1

Graphing Practice Worksheet Instructions: Complete all questions using a word document. A spreadsheet program should be used to make your tables and charts and they should be placed into your word document. Please make sure everything is labeled appropriately. 1. An experiment was performed on the surface of an asteroid. A mass was dropped from various heights and the time taken to fall was recorded. d (m)

t (s)

0

0

0.50

1.31

0.70

1.56

0.90

1.77

1.20

2.05

1.30

2.15

t2 (s2)

a. In excel, plot a straight line graph. b. From your straight line graph, determine the slope of the line (include units). c. What is the acceleration due to gravity on the surface of this asteroid?

Physics 12 Warren—NKEC

2

2. A student measures the acceleration of a lab cart as it moves at different speeds around a circular horizontal path. The data collected by the student is shown below: Acceleration (m/s2)

5.7

12.9

25.2

40.0

49.7

72.0

Velocity (m/s)

2.0

3.0

4.2

5.3

5.9

7.1

When a graph of acceleration vs. velocity is plotted a curve results as shown:

a. Manipulate the velocity data and use it to plot a straight line on the graph in excel. b. Calculate the slope of this graph including units.

3. The data below was collected in a kinematics experiment using a toy car. t (s)

0.20

0.30

0.40

0.50

0.60

0.70

0.80

0.90

v (m/s)

0.35

0.46

0.59

0.70

0.83

0.94

1.10

1.18

a. Plot the data on a v vs. t graph in excel and extrapolate your line back to t 0. b. What is the displacement of the toy car from t 0 to t 0.90s? c. What does the y-intercept of the graph represent?

Physics 12 Warren—NKEC

3

4. A force (F) was used to pull a wooden block across a floor as shown below.

The size of the force was varied and the data below shows the size of the force and the block’s resulting acceleration. F (N)

a (m/s2)

20

0.25

25

0.85

30

1.35

35

1.95

a. Plot the data in excel and draw a line of best fit. Extend the line back to the ‘y’ axis so that you have a y-intercept point and determine the slope of the line. b. Using your slope value and your y-intercept value from the graph, determine the coefficient of friction between the block and the floor. 5. A student measures the final speed of an accelerating car at various displacements. The data collected is shown below: Final Speed (m/s)

v2

Displacement (m)

5.9

2.0

6.5

4.0

7.2

6.0

7.9

8.0

8.4

10.0

9.0

12.0

Physics 12 Warren—NKEC

4

a. Plot in excel a graph of the final speed squared, v2, versus the displacement, d, of the car

on the graph below. b. Determine the slope of the line of best fit to the data and state what the slope represents.

Extend the line to the y-axis and use the y-intercept to determine the initial speed of the car. 6. A small toy car is placed in a spring-loaded launcher.

The force needed to compress the spring is recorded as a function of distance. a. Plot a graph in excel of force vs. distance using the data table shown. Force (N)

Distance (m)

7.5

0.020

13.2

0.035

14.8

0.040

19.1

0.050

23.0

0.060

29.5

0.080

b. Calculate the area under this graph from distance = 0.0 m to distance = 0.080 m. c. What does this area represent?