Sort by time | Sort by thread (beta)
- Your queue is empty. Add videos to your queue using this button:
or sign in to load a different list.
Loading...Saving...
Loading...Saving...
you are making this master's lvl statistics easy for me. thank you so much!!
lfp1966 1 week ago
@lfp1966 , I am glad that the videos help!
ExcelIsFun 1 week ago
This has been flagged as spam show
Is this guy like the biggest academic lifesaver or what when it comes to Excel?!
Amazing job, and I rarely say that too! :D
Trigz1985 3 months ago
Comment removed
Trigz1985 3 months ago
thannnnk you :D
alextagachi 4 months ago
@alextagachi , you are welcome!
ExcelIsFun 3 months ago
you are the BEST PERSON IN THE WORLD :D
thank you sooooo much ...you've helped me and made my day ..
:D :D :D
MsMooyaa 4 months ago
@MsMooyaa , You are welcome!!!
ExcelIsFun 4 months ago
I am so thankful for your video series. Passed it along to my classmates. Awesome job!!!
kisxena 11 months ago
You are welcome!
ExcelIsFun 11 months ago
I dont know what to say but i think i am goin to listen to all your videos on excell. you make it sound so fun bet I'm gonna ace this assignment and it cos of u!
You sound a lot better than my lecturer!
Thx a lot and pls
Keep this up!
jesuboi 1 year ago
You are welcome!
ExcelIsFun 1 year ago
I dont know what to say but i think i am goin to listen to all your videos on excell. you make it sound so fun bet I'm gonna ace this assignment and it cos of u!
Thx a lot and pls
Keep this up!
jesuboi 1 year ago
You are very entertaining. Love it! Moreover, you are a lot better than my lecturer. Thanks a lot for uploading.
lonelinezx 1 year ago
You are welcome!
ExcelIsFun 1 year ago
thank you so much for sharing this! this helped me so much!
spursaces21 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Hi Mike...May I ask a very basic question please?
I have been asked to work out the biasness between STDEV and STDEVP as a point estimate. In theory STDEV is an ubiased estimator whereas STDEVP is biased estimator. How is biasness calculated when using sample STDEV to estimate the population standard deviation?
I will appreciate your response. thank you MrExcell!
TajikThunderstorm 2 years ago
It may seem basic to you, but I either do not know how to do it or I do not understand what you are trying to do.
Sorry about that.
Remember: Mr Excel is Bill "Mr Excel" Jelen. Bill "Mr Excel" Jelen is the Excel guy how started all the Excel videos training that you see now online!! He is the most prolific and amazing Excel author around!! I am excelisfun. I am just a teacher who posts videos at YouTube.
ExcelIsFun 2 years ago
TajikThunderstorm:
why n - 1?
I talk about this in a few of my Statistics Excel videos (I cant remember which one):
Population has all values, including the very extreme outliers.
Samples (especially plotting Xbar), do not have the extreme values and so the variability will tend to be underestimated. N-1 increases variability. Think of it this way:
4/2 = 4
4/(2-1) = 4
Minus 1 in the denominator increases the result.
ExcelIsFun 2 years ago
If you go to my college web site and find Busn 210 you can find all my notes, including handwritten pdf notes.
ExcelIsFun 2 years ago
This has been flagged as spam show
Hi Mike, here is one thing I want to know... sample standard deviation is calculated using the STDEV function and it has n-1, whereas population standard deviation is calculated using STDEVP, ignores n-1...In point estimation STDEV is considered to be less biased than STDEVP....but I dont get it...confused....Can you help with this... any help very much appreciated!
TajikThunderstorm 2 years ago
Comment removed
TajikThunderstorm 2 years ago
Life
Saver
:)
Sincerelust 2 years ago
I am glad it helped!
ExcelIsFun 2 years ago
why did you make us do that!? haha
and then you show us the easy way! wtf? haha
timabad 2 years ago
Dear timabad,
The meaning of Standard Deviation is revealed when you do it long hand:
it is really just a way of getting an "average' of all the deveations.
--excelisfun
ExcelIsFun 2 years ago
I was just playing. I really enjoy and appreciate your videos. :)
timabad 2 years ago
Yes, but I get that question a lot!
I am glad that you liked the videos!!
ExcelIsFun 2 years ago