Sorry, you need to enable JavaScript to visit this website.

Visual Basic Applications And Spreadsheet For Teaching Estimation Of Nonparametric Density And Regression Functions


Book: 
Proceedings of the sixth international conference on teaching statistics, Developing a statistically literate society
Authors: 
Palacios-Gonzalez, F.
Editors: 
Phillips, B.
Category: 
Pages: 
Online
Year: 
2002
Publisher: 
International Statistical Institute
URL: 
http://www.stat.auckland.ac.nz/~iase/publications/1/3g3_pala.pdf
Abstract: 

The aim of this paper is to show how teachers can use Visual Basic language on the spreadsheet for student sin order to gain the skills need in using nonparametric techniques for density and regression function estimations. The author has built a useful didactic tool on Excel Visual Basic for teaching and practice of nonparametric kernel methods, being intended for students with some preliminary knowledge on this topic. This Visual Basic Application (VBA) is loaded into Excel as a MACRO (or into the modules of a Workbook for EXCEL). The specific user functions incorporated into it are easy tools for students to obtain an intuitive perception of nonparametric estimation for density and regression functions. The VBA also allows Excel to make use of an added menu similar to a small Statistical Package specialised in nonparametric methods.

register