Course title in Estonian
Andmete analüüs Excelis
Course title in English
Data Analysis in Excel
Assessment form
Examination
lecturer of 2025/2026 Autumn semester
Not opened for teaching. Click the study programme link below to see the nominal division schedule.
lecturer of 2025/2026 Spring semester
Not opened for teaching. Click the study programme link below to see the nominal division schedule.
Course aims
The objective of the course is to enable development of practical knowledge and skills necessary for conducting quantitative analysis and presentation of results in widely used programme MS Excel.
Brief description of the course
To achieve this aim, students’ knowledge of statistical analysis, practical application of statistical methodology and graphical presentation of results are developed. Course is taught in practical classes using MS Excel program. Theoretical aspects of data analysis are addressed briefly because prerequisite to participation in the course is knowledge of basic methods. Following topics will be introduced: sample and a population, organizing data before analysis, tables, diagrams, correlation analysis.
To promote students’ understanding of these topics, they have to complete one home assignment based on the dataset provided by the lecturer.
Learning outcomes in the course
Upon completing the course the student:
- has a basic understanding of the main quantitative data analysis methods;
- knows how to use most common tool of MS Excel for data analysis;
- has an understanding of how statistical inferences are reached and can present the results of the home assignments;
- has reached the level in statistical thinking where (s)he can reason using statistical terminology and apply the knowledge and skills to new research questions (problems).
Study programmes containing that course