3D data, surface plot & 3D plot fit.

[ptc-4247663]

I have a table of data x, y, z in excel.

1. What is the best way of importing this data into Mathcad 15 for further analysis?

(So far I used Insert->Component...)

2. How do you plot this data as a Surface Plot?

(Stuck here)

3. How do you produce a function that would characterize this data, similar to a curve fit? So knowing x and y, you can plug them into z=f(x,y) to get desired value. (Ultimately this is what needed. I have multiple data tables like this and need to charactarize them by a function)

Thank you in advance for taking your time to respond.

I searched for related topics here and online but no success so far.

Any help is appreciated.

[ValeryOchkov]

Vitaliy,

I have described this task in the 4-d chapter "Technical Statistic"of the book "Mathcad for students and engineers".

See for example this picture from the book:

http://twt.mpei.ac.ru/ochkov/Mathcad_12/4_03_3D_Spline.png

and others pictures here

[Fred_Kohlhepp]

Vitaliy Glotov wrote:

I have a table of data x, y, z in excel.

1. What is the best way of importing this data into Mathcad 15 for further analysis?

(So far I used Insert->Component...)

2. How do you plot this data as a Surface Plot?

(Stuck here)

3. How do you produce a function that would characterize this data, similar to a curve fit? So knowing x and y, you can plug them into z=f(x,y) to get desired value. (Ultimately this is what needed. I have multiple data tables like this and need to charactarize them by a function)

Thank you in advance for taking your time to respond.

I searched for related topics here and online but no success so far.

Any help is appreciated.

1) I prefer data tables; this puts the data into the mathcad sheet.

2) Help is hard to understand. Persist!

5) Multi-dimensional polynomial regression is available in the function "regress."