how to write a simple linear regression equation

Using these values, we can write the equation for this simple regression model:

The coefficient for the slope is 0.479072.

The coefficient for the intercept is 3.115589.Once we press ENTER, the coefficients for the simple linear regression model will be shown: We can type the following formula into cell D1 to calculate the simple linear regression equation for this dataset: =LINEST( A2:A15, B2:B15) Suppose we have the following dataset that contains one predictor variable (x) and one response variable (y): Example 1: Find Equation for Simple Linear Regression The following examples show how to use this function to find a regression equation for a simple linear regression model and a multiple linear regression model. known_x’s: One or more columns of values for the predictor variables.known_y’s: A column of values for the response variable.

This function uses the following basic syntax: LINEST(known_y's, known_x's) You can use the LINEST function to quickly find a regression equation in Excel.

How to write a simple linear regression equation