| Course Unit Code | 151-0353/02 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| FRI02 | doc. Ing. Václav Friedrich, Ph.D. |
| MIH22 | RNDr. Šárka Michalcová, Ph.D. |
| Summary |
|---|
| The aim of the subject is to train students in the practical processing of statistical data. The choice of methods is oriented towards the processing of files obtained in marketing or other economic research, mainly for the needs of bachelor theses. The course is based on the knowledge of basic statistics (Statistics for Economists or Statistics A). The software used is MS Excel with the Real Statistics add-in. |
| Learning Outcomes of the Course Unit |
|---|
The subject builds on the knowledge gained in Statistics for Economists (Statistics A).
In this course students will
- learn how to create, edit, analyse, interpret and present data files;
- learn how to create descriptive statistics, perform first and second level classification and become familiar with selected statistical tests suitable for use in undergraduate theses;
- learn the basics of academic writing (guidelines and standards, IMRaD, citations, basic typography). |
| Course Contents |
|---|
1. Statistical research and presentation of results
2. Data file, data import and coding
3. Categorised data, frequency tables and graphs
4. From research objectives to hypothesis testing
5. Second level sorting, contingency table
6. Numerical data, characteristics and distribution plots
7. Comparative tests of variance and means
8. Analysis of variance ANOVA, multiple comparisons
9 Structure and formatting of scientific papers
10. Information sources, working with references and citations
11. Word processing and graphics on the computer
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
FIELD, Andy. Adventure in Statistics: The Reality Enigma. Second Edition. Los Angeles: SAGE Publications, 2022. 664 p. ISBN 978-1529797138.
LIND, Douglas A.; MARCHAL, William G. and WATHEN, Samuel A. Basic Statistics in Business and Economics. 10th Edition. New York: McGraw-Hill Education, 2021. 640 p. ISBN 978-1260597578. |
JANÁČEK, Julius. Statistika jednoduše: Průvodce světem statistiky. Praha: Grada, 2022. 120 s. ISBN 978-80-271-1738-3.
HENDL, J. a kol. Základy matematiky, logiky a statistiky pro sociologii a ostatní společenské vědy v příkladech. Praha: Karolinum, 2022. ISBN 978-80-246-5400-3.
ZAIONTZ C. Real Statistics Using Excel Succinctly. [online] Morrisville: Syncfusion, 2015. ISBN 978-1-64200-078-8. Available from: https://www.syncfusion.com/succinctly-free-ebooks/statistics. |
| Recommended Reading: |
|---|
CAMM, Jeffrey D. et al. Statistics for Business and Economics. 15th Edition. Boston: Cengage Learning, 2023. 1120 p. ISBN 978-0357715857.
SALKIND, Neil J. and FREY, Bruce B. Statistics for People Who (Think They) Hate Statistics: Using Microsoft Excel. Fifth Edition. London: SAGE Publications, 2021. 512 p. ISBN 978-1071803882. |
HENDL, Jan. Přehled statistických metod: Analýza a metaanalýza dat. 5. rozšířené vydání. Praha: Portál, 2015. 736 s. ISBN 978-80-262-0981-2.
RABUŠIC, Ladislav; SOUKUP,Petr a MAREŠ, Petr. Statistická analýza sociálněvědních dat (prostřednictvím SPSS). 2. přepracované vydání. Brno: Masarykova univerzita, 2019. 576 s. ISBN 978-80-210-9247-1.
SALKIND, Neil J. and FREY, Bruce B. Statistics for People Who (Think They) Hate Statistics: Using Microsoft Excel. Fifth Edition. London: SAGE Publications, 2021. 512 p. ISBN 978-1071803882. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Individual consultations, Tutorials, Other activities |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit | Credit | | |
| Samostatná práce | Other task type | | |