Linear Regression Formula Excel. Y quantity sold 8536 214 835 722 price 0 592 advertising. Y dependent variable b the slope of the regression line.
The regression line is. Here s the linear regression formula. As you can see the equation shows how y is related to x.
In other words for each unit increase in price quantity sold decreases with 835 722 units.
In other words for each unit increase in price quantity sold decreases with 835 722 units. A 628 33 88 017 46 519 89 106 206 14 5 88 017 46 519 89 2. You can download this linear regression excel template here linear regression excel template. The regression line is.