To organize the given data and calculations, it can be helpful to use Excel. Create an Excel spreadsheet using the following format. It is given that 2,845 student applications were received for early admission. Of these, 1,031 students were admitted early (event E), 852 were rejected (event R), and 962 were deferred (event D). Place these values in the table. A B C D 1 Applications for early admission 2 Outcome Event Frequency Probability 3 Admitted E 1031 Correct: Your answer is correct. seenKey 1,031 4 Rejected R 852 Correct: Your answer is correct. seenKey 852 5 Deferred D 962 Correct: Your answer is correct. seenKey 962 6 Total 2,845 Recall that the probability of an event is found by dividing the number of times an event occurs by the number of all possible outcomes. That is, the probability for each outcome will be found by dividing the outcome frequency by the total number of applications. In cell D3, the probability that a student is admitted early is found by dividing the frequency of that outcome by the total number of applicants. Since this formula will be copied into other cells, the absolute cell reference should be used for the total value. Thus, the formula to calculate the probability of event E is =C3/$C$6 Correct: Your answer is correct. seenKey =C3/$C$6 . Step 2 We determined the probability for each outcome will be found by dividing the outcome frequency by the total number of applications. In the Excel spreadsheet, this can be accomplished