IDEAS home Printed from https://ideas.repec.org/p/ehl/lserod/102406.html
   My bibliography  Save this paper

The analysis of transformations for profit-and-loss data

Author

Listed:
  • Atkinson, Anthony C.
  • Riani, Marco
  • Corbellini, Aldo

Abstract

We analyse data on the performance of investment funds, 99 out of 309 of which report a loss, and on the profitability of 1405 firms, 407 of which report losses. The problem in both cases is to use regression to predict performance from sets of explanatory variables. In one case, it is clear from scatter plots of the data that the negative responses have a lower variance than the positive responses and a different relationship with the explanatory variables. Because the data include negative responses, the Box–Cox transformation cannot be used. We develop a robust version of an extension to the Yeo–Johnson transformation which allows different transformations for positive and negative responses. Tests and graphical methods from our robust analysis enable the detection of outliers, the assessment of values of the two transformation parameters and the building of simple regression models. Performance comparisons are made with non-parametric transformations.

Suggested Citation

  • Atkinson, Anthony C. & Riani, Marco & Corbellini, Aldo, 2020. "The analysis of transformations for profit-and-loss data," LSE Research Online Documents on Economics 102406, London School of Economics and Political Science, LSE Library.
    • Handle: RePEc:ehl:lserod:102406
    as

    Download full text from publisher

    File URL: http://eprints.lse.ac.uk/102406/
    File Function: Open access version.
    Download Restriction: no
    ---><---

    Other versions of this item:

    References listed on IDEAS

    as
    1. Anthony C. Atkinson, 2002. "Forward search added-variable t-tests and the effect of masked outliers on model selection," Biometrika, Biometrika Trust, vol. 89(4), pages 939-946, December.
    2. Joe Whittaker & Chris Whitehead & Mark Somers, 2005. "The neglog transformation and quantile regression for the analysis of a large credit scoring database," Journal of the Royal Statistical Society Series C, Royal Statistical Society, vol. 54(5), pages 863-878, November.
    3. Eleonora Bartoloni, 2013. "Profitability and innovation: new empirical findings based on italian data 1996-2003," Rivista Internazionale di Scienze Sociali, Vita e Pensiero, Pubblicazioni dell'Universita' Cattolica del Sacro Cuore, vol. 122(2), pages 137-170.
    4. Eleonora Bartoloni, 2013. "Profitability and innovation: new empirical findings based on italian data 1996-2003," Rivista Internazionale di Scienze Sociali, Vita e Pensiero, Pubblicazioni dell'Universita' Cattolica del Sacro Cuore, vol. 121(2), pages 137-170.
    5. Marazzi, Alfio & Villar, Ana J. & Yohai, Victor J., 2009. "Robust Response Transformations Based on Optimal Prediction," Journal of the American Statistical Association, American Statistical Association, vol. 104(485), pages 360-370.
    6. Marco Riani & Anthony C. Atkinson & Andrea Cerioli, 2009. "Finding an unknown number of multivariate outliers," Journal of the Royal Statistical Society Series B, Royal Statistical Society, vol. 71(2), pages 447-466, April.
    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. Francesca Torti & Aldo Corbellini & Anthony C. Atkinson, 2021. "fsdaSAS: A Package for Robust Regression for Very Large Datasets Including the Batch Forward Search," Stats, MDPI, vol. 4(2), pages 1-21, April.
    2. Atkinson, Anthony C. & Riani, Marco & Corbellini, Aldo, 2021. "The box-cox transformation: review and extensions," LSE Research Online Documents on Economics 103537, London School of Economics and Political Science, LSE Library.
    3. Riani, Marco & Atkinson, Anthony Curtis & Corbellini, Aldo & Farcomeni, Alessio & Laurini, Fabrizio, 2024. "Information Criteria for Outlier Detection Avoiding Arbitrary Significance Levels," Econometrics and Statistics, Elsevier, vol. 29(C), pages 189-205.
    4. Torti, Francesca & Corbellini, Aldo & Atkinson, Anthony C., 2021. "fsdaSAS: a package for robust regression for very large datasets including the batch forward search," LSE Research Online Documents on Economics 109895, London School of Economics and Political Science, LSE Library.

    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. Domenico Perrotta & Marco Riani & Francesca Torti, 2009. "New robust dynamic plots for regression mixture detection," Advances in Data Analysis and Classification, Springer;German Classification Society - Gesellschaft für Klassifikation (GfKl);Japanese Classification Society (JCS);Classification and Data Analysis Group of the Italian Statistical Society (CLADAG);International Federation of Classification Societies (IFCS), vol. 3(3), pages 263-279, December.
    2. Menjoge, Rajiv S. & Welsch, Roy E., 2010. "A diagnostic method for simultaneous feature selection and outlier identification in linear regression," Computational Statistics & Data Analysis, Elsevier, vol. 54(12), pages 3181-3193, December.
    3. Cerioli, Andrea & Farcomeni, Alessio & Riani, Marco, 2014. "Strong consistency and robustness of the Forward Search estimator of multivariate location and scatter," Journal of Multivariate Analysis, Elsevier, vol. 126(C), pages 167-183.
    4. Atkinson, Anthony C. & Riani, Marco & Corbellini, Aldo, 2021. "The box-cox transformation: review and extensions," LSE Research Online Documents on Economics 103537, London School of Economics and Political Science, LSE Library.
    5. Riani, Marco & Atkinson, Anthony C., 2010. "Robust model selection with flexible trimming," Computational Statistics & Data Analysis, Elsevier, vol. 54(12), pages 3300-3312, December.
    6. Thu A. T. Pham, 2018. "Industry Concentration, Firm Efficiency and Average Stock Returns: Evidence from Australia," Asia-Pacific Financial Markets, Springer;Japanese Association of Financial Economics and Engineering, vol. 25(3), pages 221-247, September.
    7. Marco Riani & Anthony C. Atkinson & Aldo Corbellini, 2023. "Automatic robust Box–Cox and extended Yeo–Johnson transformations in regression," Statistical Methods & Applications, Springer;Società Italiana di Statistica, vol. 32(1), pages 75-102, March.
    8. Anthony C. Atkinson & Marco Riani & Andrea Cerioli, 2018. "Cluster detection and clustering with random start forward searches," Journal of Applied Statistics, Taylor & Francis Journals, vol. 45(5), pages 777-798, April.
    9. Søren Johansen & Lukasz Gatarek, 2014. "Optimal hedging with the cointegrated vector autoregressive model," CREATES Research Papers 2014-40, Department of Economics and Business Economics, Aarhus University.
    10. Anthony C. Atkinson & Aldo Corbellini & Marco Riani, 2017. "Robust Bayesian regression with the forward search: theory and data analysis," TEST: An Official Journal of the Spanish Society of Statistics and Operations Research, Springer;Sociedad de Estadística e Investigación Operativa, vol. 26(4), pages 869-886, December.
    11. Torti, Francesca & Corbellini, Aldo & Atkinson, Anthony C., 2021. "fsdaSAS: a package for robust regression for very large datasets including the batch forward search," LSE Research Online Documents on Economics 109895, London School of Economics and Political Science, LSE Library.
    12. Pokojovy, Michael & Jobe, J. Marcus, 2022. "A robust deterministic affine-equivariant algorithm for multivariate location and scatter," Computational Statistics & Data Analysis, Elsevier, vol. 172(C).
    13. D. F. Benoit & D. Van Den Poel, 2010. "Binary quantile regression: A Bayesian approach based on the asymmetric Laplace density," Working Papers of Faculty of Economics and Business Administration, Ghent University, Belgium 10/662, Ghent University, Faculty of Economics and Business Administration.
    14. Arismendi, Juan C. & Broda, Simon, 2017. "Multivariate elliptical truncated moments," Journal of Multivariate Analysis, Elsevier, vol. 157(C), pages 29-44.
    15. Salvatore Ingrassia & Simona Minotti & Giorgio Vittadini, 2012. "Local Statistical Modeling via a Cluster-Weighted Approach with Elliptical Distributions," Journal of Classification, Springer;The Classification Society, vol. 29(3), pages 363-401, October.
    16. Vojtěch Olbrecht, 2018. "Productivity Effect of Accessing the EU: Case of Bulgaria and Romania," European Journal of Business Science and Technology, Mendel University in Brno, Faculty of Business and Economics, vol. 4(1), pages 48-55.
    17. Luke A. Prendergast & Simon J. Sheather, 2013. "On Sensitivity of Inverse Response Plot Estimation and the Benefits of a Robust Estimation Approach," Scandinavian Journal of Statistics, Danish Society for Theoretical Statistics;Finnish Statistical Society;Norwegian Statistical Association;Swedish Statistical Association, vol. 40(2), pages 219-237, June.
    18. Luca Greco & Giovanni Saraceno & Claudio Agostinelli, 2021. "Robust Fitting of a Wrapped Normal Model to Multivariate Circular Data and Outlier Detection," Stats, MDPI, vol. 4(2), pages 1-18, June.
    19. Zuppiroli, Marco & Donati, Michele & Riani, Marco & Verga, Giovanni, 2015. "The Impact of Trading Activity in Agricultural Futures Markets," 2015 Fourth Congress, June 11-12, 2015, Ancona, Italy 207848, Italian Association of Agricultural and Applied Economics (AIEAA).
    20. Kirschstein, Thomas & Liebscher, Steffen & Becker, Claudia, 2013. "Robust estimation of location and scatter by pruning the minimum spanning tree," Journal of Multivariate Analysis, Elsevier, vol. 120(C), pages 173-184.

    More about this item

    Keywords

    additivity and variance stabilization; alternating conditional expectations; Box-Cox transformation; constructed variable; fan plot; forward search; linked plots; robust methods; Yeo-Johnson transformation;
    All these keywords.

    JEL classification:

    • C1 - Mathematical and Quantitative Methods - - Econometric and Statistical Methods and Methodology: General

    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:ehl:lserod:102406. 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: LSERO Manager (email available below). General contact details of provider: https://edirc.repec.org/data/lsepsuk.html .

    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.