<?xml version="1.0" encoding="ISO-8859-1"?><article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<front>
<journal-meta>
<journal-id>0187-893X</journal-id>
<journal-title><![CDATA[Educación química]]></journal-title>
<abbrev-journal-title><![CDATA[Educ. quím]]></abbrev-journal-title>
<issn>0187-893X</issn>
<publisher>
<publisher-name><![CDATA[Universidad Nacional Autónoma de México, Facultad de Química]]></publisher-name>
</publisher>
</journal-meta>
<article-meta>
<article-id>S0187-893X2016000100021</article-id>
<article-id pub-id-type="doi">10.1016/j.eq.2015.09.009</article-id>
<title-group>
<article-title xml:lang="es"><![CDATA[Ajustando datos químicos con Excel: un tutorial práctico]]></article-title>
<article-title xml:lang="en"><![CDATA[Fitting chemical data with Excel: A practical tutorial]]></article-title>
</title-group>
<contrib-group>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Jurado]]></surname>
<given-names><![CDATA[José Marcos]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Muñiz-Valencia]]></surname>
<given-names><![CDATA[Roberto]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Alcázar]]></surname>
<given-names><![CDATA[Angela]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Ceballos-Magaña]]></surname>
<given-names><![CDATA[Silvia Guillermina]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[González]]></surname>
<given-names><![CDATA[Jorge]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
</contrib-group>
<aff id="Af1">
<institution><![CDATA[,Universidad de Sevilla Departamento de Química Analítica ]]></institution>
<addr-line><![CDATA[Sevilla ]]></addr-line>
<country>ES</country>
</aff>
<aff id="Af2">
<institution><![CDATA[,Universidad de Colima Facultad de Ciencias Químicas ]]></institution>
<addr-line><![CDATA[ Colima]]></addr-line>
<country>MX</country>
</aff>
<aff id="Af3">
<institution><![CDATA[,Universidad de Colima Facultad de Ciencias ]]></institution>
<addr-line><![CDATA[ Colima]]></addr-line>
<country>MX</country>
</aff>
<pub-date pub-type="pub">
<day>00</day>
<month>00</month>
<year>2016</year>
</pub-date>
<pub-date pub-type="epub">
<day>00</day>
<month>00</month>
<year>2016</year>
</pub-date>
<volume>27</volume>
<numero>1</numero>
<fpage>21</fpage>
<lpage>29</lpage>
<copyright-statement/>
<copyright-year/>
<self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_arttext&amp;pid=S0187-893X2016000100021&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_abstract&amp;pid=S0187-893X2016000100021&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_pdf&amp;pid=S0187-893X2016000100021&amp;lng=en&amp;nrm=iso"></self-uri><abstract abstract-type="short" xml:lang="es"><p><![CDATA[Excel es un programa de hojas de cálculo incluido en Microsoft Office utilizado en un gran número de empresas públicas y privadas en el mundo. Este programa permite realizar muchas operaciones, como el ajuste de datos experimentales a funciones matemáticas. Estas tareas son comunes en los laboratorios químicos, y parece razonable entrenar a los profesionales en el uso de estas herramientas. En este trabajo se han estudiado 4 metodologías de ajuste usando este programa, resolviendo algunos ejemplos prácticos de datos químicos, considerando sus ventajas y desventajas.]]></p></abstract>
<abstract abstract-type="short" xml:lang="en"><p><![CDATA[Excel is spreadsheets software included in Microsoft Office that is used in a high number of public and private companies all over the world. This program allows carrying out many operations such as fitting experimental data to mathematical functions. These tasks are usually performed in chemical laboratories and, accordingly, it seems reasonable to train professionals in the use of these tools. In this work, four fitting methodologies using this program have been studied by solving some practical examples of chemical data, considering their advantages and disadvantages.]]></p></abstract>
<kwd-group>
<kwd lng="es"><![CDATA[Excel]]></kwd>
<kwd lng="es"><![CDATA[Hojas de cálculo]]></kwd>
<kwd lng="es"><![CDATA[Ajuste lineal]]></kwd>
<kwd lng="es"><![CDATA[Ajuste no lineal]]></kwd>
<kwd lng="es"><![CDATA[Estimación de errores]]></kwd>
<kwd lng="en"><![CDATA[Excel]]></kwd>
<kwd lng="en"><![CDATA[Spreadsheets]]></kwd>
<kwd lng="en"><![CDATA[Linear fitting]]></kwd>
<kwd lng="en"><![CDATA[Nonlinear fitting]]></kwd>
<kwd lng="en"><![CDATA[Error estimation]]></kwd>
</kwd-group>
</article-meta>
</front><back>
<ref-list>
<ref id="B1">
<nlm-citation citation-type="book">
<collab>ANECA</collab>
<source><![CDATA[Libro Blanco. Título de Grado en Química]]></source>
<year>2004</year>
<publisher-name><![CDATA[Agencia Nacional de Evaluación de la Calidad y Acreditación (ANECA)]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B2">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Fitting straight lines with replicated observations by linear regression. IV. Transforming data]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Asuero]]></surname>
<given-names><![CDATA[A.G.]]></given-names>
</name>
<name>
<surname><![CDATA[Bueno]]></surname>
<given-names><![CDATA[J.M.]]></given-names>
</name>
</person-group>
<source><![CDATA[Critical Reviews in Analytical Chemistry]]></source>
<year>2011</year>
<volume>41</volume>
<page-range>36-69</page-range></nlm-citation>
</ref>
<ref id="B3">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Billo]]></surname>
<given-names><![CDATA[E.J.]]></given-names>
</name>
</person-group>
<source><![CDATA[Excel for Scientist and Engineers. Numerical methods]]></source>
<year>2007</year>
<publisher-loc><![CDATA[Hoboken, EE.UU. ]]></publisher-loc>
<publisher-name><![CDATA[John Wiley & Sons]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B4">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Estimating parameter precision in nonlinear least squares with Excel's Solver]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[De Levie]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Journal of Chemical Education]]></source>
<year>1999</year>
<volume>76</volume>
<page-range>1594-8</page-range></nlm-citation>
</ref>
<ref id="B5">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Curve fitting with least squares]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[De Levie]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Critical Reviews in Analytical Chemistry]]></source>
<year>2000</year>
<volume>30</volume>
<page-range>59-74</page-range></nlm-citation>
</ref>
<ref id="B6">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Gil]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
</person-group>
<source><![CDATA[Experimentos de Física. Usando las TIC y elementos de bajo costo]]></source>
<year>2012</year>
<publisher-loc><![CDATA[Buenos Aires, Argentina ]]></publisher-loc>
<publisher-name><![CDATA[Alfaomega]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B7">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Nonlinear least-squares curve fitting with Microsoft Excel Solver]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Harris]]></surname>
<given-names><![CDATA[D.C.]]></given-names>
</name>
</person-group>
<source><![CDATA[Journal of Chemical Education]]></source>
<year>1998</year>
<volume>75</volume>
<page-range>119-21</page-range></nlm-citation>
</ref>
<ref id="B8">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Harvey]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
</person-group>
<source><![CDATA[Modern Analytical Chemistry]]></source>
<year>2000</year>
<publisher-loc><![CDATA[Boston, EE.UU. ]]></publisher-loc>
<publisher-name><![CDATA[McGraw-Hill]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B9">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Direct determination of copper, lead and cadmium in aniseed spirits by electrothermal atomic absorption spectrometry]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Jurado]]></surname>
<given-names><![CDATA[J.M.]]></given-names>
</name>
<name>
<surname><![CDATA[Martín]]></surname>
<given-names><![CDATA[M.J.]]></given-names>
</name>
<name>
<surname><![CDATA[Pablos]]></surname>
<given-names><![CDATA[F.]]></given-names>
</name>
<name>
<surname><![CDATA[Moreda]]></surname>
<given-names><![CDATA[A.]]></given-names>
</name>
<name>
<surname><![CDATA[Bermejo]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
</person-group>
<source><![CDATA[Food Chemistry]]></source>
<year>2007</year>
<volume>101</volume>
<page-range>1296-304</page-range></nlm-citation>
</ref>
<ref id="B10">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Jurado]]></surname>
<given-names><![CDATA[JM.]]></given-names>
</name>
</person-group>
<source><![CDATA[Aplicación de Microsoft Excel a la Química Analítica: validación de métodos analíticos]]></source>
<year>2008</year>
</nlm-citation>
</ref>
<ref id="B11">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Miller]]></surname>
<given-names><![CDATA[N.M.]]></given-names>
</name>
<name>
<surname><![CDATA[Miller]]></surname>
<given-names><![CDATA[J.C.]]></given-names>
</name>
</person-group>
<source><![CDATA[Estadística y quimiometría para Química Analítica]]></source>
<year>2002</year>
<publisher-loc><![CDATA[Madrid, España ]]></publisher-loc>
<publisher-name><![CDATA[Prentice Hall]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B12">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Design of an Excel spreadsheet to estimate rate constants, determine associated errors, and choose curve's extent]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Moreira]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Martins]]></surname>
<given-names><![CDATA[F.]]></given-names>
</name>
<name>
<surname><![CDATA[Elvas-Leitão]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Journal of Chemical Education]]></source>
<year>2006</year>
<volume>83</volume>
<page-range>1879-83</page-range></nlm-citation>
</ref>
<ref id="B13">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Current statistical methods for estimating Km and Vmax of Michaelis-Menten kinetics]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ritchie]]></surname>
<given-names><![CDATA[R.J.]]></given-names>
</name>
<name>
<surname><![CDATA[Prvan]]></surname>
<given-names><![CDATA[T.]]></given-names>
</name>
</person-group>
<source><![CDATA[Biochemical Education]]></source>
<year>1996</year>
<volume>24</volume>
<page-range>196-206</page-range></nlm-citation>
</ref>
<ref id="B14">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Skoog]]></surname>
<given-names><![CDATA[D.A.]]></given-names>
</name>
<name>
<surname><![CDATA[Leary]]></surname>
<given-names><![CDATA[J.J.]]></given-names>
</name>
</person-group>
<source><![CDATA[Análisis Instrumental]]></source>
<year>1994</year>
<edition>4.a ed.</edition>
<publisher-loc><![CDATA[Madrid, España ]]></publisher-loc>
<publisher-name><![CDATA[McGraw-Hill]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B15">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Stone]]></surname>
<given-names><![CDATA[DC]]></given-names>
</name>
<name>
<surname><![CDATA[Ellis]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
</person-group>
<source><![CDATA[Stats Tutorial &#8212; Instrumental analysis and calibration]]></source>
<year>2011</year>
</nlm-citation>
</ref>
<ref id="B16">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Whiston]]></surname>
<given-names><![CDATA[C.]]></given-names>
</name>
</person-group>
<source><![CDATA[X-Ray methods. Analytical Chemistry by Open Learning (ACOL)]]></source>
<year>1996</year>
<publisher-loc><![CDATA[New York, NY ]]></publisher-loc>
<publisher-name><![CDATA[John Wiley & Sons]]></publisher-name>
</nlm-citation>
</ref>
</ref-list>
</back>
</article>
