Nevron Logo

Polynomial Trend Line in SharePoint with Nevron Chart Web Part

The Polynomial Regression is a form of linear regression in which the relationship between the independent variable x and the dependent variable y is modelled as an nth degree polynomial. Polynomial regression fits a nonlinear relationship between the value of x and the corresponding conditional mean of y, denoted E(y | x), and has been used to describe nonlinear phenomena such as the growth rate of tissues, the distribution of carbon isotopes in lake sediments, and the progression of disease epidemics.

Nevron Chart for SharePoint provides advanced support for drawing Polynomial Trend Lines. The Polynomial Trend Line calculates the polynomial regression of the master series values. The calculation takes into account the X values of master series. You have the option to control the polynomial order and thus create polynomial interpolations of second, third and higher degrees.

You can easily add Polynomial Trend Line to your Nevron Charts in SharePoint by following these steps:

1. Edit the pages with your Nevron Chart Web Part and Run Chart Designer:

Share Point Polynomial Trend Line run designer

2. From the Designer Pivot tab -> Data Groupings -> Values, select the Value Grouping (the master series) for which you will be plotting the Polynomial. Then go to the Calculated Series tab and click the Add button to add a new calculated series:

Share Point Polynomial Trend Line edit value groupings

3. Provide a name for the calculated series and select Polynomial Regression (10) from the Formula field:

Share Point Polynomial Trend Line select polynomial

4. From the properties associated with the Polynomial, you can specify the series type (Line, Smooth Line, Area, or Smooth Area), the Polynomial Order (the Degree of the Polynomial), display on Chart Area, Axes, Z Order, as well as other appearance and styling options. All properties of the Polynomial Trend Line can parametrized by using expressions. For example, this can help you easily see the changes of the Polynomial with a 2nd degree, 3rd degree, or higher order.

Share Point Polynomial Trend Line properties

5. Click OK to save your changes and preview the Polynomial Trend Line on your Chart Web Part:

Polynomial 2nd Order:
Share Point Polynomial Trend Line 2nd order

Polynomial 3rd Order:
Share Point Polynomial Trend Line 3rd order