Regression Formula In Excel. The format trendline dialog box opens. The regression equation is y 4 486x 86 57.
In other words for each unit increase in price quantity sold decreases with 835 722 units. The regression equation is y 4 486x 86 57. You now have a scatterplot with trendline equation and r squared value.
Click on the data tab and data analysis.
Click on the data tab and data analysis. The regression line is. Input y range is the dependent variable so. The regression equation is y 4 486x 86 57.