Skip to main content
J
jgan1-Visitor
1-Visitor
March 10, 2016
Question

Mathscad Trendline Equation?

  • March 10, 2016
  • 3 replies
  • 2298 views

Hi

Is it possible to get an equation for a graph  similar to the function of excel "Trendline" in Mathscad? I would like to get the equation for differentiation purpose. Thanks

3 replies

W
Werner_E25-Diamond I
25-Diamond I
March 10, 2016

Lookup the the various regression possibilities in the help under "Functions/Curve fitting".

More information cal also be found in the "Data Analysis E-Book".

WE

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
March 10, 2016

Can you post the file with the data separately?

W
Werner_E25-Diamond I
25-Diamond I
March 10, 2016

@Vladimir: In the attached sheet I replaced the embedded Excel component by a regular Mathcad data table, in case you are short of Excel and therefore can't read the data.

If on the other hand the reason for asking for the data was, that you want to play around in Excel and are unable to simply copy and paste the data, because of the decimal point vs decimal comma conflict, you might consider using WRITEEXCEL (augment(DataX,DataY), ".\filename.xlsx") to create an Excel sheet with the data in the correct format.

@Joseph: What do you need the regression fit /the equation for? Maybe an interpolation would do the job as well.

Without knowing what kind of equation to expect its hard to find a decent fit.

Here and attached is a first try with a gaussian:

Regards

Werner

BTW, which option would you chose in Excel ?

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
March 11, 2016

Werner Exinger wrote:

@Vladimir: In the attached sheet I replaced the embedded Excel component by a regular Mathcad data table, in case you are short of Excel and therefore can't read the data...

Danke!

Terms & ConditionsAccessibility statement