Curve fitting on Data with three variable X,Y,Z

[#1]

I have data with 3 variables X,Y,Z and i want to fit a model like ...
Y= a(x) + b(z)+c,
X and Z may have some powers (n) also.How to do it? Please guide

[#2 · Accepted solution]

Use the "Fit Model" platform. Add column Y to "Y" and columns X and Z to "Model Effects". To add powers of independent variables choose "Polynomial to Degree" under the "Macros" roll list. When you're done just hit "Run Model".

[#3]

Is there a way to determine the resulting formula? Will this same setup work for surface fitting?

[#4]

Under the top red triangle, under Save Columns, you can select Prediction Formula option.