The company must also report expected revenues for budgeting. In that process the management has also asked for the probability of revenues reaching certain thresholds to create bonus payment schemes for the sales team. The market price is expected to be $7.60, but there is some uncertainty associated with it. One analyst says that a good estimate of one standard deviation would be $2.00. Simulate 500 new trials and summarize the results in a frequency table and histogram. Include also a summary of the results using the COUNTIF and COUNTIFS functions.

Choose the conditions to be satisfied yourself.