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.
- Prof Dev