Eche un vistazo a este vídeo para aprender a estimar valores para conjuntos de datos con valores perdidos utilizando la función de regresión kernel no paramétrica NumXL en Microsoft Excel. Utilizaremos la función de peso de kernel gaussiano en la demostración e instruiremos a NumXL para que calcule el ancho de banda óptimo del kernel.
Scene 1:
Hello, and welcome. In this demo, we will use the non-parametric NumXL kernel regression function to calculate values for observations with empty or missing values.
Scene 2:First, add the X values we wish to calculate in the adjacent column.
Scene 3:Next, select the top cell in the column adjacent to the X-values and type NxKREG in the formula bar. Then, press the FX button on the left of the Excel function.
Scene 4:The Excel function arguments Window pops up.
Scene 5:For the X-argument, select the cells in column A.
Scene 6:For the Y-argument, select the cells in volume B.
Scene 7:For the polynomial order argument, type two(2) for quadratic.
Scene 8:For the kernel weight function argument, type six(6) for the Gaussian kernel.
Scene 9:For the kernel bandwidth argument, type one or leave it empty.
Scene 10:For the optimization switch argument, type one(1) or true to compute an optimal kernel bandwidth value.
Scene 11:Next, select the cells with the desired x values in column D for the Target argument.
Scene 12:Finally, enter zero(0) or leave it blank for the return type argument to return the fitted (AKA) forecast values.
Scene 13:Now, press the OK button.
Scene 14:Here you go. The function returns all fitted values using the kernel weights function with optimal bandwidth.
Scene 15:Great. Check out the fitted values and original data points on one graph.
That is it for now. Thank you for watching!
Comentarios
Inicie sesión para dejar un comentario.