Developing a function from 3 set inputs

Question

I am trying to come up with a function that takes three set inputs and spits out a number between 0 and 1.

The three inputs are X with values ranging from (0.5,1) Y with values ranging from (.75,1.5) Z with values ranging from (1,7)

The output should be between (0.5 and 1)

I have been using the norm.s.dist command on excel to get the result between 0 and 1 but am struggling with making the mathematical function inside the command work. I am trying functions like ln, log, log10, exp and was curious what else I should try?

Context: I am trying to predict a KPI based off previous data. There are three inputs that trigger the output and I am trying to develop a model to tie all 3 together and match the previous data with a small percent error. Each input has factors into the output, for instance the smaller x is, the smaller the output should be; the larger x is, the higher the output. The input variable z has the same relationship as x. Input Y is inversely related, the lower the input y, the higher the output; and the larger the input y, the smaller the output.

Answer 1

You may need a fair amount of flexibility to make your output match your data. To that end I suggest you experiment with functions of the form $$ f(x,y,z) = 0.5 + 0.5(Af_1(x) + Bf_2(y) + Cf_3(z)) $$ where

• $f_1$ is an increasing function of $x$ satisfying $f_1(0.5) = 0$ and $f_1(1) = 1$

• $f_2$ is a decreasing function of $y$ satisfying $f_2(0.75) = 1$ and $f_2(1.5) = 0$

• $f_3$ similarly defined for $z$

and

• $A$, $B$ and $C$ are positive weights that sum to $1$.

Then play with various functions and weights.

This is a generalization of @Weaam 's answer in a comment. That answer uses linear functions and equal weights.