| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Car Information | Compare your results to the class | ||||||||||||
2 | Student Name | Weight (g) | Distance (ft) | Time (s) | Velocity (f/s) | Speed (mph) | Coeff of Drag | |||||||
3 | Sample 1 | 160 | 80 | 3.1 | 25.80645161 | 17.59530792 | Car Information | |||||||
4 | Sample 2 | 229 | 80 | 3.4 | 23.52941176 | 16.04278075 | Weight (g) | Velocity | Speed | Coeff of Drag | ||||
5 | Sample 3 | 97 | 80 | 2.6 | 30.76923077 | 20.97902098 | Class Average | 186.8 | #DIV/0! | #DIV/0! | ||||
6 | 4 | 188 | 80 | 2.1 | 38.0952381 | 25.97402597 | Your Results | 160 | 23.53 | 17.6 | ||||
7 | 5 | 260 | 80 | 2.45 | 32.65306122 | 22.26345083 | ||||||||
8 | 6 | #DIV/0! | #DIV/0! | |||||||||||
9 | 7 | #DIV/0! | #DIV/0! | |||||||||||
10 | 8 | #DIV/0! | #DIV/0! | |||||||||||
11 | 9 | #DIV/0! | #DIV/0! | |||||||||||
12 | 10 | #DIV/0! | #DIV/0! | |||||||||||
13 | 11 | #DIV/0! | #DIV/0! | |||||||||||
14 | 12 | #DIV/0! | #DIV/0! | |||||||||||
15 | 13 | #DIV/0! | #DIV/0! | |||||||||||
16 | 14 | #DIV/0! | #DIV/0! | |||||||||||
17 | 15 | #DIV/0! | #DIV/0! | |||||||||||
18 | 16 | #DIV/0! | #DIV/0! | |||||||||||
19 | 17 | #DIV/0! | #DIV/0! | |||||||||||
20 | 18 | #DIV/0! | #DIV/0! | |||||||||||
21 | 19 | #DIV/0! | #DIV/0! | |||||||||||
22 | 20 | #DIV/0! | #DIV/0! | |||||||||||
23 | 21 | #DIV/0! | #DIV/0! | |||||||||||
24 | 22 | #DIV/0! | #DIV/0! | |||||||||||
25 | 23 | #DIV/0! | #DIV/0! | |||||||||||
26 | 24 | #DIV/0! | #DIV/0! | |||||||||||
27 | 25 | #DIV/0! | #DIV/0! | |||||||||||
28 | 26 | #DIV/0! | #DIV/0! | Analysis | ||||||||||
29 | 27 | #DIV/0! | #DIV/0! | Enter the data for the four cars with the greatest speed | ||||||||||
30 | 28 | #DIV/0! | #DIV/0! | 4 cars with the greatest speed | ||||||||||
31 | 29 | #DIV/0! | #DIV/0! | Weight of car (g) | Time (s) | Speed | ||||||||
32 | 30 | #DIV/0! | #DIV/0! | Fastest | ||||||||||
33 | 31 | #DIV/0! | #DIV/0! | 2nd fastest | ||||||||||
34 | 32 | #DIV/0! | #DIV/0! | 3rd fastest | ||||||||||
35 | 33 | #DIV/0! | #DIV/0! | 4th fastest | ||||||||||
36 | 34 | #DIV/0! | #DIV/0! | |||||||||||
37 | 35 | #DIV/0! | #DIV/0! | Conclusion: Describe why these cars traveled so fast. Include data from your lab graph and tables to validate your response. Compare your car's data to these four cars: which design was more successful? Why? | ||||||||||
38 | 36 | #DIV/0! | #DIV/0! | |||||||||||
39 | 37 | #DIV/0! | #DIV/0! | |||||||||||
40 | 38 | #DIV/0! | #DIV/0! | |||||||||||
41 | 39 | #DIV/0! | #DIV/0! | Answer: | ||||||||||
42 | 40 | #DIV/0! | #DIV/0! | |||||||||||
43 | 41 | #DIV/0! | #DIV/0! | |||||||||||
44 | 42 | #DIV/0! | #DIV/0! | |||||||||||
45 | AVERAGES: | 186.8 | 80 | 2.73 | #DIV/0! | #DIV/0! | ||||||||
46 | ||||||||||||||