Specifying coefficients in trendline equation

vinny21

New Member
Joined
Sep 8, 2014
Messages
1
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
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,920
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
"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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,630
Messages
5,523,991
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top