Linear Regression Equation Excel. X is an independent variable. Linear regression is a statistical tool in excel that is used as a predictive analysis model to check the relationship between two sets of data of variables.
Y dependent variable b the slope of the regression line. Select the x axis horizontal and y axis data and click ok. From our linear regression analysis we find that r 0 9741 therefore r 2 0 9488 which is agrees with the graph.
This is the predictor variable also called dependent variable.
Calculate the sum of x y x 2 and xy. Select the x axis horizontal and y axis data and click ok. Linear regression is a statistical tool in excel that is used as a predictive analysis model to check the relationship between two sets of data of variables. Using this analysis we can estimate the relationship between two or more variables.
