Build a predictive model

Job ID: 32004778

Budget: $250 – $750 USD

In the company I work, we have process described in the first picture. The influx with 2 properties (A and B) enter to the "process" where it'll be transformed. In this process, we can control 2 things, the time "t" of the process and the amount of a substance "M" to add. After the process, we got the output flux with 2 properties (A' and B'). We want the property B' to be certain value, so we add a substance D to change it. In some cases, we noted that adding D before the process we can alter B' to a different value than adding the same amount of M after the process (second picture).

What do we need?

A program that can take all the data we have (A, B, A', B', amount of M added, time "t", amount of D added and where) and make a predictive model. The final objective is giving the model the value of B' we want and the values of A and B and, in return, get the values of M, t and D.

Notes:

-B and B' are somewhat dependent of A and A'
-We have the data in Excel
Related categories: Engineering Excel Simulation Data Modeling