cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Newbie

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

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.

Tags (3)
2 REPLIES 2
Highlighted

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

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

Highlighted

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

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."

Announcements