When you perform regression analysis in Microsoft Excel, ... Create a Scatter Plot with Trendline. Select your data range. Go to the “Insert” tab and choose “Scatter” from the Charts group.

However, there may be circumstances where the relationship between the variables is non-linear (i.e., does not take the shape of a straight line), and we can draw other shaped lines through the ...

Navigate to the “Insert” tab and choose a scatter plot to visualize the relationship. 4. Right-click on any data point in the chart and select “Add Trendline” to include a regression line.