I'm using Linest to figure out the co-efficients for a quadratic equation for a set of X and Y points.
The formula looks like: LINEST(known_y's, known_x's^{1,2}
And I can get specific co-efficients using: INDEX(LINEST(known_y's, known_x's^{1,2}),ce_I_want)
To force the Y-intercept to 0, I would use: LINEST(known_y's, known_x's^{1,2}, FALSE).
But how do I force the Y-intercept to a number other than 0? For example, I would like to force the Y-intercept to 1.
The formula looks like: LINEST(known_y's, known_x's^{1,2}
And I can get specific co-efficients using: INDEX(LINEST(known_y's, known_x's^{1,2}),ce_I_want)
To force the Y-intercept to 0, I would use: LINEST(known_y's, known_x's^{1,2}, FALSE).
But how do I force the Y-intercept to a number other than 0? For example, I would like to force the Y-intercept to 1.