Specifying coefficients in trendline equation

[vinny21]

Hi all!

I would like to know if there is a way to set a coefficient in the trendline equation to zero.

For example:
The equation of the second order trendline is Ax^2 + Bx + C
I want to find a way to set B = 0

I know it's possible to set C = 0 by setting the intercept, so I was wondering if there was such a thing for other coefficients.

(the reason I want to do this is that I want to fit data to an equation where both the y and x intercepts are at zero)

Thanks

 

[Jon Peltier]

"the reason I want to do this is that I want to fit data to an equation where both the y and x intercepts are at zero"

If the Y intercept is zero, that means the equation goes through (0,0), which means the X intercept is already zero.