I thought your tutorial was informative and excellently executed. Top quality!!!
@AnselmGriffin
8 жыл бұрын
+Paul Steer Thanks very much
@laurabannatyne3849
4 жыл бұрын
Thanks for this. I have almost no background in statistics and found your example and explanation clear and helpful, though it was a pity that you ran out of "real estate" at what seemed like the critical part in terms of getting those cell addresses right.
@AnselmGriffin
4 жыл бұрын
Thanks Laura. Can I help in any way the cell addresses? I am afraid the original spreadsheet is long gone with a dead laptop but I would like to help if I can. Thanks Anselm Griffin
@laurabannatyne3849
4 жыл бұрын
@@AnselmGriffin Thanks for offering, but don't worry. With a little upping and downing/pausing and playing I'm sure I'll be fine.
@w17h0u754n17y
4 жыл бұрын
I love this video. I really struggle with statistics and you were very clear, I liked the speed and presentation and the scattering of jokes.
@AnselmGriffin
4 жыл бұрын
Thanks for the thanks Emilia
@elizabethperry418
8 жыл бұрын
This is an excellent tutorial, quite clear, with really good justification of why you used everything. I know it's an old video, but thanks for uploading it!
@AnselmGriffin
8 жыл бұрын
Thanks for than the thanks
@adilahhassen3014
10 жыл бұрын
How do you look up the critical values on the table?
@AnselmGriffin
5 жыл бұрын
This is a two-tailed test. The critical values, just like u1 and u2, must add up to n1 x n2 = 120. So if you are given 29, then you know that the other critical value must be 91.
@BigMouthAiman
3 жыл бұрын
@@AnselmGriffin Why 120?
@0123456789ops
5 жыл бұрын
Super helpful! Thanks a lot!
@sofyzub
8 жыл бұрын
wow, great tip, thank you! I tried it the U value that computed this way is almost the same as U have been proceed by SPSS Statistic
@AndreaS-jc8lp
9 жыл бұрын
It was said "the critical value was 29 and 91 for 5% level of significance". I get the 29 from the MannWhitney table, but from where is 91 ? Please advice, thanks.
@PeterVogopoulos
9 жыл бұрын
Andrea S This is a two-tailed test. The critical values, just like u1 and u2, must add up to n1 x n2 = 120. So if you are given 29, then you know that the other critical value must be 91.
@AndreaS-jc8lp
9 жыл бұрын
Now I get it. Thanks very much, really useful tutorial, it helps me alot :)
@AndreaS-jc8lp
9 жыл бұрын
Peter Vogopoulos it takes longer but it makes me understand it more. Kudos!
@mikulaskeller612
4 жыл бұрын
And please how can I find the 29? What MannWhitney table? I get how to get 91 but not the 29..Quite the opposite :D
@Oh-hardy-har-har
5 жыл бұрын
The formula at 3:17 is =RANK(C21,$C$21:$C$42,1)+COUNT($C$21:$C$42)+1-RANK(C21,$C$21:$C$43,0)-RANK(C21,$C$21:$C$42,1))/2 however this gets an error message in excel. I tried deleting the last bracket because it seemed orphaned, but then the answer is non-sensical. If a second closing bracket is needed, where is the first one?
@Oh-hardy-har-har
5 жыл бұрын
Found it! I must have been Blind LOL =RANK(C21,$C$21:$C$42,1)+(COUNT($C$21:$C$42)+1-RANK(C21,$C$21:$C$43,0)-RANK(C21,$C$21:$C$42,1))/2
@WickedPlaysChannel
9 жыл бұрын
@Adilah Hassen Check the Mann-Whitney U table for critical values according to the sample size
@joshuadavenport1330
4 жыл бұрын
I'm having trouble understanding what "we have no reason to reject the null hypothesis" means in this scenario. I often have trouble with this in stats because there are so many double and triple negatives, its really confusing.
@AnselmGriffin
4 жыл бұрын
Statisticians like to play safe. They wont say "x" is true or false. They will say "no reason to reject.....". To the man in the street no reason to reject the null hypothesis is "the null hypothesis is true". Regards Anselm Griffin
@MrEbi1992
9 жыл бұрын
It was said "the critical value was 29 and 91 for 5% level of significance". I get the 29 from the MannWhitney table, but from where is 91 ? Please advice, thanks. table is
@AnselmGriffin
5 жыл бұрын
This is a two-tailed test. The critical values, just like u1 and u2, must add up to n1 x n2 = 120. So if you are given 29, then you know that the other critical value must be 91.
@yeno.catena3507
6 жыл бұрын
Thanks for the video Anselm! I have a question, how will i calculate for the Mann Whitney U if i have various groups? (e.g. travel mode choices). Does changes will apply in the given formula as well?
@hannahdeinzer9504
7 жыл бұрын
Hi, I've got sample sizes of n1=42 and n2=22. How can I calculate the critical values? One more question I have is: Where did you consider the level of significance in your calculation? Sorry, I'm a statistical amateur... Hopefully you can help me in this two questions.
@AnselmGriffin
7 жыл бұрын
Hi Hannah For large sample sizes n1>20 and n2 >20 you use the normal distribution. See comments below from Dan A. As I said below is use the the z score (normal distribution) this is not the same as using a normal distibution based test. The Mann Whitney U test is non parametric therefore it is not at reliable. Thanks for the question Anselm Griffin
@spectrimgroup6223
8 жыл бұрын
Dear Anselm, thank you for the video!. I have a question for you: where does the critical value "91" come from? I checked in different table for Mann Whitney U test, but I could not find it. Am I missing somenting?
@anselmgriffin3521
8 жыл бұрын
+Spectrim Group Thanks for the question. This is not the first time I have got this question. Perhaps I should have explained better. Anyway I have cut and pasted from below (see comment from Andrea S) It was said "the critical value was 29 and 91 for 5% level of significance". I get the 29 from the MannWhitney table, but from where is 91 ? Please advice, thanks. Peter Vogopoulos11 months ago (edited) +Andrea S This is a two-tailed test. The critical values, just like u1 and u2, must add up to n1 x n2 = 120. So if you are given 29, then you know that the other critical value must be 91. Andrea S Andrea S11 months ago Now I get it. Thanks very much, really useful tutorial, it helps me alot :) Reply
@BigMouthAiman
3 жыл бұрын
I read the table and I understand where we got the critical value of 29 from but I did not understand where we got the value of 91 from. Could anyone please explain that part?
Hi, thank you for the tutorial! I'm trying to reproduce your test and I got confused by the end. When you're taking numbers for U2 & U1 formulas, you seem to be supplying n1 for U2 and n2 for U1. So actually the numbers should be reverse U1=32 and U2=88. Or am I missing something? Thank you!
@cyeomans4600
7 жыл бұрын
I found the same - it looks like the U1 and U2 labels are wrong?
@konstantinmikhailov3875
9 жыл бұрын
Thank you. Can you write more detailed, what's going on in "Rank with correction"? I can't get, what correction consists in.
@AnselmGriffin
9 жыл бұрын
Konstantin Mikhailov Thanks for the question. At around the 2 min 45 seconds mark I explain that there are three 92 scores. Excel ranks them as 18. This is incorrect. The correct rank is 19 (the first 92 is rank 18 the second 92 is rank 19 and the third 92 is rank 20 giving an average rank of 19). Later on I changed the 75 to 74 . Excel ranks then (the two 74s that is) as rank 6. With correction they are ranked as 6.5 (rank 6 and rank 7). Hope this helps
@konstantinmikhailov3875
9 жыл бұрын
Thank you, optiplex17
@narayanmohanchandran2090
8 жыл бұрын
I got only one critical value, how do u get two values, 29 & 91..?
@AnselmGriffin
8 жыл бұрын
Hi thanks for question. if you read the comments below you will see the quesion and answer. thanks again
@AnselmGriffin
5 жыл бұрын
This is a two-tailed test. The critical values, just like u1 and u2, must add up to n1 x n2 = 120. So if you are given 29, then you know that the other critical value must be 91.
@beansbeansbeans8701
11 жыл бұрын
The screen is fuzzy the whole video - any chance you could reupload with better quality?
@heatherfletcher8079
10 жыл бұрын
Thank you!
@Kelvin_Tso
5 жыл бұрын
One question to ask. How can I find the critical values?
@AnselmGriffin
5 жыл бұрын
Hi. I used a set of statistical tables. I did not show them on screen. The tables can be easily found on the web. Thanks Anselm
@Kelvin_Tso
5 жыл бұрын
So how can I get the critical value of 91
@AnselmGriffin
5 жыл бұрын
@@Kelvin_Tso This is a two-tailed test. The critical values, just like u1 and u2, must add up to n1 x n2 = 120. So if you are given 29, then you know that the other critical value must be 91.
@DanA-kk1ws
8 жыл бұрын
Hey Anselm, Thanks so much for the video. May I ask, if I have a sample size of n1 and n2 >20, am I still able to use the Mann Whitney U test? And furthermore, where would i get the critical values from? (As the table only accounts for 20 samples)
@AnselmGriffin
8 жыл бұрын
hi Dan. the larger the sample size the better the normal distrib approximates.
@Kruuhl
8 жыл бұрын
+Anselm Griffin Dear Anselm, I have the same question which has not yet been answered: how do I get the critical values when N>20? I.e. in my sample N1 = 9 and N2 = 32. How do I get the critical values?
@AnselmGriffin
8 жыл бұрын
+Karina Kruhl Hi Karina. you have 2 options use 9,20 critical value or use the relevant z score. If you are unlucky your score may fall between these values. However in you report you could mention this . Remember this test is limited as it is non parmetric.It is not a 'strong' test. Thanks Anselm
@daryayukimenka2361
10 жыл бұрын
THANKS A LOT!!!! :)
@ninietarvitrida9202
8 жыл бұрын
thank you! it is really helpful for me! anyway, for the corrected rank, I have some cells end up with "N/A" and "#VALUE!" results :(... could you give me any suggestion, please..? :( .. thank you again
@AnselmGriffin
8 жыл бұрын
+Niniet arvitrida Hi Niniet. without seeing the actual spreadsheet I cant really comment. Thanks for the nice comments.
@frankieroandMCR
8 жыл бұрын
I don't understand how to use the rank function in excel :(
@AnselmGriffin
8 жыл бұрын
+Jade Davies Hi Jade. At one min 24 sec into the video I have the relevant formula. The first C21 has no dollars so when I drag the cursor down c21 becomes c22 and then c23 etc. However I want to rank c22 in the same range c21 to c42 as I did c21. How do I stop c21:c42 becoming c22:c43 and then c23:c44 etc etc? Answer put dollars in ie c$21:c$42. As I drag down c$21 stays as c$21 and c$42 stays as c$42. Thanks
Пікірлер: 69