Home
Courses
Industrial Chemistry
Analysis and Data Processing in Chemistry

Analysis and Data Processing in Chemistry

Code	15970
Year	2
Semester	S1
ECTS Credits	5
Workload	TP(60H)
Scientific area	Industrial Chemistry
Entry requirements	basic math knowledge
Learning outcomes	This course aims to enable students with the set of skills/knowledge required for the use of non-specialized (Microsoft Excel) and specialized software (IBM SPSS Statistics) into the statistical analysis of experimental data collected in the context of Chemistry, namely: - Identify, minimize and quantify the sources of error in analytical determinations with the goal to increase reliability; - plan, deliver and treat the results of analytical determinations based on calibration curves or by standard addition method; - organize and resume experimental data in tables and graphics; - ability to support conclusions and technical reports on the statistical analysis of experimental data collected.
Syllabus	1. Fundamentals of Statistics Nature and context of analytical problems Identification and classification of statistical variables Population vs Sample and Statistic and Parameter Descriptive Statistics Point estimative vs Confidence Interval Normal distribution, t-Student distribution, Binominal and Qui-Square Unilateral and bilateral hypothesis testing p-Value 2. Use of SPSS and Excel Software presentations and characteristics Descriptive Statistics Study of Normality of Quantitative Variables Association tests between qualitative variables Correlation Evaluation Average and median tests of a sample Mean and median tests of two independent samples Mean and median tests of two paired samples ANOVA (Mean and median tests of three or more independent samples) Mean and median tests of three or more paired samples 3. Calibration and Regression Calibration curves in instrumental analysis Unweighted and weighted Linear regression
Main Bibliography	1.Bibliografia principal (Livros em Português) Natália Cordeiro e Alexandre Magalhães, "Introdução à Estatística – Uma perspectiva química", Lidel, 2004 Bento José Ferreira Murteira, "Probabilidade e Estatística", MacGraw-Hill Portugal, 1979 António Robalo, "Estatística" (vol I, II e III), Edições Sílabo, 1991 João Marôco, “Análise Estatística com o SPSS Statiscs”, Edição ReporterNumber, 6ª Edição – 2014. “Guia rápido do IBM SPSS Statistics 25”, Ed. IBM Corporation. 2.Bibliografia complementar (Livros em Inglês) Thomas P. Ryan, "Modern Engineering Statistics", Wiley-Interscience, 2007 Philip Rowe, "Essential Statistics for the Pharmaceutical Sciences", Willey, 2007 Douglas A. Skoog, Donald M. West and F. James Holler, "Analytical Chemistry: An introduction", Saunders College Publishing, 5th ed., 1990 J.C. Miller and J.N. Miller, "Statistical for analytical chemistry", Ellis Horwood and Prentice Hall, 1984 Sidney Tyrrel, “SPSS: Stats Practically short and Simple”, Ed. Bookboon.com, 2009
Teaching Methodologies and Assessment Criteria	Classes are fundamentally of a theoretical-practical nature, with exposition of the main contents by the teacher and with practical sheets of application and consolidation of the contents presented. It is intended to create a participatory and motivational teaching-learning process, frequently using multimedia elements and computer programs (Excel and SPSS) to organize experimental data, using tables and graphs, and perform statistical analysis. The Assessment will include the completion of worksheets, where students demonstrate the ability to solve problems/practical questions of the syllabus and also written tests.
Language	Portuguese. Tutorial support is available in English.