1 Name Drop (ft) Speed (mph) Sample Mean (x-bar) Data Entry The first 2-part question of your project will require you to use 2 Millenniu 300 93 Hypothesized Mean (mu) Data Entry concepts learned in a z-test. This includes means were the population 3 Goliath 255 85 Population Standard Deviation (o) Data Entry standard deviation is known and proportions. As usual, fill in the values 4 Titan 255 85 Sample Size (n] Data Entry In the colored boxes and write your conclusion in the space provided. 5 Phantom 228 87 -Score Formula p-value Function Fill in the values from the question for "Data Entry" cells, a formula for 6 Xcelerato 130 Data Entry "Formula" cells and a function (like=NORM.DIST) for "Function" cells. 7 Desperac 225 80 alpha-level a HyperSor 133 80 A. The board of a major credit card company requires that the mean Nitro 215 80 Conclusion wait time for customers when they call customer service is no more 225 80 than 3 minutes. To make sure that the mean wait time is not exceeding 0 Phantom 78.4 the requirement, an assistant manager tracks the wait times of 47 11 Son OF B 214 randomly selected calls. The mean wait time was calculated to be 3.2 12 Superma 221 77 minutes. Assuming the population standard deviation is 1.15 minutes, 3 X 215 76 is there sufficient evidence that the mean wait time for customers is 4 Mamba 205 75 Critical Value Function longer than 3 minutes with a 98% level of confidence ? (7 points) 5 Steel For 205 75 Margin of Error Formula 6 Wild Thir 196 74 B. For the same problem as part A, construct an appropriate confidence 7 Apollo's 210 73 Confidence Interval interval based on the alpha level in A to support your condusion from B Raging By 73 (Lower Limit. Upper Limit] part A. Recall, if you rejected the null in part A, then your expected 208 mean should not be included in the interval. If you failed to reject the 19 Ratder 166.5 73 Conclusion null hypothesis, then hesized mean should be In the Interval 20 Superma 205 73 You should only need the appropriate critical value and margin of error 21 Magnum 1946 72 In addition to values from part A Correctly round your results to two 22 Viper 171 70 decimal places in your condusion sentence and be sure to state that it 23 Volcano 70 supports your decision to reject or fall to reject based on whether the hypothesized value falls in the interval. (3 points) 24 Great An 155 68 25 Hercules 151 65 26 Kraken 144 65 27 Mean St 155 65 28 Medusa 150 65 29 Orient Ex 115 65 30 Rattler 124 65 31 Riddler's 146 65 32 Steel Eel 150 65 33 Texas GIE 137 65 34 Beast 141 648 35 Chang 144 63 36 Scream! 141 63 37 Tennesse 128 63 38 Colossus 115 62 39 Screamin 92 62 40 Hangma 95 55 41 Hurricane 100 55 42 Invertigo 138 55 43 Iron Wolf 90 55 14 Kong 95 55 45 Mind Era 95 55 46 Silver Bul 75 5.5 47 Starliner 76 55 95 5.5 49 Thunder 95 55 so Timber W 95 53 51 Wild One 88 53 52 Cheetah 90 52 53 Cannon E 70 50 #Coaster T 52 50 55 Comet 78 50 56 New Mex 75 47 57 Corksere. 62 46 58 Afterburr 47 45 59 Whizzer 64 42 60 Canyon E 66 41 61 Blue Stre 72 40 62 Steel Dra 306.75 95 63 Thunder 219.1 90.8 34 Titan 178 71.5 65 Oblivion 180 68 66 Stunt Fal 177 65.6 67 Hayabust 124.67 60.3 68 Top Gun 93 56 69 70