Dose effect analysis with XLSTAT

Probit, Logit and related modeling methods, are very useful techniques when one wants to understand or to predict the effect of a series of variables on a binary response variable (a variable which can take only two values, 0/1 or Yes/no, for example). Probit and Logit regression can be helpful to model the effect of doses in medicine, agriculture, or chemistry.

With the XLSTAT Dose Effect Analysis module you can either run the analysis on raw data (the response is given as 0s and 1s) or on aggregated data (the response is a sum of "successes" or ones, and the number of repetitions must also be available).

The methodology of logistic regression aims at modeling the probability of success depending on the values of the explanatory variables, which can be categorical or numerical variables.

The example treated here is an agrochemical case where a phytosanitary product is tested at different doses on a given species of caterpillars (grouped in boxes). The experimenters have recorded the initial number of caterpillars and the number killed after 6 hours for the various doses. An experiment was conducted with a null dose to help evaluating the natural mortality effect. An Excel sheet with both the data and the XLSTAT-Dose results can be downloaded by clicking here.

To activate the XLSTAT-Dose dialog box, start XLSTAT, then select the XLSTAT/Modeling data/XLSTAT-Dose command, or click on the corresponding button of the "Modeling Data" toolbar (see below).

When you click on the button, a dialog box appears.

Select the data on the Excel sheet. The "Response variable" corresponds to the column where the binary variable or the counts of positive cases are stored (NB: when using aggregated data the "Observation weights" must be selected). In this particular case we have one explanatory variable, the Dose.

In the "Options" tab, we selected the "Take the log" option as we know that the Probit model is usually better fitted when the log of the dose is used instead of the dose itself. The Probit model is one of the four possible models.

As we selected the column titles of all variables, we left checked the option "Variable labels" option.

In the "Options tab", the "Natural mortality parameter" option was activated to take into account the natural mortality of the caterpillars. We could either use a fixed (or user defined) value based on the null dose experiment (2/35 = 5.7 %), or ask XLSTAT to optimize the value. We chose to optimize it in this particular case.

The results are displayed on a new sheet as requested in the first dialog box.

Interpreting the results of a dose effect analysis

The first table after the descriptive statistics gives several indicators of the quality of the model (or goodness of fit). These results are equivalent to the R2 and to the analysis of variance table in linear regression and ANOVA. The most important value to look at is the probability of Chi-square test on the log ratio of the likelihoods (-2Log(Loglike)). This is equivalent to the Fisher's F test: We try to evaluate if the variables bring significant information by comparing the model as it is defined with a simpler model with only one constant. In this case, as the probability is lower than 0.0001, we can conclude that significant information is brought by the Log(Dose) variable and the mortality.

The next table gives the estimates of the parameters of the model. We can see from the very low Chi-Square probabilitiy that the Log(Dose) variable explains well the variability of the mortality. The value of the natural mortality is also given. The optimized mortality is 0.126, meaning that, given the data, it is likely that 12.6% of the caterpillars died because of factors other than the dose. This is a higher than what the null dose experience gave (2/35 = 5.7 %).

A table gives the predicted values and the residuals. This table can be used to find some regions where the model doesn't fit well. The chart which is part of the results shows the data points, the model, and the confidence range around the model. The abscissa are displayed on a log scale if the "Take the log" was selected in the dialog box.

When doing dose effects analysis you often compute the effective doses (EDs). They are used to answer the following question: which dose needs to be applied so that x% of the caterpillars are killed by the product? The table below answers that question. In this case, the doses corresponding to the first 3 probabilities cannot be computed because they are below the natural mortality threshold (0.126).

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