Study Guide

Objective

The student becomes accustomed to handling larger data sets in an efficient way with Excel as a tool. The student gains insights into the opportunities that data provides to gain a deeper understanding of their own business or leadership. The student masters the basics of descriptive data analysis and can draw correct conclusions based on analyses. The student is able to present and communicate the results of a survey or analysis in a diverse manner.

Content

• Methods for efficient data management and analysis in Excel
• Data filtering, searching, sorting, and cleaning
• Different data formats and import/export of data
• Data types
• Visualisering av data med tabeller och grafer
• Descriptive data analysis (basic statistics)
• Basic probability theory and distributions
• Confidence interval
• t-test

Qualifications

None.

Materials

Business Analytics: Communicating with numbers. Jaggia et. al., McGraw-Hill (2021)
Material on course Moodle page