Thanks and glad it helped. On a side note, KZitem has cancelled my partner program since I don't have enough subscribers (currently around 738, should be 1000 😞), so it would really help if you subscribe (and all your friends) 😉
@sharleenmischefski7438
3 жыл бұрын
Thank you so much this was super helpful
@stikpet
3 жыл бұрын
Glad it helped!
@raijuibrahim7225
5 жыл бұрын
Really helpful
@christinakakoulli
11 ай бұрын
how do I get the U value? very helpful thanks
@stikpet
11 ай бұрын
step 5 is determining the U value...
@christinakakoulli
11 ай бұрын
@@stikpet thank you so much and I appreciate the fast reply, I am using this to double check the results I got from other software for my thesis!
@shortandsweet2767
Жыл бұрын
I am struggling with Bonferroni correction... I read that "The Bonferroni correction is an adjustment made to P values when several dependent or independent statistical tests are being performed simultaneously on a single data set". Please explain what is the meaning of "single data set" there....second thing can you tell me clear assumptions of Bonferroni's correction, please...
@stikpet
Жыл бұрын
for a Mann-Whitney U test, I don't think you need a Bonferroni correction (BC). The BC is used if you do multiple tests on the same data. For example if you do a one-way ANOVA to determine if there are differences in the mean score between categories. If there are, you might want to know exactly which categories are different. You then do a test to compare category A with category B, a test to compare category A with category C, etc. Each test you usually set that if the p-value is below 0.05 (5%) you reject the null hypothesis, but this means that for each test you have a 5% risk of rejecting the null hypothesis even though it is actually true. So with all these pairwise tests there is actually a pretty good chance that we make at least once a wrong decision. The Bonferroni correction is one method to try to compensate for this risk.
@davidjennings5749
5 жыл бұрын
Thank you for the video, would it be possible to put a link to the excel file?
@stikpet
5 жыл бұрын
Just added it for you. Link in the description.
@dintababy2018
4 жыл бұрын
If the calculated value in step 12 is the p value how can we reject or accept null hypothesis pls rply
@stikpet
4 жыл бұрын
Usually the criteria to accept or reject is set a 0.05. So if it is below 0.05 usually the null hypothesis is rejected. There is some controversy on why 0.05 is used as the threshold, but it is the threshold most commonly used. In some cases 0.01 is used, and sometimes 0.10, but by far the most frequently threshold is 0.05. Hope this was what you were looking for.
@Zdeveren
Жыл бұрын
Very nice video. What puzzles me is step 8 - where is the "12" in the fraction coming from? Everything else is somehow connected with the tested data except for that one. What am I missing here?
@stikpet
Жыл бұрын
it is indeed not connected to the tested data, but always 12. It is also in the SE formula.
@severianotiberi2271
4 жыл бұрын
I did not understand that last step. Why do you use the norm.s.dist function if the Mann-Whitney U test is a non parametric test? Thank you
@shortandsweet2767
Жыл бұрын
Sir, your UDF not working in your downloaded file...It is showing #NAME?...please help
@stikpet
Жыл бұрын
If you see #NAME at a UDF it usually indicates you have not enabled macros. If you enable the macros it should work.
@mukeshbudaniya3615
Жыл бұрын
Why we using Normal distribution during P value calculation. Is this good approximation bcz as I using same method for my data but If I put FALSE in formula then P value coming something else ....Please
@stikpet
Жыл бұрын
The 'TRUE/FALSE' in the last formula is not to use normal approximation or not, but for the function to return either the cumulative or simply the height of the normal curve. We are interested in the cumulative density function, so will have to use TRUE. As to the use of the approximation instead of the exact test, various rule of thumb exist. One can be found on docs.juliahub.com/HypothesisTests/MUGEl/0.10.1/nonparametric/ The exact test is a lot trickier with Excel, since Excel does not have the exact distribution for it.
@shortandsweet2767
Жыл бұрын
@@stikpet Thanks a lot Sir, I am reading a paper and I have a doubt in paragraph below ....."For the permutation tests, we used the Asymptotic General Symmetry Test that paired results from the same individual with and without the window condition (i.e., repeated measure) and then analyzed the difference between the conditions for each individual. To assess if the potential moderator variables (Section 3.5.5) influenced the effect of the window vs. windowless experimental conditions, we used the Asymptotic General Independence Test, which treats the moderator variable groups (e.g., male versus female) as independent samples, and tests if there is a difference in the effect of the experimental conditions between the moderator variable groups. I will be grateful to you if you could explain what is the meaning of the "Asymptotic General Independence Test" is he talking about the Wilcox rank sum test .... Paper link if needed www.sciencedirect.com/science/article/pii/S0360132320301372
@stikpet
Жыл бұрын
@@shortandsweet2767 sorry, I wouldn't know. Perhaps you can email the author of the article. The email adress is in the link you shared.
@shortandsweet2767
Жыл бұрын
@@stikpet Ok Sir, But if possible please tell me when we should consider exact distribution and when approximate distribution in Mann Whitney test, please
@stikpet
Жыл бұрын
@@shortandsweet2767 as mentioned befor different authors have different criteria. One of them can simply be found in the Mann-Whitney U section on docs.juliahub.com/HypothesisTests/MUGEl/0.10.1/nonparametric/
@christinakakoulli
11 ай бұрын
thank you! so which cell is the U value?
@stikpet
11 ай бұрын
step 5 is determining the U value...
@aryanjain3634
2 жыл бұрын
I am getting a negative number in step 5 as my r1 is lower than n1(n1+1)/2. What should i do?
@stikpet
2 жыл бұрын
which step is then not working? Not clear where a negative R1 would cause a problem...
@aryanjain3634
2 жыл бұрын
@@stikpet sorry had made an error while computing the formula. Thanks for your response :)
@dintababy2018
4 жыл бұрын
If we are accepting or rejecting the null hypothesis on the basis of the value finded in step 12, then value in step 11 stands for what ie, the z value? Why that value is not considered for accepting or rejecting the null hypothesis.? Hope u will rply
@stikpet
4 жыл бұрын
Uhm the z-value is considered. The formula is using cell M60 (although the orange still has M57, but you can see at 10:05 I'm actually using M60). The idea in testing is as follows: 1) We make a null hypothesis, which is a claim about the population 2) Determine a result from a sample (in this case a z-value) 3) Determine the chance of such a result as in the sample, or an even more extreme result, if the null hypothesis were true, this is the p-value/significance. In this case the chance of a z-value of 2.84 or higher (or -2.84 or lower). 4) If this chance is very low (usual considered low below .05) then we have a very low chance of this kind of result in a sample, if the null hypothesis were true, which indicates the null hypothesis is probably not true. This is always a bit tricky to understand, but read it carefully and it should make sense.
@dintababy2018
4 жыл бұрын
@@stikpet third and fourth steps are not clear. The z value is calculated from the sample. Then what is the logic behind checking the chance of such z value or a value higher than it on the sample?
@stikpet
4 жыл бұрын
@@dintababy2018 Statisticians have proven that if you would take an infinite amount of samples from any population they will form a normal distribution with at the center the population mean. So if we have one z-value and know the distribution we can also determine how rare it is to have such a sample or even a rarer sample. Perhaps my webpage on significance might be good to go over: peterstatistics.com/CrashCourse/1-Fundamentals/4-Significance.html and my video on explaining significance: kzitem.info/news/bejne/taqYz5hsgKF3e5g
@aymanraouf8010
5 жыл бұрын
Is step 12 the p-value? What is the confidence interval in your calculator?
@stikpet
5 жыл бұрын
Indeed significance = p-value. I'm not sure what you mean with 'my calculator' also since I don't think I calculate a confidence interval anywhere. Would not really know what to calculate a confidence interval about in a Mann-Whitney U test. Hope this still helps.
@aymanraouf8010
5 жыл бұрын
Excuse the language phrases. I usually call spreadsheets as calculators. The p-value to accept or reject a null hypothesis is set on a confidence value of alpha.
@stikpet
5 жыл бұрын
@@aymanraouf8010 Ah, that makes sense :-) The confidence level (alpha) is usually set at .05 (although there is some debate about this), so anything less is then considered significant.
@aymanraouf8010
5 жыл бұрын
So a value of more than 0.05 in Step 12 will mean that I will reject the Null Hypothesis?
@stikpet
5 жыл бұрын
Almost, but it is the other way around. The null hypothesis is rejected if the significance is below 0.05. If it is above, then we have insufficient evidence to reject it. The null hypothesis is usually that things are equal, or that there is no association. A bit more info on my website at peterstatistics.com/CrashCourse/1-Fundamentals/4-Significance.html Hope this helps.
Пікірлер: 45