Microsoft Excel Workshop.xlsx - Calculating an Average Formula that will be used 3.6 3.8 3.5 3.7 3.6 L Average Using excel's average 3.64 3.64

Microsoft Excel Workshop.xlsx - Calculating an Average...

This preview shows page 1 - 12 out of 18 pages.

Calculating an Average Formula that will be used Average Using excel's average 3.6 3.64 3.64 3.8 3.5 3.7 3.6 L
Conversion factor (mi/km) mi/h km/h 0.62 10 16.13 Formula: 20 32.26 0.62mi/km / (mi/h) = km/h 30 48.39 40 64.52 50 80.65 60 96.77 70 112.90 80 129.03 90 145.16 100 161.29
PROJECTILE MOTION 1 Angle 35 degrees 30 m/s 17.21 m/s 24.57 m/s TIME OF FLIGHT 0 m g: 9.8 t: 3.51 s HORIZONTAL TRAVEL DISTANCE x: 86.30 m V o : V oy : V ox : y final : m/s 2
PROJECTILE MOTION 2 Angle 30 degrees 30 m/s 15.00 m/s 25.98 m/s TIME OF FLIGHT 0 m g: 9.8 t: 3.06 s HORIZONTAL TRAVEL DISTANCE x: 79.53 m V o : V oy : V ox : y final : m/s 2 B degr 0. dist
By decreasing the angle to 30 rees the flight time increases by .5 seconds and the horizontal tance traveled decreases by 6.8 m.
Descriptive Statistics Random # Average: 1.846 2.669 0.608 1.450 2.800 2.939 0.930 0.317 2.105 1.315 2.461 1.047 1.901 0.232 0.072 1.247 2.729 1.921 0.539 1.957 1.566 0.111 0.702 0.378 2.843 1.012 1.603 0.201 0.978 0.519 1.498 0.519 0.220 2.370 1.983 0.105 2.308 2.476 1.645 1.157 0.146 1.961 0.637 2.442 0.253 0.990 0.365 2.071 1.910 1.751 2.810 2.643 1.204 1.446 2.715 1.737 1.311 0.448 2.366 2.545 1.416
Median: Max: Minumum: Standard Deviation: Quartile Quartile 2 = M 1.472 2.939 0.072 0.892 1 0.591 1 2 1.472 3 2.155
Median
Bin Frequency 0.07 1 0.79 17 1.51 13 2.22 14 3.00 15 0.07 0.79 1.51 0 2 4 6 8 10 12 14 16 18 Histogram for Random Numbe Frequency Bin Frequency
2.22 3.00 ers
Column1 Column2

You've reached the end of your free preview.

Want to read all 18 pages?