Arbeitspapier

Computational Statistics with Spreadsheets Towards Efficiency, Reproducibility and Security

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.

Language
Englisch

Bibliographic citation
Series: SFB 373 Discussion Paper ; No. 2003,26

Classification
Wirtschaft
Subject
Statistics in education and practice
Spreadsheets
Client / Server based statistical Computing
Security
XploRe
Statistische Methodenlehre
PC-Software
XploRe

Event
Geistige Schöpfung
(who)
Aydınlı, Gökhan
Härdle, Wolfgang Karl
Neuwirth, E.
Event
Veröffentlichung
(who)
Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes
(where)
Berlin
(when)
2003

Handle
URN
urn:nbn:de:kobv:11-10050260
Last update
10.03.2025, 11:42 AM CET

Data provider

This object is provided by:
ZBW - Deutsche Zentralbibliothek für Wirtschaftswissenschaften - Leibniz-Informationszentrum Wirtschaft. If you have any questions about the object, please contact the data provider.

Object type

  • Arbeitspapier

Associated

  • Aydınlı, Gökhan
  • Härdle, Wolfgang Karl
  • Neuwirth, E.
  • Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes

Time of origin

  • 2003

Other Objects (12)