(in Polish) Microsoft Excel w zastosowaniach statystycznych i biznesowych 2400-INTER-MEZS-OG

The scope of the Microsoft Excel course in statistical and business applications includes descriptive statistics, correlation measures, time series, parametric and non-parametric statistical tests, graphs - histograms, dot plots, box plots (BoxPlot), linear regression models, optimization tasks (Solver), simulation analysis of project profitability (Monte Carlo method). The MS Excel in Statistical and Business Applications course is accompanied by numerous examples, which will allow participants to learn the practical application of statistical analysis in various fields of work.

Topics of the course
1. Descriptive statistics and correlation measures.
Mean, median, dominant, percentiles, standard deviation, quarterly spread, coefficients of variation, methods of calculation, interpretation, visualization (histograms, box plots - so-called BoxPlot).
Methods of calculation (Pearson's and Spearman's correlation), interpretation, visualization (dot plots).

2 Time series analysis.
Graphical presentation, analysis of growth rates, construction and conversion of indices, conversion of nominal and real values, analysis of data (stock market, currency, macroeconomic).

3. Verification of statistical hypotheses.
Construction of tests (distributions, significance, errors of the first and second kind), types of tests (for dependent and independent samples, for small and large samples, for mean and variance), selection of an appropriate test, interpretation of test results, visualization of results, non-parametric tests (Mann-Whitney U, Wilcoxon).

4 Linear regression model.
Linear regression model, model estimation, significance of variables, interpretation of the model - quality of fit, errors, coefficients of variables, models with and without a constant, zero-one variables, time trends, practical examples of econometric analysis.

5. Optimization and scenarios in decision-making.
Optimization problems in economics and business, conditional analysis (scenario manager, data tables, search for a result), Solver optimization package - goal setting, limiting conditions, changed values, calculation methods, calculation parameters.

6. Simulation models and decision-making.
Applications of simulation in economics and business, Monte Carlo method - the idea, how to use, advantages and disadvantages, estimation of profitability and risk of a venture - business plan, study of company profits, analysis of profit and loss account in connection with the structure and cost of production.

Notes:
1. Classes are held in the form of e-learning (full class materials with solutions and pre-prepared instructional videos explaining the issues discussed - no live classes) on the platform: https://elearning.wne.uw.edu.pl.

2 It is possible to implement the courses "Microsoft Excel in statistical and business applications" and "Microsoft Excel in the work of a financier-practical examples of applications" in one semester. The courses will be implemented one after the other - Excel in statistical and business applications until mid-November (6 blocks of 5 hours each), and the course "Excel in the work of a financier" from mid-November (8 blocks of 3 hours 45 minutes each).

3 The software version valid for the course is Microsoft Office 2019 or later (language version: Polish, operating system: Windows). The use of an earlier version is possible, but will involve some difficulties. English language version l operating system (e.g. Mac) may involve some difficulties (different Ribbon design, different operation of some Excel tools, different keyboard shortcuts). The University of Warsaw does not provide participants with the necessary computer hardware or software.