Bootstrap Sampling Using Excel

[@ZZU04]

The point very to be noted...When we have small sample and haven't any information about distribution , bootstrap estimator...Great lecture Sir..ALLAH bless you..

[@suzannegrudem9850]

Great video, I especially appreciate how you enunciate so precisely. And I was really scratching my head trying to figure out how to generate the samples; your use of "=index()" really helps. One question: If I were to do as you say and form the confidence interval from the middle 95% of the sorted values, how do I sort when the random function keeps dynamically changing? (Obviously, one could simply fix the values with a "paste values" copy and paste, but I am wondering if there is something more elegant available.) Thank you for posting this, Professor, and for helping me to be a better teacher as well! SG

[@ZahidAsghar]

Thank you very much for nice comments. If they are dynamically changing, it means sorting is not possible. A better way is to use Bootstrap Add-Ins from www3.wabash.edu/econometrics/ and that is more elegant way of doing the same thing and repeating aprocess a large number of times.

[@gonzalosalvado435]

Hi my friend, it seems that the second video: "Bootstrap simulation experiment in regression/econometric/statistics/machine learning" is not longer available... that is a shame :(

[@naeemabbasi3343]

The great sir, very nice explanation ❤️please make a video on large datasets handling techniques

[@ZahidAsghar]

Ok i ll do

[@naeemabbasi3343]

@@ZahidAsghar many thanks sir❤️

[@mimalshasandushi5858]

thank you so much

[@lowqchannel]

Can i calculate the confidence interval for 85th percentile point

[@ZahidAsghar]

Can you please elaborate little more about your query?

[@lowqchannel]

@@ZahidAsghar i think i got the answer. in your example, you did ci for mean, so ci for 85th should follow the same steps only do it for percentiles right?

[@MirGlobalAcademy]

Great Work!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@sajdahhassan2729]

Our teacher 😍😍😍

[@MirGlobalAcademy]

Wonderful

[@saleemazhar5230]

Dear sir I have applied your formula to pic a number it does not work as I drag it. Please guide me.

[@ZahidAsghar]

drag it from the corner when + sign become little dark

[@saleemazhar5230]

@@ZahidAsghar i have done many times. But it does not pic random numbers. It only copy the same number it had picked first time.

[@saleemazhar5230]

I typed your formula very carefully many times. It does not work. Please check your formula and guide me.

[@ZahidAsghar]

@@saleemazhar5230 Make sure you have random numbers changing when you press F9 key. Secondly you are using formula. Then copy formula in a cell. Select two cells and follow. Otherwise I can help you by having screen sharing through google meet or some other forum

[@saleemazhar5230]

@@ZahidAsghar again does not work

[@naeemabbasi3343]

♥️♥️♥️👌👌👌