XLSTAT wird Mitglied der Lumivero Familie. Mehr erfahren.

Analyse eines Mischungsplan

Use this tool to analyze a mixture design for 2 to 6 factors. Available in Excel with the XLSTAT software.

Ternary.PNG

What is mixture design analysis

Description of models

The analysis of a mixture design is based on the same principle as linear regression. The major difference comes from the model that is used. Several models are available.

By default, XLSTAT associates a reduced model (Simplified Canonical Model) to centroïd simplexes. However, it is possible to change the model if the number of degrees of freedom is sufficient (by increasing the number of repetitions of the experiments).

To fulfil the constraint associated to a mixture design, a polynomial model with no intercept is used. We distinguish two types of models, simplified (special) models and full models (from level 3).

The following models are available:

  • Linear model (level 1)
  • Quadratic model (level 2)
  • Full cubic model (level 3)
  • Simplified cubic model (special)
  • XLSTAT allows to apply models up to level 4 (simplified and full quartic model).

Estimation of these models is done with classical regression. 

Responses optimization and desirability

In the case of many response values y1, ..., ym​ it is possible to optimize each response value individually and to create a combined desirability function and analyze its values. Proposed by Derringer and Suich (1980), this approach is to first convert each response yi​ into an individual desirability function di​ that varies over the range 0 ≤ di ​≤ 1.

In the display, XLSTAT gives the 5 best solutions found during the optimization.

Outputs of the analysis of a mixture design in XLSTAT

Variables information: This table shows the information about the factors. For each factor the short name, long name, unit and physical unit are displayed.

Responses optimization: This table gives the 5 best solutions obtained during the responses optimization.

Correlation matrix: This table is displayed to give you a view of the correlations between the various variables selected.

Goodness of fit statistics: The statistics relating to the fitting of the regression model are shown in this table (number of observations, sum of weights, DF, R2, adjusted R2, MSE, RMSE, MAPE, the Durbin-Watson statistic (DW), Mallows Cp coefficient (Cp), AIC, Schwarz' Bayesian (SBC), Amemiya’s Prediction Criterion (PC), Press' statistic, Q2).

The analysis of variance table is used to evaluate the explanatory power of the explanatory variables. 

The parameters of the model table displays the estimate of the parameters, the corresponding standard error, the Student’s t, the corresponding probability, as well as the confidence interval.

The equation of the model is then displayed to make it easier to read or re-use the model.

The table of standardized coefficients (also called beta coefficients) are used to compare the relative weights of the variables. The higher the absolute value of a coefficient, the more important the weight of the corresponding variable. When the confidence interval around standardized coefficients has value 0 (this can be easily seen on the chart of standardized coefficients), the weight of a variable in the model is not significant.

The predictions and residuals table shows, for each observation, its weight, the value of the qualitative explanatory variable, if there is only one, the observed value of the dependent variable, the model's prediction, the residuals, the confidence intervals together with the fitted prediction and Cook's D if the corresponding options have been activated in the dialog box. 

The charts which follow show the results mentioned above. If there is only one explanatory variable in the model, the first chart displayed shows the observed values, the regression line and both types of confidence interval around the predictions. The second chart shows the standardized residuals as a function of the explanatory variable. In principle, the residuals should be distributed randomly around the X-axis. If there is a trend or a shape, this shows a problem with the model.

The three charts displayed next respectively show the evolution of the standardized residuals as a function of the dependent variable, the distance between the predictions and the observations (for an ideal model, the points would all be on the bisector), and the standardized residuals on a bar chart. The last chart quickly shows if an abnormal number of values are outside the interval ]-2, 2[]−2,2[ given that the latter, assuming that the sample is normally distributed, should contain about 95% of the data.

For each combination of factors, we draw a ternary diagram. This graph shows a response surface on one of the faces of the polyhedron to which the experimental space corresponds. These charts facilitate the interpretation of the model and allow to identify the optimal configurations.

ternary diagramneural network diagram

analysieren sie ihre daten mit xlstat

kostenlose 14-tage-testversion