excel - Speed(mph Time(sec 30 1.9 40 2.8 50 3.8 60 5.2...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Speed (mph) Time (sec) 30 1.9 40 2.8 50 3.8 60 5.2 power 70 6.5 80 8.3 90 10.4 100 12.7 110 15.6 120 19 130 23.2 140 31.2 150 45.1 y=1.088e^(0.0244x) 8.66 Speed 85 Linear EXPONENTIAL The R 2 value is closest to 1 20 40 60 80 100 120 140 160 5 10 15 20 25 30 35 40 45 50 f(x) = 1.09·1.02^x R² = 0.99 f(x) = 0.3x - 12.56 R² = 0.84 f(x) = 0 x^1.87 R² = 0.97 Time (sec) Vs. Speed (mph) Speed (mph) Time (sec) Bin Frequency 925 950 1 975 9 1000 5 1025 8 1050 1 More 925 950 975 1000 1025 1050 More 5 10 Histogram Bin Frequency Sample Resistnance 1 1006 BINS 2 1006 925 3 978 950 4 965 975 5 988 1000 6 973 1025 7 1011 1050 8 1007 9 935 10 1045 mean 985.79 AVERAGE(B3:B26) 11 1001 mode 973 MODE(B3:B26) 12 974 maximum 1045 MAX(B3:B26) 13 987 Std Deviation 24.96 STDEV(B3:B26) 14 966 15 1013 16 960 17 976 18 954 19 1004 20 975 21 1014 22 955 23 973 24 993 y=-4x^3+2x^2-7x+23-462 X Value x y 5-4 339-3.5 243.5-3 170 goal seek-2.5 115.5-2 77-1.5 51.5 Zero value-1 36 1.62-0.5 27.5 23 0.5 19.5 1 14 1.5 3.53....
View Full Document

{[ snackBarMessage ]}

Page1 / 10

excel - Speed(mph Time(sec 30 1.9 40 2.8 50 3.8 60 5.2...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online