Rank-based regression in Excel
This tutorial shows how to run a rank-based regression in Excel using the XLSTAT-R engine.
What is rank-based regression?
Rank-based regression allows estimating rank-based coefficients for linear models. Those estimations are considered to be more robust with regards to outliers compared to more classical estimation approaches.
The Rank-based regression function developed in XLSTAT-R calls the rfit function from the Rfit package in R (John Kloke).
Data set for launching a rank-based regression in XLSTAT-R
The data corresponds to the data used in the XLSTAT ANCOVA analysis in Excel tutorial.
Setting up a rank-based regression in XLSTAT-R
Open R / Rfit / Rank-Based Regression
Fill in the general tab as follows:
Activate the Interactions option in the Options tab.
In the dialog box that appears, select the terms you want to include in the model:
Select the terms you want to keep and click OK.
Interpret the results.
Was this article useful?