Please show the answer using Excel Disillusioned with the prospects of political life, Pierre has decided to turn his attention away from running in the election and toward a study of voting procedures. His goal is to develop an efficient voting system by studying arrivals to the voting facility, the time it takes to check in at the voting facility, the time it takes to vote once one is at the voting booth, and the time spent waiting in line for these procedures. Pierre gathered data from the previous election at local voting facilities and found that the time between voters arriving at the check-in station is distributed as follows:

The time spent at the check-in station is assumed to be normally distributed with a mean of 120 seconds and a standard deviation of 30 seconds. The time spent in the voting booth is distributed as follows:

Question 8: Build a simulation model of this situation (the model should simulate 250 voters moving through the system). What is the average amount of time spent in the entire voting system (measured as the difference between the time that a person finishes voting and the time that they arrived)?

Question 9: What is the average time spent waiting in line at the check in station?

Question 10: What is the average time spent waiting in line for the voting booth?

Question 11: What proportion of voters wait in at least one of the lines?

\begin{tabular}{|l|l|l|l|l|} \hline TimeBetweenArrivals(Seconds) & 90 & 120 & 150 & 180 \\ \hline Probability & 0.1 & 0.15 & 0.5 & 0.25 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline Time (Seconds) & 60 & 90 & 120 & 180 \\ \hline Probability & 0.4 & 0.3 & 0.2 & 0.1 \\ \hline \end{tabular}