IDEAS home Printed from https://ideas.repec.org/p/arx/papers/2212.06080.html
   My bibliography  Save this paper

Logs with zeros? Some problems and solutions

Author

Listed:
  • Jiafeng Chen
  • Jonathan Roth

Abstract

When studying an outcome $Y$ that is weakly-positive but can equal zero (e.g. earnings), researchers frequently estimate an average treatment effect (ATE) for a "log-like" transformation that behaves like $\log(Y)$ for large $Y$ but is defined at zero (e.g. $\log(1+Y)$, $\mathrm{arcsinh}(Y)$). We argue that ATEs for log-like transformations should not be interpreted as approximating percentage effects, since unlike a percentage, they depend on the units of the outcome. In fact, we show that if the treatment affects the extensive margin, one can obtain a treatment effect of any magnitude simply by re-scaling the units of $Y$ before taking the log-like transformation. This arbitrary unit-dependence arises because an individual-level percentage effect is not well-defined for individuals whose outcome changes from zero to non-zero when receiving treatment, and the units of the outcome implicitly determine how much weight the ATE for a log-like transformation places on the extensive margin. We further establish a trilemma: when the outcome can equal zero, there is no treatment effect parameter that is an average of individual-level treatment effects, unit-invariant, and point-identified. We discuss several alternative approaches that may be sensible in settings with an intensive and extensive margin, including (i) expressing the ATE in levels as a percentage (e.g. using Poisson regression), (ii) explicitly calibrating the value placed on the intensive and extensive margins, and (iii) estimating separate effects for the two margins (e.g. using Lee bounds). We illustrate these approaches in three empirical applications.

Suggested Citation

  • Jiafeng Chen & Jonathan Roth, 2022. "Logs with zeros? Some problems and solutions," Papers 2212.06080, arXiv.org, revised Nov 2023.
  • Handle: RePEc:arx:papers:2212.06080
    as

    Download full text from publisher

    File URL: http://arxiv.org/pdf/2212.06080
    File Function: Latest version
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Ghislain B D Aihounton & Arne Henningsen, 2021. "Units of measurement and the inverse hyperbolic sine transformation," The Econometrics Journal, Royal Economic Society, vol. 24(2), pages 334-351.
    2. Chetty, Raj, 2006. "A general formula for the optimal level of social insurance," Journal of Public Economics, Elsevier, vol. 90(10-11), pages 1879-1901, November.
    3. Jeffrey M Wooldridge, 2010. "Econometric Analysis of Cross Section and Panel Data," MIT Press Books, The MIT Press, edition 2, volume 1, number 0262232588, December.
    4. Marc F. Bellemare & Casey J. Wichman, 2020. "Elasticities and the Inverse Hyperbolic Sine Transformation," Oxford Bulletin of Economics and Statistics, Department of Economics, University of Oxford, vol. 82(1), pages 50-61, February.
    5. Baily, Martin Neil, 1978. "Some aspects of optimal unemployment insurance," Journal of Public Economics, Elsevier, vol. 10(3), pages 379-402, December.
    6. Abadie, Alberto, 2003. "Semiparametric instrumental variable estimation of treatment response models," Journal of Econometrics, Elsevier, vol. 113(2), pages 231-263, April.
    7. David S. Lee, 2009. "Training, Wages, and Sample Selection: Estimating Sharp Bounds on Treatment Effects," The Review of Economic Studies, Review of Economic Studies Ltd, vol. 76(3), pages 1071-1102.
    8. Fan, Yanqin & Guerre, Emmanuel & Zhu, Dongming, 2017. "Partial identification of functionals of the joint distribution of “potential outcomes”," Journal of Econometrics, Elsevier, vol. 197(1), pages 42-59.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Matteo Aquilina & Giulio Cornelli & Marina Sanchez del Villar, 2024. "Regulation, information asymmetries and the funding of new ventures," BIS Working Papers 1162, Bank for International Settlements.
    2. Araujo, Rafael & Borges, Bruna & Costa, Francisco J M & Santos, Kelly, 2024. "Seeds of Disparity: the Gender Land Divide from Brazil's Agricultural Transition," SocArXiv dk4bc, Center for Open Science.
    3. Kiss, Andrea & Garlick, Robert & Orkin, Kate & Hensel, Lukas, 2023. "Jobseekers' Beliefs about Comparative Advantage and (Mis)Directed Search," IZA Discussion Papers 16522, Institute of Labor Economics (IZA).
    4. Thieme, Sebastian, 2024. "(When) are Lobbying Expenditures a Good Proxy for Lobbying Activity?," IAST Working Papers 24-160, Institute for Advanced Study in Toulouse (IAST).
    5. Yoosoon Chang & Steven N. Durlauf & Bo Hu & Joon Y. Park, 2024. "Accounting for Individual-Specific Heterogeneity in Intergenerational Income Mobility," Working Papers No 03/2024, Centre for Applied Macro- and Petroleum economics (CAMP), BI Norwegian Business School.
    6. Frank Y. Huang & Po-Chun Huang, 2024. "Enhancing Urban Traffic Safety: An Evaluation on Taipei's Neighborhood Traffic Environment Improvement Program," Papers 2401.16752, arXiv.org, revised Feb 2024.
    7. Pedro H. C. Sant'Anna & Qi Xu, 2023. "Difference-in-Differences with Compositional Changes," Papers 2304.13925, arXiv.org.
    8. Böken, Johannes & Draca, Mirko & Mastrorocco, Nicola & Ornaghi, Arianna, 2023. "The Returns to Viral Media: The Case of US Campaign Contributions," CAGE Online Working Paper Series 681, Competitive Advantage in the Global Economy (CAGE).
    9. Chaturvedi, Sugat & Mahajan, Kanika & Siddique, Zahra, 2023. "Using Domain-Specific Word Embeddings to Examine the Demand for Skills," IZA Discussion Papers 16593, Institute of Labor Economics (IZA).
    10. Paolo Buonanno & Francesco Cinnirella & Elona Harka & Marcello Puca, 2024. "Books Go Public: The Consequences of the Expropriation of Monastic Libraries on Innovation," CESifo Working Paper Series 11015, CESifo.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Andreas Haller & Stefan Staubli & Josef Zweimüller, 2024. "Designing Disability Insurance Reforms: Tightening Eligibility Rules or Reducing Benefits?," Econometrica, Econometric Society, vol. 92(1), pages 79-110, January.
    2. Ahn, Soojung & Steinbach, Sandro, 2022. "COVID-19 Trade Actions and Their Impact on the Agricultural and Food Sector," 2023 Allied Social Sciences Association (ASSA) Annual Meeting, January 6-8, 2023, New Orleans, Louisiana 316789, Agricultural and Applied Economics Association.
    3. Ghislain B. D. Aïhounton & Arne Henningsen & Neda Trifkovic, 2021. "Pesticide Handling and Human Health: Conventional and Organic Cotton Farming in Benin," IFRO Working Paper 2021/06, University of Copenhagen, Department of Food and Resource Economics.
    4. Guigonan S. Adjognon & Daan van Soest & Jonas Guthoff, 2021. "Reducing Hunger with Payments for Environmental Services (PES): Experimental Evidence from Burkina Faso," American Journal of Agricultural Economics, John Wiley & Sons, vol. 103(3), pages 831-857, May.
    5. Adjognon,Guigonan Serge & Nguyen Huy,Tung & Guthoff,Jonas Christoph & van Soest,Daan, 2022. "Incentivizing Social Learning for the Diffusion of Climate-Smart Agricultural Techniques," Policy Research Working Paper Series 10041, The World Bank.
    6. Ghislain B. D. Aihounton & Arne Henningsen, 2023. "Does Organic Farming Jeopardize Food and Nutrition Security?," IFRO Working Paper 2023/02, University of Copenhagen, Department of Food and Resource Economics.
    7. Delius, Antonia & Sterck, Olivier, 2024. "Cash transfers and micro-enterprise performance: Theory and quasi-experimental evidence from Kenya," Journal of Development Economics, Elsevier, vol. 167(C).
    8. Fredriksson, Peter & Söderström, Martin, 2020. "The equilibrium impact of unemployment insurance on unemployment: Evidence from a non-linear policy rule," Journal of Public Economics, Elsevier, vol. 187(C).
    9. Leopoldo Fergusson & Carlos Molina, 2020. "Facebook Causes Protests," HiCN Working Papers 323, Households in Conflict Network.
    10. Elira Kuka, 2020. "Quantifying the Benefits of Social Insurance: Unemployment Insurance and Health," The Review of Economics and Statistics, MIT Press, vol. 102(3), pages 490-505, July.
    11. Upasak Das & Rupayan Pal & Udayan Rathore & Bibhas Saha, 2023. "Rein in pandemic by pricing vaccine: Does social trust matter?," Indira Gandhi Institute of Development Research, Mumbai Working Papers 2023-008, Indira Gandhi Institute of Development Research, Mumbai, India.
    12. Alfonso Rosolia & Paolo Sestito, 2012. "The effects of unemployment benefits in Italy: evidence from an institutional change," Temi di discussione (Economic working papers) 860, Bank of Italy, Economic Research and International Relations Area.
    13. Jonas Kolsrud & Camille Landais & Peter Nilsson & Johannes Spinnewijn, 2015. "The Optimal Timing of UI Benefits: Theory and Evidence from Sweden," CEP Discussion Papers dp1361, Centre for Economic Performance, LSE.
    14. François Gerard & Joana Naritomi, 2021. "Job Displacement Insurance and (the Lack of) Consumption-Smoothing," American Economic Review, American Economic Association, vol. 111(3), pages 899-942, March.
    15. Wei Dong & Geoffrey Dunbar & Christian Friedrich & Dmitry Matveev & Romanos Priftis & Lin Shao, 2021. "Complementarities Between Fiscal Policy and Monetary Policy—Literature Review," Discussion Papers 2021-4, Bank of Canada.
    16. Maclean, J. Catherine & Pichler, Stefan & Ziebarth, Nicolas R., 2020. "Mandated Sick Pay: Coverage, Utilization, and Welfare Effects," IZA Discussion Papers 13132, Institute of Labor Economics (IZA).
    17. Kuester, Keith & Jung, Philip & Ignaszak, Marek, 2020. "Federal unemployment reinsurance and local labor-market policies," CEPR Discussion Papers 15465, C.E.P.R. Discussion Papers.
    18. Michal Kolesár, 2013. "Estimation in an Instrumental Variables Model With Treatment Effect Heterogeneity," Working Papers 2013-2, Princeton University. Economics Department..
    19. Bergstrom, Katy & Dodds, William, 2021. "The targeting benefit of conditional cash transfers," Journal of Public Economics, Elsevier, vol. 194(C).
    20. Fadlon, Itzik & Nielsen, Torben Heien, 2019. "Household labor supply and the gains from social insurance," Journal of Public Economics, Elsevier, vol. 171(C), pages 18-28.

    More about this item

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:arx:papers:2212.06080. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: arXiv administrators (email available below). General contact details of provider: http://arxiv.org/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.