Fitting a cubic spline with XLSTAT

The data that we use are the speed of numerous cars and the distance they need to stop [Ezekiel, M. (1930)]. Note that the data were recorded in the 1920s. Click here to download the spreadsheet.

The goal is to fit those data using a cubic spline. 

Setting up a cubic spline

After opening XLSTAT, select the XLSTAT / Modeling data/ Cubic splines command, or click on the matching button of the toolbar.

Once you've clicked on the button, the dialog box appears.

The data are presented in a table of 50 observations and 2 variables. Speed is the X variable and Distance the Y variable. As we select the column title for the variables, we leave the option Variable labels activated.

Cubic Spline data

In the Options tabthree approaches are proposed to defined the spline nodes. Here we choose to fix the number of nodes to 10.

Cubic spline options tab

The computations begin once you have clicked on OK. The results will then be displayed in a new sheet.

Interpreting the results

The first results being displayed are the statistics and the correlation matrix for the 2 variables. Next, we get the table of the coefficients of the polynomials for each interval.

Cubic spline coefficients

The cubic spline is then displayed on graph.

Cubic spline graphic results

Finally, table and graphs enable us to take a closer look at each of the residuals. 

Click here for other tutorials.

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey


Like us on Facebook Facebook

Get in Touch

  • Email:
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414