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
Image of page 1
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
Image of page 2
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
Image of page 3
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
Image of page 4
By decreasing the angle to 30 rees the flight time increases by .5 seconds and the horizontal tance traveled decreases by 6.8 m.
Image of page 5
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
Image of page 6
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
Image of page 7
Median
Image of page 8
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
Image of page 9
2.22 3.00 ers
Image of page 10
Column1 Column2
Image of page 11
Image of page 12

You've reached the end of your free preview.

Want to read all 18 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture