- 3 minutes to read
This topic describes how linear regression analysis can be applied to your chart's visual data with the Regression Line statistical tool.
The topic consists of the following sections.
Regression Line Overview
A Regression Line is a statistical analysis instrument. It is a line drawn across a chart's diagram, constructed based on linear regression analysis.
A Regression Line differs from a Trend Line in that is a straight line indicating whether a particular data set has increased or decreased over a period of time. Trend Lines are sometimes used in business analytics to show changes in data over time because they are simple. However, they suffer from a lack of scientific validity in cases where other potential changes can affect the data. Thus, regression lines are a more sophisticated analytical instrument.
Regression Lines determine whether the data suggests some kind of simple function between its variables. (In general, there are one or more independent variables and a single dependent variable, the values of which depend on the values of the other variables). Linear regression analysis involves determining the underlying equation through a method called least squares. This method minimizes the error terms depending on how far away each data point is from the underlying linear function. Thus, the method by minimizes the sum of the squares of the errors.
A Regression Line is represented by an instance of the RegressionLine class (which is a descendant of the Indicator class) and resides (along with other indicators) in the IndicatorCollection of a series returned by the XYDiagram2DSeriesViewBase.Indicators property.
Because a regression line is built upon a specified value level, it is used to deal with either date-time or numerical data. Thus, you cannot create a Regression Line based upon series arguments, nor for any data of the qualitative scale type.
The view type of the series to which a Regression Line is assigned is returned by the Indicator.View property.
A series can possess any number of Regression Lines and any number of them can be drawn across the same value level.
Draw a Regression Line
Do the following to access a series collection of indicators at design time:
click the Series ellipsis button in the Properties window to invoke the Series Collection Editor;
click the Add... button in the invoked Indicators dialog;
select the Regression Lines type, and click OK in the Indicator Type dialog.
After a Regression Line is created, you can define its SingleLevelIndicator.ValueLevel and other properties in the Indicators dialog.