Open AccessPLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL
Author(s) -
Felipe Ferri Hilário,
Jeyne Pricylla Castro,
Tomas Edson Barros,
Edenir Rodrigues Pereira-Filho
Publication year - 2021
Publication title -
química nova
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.214
H-Index - 73
eISSN - 1678-7064
pISSN - 0100-4042
DOI - 10.21577/0100-4042.20170750
Subject(s) - computer science , visualization , computer graphics (images) , plot (graphics) , engineering drawing , data mining , mathematics , statistics , engineering
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