Modeling and Analysis of Economic Data in Excel (Online Course)

general courses

(in Polish) Kurs skierowany jest dla studentów wszystkich Wydziałów UW z wyjątkiem:

- Wydziału Zarządzania

Znajomość podstaw programu Excel oraz statystyki.

Do udziału w zajęciach wymagane jest wcześniejsze doświadczenie z programem Excel.

Zajęcia online. Spotkania na platformie Zoom.

Remote learning

The course is aimed at participants who want to learn about statistical methods in data analysis based on available Excel tools. Classes are conducted in the form of mini lectures and practical exercises. The emphasis is on gaining knowledge that can be used to prepare the empirical part of the dissertation, as well as its practical application in professional work.

Detailed course topics:

1. Basic concepts of data analysis and statistics:

- grouping and subtotals,

- sorting and filtering data,

- text, date and time, conditional formulas,

- summaries and multi-condition searches (aggregated columns),

- array functions,

- statistical distributions: probability density function,

- types of distributions: Gauss, Poisson, others.

2. Basics of descriptive statistics:

- statistical series,

- histograms and diagrams of empirical distributions,

- average measures - classic and positional,

- dispersion measures,

- measures of asymmetry.

3. Basics of mathematical statistics:

- empirical and theoretical distributions,

- parametric estimation,

- verification of hypotheses,

- correlation and regression,

- trend and periodic fluctuations.

4. Estimating basic econometric models:

- formulating a research hypothesis,

- selection of a functional form,

- data collection,

- estimation,

- verification,

- application.

As part of the course, participants receive a set of course materials with solutions.

- Own materials,

- Michael Alexander, Richard Kusleika, John Walkenbach, 2019, Excel 2019 PL. Biblia, Helion, Warszawa,

John Walkenbach, 2014, Excel 2013. 101 porad i sztuczek, które oszczędzą Twój czas, Helion, Warszawa.

Thanks to the course, participants will:

- use Excel tools to solve statistical problems and conduct analyses,

- use selected methods of descriptive statistics and mathematical statistics,

- present research results in the form of charts,

- interpret the obtained results,

- conclude and forecast based on the solutions received.

The final grade consists of:

- homework for 10 points (final design using the presented tools),

- activity during classes.

Punctation:

Score Points

[0-5) 2

[5-6) 3

[6-7) 3,5

[7-8) 4

[8-9) 4,5

[9-10] 5

above 10 5!