In our data-driven world, it is hard to imagine a modern manager who does not know the basic tools of quantitative analysis. The course will include a necessary minimum of theory (30% of the time) and a lot of practical examples using real data from business, management, and finance. We will begin with a motivational example of forecasting sales using Excel Add-in. Then we will learn how to summarize data and build informative graphs. We will next briefly discuss the probability theory and mechanics behind Ordinary Linear Squares (OLS) regression. Linear Regression is a powerful quantitative methods which will be covered in depth using multiple datasets from Harvard Business Publishing. Then we will consider two extensions to regression: linear probability model to analyze binary data and time series models. The course will end with a brief introduction of advanced topics of big data analysis in R/RStudio that will lay down a foundation for future independent learning by the most motivated students.
Students are expected to bring a laptop with an installed Excel 2013 (or later) English version. While group work on assignments is encouraged, 50% of the Final exam will be based on empirical exercises so each student should be proficient in Excel by the end of the course.
Exams & certification: After the successful completion of the course, the participants will get a certificate.