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

Mathscad Trendline Equation?

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

4 replies

Werner_E
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

Translate
VladimirN24-Ruby IV
24-Ruby IV
March 10, 2016

Can you post the file with the data separately?

Translate
Werner_E
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 ?

Translate
VladimirN24-Ruby IV
24-Ruby IV
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!

Translate
Terms & ConditionsAccessibility statement