How to Set Up an Ordinal Variable in Excel. An ordinal variable is a number that shows the position of an object within a series of objects with the use of a suffix, for example, "1st" or "453rd." ...

How to Use Goal Seek in Excel . Goal Seek is already built into Excel. It's under the Data tab, in the What-If Analysis menu. Let's walk through it with a simple example.

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.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...