PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL
Autor(a) principal: | |
---|---|
Data de Publicação: | 2021 |
Outros Autores: | , , |
Tipo de documento: | Artigo |
Idioma: | por |
Título da fonte: | Química Nova (Online) |
Texto Completo: | http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0100-40422021000700874 |
Resumo: | 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. |
id |
SBQ-3_cc7dad50af5bc61e826386acdbd4ffe7 |
---|---|
oai_identifier_str |
oai:scielo:S0100-40422021000700874 |
network_acronym_str |
SBQ-3 |
network_name_str |
Química Nova (Online) |
repository_id_str |
|
spelling |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIALOctavemixture designanalysis of varianceregression modeltemplate mixturespartial derivativesMIXTURE 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.Sociedade Brasileira de Química2021-01-01info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersiontext/htmlhttp://old.scielo.br/scielo.php?script=sci_arttext&pid=S0100-40422021000700874Química Nova v.44 n.7 2021reponame:Química Nova (Online)instname:Sociedade Brasileira de Química (SBQ)instacron:SBQ10.21577/0100-4042.20170750info:eu-repo/semantics/openAccessHilário,Felipe FerriCastro,Jeyne PricyllaBarros,Tomas EdsonPereira-Filho,Edenir Rodriguespor2021-09-08T00:00:00Zoai:scielo:S0100-40422021000700874Revistahttps://www.scielo.br/j/qn/ONGhttps://old.scielo.br/oai/scielo-oai.phpquimicanova@sbq.org.br1678-70640100-4042opendoar:2021-09-08T00:00Química Nova (Online) - Sociedade Brasileira de Química (SBQ)false |
dc.title.none.fl_str_mv |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL |
title |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL |
spellingShingle |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL Hilário,Felipe Ferri Octave mixture design analysis of variance regression model template mixtures partial derivatives |
title_short |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL |
title_full |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL |
title_fullStr |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL |
title_full_unstemmed |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL |
title_sort |
PLANEJAMENTO DE MISTURAS E VISUALIZAÇÃO DA REGIÃO ÓTIMA COM PLANILHAS NO EXCEL: UM TUTORIAL |
author |
Hilário,Felipe Ferri |
author_facet |
Hilário,Felipe Ferri Castro,Jeyne Pricylla Barros,Tomas Edson Pereira-Filho,Edenir Rodrigues |
author_role |
author |
author2 |
Castro,Jeyne Pricylla Barros,Tomas Edson Pereira-Filho,Edenir Rodrigues |
author2_role |
author author author |
dc.contributor.author.fl_str_mv |
Hilário,Felipe Ferri Castro,Jeyne Pricylla Barros,Tomas Edson Pereira-Filho,Edenir Rodrigues |
dc.subject.por.fl_str_mv |
Octave mixture design analysis of variance regression model template mixtures partial derivatives |
topic |
Octave mixture design analysis of variance regression model template mixtures partial derivatives |
description |
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. |
publishDate |
2021 |
dc.date.none.fl_str_mv |
2021-01-01 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0100-40422021000700874 |
url |
http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0100-40422021000700874 |
dc.language.iso.fl_str_mv |
por |
language |
por |
dc.relation.none.fl_str_mv |
10.21577/0100-4042.20170750 |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
text/html |
dc.publisher.none.fl_str_mv |
Sociedade Brasileira de Química |
publisher.none.fl_str_mv |
Sociedade Brasileira de Química |
dc.source.none.fl_str_mv |
Química Nova v.44 n.7 2021 reponame:Química Nova (Online) instname:Sociedade Brasileira de Química (SBQ) instacron:SBQ |
instname_str |
Sociedade Brasileira de Química (SBQ) |
instacron_str |
SBQ |
institution |
SBQ |
reponame_str |
Química Nova (Online) |
collection |
Química Nova (Online) |
repository.name.fl_str_mv |
Química Nova (Online) - Sociedade Brasileira de Química (SBQ) |
repository.mail.fl_str_mv |
quimicanova@sbq.org.br |
_version_ |
1750318121445490688 |