Basics of statistics in Excel - AISV5952
|
|
|
||
Last update: Mgr. David Jiří Šlosar (08.12.2022)
The topics of descriptive statistics (average, median, types of data distribution, frequency, etc.) will be discussed in detail. Emphasis will be placed on practical application. Graduates will be able to use basic statistical methods and interpret results. Microsoft Excel is chosen as a tool of application of statistics. Course is also an introduction to work with a spreadsheet, data import, control, calculations above them and visualization. Relevant functions, their chaining, work with larger data automation data packages will be presented. In the case of distance learning, the online Zoom platform will be used. It is expected from students, that they will work on their own notebooks with Microsoft Excel (version 2010 or higher) instaled. It is possible to use Office 365 available under faculty licence https://office.ff.cuni.cz/ |
|
||
Last update: Mgr. David Jiří Šlosar (08.12.2022)
Atestace je formou seminární práce. 1. Nalezení alespoň 80 % chyb v podkladových souborech, vypracování jejich dokumentace spolu s popisem opravy. 2. Správné vypracování alespoň 10 z 12 zadaných úkolů nad podkladovými soubory. Zaslání souboru s vyhotoveným zadáním.
|