Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Mar 14, 2019

Allow for a linear regression to intercept ANY value in the Y axis

Sometimes you need for your linear regression to be forced through the origin or any value you want. This is a very old and standard feature available in Excel, which is important as an option when running linear regressions, that not necessarily need to go through a free fitting. I am sure lots of people will find this feature useful.

  • Attach files
  • Guest
    Nov 14, 2023

    Please note that Spotfire has two distinct, non-overlapping ways to ask for a linear regression, and it is not clear whether this Idea is about

    (a) Scatter Plot Properties > Lines & Curves > Linear Curve Fit


    (b) Tools > Linear Regression Modeling...


    The following public knowledge base article shows a way to specify a y-axis intercept of zero in case (b):


    The following Idea (merged with this one, among others) specifically asks for implementation of a solution for use in case (a):


    Straight line fit through origin (0,0) or with zero intercept [Merged]

    Line & curves function allows to add a straight line fit. However, there is no option to force this fit line through (0,0) origin or with zero intercept. Like the way we have such option in MS Excel or SAS JMP, this isnt available in spofire.

    Having such an option helps in comparing line fits/line slopes in cases where the lines are expected to start from origin. It gives the power to prove that two or more categories in a data set are have same or different trends and make a decision accordingly.

    Lack of this is hindering the progress in many of our analytics projects and we had to rely on other softwares to do this as an intermittent approach.


Enable force of best fit line to go through the origin

When adding a best fit line to a visualization we need to be able to force the line to go through the origin similar to this option in excel graphing.
over 7 years ago in Spotfire / Visualization 0 Future Consideration

Allow to set y-intercept in Regression modeling

I want to set y-intercept in Regression modeling, like Excel.
almost 7 years ago in Spotfire / Analytics 2 Future Consideration