Prelab3.xlsx

Sheet1

Understanding the color code for PHY 241
Raw Data Formula provided by instructor Formula that needs to be entered Open Response area
Prelab 3
It is good idea to know roughly how the CBR we are using in lab works. After using echolocation/sonar to determine the position of a cart, the Logger Pro software calculates the velocity and acceleration. For this prelab we will be using our average velocity and average acceleration formulae to complete these calculations.
For Questions 1-3, Two different groups are measuring the SAME cart travelling with a constant velocity on a straight track. Table 1 and Table 2 represent the data collected by each group.
Table 1 1. Use the standard "Kinematics Equations" for velocity and acceleration to find these values for each time step in Table 1 and Table 2 as well as their average and uncertainty. Definitely take advantage of Excel's "Copy" and "Paste" functions so you only need to type equations once or twice. Give special attention to the cells on the edge of the data set.
Average Velocity: Average Acceleration:
Velocity Uncertainty: Acceleration Uncertainty:
Time (s) Position (cm) Velocity (cm/s) Acceleration (cm/s/s)
0 0 0 0
1 14.5 15.3 15.3
2 26.325 8.7 -3.3 2. Use proper rounding techniques to report the velocity and acceleration of the cart for each data table. (Note, because the data updates every time you edit this sheet, the instructor is aware that there might be a slight mismatch between your reported value and data showing at the time of submission.)
3 39.725 17.75 3.02
4 54.6 9.01 -2.19
5 66.9 16.87 1.57
6 81.675 9.9 -1.16
7 90.575 16.46 0.94
8 105.3 9.65 -0.85 Table 1: Velocity = 13.25 cm/s
9 118.725 16.59 0.77
10 129.8 10.29 -0.63 Table 2: Velocity = 12.05 cm/s
11 146.275 15.86 0.51
12 157.575 10.33 -0.46 Table 1: Acceleration = 0.73 cm/s^2
13 171.475 15.94 0.43
14 183.625 10.59 -0.38 Table 2: Acceleration =
15 196.025 15.49 0.33
16 212.475 10.89 -0.29 3. Are your results consistent with the description given above: "Two different groups are measuring the same cart travelling with constant velocity on a straight track." Explain any numerical inconsistencies that are in the data using your understanding of "Uncertainty".
17 225.8 15.74 0.29
18 236.075 10.8 -0.27
19 250.625 15.53 0.25
Table 2 The results are not consistent.
Average Velocity 251.69 Average Acceleration: 13.88
velocity uncertainty: 13.25 Acceleration Uncertainty: 0.73
Time (s) Position (cm) Velocity (cm/s) Acceleration (cm/s/s)
0 0 0 0
0.1 2.17 -17.1 171
0.2 1.04 31.8 244.5
0.3 4.56 2.27 -98.43 4. Compare and contrast the uncertainties measured by these two groups. Fundamentally what caused one group to get more precise data than another?
0.4 5.705 33.63 78.4
0.5 4.375 -15.53 -98.32 Deffrence in results: Velocity = 1.2 cm/s, while the accelaratoin is 17.31 m/s^2. The inconsistency is attributed to error during measurements.
0.6 9.77 18.3 56.38
0.7 10.665 8.74 -13.66
0.8 12.31 12.29 4.44
0.9 10.53 13.3 1.12
1 14.025 12.05 -0.8
1.1 16.045 14.9 2.59
1.2 16.265 15.62 0.6
1.3 14.91 13.59 -1.56
1.4 18.005 10.92 -1.91
1.5 22.05 17.11 4.13
1.6 21.495 10.45 -4.16
1.7 23.815 18.69 4.85
1.8 26.085 10.04 -4.81
1.9 26.33 18.54 4.47