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.

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

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.