Insert Draw Formulas Review View Comments Home Page Layout Data Tell me Share Insert v Calibri (Body) 11 VA A General Delete v $ ~ % " 1308 Conditional Format Cell Sort & Find & Analyze Paste BI U ~ BY avAv E Formatting as Table Styles Format v Filter Select Data R11 x v fx J L M N O P F G H K Q R A B C D E S -18 3700 -1 3700 3300 500 1200 6800 -47 w -43 -1 2200 1400 3000 200 6800 34 2200 3200 400 1900 4000 $700 13 3200 5000 4 000 400 800 1800 3100 28 5900 16 6900 1000 300 8500 $700 4 9700 2200 9500 2400 200 9700 1300 1300 2100 1400 1800 700 10 000 100 .500 200 1200 11 100 100 1500 1900 4200 300 700 600 12 4700 $400 1900 13 5300 5300 900 3200 800 700 14 7700 7700 7900 800 4100 8200 15 300 900 7500 1400 900 1400 1000 1000 2600 3800 7500 9800 16 17 2800 2800 1700 1800 3600 4600 18 6900 -27 5900 100 1800 2900 4700 -27 20 19 80 20 800 2000 800 300 1800 7900 -15 13 20 700 -15 700 200 800 900 21 700 -25 700 6300 700 500 100 -25 22 2400 -20 2400 6800 9900 9300 800 -20 23 Correlation Altimeter Error (Y) 24 Coefficient - r 0.190127976 25 Coefficient of y = 0.0008x - 6.0031 R = 0.0361 26 Determination - r 0.0361 20 27 28 29 30 With appreciation to Dr. John Barstow (ERAU WW Adjunct Faculty) for his contributions to this assignment. 31 32 Series1 Altimeter Error (v) 33 8000 10000 120 00 .......* Linear (Series1] 34 35 36 10 37 Mod 2 Assgnment + + 100% Ready