M N o 1 EXCEL-LENT PARK ROLLER COASTERS Roller Coaster Special Features 2 Riders Avg mph 120 70 40 150 ft Cork 3 Name Level Drop Suspend Loop Screw 4 Top Thrill Dragster 5 TRUE FALSE FALSE TRUE 5 Millenium Force 5 TRUE FALSE TRUE TRUE 6 Maverick 5 FALSE FALSE FALSE TRUE 7 Blue Streak TRUE FALSE TRUE FALSE 8 Wildcat 4 FALSE FALSE FALSE FALSE 9 Jr. Gemini 2 FALSE FALSE FALSE FALSE 10 Mean Streak 5 TRUE FALSE FALSE FALSE 11 Raptor 5 FALSE TRUE FALSE TRUE 12 Faceoff 5 FALSE TRUE TRUE FALSE 13 Biarro 5 TRUE FALSE TRUE FALSE 14 El Toro 5 TRUE FALSE TRUE FALSE 15 Diamondback 4 TRUE FALSE FALSE TRUE 16 Tatsu 5 TRUE TRUE TRUE FALSE 17 Goliath 5 TRUE FALSE TRUE FALSE 18 Only Level 57 (T/F) FALSE TRUE FALSE FALSE 19 Name of fastest coaster: Top Thril Dragster Feet 5.000 15,000 8,000 3,500 4,000 1.500 10,000 7,000 5.000 5.400 4,400 OOO 10123: : : : : : : : : : : : Ride 150 Speed Length in Riders per Cool Sus Cork Based Seconds Hour Rating drop Pend Loop Screw Level Name 28 2,534 FALSE 1 0 0 1 5 Top Thrill Dragster 108 1,427 TRUE 1 0 1 1 5 Millenium Force 78 1,109 FALSE 0 o 1 4 Maverick 60 805 TRUE o 1 . 2 Blue Streak 55 704 FALSE 0 0 o 2 Wildcat 41 1,403 FALSE 0 0 1 ar. Gemini 105 686 FALSE 1 0 0 O 1 Mean Streak BO 905 TRUE 0 1 0 1 3 Raptor 697 FALSE 0 1 1 O 2 Faceoff 48 1,305 TRUE 1 0 1 O 4 Bizarro 43 1,344 TRUE 1 1 4 El Toro 44 1.408 FALSE 1 0 O 1 5 Diamondback 41 1,760 TRUE 1 1 1 3 Tatsu 44 1314 TRUE 1 0 o 4 Goliath Yearly Insurance Percentage Rate 23 25% 25% 17% 20% 10% 25% 23% 23% 23% 23% 17% 25% 23 OO 5.200 3,600 4.500 RIDES 150+ft Drop Suspend Loop 0 1 Level Rides Rank 2 1 0.0% 4 3 2 7.1% 3 4 0.0% 4 5 4 21.4% 2 6 5 71.4% 1 LEVELS Nm NOO DOO OOO Om Cork Screw Rating 0 Below Below Below 1 Above 4 Best A B 1 Units 2 5,280 Feet/Mile 3 60 Minutes/Hour 4 60 Seconds/minute 5 40 Seconds actual Ride Time per Minute UNITS POO B C D E F 1 Levels 2 Speed (mph) 0 40 60 70 80 3 Level 1 2 3 4 5 SPEED Insurance % Insurance % 2 or less Special 3 or more Special Level Features Features 2 1 3% 5% 3 2 7% 10% 4 3 13% 15% 5 4 17% 20% 6 5 23% 25% INSURANCE RATES Write an Excel formula in cell RIDES!S4, which can be copied down to cell RIDES!S17, to determine the annual Insurance percentage rate based on the level of the coaster and if the coaster has 2 or less Special Features or if the coaster has 3 or more Special Features. =VLOOKUP(A4,Insurance Rates!A$1:C$6,2,False) O =VLOOKUP(B4, Insurance Rates'!A$2:C$6,IF(COUNTIF(C4:F4,TRUE)