Documentation

Trendline & R²

In datapine, you can add a variety of trend lines to the data points in your chart including linear, exponential, logarithmic, power and polynomial trend lines. The following guide will show you how to visualize trends in a few and easy steps and how to do regression analysis in datapine.

 

Display Trendline, Trend Fit and Equation

 

Open the Chart Creator with a click on Analyze in the upper navigation bar. Create your chart using the fields from your data source.

  1. To add a trendline to your data set, right click on the data series in your chart to open the quick options for this data series and select Advanced Options.
  2. In the Field Editor & Chart Options on the right below Advanced,tick the checkbox next to Show Trend Line.
  3. This will display a dropdown menu with a selection of trendline functions to choose from. Select the type of trend line you wish to use for your chart. You may choose between linear, exponential, logarithmic, power, polynomial or the best fit line that automatically uses the function with the lowest R2 value.
  4. You can now choose to add the trend line to the legend and to display the trend fit or equationtoo.

how to add a trend line to a chart in datapine

 

 

Types of Trendlines

 

datapine offers a variety of trendlines to choose from. Please find below the list of trendlines and explanations that datapine offers.

 

Exponential

 

An exponential trendline is a curved line that is most useful when data values rise or fall at increasingly higher rates. You cannot create an exponential trendline of your data which contains zero or negative values.

 

exponential trend line example

 

Linear

 

The linear trendline is a straight line that is used with simple linear data sets. Your data is linear if the pattern of its data points resembles a line. A linear trend line usually indicates a steady growth or decrease in your data.

 

linear trend line example

 

 

Logarithmic

 

A logarithmic trendline is a best-fit curve that is most useful when the rate of change between one unit of your data increases or decreases quickly and then levels out. A logarithmic trendline can be used when having positive and negative values.

 

logarithmic trend line example

 

Polynomial

 

A polynomial trend line is a form of linear regression used when data fluctuates. Use this type of regressions when analyzing gains and losses over larger data sets to adjust the trend to the fluctuations. The order of the polynomials determines the number of ups and downs in your curve. Choosing an order 2 usually has only one fluctuation, order 3 has two hills or valleys and order 4 contains already 3 fluctuations.

 

polynomial trend line example

 

Power

 

A power trendline is a curved line that is best used for data sets that compare measurements that increase at a specific rate. Power regressions will not allow a negative input value or an input value of zero.

 

power trend line example

 

Best Fit Line

 

The best fit line will automatically choose the best trend function for your data with the lowest R2 value.