Charting a Regression in Excel. We can chart a regression in Excel by highlighting the data and charting it as a scatter plot. To add a regression line, choose "Add Chart Element" from the "Chart ...

The next time you cover this topic, consider teaching students how to perform a simple linear regression analysis in Excel. Below is an example screenshot illustrating 12 months of cost data for a ...

Figure 1: The results of multiple linear regression depend on the correlation of the predictors, as measured here by the Pearson correlation coefficient r (ref. 2). (a) ...