Home
Numerical Excel Tutorial
Microscopic Pedestrian Simulation
Kardi Teknomo's Tutorial
MicroPedSim
Free Download
Personal Development Handbook
Research
Publications
Tutorials
Resume
Resources
Contact
Tutorial Feedback
Visitors' Comments on Tutorial: KernelRegression
We have 14 comments on this tutorial
Question > OpenOffice (date: 20100725)
By Mike
I like OpenOffice, but the solvers for it are different than those for Excel. Can you comment on using this technique with OpenOffice?
rate up: 802  rate down: 231  last rated date: 20170222
Is this comment useful?
yes

no
Answer > OpenOffice (date: 20100726)
By Kardi
Unfortunately Open Office does not have similar capability of MS Excel Solver
rate up: 295  rate down: 402  last rated date: 20170223
Is this comment useful?
yes

no
Thank you > Weights (date: 20110123)
By anon12345
Thank you for the excellent overview tutorial! Aside from solver, how can you find the weights?
rate up: 251  rate down: 212  last rated date: 20170220
Is this comment useful?
yes

no
Thank you > Kernel regression (date: 20110505)
By John
I read a lot of materials to understand how the Kernel regression works.Most of them describe the theory very well which is not difficult to understand; however, I was unable to practically use the method for my regression problem. But after reading the tutorial in this website, I am very much confident that I can write my own code in R to solve the problem. Did you notice that the solver function in excel gives new values each time we optimize ? however, the results are not that much different. Thanks, John
rate up: 248  rate down: 189  last rated date: 20170218
Is this comment useful?
yes

no
Suggestion > Kernel Regression (date: 20110516)
By Burcak Otlu Saritas
I would like to thank your tutorial on Kernel regression. I have some suggestions. First of all, font style for formulas is not good. formulas are not clear. Second, how the weight parameters are estimated in Kernel Regression (NadarayaWatson) is missing. Thanks, Burcak Otlu Saritas
rate up: 242  rate down: 196  last rated date: 20170218
Is this comment useful?
yes

no
Question > How to calculate weights (date: 20110727)
By Khongor Tsogt
I just found paper that discuss about kernel density estimation and it is very useful to my study if I can use it. But, I have no knowledge about how to do kernel density estimation. So, I want to use your sample to do it my own. But, it is still not clear to understand. If it is possible can you give me description. In the internet only your example is the most easy to understand for me. Thank you.
rate up: 240  rate down: 183  last rated date: 20170218
Is this comment useful?
yes

no
Question > How to compute kernel (date: 20111207)
By Dia
If I have the following data structure: x = [1 2 3; 3 2 4] I want to find the values form Gaussian kernel assuming that sigma = 1. All the values from kernel is z = [1 1 1; 1 1 1]; Am I correct?
rate up: 209  rate down: 155  last rated date: 20170218
Is this comment useful?
yes

no
Answer > kernel (date: 20111213)
By Kardi
Hi Vita, In my tutorial, capital X represents your data point while small x indicates extension of that data in a very small step for the purpose of smoothing. I cannot comment on the formulations of other people. You may download the spreadsheet companion of this tutorial. It gives you example how to compute in very detail.
rate up: 235  rate down: 162  last rated date: 20170218
Is this comment useful?
yes

no
Others > Review (date: 20120111)
By Erik Stewart
Good examples. I think the tutorial would be more helpful if you included a larger dataset and worked with a smaller subsample space (dx) to illustrate weighting and the smoothing effect across more points than just 5. Other than that, this is an exceptional introductory tutorial and is easy to understand for someone with a limited mathematical background like myself.
rate up: 241  rate down: 145  last rated date: 20170218
Is this comment useful?
yes

no
Suggestion > Como calculas los pesos (date: 20120118)
By Hermes Herrera Martinez
Creo que pudo haberse publicado como calcular los pesos, no se como el Excel calcula, que metodo se utiliza para calcular los pesos.
rate up: 221  rate down: 139  last rated date: 20170218
Is this comment useful?
yes

no
Question > Weight parameters (date: 20120802)
By Lazaro Martinez
How can I calculate the weights. How the weight parameters are estimated. By the way, can you help us publishing another example.
rate up: 158  rate down: 144  last rated date: 20170215
Is this comment useful?
yes

no
Answer > Multivariate Kernel Regression (date: 20140807)
By Kardi
Thank you. For multivariate kernel regression, you can refer to the book of Hastie et al (2003) The Elements of Statistical Learning: Data Mining, Inference, and Prediction.
rate up: 79  rate down: 50  last rated date: 20170220
Is this comment useful?
yes

no
Question > Kernel Regression (date: 20140807)
By Leon Bezuidenhout
Good morning I found this tutorial very interesting and helped a lot with the understanding and applications. I would like to know how the spreadsheet calculation would be adjusted in the multivariate case?
rate up: 78  rate down: 52  last rated date: 20170215
Is this comment useful?
yes

no
> (date: )
By
rate up: 3  rate down: 1  last rated date: 20170219
Is this comment useful?
yes

no
© 2007 Kardi Teknomo. All Rights Reserved.
Designed by
CNV Media