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

Highlighted

## 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)

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:

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