Creation of a 'design tool'

Hi,

I would like to ask very kindly for little help in selection of the best approach to my problem.

I have conducted 9 runs in Ansys simulation software having two variables (factor A and factor B) and three levels (low, mid, high) of their values.
Based on the 9 runs input and output data I would like to create something what I call as a 'design tool'.
A 'design tool' would have to answer to a question such as (e.g.) if I decrease value of 'B' factor by say 10% how much I need to increase value of 'A' factor in order not to decrease the output.

I am not certain what would be the best method (approach) for this task in Excel (I consider alternatively Design of Experiment program).


I would be very obliged for your opinion.
Thank you.

Regards,
Robert

Can you upload a file with the data, or exemplary data?

It sounds like you want to interpolate the values you have and do a multiple regression.

http://cameron.econ.ucdavis.edu/exce...egression.html

Hi JYTS,

Thank you for your reply.
I will review the page under the link you have sent.

I attach to this post the data from the 9 runs (experiments).

Thank you.

Regards,

Robert