IDEAS home Printed from https://ideas.repec.org/p/zbw/sfb373/200326.html
   My bibliography  Save this paper

Computational Statistics with Spreadsheets Towards Efficiency, Reproducibility and Security

Author

Listed:
  • Aydınlı, Gökhan
  • Härdle, Wolfgang Karl
  • Neuwirth, E.

Abstract

The use of electronic spreadsheets as the primary software tool for teaching management science modeling techniques and quantitative methods in economics and finance undoubtedly played a key role in the increasing impact of quantitative lectures given in graduate programs. Researchers suggest that the ability to extract data from various sources and embed analytical decision models within larger systems are two of the most valuable skills for business students entering today?s IT dominated workplace. In this paper we will try to contribute to this evolution and furthermore want to argue in favor of spreadsheet applications as appropriate interface solution to matrix oriented statistical languages. We present two software solutions which are aimed to combine statistical method servers and the spreadsheet application Excel. We will emphasize the productivity gain in terms of transparency and reproducibility available by combining the computational power of a statistical programming environment with the direct manipulation facilities available in spreadsheet programs like Excel. We also want to stimulate the discussion of securing the communication in such a client/server environment.

Suggested Citation

  • Aydınlı, Gökhan & Härdle, Wolfgang Karl & Neuwirth, E., 2003. "Computational Statistics with Spreadsheets Towards Efficiency, Reproducibility and Security," SFB 373 Discussion Papers 2003,26, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
  • Handle: RePEc:zbw:sfb373:200326
    as

    Download full text from publisher

    File URL: https://www.econstor.eu/bitstream/10419/22241/1/dpsfb200326.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Aydinli, Gökhan, 2002. "Net based spreadsheets in quantitative finance," SFB 373 Discussion Papers 2002,42, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    2. Cliff T. Ragsdale, 2001. "Teaching Management Science with Spreadsheets: From Decision Models to Decision Support," INFORMS Transactions on Education, INFORMS, vol. 1(2), pages 68-74, January.
    3. Fengler, Matthias R. & Schwendner, Peter, 2003. "Correlation Risk Premia for Multi-Asset Equity Options," SFB 373 Discussion Papers 2003,10, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    4. Wolfgang Härdle & Torsten Kleinow & Rolf Tschernig, 2001. "Web Quantlets for Time Series Analysis," Annals of the Institute of Statistical Mathematics, Springer;The Institute of Statistical Mathematics, vol. 53(1), pages 179-188, March.
    5. Robert L. Carraway & Dana R. Clyman, 2000. "Integrating Spreadsheets into a Case-based MBA Quantitative Methods Course: Real Managers Make Real Decisions," INFORMS Transactions on Education, INFORMS, vol. 1(1), pages 38-46, September.
    6. Neuwirth, Erich, 2000. "Spreadsheets as tools for statistical computing and statistics education," SFB 373 Discussion Papers 2000,47, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    Full references (including those not matched with items on IDEAS)

    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. Daniel B. McLaughlin & John R. Olson, 2017. "Teaching the Use of Systems Dynamics for Strategic Decision Making in Healthcare," INFORMS Transactions on Education, INFORMS, vol. 17(3), pages 99-106, May.
    2. Cibej, Joze Andrej, 2002. "Operations research education for forgotten populations," European Journal of Operational Research, Elsevier, vol. 140(2), pages 225-231, July.
    3. Palocsay, Susan W. & Markham, Ina S. & Markham, Steven E., 2010. "Utilizing and teaching data tools in Excel for exploratory analysis," Journal of Business Research, Elsevier, vol. 63(2), pages 191-206, February.
    4. Pellegrino, Tommaso & Sabino, Piergiacomo, 2014. "On the use of the moment-matching technique for pricing and hedging multi-asset spread options," Energy Economics, Elsevier, vol. 45(C), pages 172-185.
    5. Feuerhake, Jörg, 2002. "XQS/MD*Crypt as a means of education and computation," SFB 373 Discussion Papers 2002,46, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    6. Aydınlı, Gökhan & Härdle, Wolfgang Karl & Rönz, Bernd, 2003. "E-learning, e-teaching of statistics: A new challenge," SFB 373 Discussion Papers 2003,20, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    7. John F. Wellington & Stephen A. Lewis, 2021. "Getting Beyond the First Result of Solving a Vehicle Routing Problem," INFORMS Transactions on Education, INFORMS, vol. 22(1), pages 9-27, September.
    8. Kleinow, Torsten & Lehmann, Heiko, 2002. "Client/server based statistical computing," SFB 373 Discussion Papers 2002,49, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    9. Christian Hafner, 2003. "Simple approximations for option pricing under mean reversion and stochastic volatility," Computational Statistics, Springer, vol. 18(3), pages 339-353, September.
    10. Härdle, Wolfgang & Rönz, Bernd, 2002. "E-learning / e-teaching of statistics: Students' and teachers' views," SFB 373 Discussion Papers 2002,84, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    11. Michael Francis Gorman, 2023. "Case Article—Blending Statistics, Optimization, and Simulation in a Multiphase Case," INFORMS Transactions on Education, INFORMS, vol. 23(3), pages 173-176, May.
    12. Ostap Okhrin & Stefan Trück, 2015. "Editorial to the special issue on Applicable semiparametrics of computational statistics," Computational Statistics, Springer, vol. 30(3), pages 641-646, September.
    13. Rönz, Bernd, 2001. "MM*Stat - a multimedia tool for teaching of statistics," SFB 373 Discussion Papers 2001,85, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    14. Härdle, Wolfgang & Lehmann, Heiko & Rönz, Bernd, 2001. "MM*STAT: Eine interaktive Einführung in die Welt der Statistik," SFB 373 Discussion Papers 2001,4, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    15. Farnaz Farzan & Khashayar Mahani & Kaveh Gharieh & Mohsen Jafari, 2015. "Microgrid investment under uncertainty: a real option approach using closed form contingent analysis," Annals of Operations Research, Springer, vol. 235(1), pages 259-276, December.

    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:zbw:sfb373:200326. 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: ZBW - Leibniz Information Centre for Economics (email available below). General contact details of provider: https://edirc.repec.org/data/sfhubde.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.