G3101 Basics of geological data treatment

Faculty of Science
Autumn 2015
Extent and Intensity
1/2. 4 credit(s). Type of Completion: graded credit.
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.
Supplier department: Department of Geological Sciences - Earth Sciences Section - Faculty of Science
Thu 10:00–11:50 Bp1,01007, Thu 12:00–12:50 Bp1,01007
! 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.

The capacity limit for the course is 20 student(s).
Current registration and enrolment status: enrolled: 0/20, only registered: 0/20
fields of study / plans the course is directly associated with
there are 26 fields of study the course is directly associated with, display
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.).
  • 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.

    2. History and the 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 - frequency distribution. Frequency - absolute, relative, cumulative. Graphing the frequency distribution; probability paper.

    4. Basic statistical parameters Median, quantiles, mode, range. Moments: arithmetic mean, variance, standard deviation, coefficient of variation), skewness, kurtosis. 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.

    recommended literature
  • ZVÁRA, Karel. Biostatistika. 1. vyd. Praha: Karolinum, 1998. 210 s. ISBN 8071847739. 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, 1998. xxi, 839 s. ISBN 80-7219-003-2. info
  • LEPŠ, Jan. Biostatistika. Vyd. 1. České Budějovice: Jihočeská universita, 1996. 165 s. ISBN 8070401540. info
  • BRÁZDIL, Rudolf. Statistické metody v geografii : cvičení. 3. vyd. Brno: Vydavatelství Masarykovy univerzity, 1995. 177 s. ISBN 8021012609. info
  • HANOUSEK, Jan and Pavel CHARAMZA. Moderní metody zpracování dat :matematická statistika pro každého. 1. vyd. Praha: Grada, 1992. 210 s. ISBN 80-85623-31-5. info
  • SATTRAN, Vladimír and Blahomil SOUKUP. Použití matematických metod v geologii. Vyd. 1. Praha: Ústřední ústav geologický v Academii, 1973. 153 s., ii. 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
Further Comments
Study Materials
The course is taught annually.
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 2011 - acreditation, Autumn 2013, Autumn 2014, Autumn 2019, Autumn 2020.
  • Enrolment Statistics (Autumn 2015, recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2015/G3101