Advanced Search
MyIDEAS: Login

Computational Statistics with Spreadsheets Towards Efficiency, Reproducibility and Security

Contents:

Author Info

  • 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. --

Download Info

If you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
File URL: http://econstor.eu/bitstream/10419/22241/1/dpsfb200326.pdf
Download Restriction: no

Bibliographic Info

Paper provided by Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes in its series SFB 373 Discussion Papers with number 2003,26.

as in new window
Length:
Date of creation: 2003
Date of revision:
Handle: RePEc:zbw:sfb373:200326

Contact details of provider:
Postal: Spandauer Str. 1,10178 Berlin
Phone: +49-30-2093-5708
Fax: +49-30-2093-5617
Email:
Web page: http://www.wiwi.hu-berlin.de/
More information through EDIRC

Related research

Keywords: Statistics in education and practice; Spreadsheets; Client / Server based statistical Computing; Security; XploRe; R;

References

References listed on IDEAS
Please report citation or reference errors to , or , if you are the registered author of the cited work, log in to your RePEc Author Service profile, click on "citations" and make appropriate adjustments.:
as in new window
  1. Härdle, Wolfgang & Kleinow, Torsten & Tschernig, Rolf, 2000. "Web quantlets for time series analysis," SFB 373 Discussion Papers 2000,1, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
  2. 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.
  3. 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.
Full references (including those not matched with items on IDEAS)

Citations

Lists

This item is not listed on Wikipedia, on a reading list or among the top items on IDEAS.

Statistics

Access and download statistics

Corrections

When requesting a correction, please mention this item's handle: RePEc:zbw:sfb373:200326. See general information about how to correct material in RePEc.

For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (ZBW - German National Library of Economics).

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 references are entirely missing, you can add them using this form.

If the full references list an item that is present in RePEc, but the system did not link 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 profile, as there may be some citations waiting for confirmation.

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