How to fit an equation

[Guest]

Hi all,

I have a scenario with three variables, X,Y,Z and Result This is what I know
about them:

X could go be from 1 – 100 say in meters
Y could be 0 – 31 say ranking
Z could be 1- 100 say meters
Result is in meters (1-100)

For values of X between say 1-20 meters, and 80-100 meters it impacts the
result very much i.e low values of Result i.e. like a bell shaped curve.
If Y increases then the Result increases for the most part of course there
could be some exceptions.
IF Z increases then the Result increases again with an exception that if Z
becomes like 50 meters then the probability of achieving that high Result
(meters) is very low.

How do I put together an equation that consists of X, Y, Z to achieve the
Result. Should I assume a correlation coefficient and then try to fit an
equation. I have no clue about this.
Any help is greatly appreciated.

Thanks.

 

[Jerry W. Lewis]

LINEST will do multiple linear regression (including polynomials). If
you are suggesting that different models apply in different regions,
then you could fit multiple models with subsets of the data.

For models that are nonlinear in the unkowns, you could use Solver to
minimize the sum of squared deviations.

Jerry