XLSTAT-PLS

XLSTAT-PLS is an Excel add-in that has been developed to provide XLSTAT-Pro users with a powerful solution for Partial Least Squares regression. All XLSTAT-PLS functions have been intensively tested against other software to guarantee the users fully reliable results.

Partial Least Squares Regression is a method that was developed during the 1980s, and that is now used in more and more industries and research fields. It frees oneself from some of the constraints of the classical linear regression (Ordinary Least Squares regression - OLS): with PLS regression it is possible to model one or more dependent variables by a very high number of explanatory variables whatever the number of observations without running the risk of obtaining an overfitted model. This module also makes available PCR (Principal Components Regression and OLS regression.

Method Description
PLS regression
  • PLS1 and PLS2 regression
  • Explanatory variables can be quantitative and/or qualitative
  • Computes and displays components
  • Correlation charts and biplots
  • Equations of the models
  • Standardized coefficients and confidence intervals
  • Predictions and residuals
  • Predictions and residuals on validation set
  • Predictions on prediction set
PCR regression
  • Explanatory variables can be quantitative and/or qualitative
  • PCA with options adapted for the regression
  • Correlation and observations charts and biplots
  • Goodness of fit statistics, analysis of variance
  • Model coefficients with the components
  • Model coefficients with the input variables
  • Standardized coefficients and confidence intervals
  • Display of the equation
  • Predictions and residuals
  • Predictions and residuals on validation set
  • Predictions on prediction set
OLS regression
  • Explanatory variables can be quantitative and/or qualitative
  • Four methods for selecting variables with several possible criteria
  • Analysis of variance, Type I SS, Type III SS
  • Model coefficients
  • Standardized coefficients and confidence intervals
  • Display of the equation
  • Predictions and residuals
  • Predictions and residuals on validation set
  • Predictions on prediction set

Maximum size of datasets:

65500 rows and 250 columns. Variables can be in rows or in columns.

Available languages:

English, German, Spanish, Italian, Portuguese, Japanese, French.

Demo version

A trial version of XLSTAT-PLS is included in the main XLStat-Pro download.

Ordering XLStat-PLS

The prices, in UK£ and US$, for academic and commercial users are listed below. There are two ordering options:

  1. E-mail only - a registration code will be e-mailed to you that will unlock the demo version of the program from our web site.
  2. With CD-ROM - this costs an additional £15 ($30) + shipping & handling.

You can order on-line using our secure shopping cart facility below. Simply choose the required item and price and press the "Add to cart" button in that row to add the item to your shopping cart.

Item Price (ex VAT & shipping)
Order
XLStat-Pro and XLStat-PLS (e-mail only)
XLStat-Pro and XLStat-PLS (CD-ROM)

If you already have XLStat-Pro then use the section below to order just the advanced module. Please send us your original XLStat-Pro serial number, either in the Special Instructions section of the order form or in a separate e-mail.

XLStat-PLS (e-mail only)
XLStat-PLS (CD-ROM)

Notes:

  1. Academic prices (where offered) apply to students and staff at educational institutions using the software for research as well as charities/NGOs and residents of least developed countries. Governmental bodies pay the commercial price. Commercial prices also apply if the software is to be used for commercial consulting within universities.
  2. VAT - Customers within the UK will have Value Added Tax at 17.5% added to the order. Those in other countries in the European Union will also have VAT added, unless they are registered for VAT in their own country and supply their registration number with their order (in the "Special Instructions" section at checkout). Our VAT registration number is GB 625 3760 41.
  3. If you wish to order by fax or postal mail, or need to pay by means other than credit card, then you can also use the shopping cart above, but choose the appropriate option when you check out. You can also print out and use our printed order form.
  4. All credit card orders are charged in British pounds. The US$ prices apply only when paying in US$ by check (drawn on a US bank) or bank transfer.
  5. Your order will normally be processed within two working days. Orders outside of the United Kingdom are shipped by air-mail. Within the UK first class post is used.
  6. All prices above are for single computer/user licenses. The program may only be used on a single computer, or by a single user on up to two computers (i.e. a single user can use it on both an office computer and a laptop, so long as no one else is using those computers). Contact us for discounts on multiple copies and site licenses.

 

Copyright © 2008 Kovach Computing Services, Anglesey, Wales. All Rights Reserved. Portions copyright Addinsoft, Provalis Research, and Data Description Inc.

Last modified 8 May, 2008