In the context of Monte Carlo simulations in Excel, which choise is correct: The end goal of simulation is typically to determine what proportion of the scenarios result in different levels of profits. To tabulate and then plot the proportion of scenarios at each profit level, we typically use the following Excel functions: COUNTIF$()$ or FREQUENCY$(),$ VLOOKUP$()$ or HLOOKUP$(),$ SUM$()$ or AVERAGE$(),$ INDEX$()$ or MATCH$()$