50.1K

Verified Solution

Link Copied!

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!L4, which can be copied down to cell RIDES!L17, to determine (T/F) If the coaster gets a "cool" rating. The coaster gets a TRUE"cool" rating for either of the following two criteria: the coaster has both a 150+ foot Drop and a Loop special features OR the coaster has both Suspend and Cork Screw special features =AND(AND(C4:E4), AND(D4:F4)) =OR(AND(C4,E4), AND(D4,F4)) =AND(OR(C4,E4), OR(D4,F4)) =OR(OR(C4:E4), OR(D4:F4))

Answer & Explanation Solved by verified expert

See Answer