About OpenKnowledge@NAU | For NAU Authors

XLR: A free Excel add-in for introductory business statistics

Ng, Pin T. (2013) XLR: A free Excel add-in for introductory business statistics. Open Journal of Applied Sciences, 3 (1). pp. 32-36. ISSN 2165-3925

[img]
Preview
Text
Ng_P_2013_XLR_free_excel_Add-in.pdf
Available under License Creative Commons Attribution.

Download (413kB) | Preview
Publisher’s or external URL: http://dx.doi.org/10.4236/ojapps.2013.31b1007

Abstract

XLR is an Excel add-in that unifies the user friendly, widely popular interface of Excel with the powerful and robust computational capability of the GNU statistical and graphical language R. The add-in attempts to address the American Statistical Association’s comment that “Generic packages such as Excel are not sufficient even for the teaching of sta- tistics, let alone for research and consulting.” R is the program of choice for researchers in statistical methodology that is freely available under the Free Software Foundation’s GNU General Public License (GPL) Agreement. By wedding the interactive mode of Excel with the power of statistical computing of R, XLR provides a solution to the problem of numerical inaccuracy of using Excel and its various internal statistical functions and procedures by harnessing the computational power of R. XLR will be distributed under the GNU GPL Agreement. The GPL puts students, instructors and researchers in control of their usage of the software by providing them with the freedom to run, copy, distribute, study, change and improve the software, thus, freeing them from the bondage of proprietary software. The creation of XLR will not only have a significant impact on the teaching of an Introductory Business Statistics course by providing a free alternative to the commercial proprietary software but also provide researchers in all disciplines who require so- phisticated and cutting edge statistical and graphical procedures with a user-friendly interactive data analysis tool when the current set of available commands is expanded to include more advance procedures.

Item Type: Article
ID number or DOI: 10.4236/ojapps.2013.31B1007
Subjects: Q Science > QA Mathematics > QA76 Computer software
NAU Depositing Author Academic Status: Faculty/Staff
Department/Unit: The W.A. Franke College of Business > Business Divisions > Business Economics
The W.A. Franke College of Business
Date Deposited: 10 Nov 2015 18:04
URI: http://openknowledge.nau.edu/id/eprint/1077

Actions (login required)

IR Staff Record View IR Staff Record View

Downloads

Downloads per month over past year