Visokio website     Downloads     Video tutorials     KnowledgeBase  
Extract best fit line data ? - Visokio Forums
Extract best fit line data ?
  • hannah.dadds January 13, 2011 12:44PM
    Hi

    Is it possible to extract the best fit line data from graphs to a visokio or excel file? To clarify which data I mean I have included a screenshot.

    Thanks,
    Hannah
  • 4 Comments
  •     tjbate January 13, 2011 1:18PM
    Hannah - If you set the Graph View axes to be the fields of correlation, Omniscope will show the real data points and an estimated line of best fit. If you want to add synthesised data points lying along the estimated line of best fit, create a Formula field with the line equation as a formula. This will generate points closer to the line of best fit as actual values in the file. You can also change the filtering selection mode in the Graph View to "best fit" select a range of points around the line of best fit and use Move/Keep filter operations to manage the data points in the IN data subset. This will affect the linear regression calculation and change/refine the line equation coefficients, which can can reflect in the formula field.
  • hannah.dadds January 13, 2011 2:37PM
    I only want to extract specific values i.e. the gradient and the Y intercept for a graph, I but will have a lot of graphs so manually retrieving these is quite time consuming.

    Is there any way to automate this?

    Thanks
  •     tjbate January 13, 2011 4:19PM
    Hannah - there are currently no options to export/import the results of the X/Y relationships analysis...if you post this under Ideas and it gets enough votes, it may make it into a future release...
  •     steve January 13, 2011 4:28PM
    Would this be better solved using a formula function to do the same calculation as is currently available in the Graph view's trend line?

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership