What-if analysis data table of a value generated from another data table

Occasional Visitor

As an example, from 3 inputs: alpha (%), p (%), and scenario (1-2000), are used to calculate cost. Then, I generate data table of cost for 2000 different scenarios, and finally calculated the average cost of those 2000 scenarios. Is it possible to create a two-variable data table of different inputs of alpha (%) and p (%) that calculates the average cost?

0 Replies