Skip to main content
P
ptc-42476631-Visitor
1-Visitor
September 30, 2011
Question

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

  • September 30, 2011
  • 2 replies
  • 4893 views

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.

2 replies

V
ValeryOchkov24-Ruby IV
24-Ruby IV
October 1, 2011

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

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
October 1, 2011

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

Terms & ConditionsAccessibility statement