G3101 Basics of geological data treatment

Faculty of Science
Autumn 2011 - acreditation

The information about the term Autumn 2011 - acreditation is not made public

Extent and Intensity
1/2. 4 credit(s). Type of Completion: graded credit.
Teacher(s)
Mgr. Renata Čopjaková, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Rostislav Melichar, Dr.
Department of Geological Sciences – Earth Sciences Section – Faculty of Science
Contact Person: doc. Mgr. Martin Ivanov, Dr.
Prerequisites
! G3100 Geological Data Treatment && ( (!( PROGRAM ( B - GE )|| PROGRAM ( N - GE )|| PROGRAM ( D - GE4 )|| PROGRAM ( D - GE )|| PROGRAM ( C - CV ))) || ( NOW ( G0101 Occupational healt and safety )&& NOW ( C7777 Handling chemicals )))
Knowledge of mathematics on secondary school level
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The curriculum is focused on the acquisition of theoretical background to statistical analysis of numerical data in geosciences and their practical treatment using Microsoft Excel. The students are acquainted with principles of probability, descriptive (exploratory)statistics, statistical inference, parametric and non-parametric testing of hypotheses, characterisation of multidimensional datasets by regression and correlation analysis, time-series analysis, multivariate methods of statistical analysis (cluster, discriminant, factor etc.).
Syllabus
  • 1. Introduction. Teach-in. The notion of data, types of geological data. Stages of data analysis: Data acquisition; analysis and choice of data. Formalisation (codification and standardization) of data. Data recording and classification. Exploratory data analysis, graphical presentation, types of graphs used in geosciences. Factual interpretation and formulation of results závěrů.

    2. History and present of statistics. Examples of usage of statistics in geology. Basic statistical terms: statistical unit, statistical variable (qualitative/ quantitative; ordinal; continuous / discrete; alternative), statistical population (unidimensional, multidimensional). Definition of probability, random variable.

    3. Description of univariate data. Random sampling. Distribution of data in the population - freequency distribution. Frequency - absolute, relative, cummulative. Graphing the frequency distribution; probability paper.

    4. Basic statistical parameters Median, quantiles, mode, range. Moments: arithmetic mean, variance, standard deviation, coefficient of variation), skewnes, curtosis. Geometrical mean. Harmonical mean.

    5. Basic types of frequency distributions. Distributions - normal, log-normal, binomial aand Poisson, special types (t-, F, chi square distributions). Examples of geological phenomena and their frequency distributions. Statistical inference. Estimates of the parameters of population. Properties of estimates, consistence, accuracy, robustness.

    6. Testing statistical hypotheses Basic terms and testing procedures. Errors of the first and second type. Goodness of fit tests, test of variance, significance tests of difference between means. Paired tests. Identification of outliers. Analysis of variance(one-way, two-way). Non-parametrical testing (test for randomness, Wilcoxon test, Mann-Whitney test)

    7. Statistical description of relations between variables. Correlation analysis. Regression analysis (simple linear correlation, nonlinear correlation, multiple correlation.

    8. Multivariate statistical methods. Discriminant analysis. Cluster analysis (hierarchical, nonhierarchical methods, fuzzy clustering). Factor analysis, principle components method.

Literature
    recommended literature
  • ZVÁRA, Karel. Biostatistika. 1. vyd. Praha: Karolinum. 210 s. ISBN 8071847739. 1998. info
  • Statistické zpracování experimentálních dat :v chonometrii, biometrii, ekonometrii a v dalších oborech přírodních , technických a společenských věd. Edited by Milan Meloun. 2. vyd. Praha: East Publishing. xxi, 839 s. ISBN 80-7219-003-2. 1998. info
  • LEPŠ, Jan. Biostatistika. Vyd. 1. České Budějovice: Jihočeská universita. 165 s. ISBN 8070401540. 1996. info
  • BRÁZDIL, Rudolf. Statistické metody v geografii : cvičení. 3. vyd. Brno: Vydavatelství Masarykovy univerzity. 177 s. ISBN 8021012609. 1995. info
  • BRÁZDIL, Rudolf, Miroslav KOLÁŘ and Pavel PROŠEK. Statistické metody v geografii (Statistical methods in geography). Brno: Masarykova univerzita Brno. 177 pp. ISBN 80-210-1260. 1993. info
  • HANOUSEK, Jan and Pavel CHARAMZA. Moderní metody zpracování dat :matematická statistika pro každého. 1. vyd. Praha: Grada. 210 s. ISBN 80-85623-31-5. 1992. info
  • SATTRAN, Vladimír and Blahomil SOUKUP. Použití matematických metod v geologii. Vyd. 1. Praha: Ústřední ústav geologický v Academii. 153 s. 1973. info
Teaching methods
lectures and theoretical training, statistical functions in the Excel
Assessment methods
The final test of theoretical and practical knowledge (Excel)
Language of instruction
Czech
Further comments (probably available only in Czech)
The course is taught once in two years.
Information on the per-term frequency of the course: Bude otevřen v podzimním semestru 2011/2012.
The course is taught: every week.
Listed among pre-requisites of other courses
The course is also listed under the following terms Autumn 2007 - for the purpose of the accreditation, Autumn 2003, Autumn 2004, Autumn 2005, Autumn 2007, Autumn 2011, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2019, Autumn 2020, autumn 2021, Autumn 2022, Autumn 2023, Autumn 2024.