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 graduate Rating of University Outstanding Average Poor Most Desirable 21 25 2 Good 20 36 10 Adequate 14 Undesirable 8 6 Show anwers 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 of graduated from a university that was rated poor? 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