Tualatin High School Physics

Physics Research Project

RAW DATA

Data: Text .:. Excel

 

These worksheets will contain the formulas that were used to calculate the final numbers which were interpreted by the graphs.  The formulas should be located in the formula bar at the top of the worksheet.

POOL BALL

Weight (g)

170

Ramp (m)

1.2192

 

 

 

 

 

 

 

 

 

 

 

ANGLE (DEGREES)

 

 

20

30

40

45

50

60

 

 

1

0.84

0.73

0.63

0.6

0.54

0.45

 

T

2

0.85

0.75

0.62

0.6

0.53

0.46

T

R

3

0.87

0.72

0.64

0.58

0.52

0.44

I

I

4

0.87

0.73

0.62

0.59

0.53

0.45

M

A

5

0.86

0.72

0.62

0.58

0.52

0.45

E

L

6

0.85

0.72

0.63

0.58

0.54

0.44

S

 

7

0.84

0.75

0.63

0.57

0.54

0.47

 

#

8

0.87

0.75

0.62

0.59

0.53

0.45

(s)

 

9

0.87

0.75

0.63

0.6

0.54

0.46

 

 

10

0.85

0.75

0.64

0.57

0.54

0.46

 

AVERAGE TIME

0.857

0.737

0.628

0.586

0.533

0.453

 

HORIZONTAL/VERTICAL

H

V

H

V

H

V

H

V

H

V

H

V

 

DISPLACEMENT (m)

1.15

0.42

1.06

0.61

0.93

0.78

0.86

0.86

0.78

0.93

0.61

1.06

S

INITIAL VELOCITY (m/s)

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

U

FINAL VELOCITY (m/s)

4.74

2.86

4.55

3.46

4.28

3.92

4.11

4.11

3.92

4.28

3.46

4.55

V

ACCELERATION (m/s/s)

0.00

9.81

0.00

9.81

0.00

9.81

0.00

9.81

0.00

9.81

0.00

9.81

A

TIME (s)

0.86

0.86

0.74

0.74

0.63

0.63

0.59

0.59

0.53

0.53

0.45

0.45

T

AVG. HORIZ. VELOCITY (m/s)

1.337

1.433

1.487

1.471

1.470

1.346

 

AVG. VERT. VELOCITY (m/s)

0.487

0.827

1.248

1.471

1.752

2.331

 

AVERAGE VELOCITY (m/s)

1.423

1.654

1.941

2.081

2.287

2.691