I need to develop this table. Panel A needs to calculate mean expenditure amount in event pre-event and post-event year. Where the event is the year in which value of built is 1 and value of acquis is 1.
Panel B is for Median financing proportion during event year.
While Panel C is little different. Economic events are defined as major investments (Built, acquis) with adjacent event years, starting with a pre-event year and ending with a post-event year (e.g., a sequence in event time of [–1, 0, 0, +1] over 4 years). Thanking in anticipation.