Home > Forum Home > Analyzing Corporate Financial Data > Regression Analysis for memory retention data > Scatter Pot with Linear Regression Trend Share

Scatter Pot with Linear Regression Trend

Excel Help for Scatter Pot With Linear Regression Trend in Analyzing Corporate Financial Data


Forum TopicLogin

Scatter Pot With Linear Regression Trend

Rate this:
(3/5 from 1 vote)
SurprisedIn this case, you can start by creating a simple XY scatter plot chart from the source data. By selecting the series in the chart you can right click and select Add Trend line > Linear.  Right click the Trend Line and choose Form Trend line > Options and choose to add the equation and R-squared on the chart.  This will give you the regression equation and the predictive quality (R-squared) for your analysis.

To transform or analyze the data before charting, you can use the LOG function and/or other statistical functions such as SLOPE (regression coefficient) under the Statistical functions in Excel.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Scatter Pot with Linear Regression Trend in the