Is there any Excel function that gives an output similar to Regression analysis (e.g. Regression statistics, ANOVA, intercept, X variable) but shows the x-intercept instead of the y-intercept?
If you have a given regression model (i.e. y = Mx + B, where M is the slope and B is the intercept), you could find the x-intercept by plugging in 0 for Y and then solving the equation for x.
It is possible for a model to have no x-intercept (for example, a model with a quadratic term could result in a parabola that is always positive).
See the links:
https://answers.yahoo.com/question/index?qid=20100214211616AA1weI0
http://www.excelforum.com/l/742805-finding-x-axis-intercept.html
If you have a given regression model (i.e. y = Mx + B, where M is the slope and B is the intercept), you could find the x-intercept by plugging in 0 for Y and then solving the equation for x.
So, x intercept is equal to -B/M. As a single Excel formula it can be expressed as:
=-INTERCEPT(y_range,x_range)/SLOPE(y_range,x_range)
(commas in the formula must be replaced with semicolon if the decimal separator in national settings is comma - continental Europe style).
In using Data analysis / regression using Excel it becomes imperative to decide which variable is dependent variable and which is independent. Fell free to take
Y = F (X)
or
X = F (Y)
However, in non-linear, parabolic or hyperbolic models the intercept for X may be more than one, as many as times the curve crosses the X-axis.
Nader, you're right but if not specified explicitly, we just assume a linear regression model.
- Badges
- Science method
- Similar topics
- Mathematics
- Statistics
- Statistical Modeling
- Analyses of Variance
- ANOVA