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.

Random numbergenerator is used to generate random no as much as you want and also you can specify the range in which you want the numbers.steps to use random number generator:select data analysis from ...

How to Find a Qualitative Variable in Excel. Quantitative variables take the form of numerical figures. Qualitative variables describe data by placing them into broad categories.