|
Lecturer(s)
|
|
|
|
Course content
|
1. Introduction to data processing, types of variables from the perspective of informatics and statistics - Introduction to Excel, data insertion and formatting, absolute and relative addressing, data export and import. 2. Table and non-table databases - Operators and functions 3. Data visualization, conditional formatting, graphs 4. Sensitivity analysis tools, solver, lists and filters 5. Crosstabs, matrix and prediction functions 6. Introduction to R - RStudio, basic data types, variables, functions, vectors, matrices 7. Factors, data frames, lists, visualization in R. 8. Data transformation using dplyr library. 9. Basics of statistics - How to design an experiment? What can I find out? Descriptive statistics. Directional statistics - what about azimuth? 10. Probability, random distributions, significance tests, test selection. Histograms, boxplot diagrams. 11. One or more variables. Mutual bond. Correlation and basics of regression analysis. 12. Examples of further analyzes (principal component analysis, cluster analysis). Solved examples in Excel and R.
|
|
Learning activities and teaching methods
|
Lecture, Demonstration
- Attendace
- 36 hours per semester
|
|
Learning outcomes
|
The aim of the course is to acquaint students with basic processing of not only biological data, their visualization and basic analysis including preparation for statistical evaluation.
The student is able to efficiently process data in Excel and R. environments. He understands the basic principles of probability and statistical data processing.
|
|
Prerequisites
|
The knowledge of computer skills at the secondary school level is expected.
|
|
Assessment methods and criteria
|
Written exam
Knowledge of inserting, processing, visualization and basic data analysis in MS Excel and R.
|
|
Recommended literature
|
-
Miroslav Navarrů. (2019). Excel 2019: podrobný průvodce uživatele.. Praha.
-
WICKHAM, H a G GROLEMUND. (2016). R for Data Science: Import, Tidy, Transform, Visualize, and Model Data.
-
Zvárová, J. (2016). Základy statistiky pro biomedicínské obory. Praha: Karolinum.
|