Basic Statistics in Excel 2700-L-FAK-D-BSIE
The aim of the course is to help students fully understand the nature of data, its acquisition, processing, and interpretation. Data categorization, its philosophical essence, and practical properties will be considered within the conceptual framework of David J. Hand. Microsoft Excel, as a widely available tool at universities, will be used for practical training in selected elements of data analysis. Data interpretation will be covered through descriptive statistics. Finally, Benford’s Law as a statistical power-tool will be introduced. All these objectives are synthesized in a practical project for which attestation is obtained.
Type of course
Mode
Prerequisites (description)
Course coordinators
Learning outcomes
Learning outcomes
KNOWLEDGE:
Students will obtain knowledge about:
- Properties of data.
- Functions of Excel which can be used in data analysis.
- Tools of Microsoft Excel and its limitations.
- Descriptive statistics and proper way to use it.
- Culture of data presentation with Excel graphs.
SKILLS:
Entry level of skills is Excel non-users. The output sklil level is the ability to reflect on the nature of data, its properties, and how to process it appropriately. Students should acquire the skills to measure, process, and graphically present data in a manner appropriate to the field of bachelor's degree information studies. All of these skills should be realized in Microsoft Excel.
Assessment criteria
Assessment methods and assessment criteria
At the end of the course, students independently search for a public data source and perform an analysis of its conformity with Benford's law. The obtained data set with the calculations and analysis report is submitted. The report includes a description of the data source, the data obtained, and the data cleaning and processing. It also contains a graphical presentation of the calculated results of the data's conformity with Benford's law and the student's own interpretation of the findings. An important point for the assessment of the attestation is the completeness of the report and the replicability of the procedure used.
Practical placement
none
Bibliography
Bibliography
Salkind, N. J. (2016). Excel for Statistics: a Quick Guide. 3rd Ed. Los
Angels: SAGE Publications.
Triola, M. F. (2018). Elementary Statistics Using Excel. Sixth Edition.
Boston: Pearson.
HAND, D. J. Measurement: a very short introduction. Very short introductions. Oxford: Oxford University Press, 2016. ISBN 978-019-8779-568.
HAND, D. J. Measurement theory and practice: the world through quantification. Chichester: Wiley, [2010]. ISBN 978-047-0685-679.
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: