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 ad...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 statistics, 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 sophisticated 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.展开更多
随着医疗行业数据量的迅速增长,如何有效进行数据录入与验证成为一个关键问题。作为常用的数据处理工具,Excel结合内置的Visual Basic for Applications(VBA)编程功能,能够极大提升医疗数据管理的效率。文章介绍了Excel VBA在自动化医...随着医疗行业数据量的迅速增长,如何有效进行数据录入与验证成为一个关键问题。作为常用的数据处理工具,Excel结合内置的Visual Basic for Applications(VBA)编程功能,能够极大提升医疗数据管理的效率。文章介绍了Excel VBA在自动化医疗数据录入与验证中的应用,重点分析了其工作流程、功能实现及在医疗数据处理中的优势。展开更多
文摘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 statistics, 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 sophisticated 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.
文摘随着医疗行业数据量的迅速增长,如何有效进行数据录入与验证成为一个关键问题。作为常用的数据处理工具,Excel结合内置的Visual Basic for Applications(VBA)编程功能,能够极大提升医疗数据管理的效率。文章介绍了Excel VBA在自动化医疗数据录入与验证中的应用,重点分析了其工作流程、功能实现及在医疗数据处理中的优势。
