Czech

Not applicable.

Integral information on fundamental methods of numerical treatment
of one-dimensional data, fundamental methods of numerical treatment of
simple dependences and data smoothing.
Practical utilization of acquired piece of knowelge in experimental
data processing from selected thematic fields in MS-Excel environment.

Knowledge from courses Hydrochemistry, Technology of water treatment, Laboratory classes - technology of water treatment I; capability to work in environment of MS Excel

Not applicable.

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Graded course-unit credit
Requirements:
- successful passing of credit test
- oral examination by colloquial form

1. Chemical data
2. Probability and statistics. Probability distributions
3. Point estimators, confidence intervals, significance levels and hypotesis tests
4. Tests for comparison of means
5. Transformation of instrumental data
6. Design of experiments
7. Analysis of variance (ANOVA)
8. Linear models
9. Quantification of analytes. Mesure of performance of analytical methods
10. Mesurement of data quality
11. Non-parametric tests
12. Numerical treatment of data
13. Multiple regression

Not applicable.

Replenishment and acquisition of new theoretical information and practical know-how necessary for numerical processing of data acquired by own experimental activities.

none

Not applicable.

Not applicable.

Milan Meloun a Jiří Militký: Kompendium statistického zpracování dat. Academia 2002 (CS)
Zdeněk Šťastný: Matematické a statistické výpočtu v Microsoft® Excelu. Computer Press Brno 1999, ISBN 80-7226-141-X (CS)

Billo, E. J.: MS Excel for Chemists. John Wiley & Sons, Inc., New York 1997 (CS)
F. Carley and P. H. Morgan: Computaional Methods in the Chemical Sciences. Ellis Horwood Limited Chichester 1989, ISBN 0-85312-746-8 (CS)
Green, J. R. a Margerison, D.: Statistical treatment of experimental data. Elsevier Sci. Publ. Comp. Amsterodam 1978 (CS)
Jerald L. Schnoor: Environmental Modeling. John Wiley a Sons, Inc., New York 1996, ISBN 0-471-12436-2 (CS)
Richard C. Graham: Data Analysis for the Chemical Sciences. VCH Publishers, Inc., New York, 1993, ISBN 1-56081-048-3 (CS)