PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL
MIXTURE DESIGN AND OPTIMUM REGION VISUALIZATION WITH SPREADSHEETS AT EXCEL: A TUTORIAL. This tutorial shows how to perform the data treatment for mixture design with two and multiple responses. Two data sets from the literature were used to exemplify the calculations. A template in Excel was proposed to prepare contour plot and response surface to visualize the optimum region of the mixture, which usually is made with commercial computational programs. The desirability function was used in example 2 (optimization of 5 responses simultaneously), and a code also available for download was proposed. Besides, 21 videos were prepared to show all the details for the readers and, it is available on YouTube. With this tutorial, it is possible to learn in a practical fashion how to handle the data from mixture design and, the authors hope to contribute with the researchers in this area.
Main Authors: | Hilário,Felipe Ferri, Castro,Jeyne Pricylla, Barros,Tomas Edson, Pereira-Filho,Edenir Rodrigues |
---|---|
Format: | Digital revista |
Language: | Portuguese |
Published: |
Sociedade Brasileira de Química
2021
|
Online Access: | http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0100-40422021000700874 |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
Similar Items
-
Quimiometria II: planilhas eletrônicas para cálculos de planejamentos experimentais, um tutorial
by: Teófilo,Reinaldo F., et al.
Published: (2006) -
Utilizando analogias para a visualização de equipotenciais com uma planilha de dados
by: Santos,A.C.F., et al.
Published: (2013) -
APLICAÇÃO DE PROGRAMA COMPUTACIONAL LIVRE EM PLANEJAMENTO DE EXPERIMENTOS: UM TUTORIAL
by: Pereira,Fabíola Manhas Verbi, et al.
Published: (2018) -
Ajustando datos químicos con Excel: un tutorial práctico
by: Jurado,José Marcos, et al.
Published: (2016) -
Tutorial de um sistema de visualização da base de dados SIG do projeto "Rede de pesquisa participativa".
by: CARDOSO, J. H.
Published: (2014)