Please answer 1-14. NOTE: You must use Excel (functions and/or create formulas - see "COMMENT" by each Scenario) to obtain your answers. Also, note the required number of decimal places for answers.

NOTE: You must use Excel (functions and/or create formulas - see "COMMENT" by each Scenario) to obtain your answers. Also, note the required number of decimal places for answers. Scenario 1: Data on University and Recent Graduates COMMENT: You are basically using Excel as your calculator in Scenario 1. The table below contains data collected by the personnel director for a large, research- oriented firm. The data categorizes the universities as most desirable, good, adequate, and undesirable for purposes of hiring their graduates. The director collects data on 156 graduates that were hired and has each graduate rated by their supervisor as outstanding. average, or poor. Rating of University Rating of graduate Outstanding Average Poor Most Desirable 21 Food 20 36 Adequate Undesirable Show answers to 3 decimal places. For example, 0.284 Format your answer cells to show three decimals. 1 What is the probability that a randomly selected graduate is rated outstanding? 2 What is the probability a randomly chosen graduate is rated average or graduated from a university that was rated poor? 1717 3 Given that the graduate is from a university that was rated good, what is the probability the graduated was rated outstanding? 4 Given that the graduate was rated poor, what is the probability they are from a. university that was rated adequate? Scenario 2: Emergency Service Calls COMMENT: You must use Excel's The table below contains data for the number of daily emergency service calls for the last 50 SUMPRODUCT function for the days for a medium-size town in Mississippi. For example, there were 22 days on which the Expected Value and Variance. emergency service had two emergency calls. Calls Frequency 0 Show answers to 3 decimal places. For example, 0.284 Format your answer cells to show three decimals. 5 What is the Expected number of calls per day? 6 What is the Variance of the calls per day? 7 What is the Standard Deviation of the calls per day? 8 What is the probabilty of three or fewer calls per day? Scenario 3: Automobile Emissions Testing COMMENT: You must use the In an inspection of automobiles in Los Angeles, 60% of all automobiles had emissions that BINOM.DIST function. failed to meet EPA regulations. For a random sample of 10 automobiles, use the Binomial probability distribution to answer the questions that follow. Show answers to 3 decimal places. For example, 0.284 Format your answer cells to show three decimals. 9 What is the probability that exactly six of the ten automobiles failed the inspection? 10 What is the probability that six or more failed the inspection? 11 What is the probability that all ten of the automobiles passed the inspection? Scenario 4: Equipment Breakdowns COMMENT: You must use the A new automated process averages 1.5 breakdowns per day. Assume the breakdowns occur POISSON.DIST function. randomly, that the probability of a breakdown is the same for any two time intervals of equal length, and that breakdowns in one period or independent of breakdowns in other periods. Show answers to 3 decimal places. For example, 0.284 Use the Poisson probabilty distribution to answer the following questions. Format your answer cells to show three decimals. 12 What is the probability of having 3 or more breakdowns during a day? 13 What is the probability of having exactly 2 breakdowns during a day? 14 What is the probability of having between one and three (inclusive) break downs during a day