AutoSave . OFF APP . C ... Unit 4C Project(1) Share Comments Home Insert Draw Page Layout Formulas Data Review View 9 Tell me Insert v = = EX AY- O. Calibri (Body) v 11 ~ A" A" ap Wrap Text General x Delete Sort & Find & Analyze Paste BIU~ ~ OVA- E Merge & Center v $ ~ % " Conditional Format Cell Formatting as Table Styles Format v Filter Select Data E41 fx B C D E F G H 1 J K L M N Q R S T U w X 32 attler 124 65 33 iddler's Revenge 146 65 34 teel Eel 150 65 35 exas Giant 137 65 36 east 141 54.8 37 hang 144 63 38 cream! 141 63 39 ennessee Tornado 128 63 40 olossus 115 62 41 creamin' Eagle 92 62 42 angman 95 43 urricane 100 44 ivertigo 138 45 on Wolf 90 46 ong 95 47 lind Eraser 95 48 ilver Bullet 75 49 tarliner 76 50 2 95 51 hunderbolt 95 52 imber Wolf 95 53 Vild One 8 8 54 heetah 90 55 annon Ball 70 50 56 fterburner 47 45 57 Whizzer 64 42 58 anyon Blaster 66 41 59 lue Streak 72 40 60 teel Dragon 2000 306.75 95 61 hunder Dolphin 218.1 80.8 62 itan 178 71.5 63 blivior 180 68 64 tunt Fall 177 $5.6 65 ayabusa 124.67 60.3 66 pp Gun 93 56 67 68 69 70 71 72 73 74 75 A 1. Z-Testing (Ch.10) 2. t-Testing (Ch.10) 4. Regression Analysis (Ch.12) + Data Set 3. Testing 2 Samples (Ch.11) + 100% ReadyAutoSave . OFF APP ? . C ... Unit 4C Project(1) Home Insert Draw Page Layout Formulas Data Review View 9 Tell me Share Comments Calibri (Body) v 11 ~ A" A " ap Wrap Text v General Insert v EX AY- O. x Delete Paste BIUV FV OVA- E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v Filter Select Data A12 x v fx B D E F G H M N 0 P Q R S T U V w Z AA For your last question on your last project, I am going to take it easy on you. The data set in columns A-C of the Data Set page give the name, top speed in mph and drop distance of several popular roller coasters. Using this data, do the following: A. Create a scatterplot of the data (4 pts). The scatterplot should have the title "Rollercoaster Speed vs. Drop Distance" (1 pts). Using the Design tab, be sure to add both axis titles (1 pts) and a trendline (2 pts). B. Use the "Add chart elements" option to display both the LSRL equation and r- squared value on your scatterplot. (2 points) Keep in mind that you only have one set of data, so you should only have one line of regression. If you submit a scatterplot with two separate lines, you will earn 0 points. 3. Testing 2 Samples (Ch.11) 4. Regression Analysis (Ch.12) + Ready + 100%AutoSave . OFF A BOY . C ... Unit 4C Project(1) Insert Draw Page Layout Formulas Data Review View 9 Tell me Share Comments Home Insert v Calibri (Body) v 11 " A" A = = 29 Wrap Text v General EX AY - O. x Delete E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Paste Formatting as Table Styles Format v v Filter Select Data E41 fox B D E F G H J K L M N 0 Q R S T U V W X 1 Name Drop (ft) Speed (mph) 2 Millennium Force 300 93 Goliath 255 85 4 Titan 255 85 Phantom's Revenge 228 82 6 Xcelerato 130 82 7 Desperado 225 80 8 HyperSonic XLC 133 80 9 Nitro 215 80 10 Phantom's Revenge 225 80 11 Son Of Beast 214 78.4 12 Superman - Ride Of Steel 221 77 13 X 215 76 14 Mamba 205 75 15 Steel Force 205 75 16 Wild Thing 196 74 17 Apollo's Chariot 210 73 18 Raging Bull 208 73 19 Rattler 166.5 73 20 Superman - Ride Of Steel 205 73 21 Magnum XL-200 194.6 72 22 Vipe 171 70 23 Volcano The Blast Coaster 80 70 24 Great American Scream Machine 155 68 25 Alpengeist 170 67 26 Batman Knight Flight 148 65 27 Hercules 151 65 28 Kraken 144 65 29 Mean Streak 155 65 30 Medusa 150 65 31 Orient Express 115 65 32 Rattler 124 65 33 Riddler's Revenge 146 65 34 Steel Eel 150 65 35 Texas Giant 137 65 36 Beas 141 64.8 37 Chan 144 63 38 Scream! 141 63 39 Tennessee Tornado 128 63 40 Colossus 115 62 Screamin' Eagle 92 62 42 Hangman 95 55 43 Hurricane 100 55 44 Invertigo 138 Data Set A 1. Z-Testing (Ch.10) A 2. t-Testing (Ch.10) A 3. Testing 2 Samples (Ch.11) 4. Regression Analysis (Ch.12) + + 100% Ready