Using Excel is a great way to perform what-if analysis, and formulas generating random values that make sense for your forecasting help present a variety of outcomes for analysis.

How to Choose Random Sampling in Excel. Randomly selected samples from a larger population prevent bias in statistical procedures while avoiding the hassle of dealing with the entire dataset.