Тёмный
EngSuite
EngSuite
EngSuite
Подписаться
Yes/No MsgBox Buttons - Excel VBA
5:18
14 дней назад
Get User Input from MsgBox - Excel VBA
1:30
14 дней назад
Complete Guide to MsgBox - Excel VBA
20:42
14 дней назад
How to Cancel/Prevent Events Excel VBA
1:38
2 месяца назад
Worksheet Pivot Table Update - Excel VBA
2:21
2 месяца назад
Cell Change Event - Excel VBA
1:56
2 месяца назад
Worksheet Calculate Event Handler Excel VBA
1:33
2 месяца назад
Complete Guide to Worksheet Events Excel VBA
15:26
2 месяца назад
Delete Shapes - Excel VBA
0:56
3 месяца назад
Rename a New Group of Shapes - Excel VBA
1:20
3 месяца назад
Ungroup Shapes - Excel VBA
0:35
3 месяца назад
Group Shapes Together - Excel VBA
0:53
3 месяца назад
Комментарии
@falagamer153
@falagamer153 17 дней назад
Muito obrigado por sua ajuda... i am learning a lot... thank you so much for help me to improve myself
@engsuite3958
@engsuite3958 16 дней назад
That's great to hear! Were you able to get the function working in Excel?
@BNT05
@BNT05 26 дней назад
Thank you for providing this content. You have been quite helpful, and I believe this is not only for me. ●So, did I get correctly that if an A-D value is higher, it corresponds to a lower p-value and hence a higher risk of rejecting Ho that assumes the distribution comes from a specifed distribution (i.e., normal distribution) when the p-value is less than the significance level? ●Is it accurate to argue that the smaller the A-D value, the more likely your distribution is to be normal because the p-value will be larger (above the significance level), allowing Ho to assume that the distribution is from the specified distribution? ● The higher A-D value, the lower p-value and the higher chance of rejecting Ho? ●Otherwise, how should the A-D value be used in respect to the p-value? Thank you in advance.
@engsuite3958
@engsuite3958 23 дня назад
Hello, Yes, you are correct that a higher AD value corresponds to a lower p-value and a higher risk of rejecting H0. And yes, the inverse of that would also be true: a smaller AD value corresponds to higher p-value and thus failing to reject the null hypothesis. - IMPORTANT - However, I would not recommend using the AD value to make your conclusions about normality because the p-value calculation also takes the sample size into account. This is one of the main reasons we use the p-value. It standardizes the criteria across sample sizes. Another important reason that we use p-values is because it is directly linked to the risk of Type I Error, this means that by specifying our alpha (generally 0.05) we are actually specifying the acceptable risk of Type I Error at our specific sample size. - CONCLUSION - The p-value is a standardized statistic that allows us to control Type I Error and to ensure that sample size effects are properly controlled. The AD test statistic is still important but should not be used by itself to make conclusions.
@BNT05
@BNT05 23 дня назад
@@engsuite3958 Thank you for your insights here. Well noted. Keep up this good work 👏
@bbom9197
@bbom9197 Месяц назад
❤❤❤❤
@Shaunmcdonogh-shaunsurfing
@Shaunmcdonogh-shaunsurfing Месяц назад
Excellent video
@Dergicetea
@Dergicetea 2 месяца назад
I really liked so much the approach of this video through the lens of engineering 👏🏼
@renieloanes1785
@renieloanes1785 2 месяца назад
Thank you for this straight to the point tutorial. This is exactly what I need.
@NoNamosss
@NoNamosss 3 месяца назад
Isn’t this the Kuiper Test?
@engsuite3958
@engsuite3958 3 месяца назад
Hi, The Kuiper Test and Kolmogorov-Smirnov Test are both very similar. They both use the maximum discrepancies from the CDF to calculate a test statistic. The difference between the two is that the Kolmogorov-Smirnov Test Statistic is the overall maximum discrepancy MAX(D+, D-) whereas the Kuiper Test Statistic is the sum of the maximum discrepancies above and below the CDF SUM(D+, D-).
@sesppsfd3815
@sesppsfd3815 4 месяца назад
Cool
@Daciouskasoka
@Daciouskasoka 4 месяца назад
Very helpful, thank you.
@gabutnyaasmr7415
@gabutnyaasmr7415 5 месяцев назад
thankyou so much! i am from Indonesia and currently studied statistics in college, this video really helps me out, definitely would recommend you to my friends!
@engsuite3958
@engsuite3958 5 месяцев назад
That is great to hear! If you are interested in Normality testing, especially if you're studying statistics, you should check out this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WKyAYsqTSCM.html It might change how you see the AD Test. Thanks, Lucius LaFromboise
@hawtpotato90210
@hawtpotato90210 6 месяцев назад
first
@javedahmed8343
@javedahmed8343 8 месяцев назад
Great
@stefanperko
@stefanperko 8 месяцев назад
f(x) does NOT give you the probability of x occurring. That probability would be zero.
@exploreyourdreamlife
@exploreyourdreamlife 10 месяцев назад
I used to stress about managing normality in excel, but this video provided a fresh perspective. Much respect to the creator for simplifying it! Liked and Subbed!
@exploreyourdreamlife
@exploreyourdreamlife 10 месяцев назад
Amazing and straightforward. This Normality test is a dream guide for every expert Liked and Subbed!
@neeleshanand6863
@neeleshanand6863 Год назад
'QE.CAPABILITYANALYSIS' is always returning #VALUE! error, even though all data is as per the video. Do you have sample excel file from the demo somewheare on the cloud? Can you share the link?