QUESTION 1 Elise has just graduated from her BCom degree and is facing a post-graduation crisis where she does not know what she wants to do with her life. Because she did not have a job lined up for the summer, she has decided to take this time to go on vacation and "find herself". Elise has decided that, since life is unpredictable, it would be fitting to plan her trip randomly. To determine where she will go on vacation, she will be using an Excel simulation based on the suggestions from her ten closest friends: three suggested to travel around Europe (EUR), six suggested to backpack through South East Asian (SEA), and one suggested to take a roadtrip across the states (USA). Elise is also unsure whether or not she should travel with friends (F) or alone (A), so she will determine this based on a coin toss using a fair coin. Assume that the outcome of the travel destination does not affect, and is not affected by, whether Elise travels alone. Having taken BUS 404, Elise started a probability tree on which destination she will travel to and whether she will travel alone. Some of the numbers have been blocked out. Help Elise fill in the missing parts. Destination Alone? Sample Space Probability F Europe n Friends 0.15 EUR A D Europe n Alone E F S.E. Asian Friends F SEA A S.E. Asian Alone 0.3 F USA n Friends G USA A USA n Alone 0.05 H 0.30 A B Total QUESTION 6 Instead of just picking a random number between 0 to 1, Elise wants a more robust simulation, so she will run 100 trials with 100 randomly generated numbers. The conditions associated with the probabilities for each vacation destination are shown in the screenshot below. Elise spends hours determining whether each randomly generated number is associated with EUR, SEA, or USA in column C. What Elise did not realize is that she could have written a nested IF statement, apply the same formula from C9:C108, and Excel would analyze all of column C for her. Help Elise figure out how to write that formula by filling in the blanks of the IF statement. A B D E F G 1 Elise's Vacation: Destination 2 Outcome Total Trial Outcomes Condition If 0.3 and 0.9 Outcome SEA USA USA EUR SEA SEA EUR SEA SEA SEA SEA EUR EUR ~345 6 7 8 9 10 11 Trial 1 2 3 4 5 6 7 8 9 18 10 106 107 98 108 99 109 100 === 2345678 12 13 14 15 16 17 == Random 0.89659282 0.91172334 0.95720761 0.01605405 0.76320319 0.35377676 0.13390572 0.67059158 0.47178079 0.88150466 0.88386108 0.04786723 0.12263784 Total # of EUR Total # of SEA Total # of USA 26 63 Hint: nested IF statements are when there is an "IF" function inside another "IF" function. Recall that all IF statements have 3 parts: the condition that can be tested to be true or false, the result if the condition is true, and the result if the condition is false. In the example below, we have the inner IF statement in the place of the result if the condition is false. What this means is that Excel will analyze the condition (the inequality that tests whether cell B9 is less than or equal to a certain value); if this condition is true (B9 value), then Excel will move on to the inner "IF" function and analyze this "IF" function normally. Fun fact, you can nest up to 7 IF statements! =IF(B9 ")) Note: there are many ways to write this nested IF statement for column C, and the one shown above is just one of the many ways. It is good practice to recreate this simulation yourself and try out other ways to write this nested IF statement! If it is a number, report in one decimal. QUESTION 7 After running her simulation, Elise tallied up the total number of times each of the three destinations were recommended (as shown in cells F3:G6). Answer the following questions based on the screenshot provided in the previous question. Based on Elise's simulation, how many times was a roadtrip across USA the recommended destination? Report the answer as a whole number. Elise will take her vacation to the destination that is suggested the greatest number of times. Where will Elise be taking her vacation? Respond with EUR, SEA, or USA. QUESTION 1 Elise has just graduated from her BCom degree and is facing a post-graduation crisis where she does not know what she wants to do with her life. Because she did not have a job lined up for the summer, she has decided to take this time to go on vacation and "find herself". Elise has decided that, since life is unpredictable, it would be fitting to plan her trip randomly. To determine where she will go on vacation, she will be using an Excel simulation based on the suggestions from her ten closest friends: three suggested to travel around Europe (EUR), six suggested to backpack through South East Asian (SEA), and one suggested to take a roadtrip across the states (USA). Elise is also unsure whether or not she should travel with friends (F) or alone (A), so she will determine this based on a coin toss using a fair coin. Assume that the outcome of the travel destination does not affect, and is not affected by, whether Elise travels alone. Having taken BUS 404, Elise started a probability tree on which destination she will travel to and whether she will travel alone. Some of the numbers have been blocked out. Help Elise fill in the missing parts. Destination Alone? Sample Space Probability F Europe n Friends 0.15 EUR A D Europe n Alone E F S.E. Asian Friends F SEA A S.E. Asian Alone 0.3 F USA n Friends G USA A USA n Alone 0.05 H 0.30 A B Total QUESTION 6 Instead of just picking a random number between 0 to 1, Elise wants a more robust simulation, so she will run 100 trials with 100 randomly generated numbers. The conditions associated with the probabilities for each vacation destination are shown in the screenshot below. Elise spends hours determining whether each randomly generated number is associated with EUR, SEA, or USA in column C. What Elise did not realize is that she could have written a nested IF statement, apply the same formula from C9:C108, and Excel would analyze all of column C for her. Help Elise figure out how to write that formula by filling in the blanks of the IF statement. A B D E F G 1 Elise's Vacation: Destination 2 Outcome Total Trial Outcomes Condition If 0.3 and 0.9 Outcome SEA USA USA EUR SEA SEA EUR SEA SEA SEA SEA EUR EUR ~345 6 7 8 9 10 11 Trial 1 2 3 4 5 6 7 8 9 18 10 106 107 98 108 99 109 100 === 2345678 12 13 14 15 16 17 == Random 0.89659282 0.91172334 0.95720761 0.01605405 0.76320319 0.35377676 0.13390572 0.67059158 0.47178079 0.88150466 0.88386108 0.04786723 0.12263784 Total # of EUR Total # of SEA Total # of USA 26 63 Hint: nested IF statements are when there is an "IF" function inside another "IF" function. Recall that all IF statements have 3 parts: the condition that can be tested to be true or false, the result if the condition is true, and the result if the condition is false. In the example below, we have the inner IF statement in the place of the result if the condition is false. What this means is that Excel will analyze the condition (the inequality that tests whether cell B9 is less than or equal to a certain value); if this condition is true (B9 value), then Excel will move on to the inner "IF" function and analyze this "IF" function normally. Fun fact, you can nest up to 7 IF statements! =IF(B9 ")) Note: there are many ways to write this nested IF statement for column C, and the one shown above is just one of the many ways. It is good practice to recreate this simulation yourself and try out other ways to write this nested IF statement! If it is a number, report in one decimal. QUESTION 7 After running her simulation, Elise tallied up the total number of times each of the three destinations were recommended (as shown in cells F3:G6). Answer the following questions based on the screenshot provided in the previous question. Based on Elise's simulation, how many times was a roadtrip across USA the recommended destination? Report the answer as a whole number. Elise will take her vacation to the destination that is suggested the greatest number of times. Where will Elise be taking her vacation? Respond with EUR, SEA, or USA
