How to Simulate The Excel LINEST Function in LabVIEW

[dj143]

This may be a dummy question but I’m pressed for time.  I have used the Linear Fit.vi function to duplicate the Excel LINEST function and it works great.  However, the engineers here want to set the LINEST const option to FALSE.  How can I duplicate this option using LabVIEW?  I’m using LV v.8.5.1.

[Darin.K]

I have only been forced to use Excel for fitting a few times, but I seem to recall that setting LINEST to FALSE means that you want to fit a line with zero intercept.  I can do this in LV 8.2 using the General Polynomial Fit vi with the zero order coefficient constrained to 0.  There are some Regression examples that ship with LV.

[dj143 · Accepted solution]

Hi Darin,

 

Your suggestion to use the General Polynomial Fit.vi lead me in the right direction.  I am able to duplicate the “const” option within the Excel LINEST function by using this vi.  Your response is much appreciated because it saved me considerable time.  Attached is a modified version of the Regressions Demo.vi that was available in LV help.  It shows how the “const” option makes a difference in the linear slope.

 

Thanks again,

 

Dave J.