Question: 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,
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 by entering the formula =C3/$C$6 in cell D3. Copy this formula to cells D4 and D5 to find the requested probabilities, rounding each to four decimal places. A B C D 1 Applications for early admission 2 Outcome Event Frequency Probability 3 Admitted E 1,031 P(E) = Incorrect: Your answer is incorrect. 4 Rejected R 852 P(R) = Incorrect: Your answer is incorrect. 5 Deferred D 962 P(D) = 6 Total 2,845
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
