Linear Regression Line Formula. Lm_eqn. If all of the assumptions underlying linear regression are true see below the regression slope b will be approximately t-distributed. For example y 3x 4. The equation for a line is y a bX.
On an Excel chart theres a trendline you can see. A and b are given by the following formulas. Y Values of the second data set. Numbers exceeding this length will be truncated. Y β1 β2X ϵ where β1 is the intercept and β2 is the slope. X Values of the first data set.
A straight line depicts a linear trend in the data ie the equation describing the line is of first order.
In statistics simple linear regression is a linear regression model with a single explanatory variable. The aim of linear regression is to model a continuous variable Y as a mathematical function of one or more X variable s so that we can use this regression model to predict the Y when only the X is known. A linear regression line has an equation of the form Y a bX where X is the explanatory variable and Y is the dependent variable. Therefore confidence intervals for b can be calculated as CI b tα 2 n2sb 18 To determine whether the slope of the regression line is statistically significant one can straightforwardly calculate t. Formula for linear regression equation is given by. Table field accepts numbers up to 10 digits in length.