The last method for regression is not so commonly used and requires statistical functions like slope (), intercept (), correl (), etc., to carry out regression analysis.
Now our regression analysis output will be created in a new worksheet, stating the Regression Statistics, ANOVA, residuals and coefficients.
#REGRESSION EXCEL MAC 2011 DOWNLOAD#
You can download this Linear Regression Excel Template here – Linear Regression Excel Template Method #1 – Scatter Chart with a Trendline