Jul 11, 2010
Add a Linear Regression Trendline to an Excel Scatter Plot
Although Excel is capable of calculating a number of descriptive and inferential statistics for you, it is often better to show a visual representation of data when presenting information to a group. Using Excel’s built in trendline function, you can add a linear regression trendline to any Excel scatter plot. Inserting a Scatter Diagram into Excel Suppose you have two columns of data in Excel and you want to insert a scatter plot to examine the relationship between the two variables
View post:
Add a Linear Regression Trendline to an Excel Scatter Plot