Question: AutoSave WA BY C ... STAT 211 M3 Assignment Alt (2024 Update) Q Search (Cmd + Ctri + U) Home Insert Draw Page Layout t

AutoSave WA BY C ... STAT 211 M3 Assignment Alt (2024 Update) Q Search (Cmd + Ctri + U) Home Insert Draw Page Layout t Formulas Data Review View Automate Comments Share . Cut Aptos Narrow (Bod... v 11 A 29 Wrap Text General Normal Bad Good AutoSum A LG Copy Paste BIUVV MV Av Merge Center v v % " 00 -20 Conditional Format Neutral Calculation Check Cell Insert Delete Format Sort Find Sensitivity Add-ins Analyze Format Formatting as Table Clear v Filter Select Data AA43 fx B C D G M N P Q S U V W AA AB AC AD AE I'm one yellow and one blue column Pick one column for X (independent variable) - paste cells 3-22 in Cell A3 Pick one column for Y (dependent variable), paste cells 3-22 in Cell B3 Altitude (X) Altimeter Error () Altitude in Feet Altimeter Error in Feet A W N - 3754 -44 3704 3404 3604 3754 3754 6800 43 2200 4400 3000 7200 6800 4 8700 13 3200 400 4900 4000 8700 w w in 8100 28 6000 400 9800 9800 8100 5700 5900 1000 7300 8500 5700 16 3 200 46 9700 2200 9500 2400 200 -16 700 49 1300 2100 1400 1800 700 4200 41 5000 100 1500 200 4200 1300 AT 100 4500 1900 4200 1300 8600 4700 3400 1900 4000 8600 9700 5300 900 3200 6800 9700 8200 7700 7900 800 4100 8200 4400 900 7500 1400 900 4400 9800 1000 2600 8800 7500 9800 4600 2800 1700 4800 6200 4600 -15 4700 6900 100 3800 2900 4700 -27 4800 9800 2000 7800 8300 4800 20 7900 7700 3200 800 2900 7900 -15 100 31 700 6900 3700 3500 100 - 25 800 2400 6800 9900 9300 800 20 Please answer the following questions on this spreadsheet before turning in the spreadsheet file for this assignment (version 4.5) -0.0540578 #1 Correlation 26 C Coefficient - -0.054057838 SLOPE -0.000563 27 INTERCEPT 0.4508583 #2 Coefficient of 8 Determination -r 0.00292225 Chart Title 30 y =-0.0006x + 0.4509 R2 = 0.0029 32 #3 What is Pearson's r that you calculated, and what does it tell us? 40 33 35 #4 What is the r2 that you calculated, and what does it tell us? 20 36 38 #5 Is this regression model good for prediction? Why or why not? Axis Title 0 . Series1 2000 4000 6000 100 00 120 00 Linear (Series1) 20 60 Axis Title Sheet + Ready Ex Accessibility: Investigate 100%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!