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