View by Day
16:30 | Macro Research Seminar
Pavel Ševčík, Ph.D. (UQAM) “Occupational Choice, Human Capital, and Financial Constraints”
Université du Québec à Montréal (UQAM), Canada
Authors: Rui Castro and Pavel Ševčík
Abstract: We study the aggregate productivity effects of firm-level financial frictions. Credit constraints affect not only production decisions but also household-level schooling decisions. In turn, entrepreneurial schooling decisions impact firm-level productivities, whose cross-sectional distribution becomes endogenous. In anticipation of future constraints, entrepreneurs under-invest in schooling. Frictions lower aggregate productivity because talent is misallocated across occupations, and capital misallocated across firms. In addition, firm-level productivities are also lower due to schooling distortions. These effects combined account for between 22 and 44 percent of the U.S.-India aggregate productivity difference, depending on the calibration. Schooling distortions are the major source of these aggregate productivity differences.
Keywords: Aggregate Productivity, Financial Frictions, Entrepreneurship, Human Capital.
JEL Codes: E24, I25, J24, O11, O15, O16, 047.
Full Text: “Occupational Choice, Human Capital, and Financial Constraints”
17:00 | Economics Discovery Hub
What the Retailers Know from the Customers Data
Time: 17:00 – 18:00
Date: Thursday, 9 March 2017
Petr Křiklan, a Retail Analytics professional, will introduce Nielsen as a leading company at the consumer goods market measurement and shopper behavior analytics. He will show customer data insights and advanced analytics that help retailers and manufacturers to drive business success.
The event will most benefit students interested in the Fast Moving Consumer Goods market dynamics, advanced analytics and data modeling, or those that are interested in what the retailers can actually read about their customers based on data points they generate during their purchasing process.
About the facilitator:
Petr Křiklan is a Retail Analytics Leader for Central/East Europe at Nielsen with over 20 years of experience with FMCG market at various analytical and leadership positions across Nielsen and Globus.
Places are limited so please register to be considered for this course. We usually close the registration one week prior to the start of the activity and inform participants if they have been accepted.
Registration for this course is closed.
18:30 | Economics Discovery Hub
Thursdays, 18:30-20:30
Starting date: 9 March, 2017
Finishing date: 30 March, 2017
Prerequisities:
No prior knowledge of Excel neccessary.
Participants need to bring their own laptops with Excel 2007 or later installed, ideally 2013 or 2016.
Curriculum:
Lecture 1:
- Basic information
- Keyboard shortcuts
- Formatting (& conditional, pt.1)
- Visuals, help (comments, cell borders, ...)
- Column/cell hide, size, group, merge cells
- Introduction to formulas (basic math, SUM, COUNT, AVERAGE)
- IFs, AND, OR, NOT
Lecture 2:
- Conditional formatting, pt. 2
- Anchoring cells
- SUMIF, COUNTIF
- Freeze panes, rows & columns
- Filters
- IFERROR, ISBLANK
- INDEX, MATCH, VLOOKUP
Lecture 3:
- SUMPRODUCT, SUMIFS
- DATE
- Text functions
- RAND, RANDBETWEEN
- Calculation options
- Pivot tables
Lecture 4:
- Data validation (esp. lists)
- Text to columns
- OFFSET, INDIRECT
- (Dynamic) named ranges
- Paste special
- Other formats
- Formula auditing (F9, tracing)
- Etiquette in Excel
Participants who attend at least 75% of the sessions will obtain a Certificate of Attendance issued by CERGE-EI.
About the facilitator:
Petar Buha
Petar is an MA in Applied Economics graduate from 2015 and currently works as an Analyst at Accenture. He is interested in analysis, innovation, and IT; it was due to these interests that he worked at Social Bakers prior to his studies and why he joined Accenture after graduation. He used Excel considerably during his studies, especially on the practical Financial Modeling course, and he also uses it extensively in his current role, where he has developed complex models for an insurance provider's regulatory reporting and is administering reporting capabilities for a data migration stream, analyzing and forecasting the productivity of developers and their deliverables. In his free time, Petar likes to do kick-boxing, watch sci-fi movies and actively socialize.
Registration for this course is closed.
We thank our partner EY for supporting Economics Discovery Hub.
