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

%3CLINGO-SUB%20id%3D%22lingo-sub-2148885%22%20slang%3D%22en-US%22%3EWhat-if%20analysis%20data%20table%20of%20a%20value%20generated%20from%20another%20data%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2148885%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20an%20example%2C%20from%203%20inputs%3A%20%3CSTRONG%3Ealpha%20%3C%2FSTRONG%3E(%25)%3CSTRONG%3E%2C%3C%2FSTRONG%3E%26nbsp%3B%3CSTRONG%3Ep%20%3C%2FSTRONG%3E(%25)%3CSTRONG%3E%2C%20and%20scenario%3C%2FSTRONG%3E%20(1-2000)%2C%20are%20used%20to%20calculate%26nbsp%3B%3CSTRONG%3Ecost%3C%2FSTRONG%3E.%20Then%2C%20I%20%3CU%3Egenerate%20data%20table%3C%2FU%3E%20of%26nbsp%3B%3CSTRONG%3Ecost%3C%2FSTRONG%3E%20for%202000%20different%26nbsp%3B%3CSTRONG%3Escenarios%3C%2FSTRONG%3E%2C%20and%20finally%20calculated%20the%26nbsp%3B%3CSTRONG%3Eaverage%20cost%26nbsp%3B%3C%2FSTRONG%3Eof%20those%202000%20scenarios.%20Is%20it%20possible%20to%20create%20a%20%3CU%3Etwo-variable%20data%20table%3C%2FU%3E%20of%26nbsp%3Bdifferent%20inputs%20of%26nbsp%3B%3CSTRONG%3Ealpha%20%3C%2FSTRONG%3E(%25)%20and%26nbsp%3B%3CSTRONG%3Ep%20%3C%2FSTRONG%3E(%25)%20that%20calculates%20the%26nbsp%3B%3CSTRONG%3Eaverage%20cost%3F%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2148885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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