excel - Tranform curve into linear -

excel - Tranform curve into linear -

how can transform bluish curve values linear (red curve)? doing tests in excel, have bluish line values within 3d app want manipulate python can create values linear. there mathematical approach missing?

the x axis goes 0 90, , y axis 0 1.

for example: in middle of graph bluish line gives me value of "0,70711", , know in linear "0,5". wondering if there's easy formula transform incoming non-linear values linear.

i have no thought "formula" creating non-linear bluish line, ignore yellowish line since trying "reverse engineer" see if lead me conclusion.

thank you

find linear function y = ax + b x = 0 gives value 1 , x = 90 gives 0, function represented bluish curve.

in case, scheme of equations following:

1 = b // x = 0 0 = a*90 + b // x = 90

solution provided solver next : { = -1/90, b = 1 }, reddish linear function have form y = ax + b, set values of , b found solver , find linear function looking y = -x/90 + 1 .

the tool used solve scheme of equations:

http://wims.unice.fr/wims/en_tool~linear~linsolver.en.html

excel math