Using Microsoft Excel for Chi-Square Test (Nonparametric Test)

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 113

  • @mfion
    @mfion 3 роки тому +10

    A sincere thank you for taking the time to explain every detail and walking us through the steps slowly. This will help me finally submit a paper for publication. :)

  • @veronicagida2397
    @veronicagida2397 3 роки тому +7

    Continue what you're doing. You are such a blessing to those struggling for statistics.😇

  • @kannelouw
    @kannelouw 3 роки тому +5

    THANK YOU SO MUCH!! u helped to explain a lot of unnecessary details that seem unnecessary for u, but definitely matter for US!

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому

      Pleasure

    • @syahiraismail7222
      @syahiraismail7222 3 роки тому

      @@jskeshminder4627 hi. Can you explain how to denote significant difference in each data set ?

  • @alexdemars872
    @alexdemars872 3 роки тому +2

    This video saved my entire final project. Thanks man!

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому

      Good to know! All the best for your project submission

  • @AtlascityGG
    @AtlascityGG 3 роки тому +5

    Your video saved me from Depression xD

  • @anbanathansubramaniam9581
    @anbanathansubramaniam9581 3 роки тому +3

    Thank you so much, it's a clear and simple understanding of Chi-square methodology

  • @JaniGreeff
    @JaniGreeff 11 місяців тому

    Thank you for helping out a psychology honours student in South Africa with her data (that's me!) 🙂

  • @gustav_ostervall_92
    @gustav_ostervall_92 3 роки тому +1

    This is an excellent video with clear information. Much appreciated.

  • @loremipsum6484
    @loremipsum6484 2 роки тому +1

    So well explained and very detailed. This was such a clear instruction.

  • @rosebunker3081
    @rosebunker3081 3 роки тому +3

    Thank you - this is perfect for what I needed!

  • @ashutoshtiwarijee792
    @ashutoshtiwarijee792 8 місяців тому

    lovely explanation please try to cover all topics of statistics , kudos to your work really appreciate it

  • @venkatasurendra5516
    @venkatasurendra5516 Рік тому

    Watching a day before my exam... Thank you sir

  • @AbdulMax021
    @AbdulMax021 3 роки тому +1

    This video saved my life today

  • @ezekielfemi3441
    @ezekielfemi3441 3 роки тому +1

    Good job... God bless.
    Nice work 👍 👍 👍

  • @ashishmishra-lr9ib
    @ashishmishra-lr9ib 4 роки тому +2

    Excellent explanation. Thank you very much

  • @olashinaolaniyi729
    @olashinaolaniyi729 11 місяців тому

    Thank you so much for this video. God bless you richly

  • @thineswarygobi2102
    @thineswarygobi2102 2 роки тому +1

    Sir , thanks a lot, so helpful very detail explanation 🙏🙏🙏😭

  • @Pandaoniman
    @Pandaoniman 3 роки тому +1

    You make it easy to replicate and remember bro. Thank you.

  • @botanywithsonam3069
    @botanywithsonam3069 2 роки тому

    Thank you so much sir 🙏 making it so easy to understand. You are a great teacher

  • @mehuldudhat4821
    @mehuldudhat4821 3 роки тому +2

    nice, very helpful for making last year college project report.

  • @zoeee_eventing1549
    @zoeee_eventing1549 3 роки тому +1

    This was so so helpful for my dissertation ! :)

  • @nuriyesahinhodoglugil8175
    @nuriyesahinhodoglugil8175 2 роки тому

    Thank you so much, very clear and very well paced.

  • @nazrenanuar3371
    @nazrenanuar3371 4 роки тому +1

    Thank you so much Dr. Keshminder

  • @SumaiyaSherin
    @SumaiyaSherin 2 роки тому

    Thank you so much sir ur explanation was wonderful!!!

  • @umamahfaizansari7667
    @umamahfaizansari7667 3 роки тому +1

    Thank you so much, this helped me complete my research work.

  • @mrsusan5672
    @mrsusan5672 3 роки тому +1

    Amazing! Thank you so much for this!

  • @DominicDsouza5
    @DominicDsouza5 2 роки тому

    Thank you for the video, Well explained.

  • @alimariposa119
    @alimariposa119 11 місяців тому

    Thank you so much for your help❤❤❤

  • @aurikafilipova2826
    @aurikafilipova2826 Рік тому

    Perfect! Thanks you so much for the video ❤

  • @aimansstudio6322
    @aimansstudio6322 4 роки тому +1

    Thank you Dr. It is well explained.

  • @swatimandavawalla1265
    @swatimandavawalla1265 2 роки тому

    Very nicely explained.

  • @manishapant9028
    @manishapant9028 4 роки тому +1

    Thank you for explaining so nicely.

  • @jaxparrow1794
    @jaxparrow1794 3 роки тому

    You are a lifesaver!
    Thank you!

  • @thegreatpiratemorgan
    @thegreatpiratemorgan 3 роки тому +1

    YOU ARE INCREDIBLE!!! THANK YOU!

  • @dakshap4383
    @dakshap4383 3 роки тому +1

    how should i thank u sir thank u sooooooooo much for this i did like wise u told n i got it

  • @jieliu4595
    @jieliu4595 2 роки тому

    Thank you for the explanation, how about if multiple variables (more than 2 variables), how to check if one variable is dependent/independent from the other variables, also how to check if the other variables are independent with each other, do you have to check one by one

  • @mahamaseidualhassan9135
    @mahamaseidualhassan9135 3 роки тому

    Fantastic explanation

  • @nurfazila180
    @nurfazila180 3 роки тому +1

    Thank you so much!

  • @imranjaffrey2195
    @imranjaffrey2195 3 роки тому +1

    How to decide probability as 0.05? Can we take this probability in every chisquare test? Or only having 2 variables?

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому

      you can take it, it is just the level of significance

  • @hanankhalifa2589
    @hanankhalifa2589 Рік тому

    Thank you so so so much

  • @nhuiyu3462
    @nhuiyu3462 3 роки тому

    Thank you for the clear instruction. Just curious if Fisher's Exact is applicable in this example and how to decide which is better in this case?

  • @hoya_hydragea
    @hoya_hydragea 3 роки тому

    Thank you Dr !

  • @abdulwahabsheikh5069
    @abdulwahabsheikh5069 2 роки тому

    It was so helpful thank you

  • @orleneblissnisnisan8417
    @orleneblissnisnisan8417 3 роки тому +1

    THANKSS! GREAT HELP

  • @vivianchoo269
    @vivianchoo269 Рік тому

    does this mean if u have likert scale you cannot use chi-test?

  • @tanvijakhar931
    @tanvijakhar931 7 місяців тому

    How to take the level of significance....please explain

  • @ganesharya3512
    @ganesharya3512 2 роки тому

    what do u mean by probability value 0.05 ? Secondly, what is meant by a reduced chi-square value? Actually, I am using a labfit software for curve fitting and it gives me reduced chisquare vales as a parameter for the goodness of fit

  • @bettaenthusiastb339
    @bettaenthusiastb339 2 роки тому

    Hye sir, I would like to know in case we reject null hypothesis and there is significant differenece is it a must to carry out post hoc test? If yes I would like to know which post hoc test is the most suitable to use. Is it bonferroni correction with adjusted residuals?

  • @dr.shalmaligadge1683
    @dr.shalmaligadge1683 Рік тому

    why 2 has been taken in chi-square calculation ?

  • @mfion
    @mfion 3 роки тому +1

    If I may ask a question... Is there a way to calculate effect size in Excel along with the Chi-Square so that I can submit this information too in my paper?

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому +1

      there are videos showing how to calculate the effect size.
      try have look at the following link:
      ua-cam.com/video/DcRN36L2qzQ/v-deo.html

  • @pradipthombare1700
    @pradipthombare1700 3 роки тому +1

    Thank you sir...

  • @tiffanywong7285
    @tiffanywong7285 4 роки тому +1

    Hi sir may i ask if i got lots of decimal places at the expected table should i round it up? If yes, how many decimal places?
    Ps. Your explanation is so good i understand all now TuT. TQSM!!

    • @jskeshminder4627
      @jskeshminder4627  4 роки тому

      Hi Tiffany you should round up to two or three decimal points. I am glad it helped! All the best.

  • @rspradeep8248
    @rspradeep8248 3 роки тому

    Thank you sir. But in my ex-cel, I can't get critical value

  • @kerish23
    @kerish23 3 роки тому

    Thank you!

  • @riaariarini8553
    @riaariarini8553 3 роки тому

    Thank you sir, very helpful. I have a question : can we obtain fischer exact test also in excel as an alternative for chi-square?

  • @greensun1352
    @greensun1352 10 місяців тому

    What does reject and failed to reject means?

    • @greensun1352
      @greensun1352 10 місяців тому

      How can we apply it to our research?

  • @chaowang1071
    @chaowang1071 9 місяців тому

    Tks

  • @prasannaganesh1775
    @prasannaganesh1775 2 роки тому

    how to analyze : yes or no question using chi-square sir

  • @jessicaarrabe7095
    @jessicaarrabe7095 3 роки тому

    how did u get the probability?

  • @deanab-se5op
    @deanab-se5op 3 роки тому +2

    Wow Malaysian!!!

  • @trisandaffa
    @trisandaffa 3 роки тому

    Sir I want to ask, my observed data have 0 scores, so what should I do? I can’t calculated it to chi square cause when I entered the chi square formula it always said error. Help me please😢 thank you in advance🙏

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому

      The error is with your microsoft excel or the data. There should not be any problem

    • @trisandaffa
      @trisandaffa 3 роки тому

      @@jskeshminder4627 Oh I see, thank you so much sir🙏

  • @NavdeepSingh-bm8or
    @NavdeepSingh-bm8or 3 роки тому

    excellent

  • @farahilyana9964
    @farahilyana9964 4 роки тому +1

    dr. how to know the probability, the alpha

    • @jskeshminder4627
      @jskeshminder4627  4 роки тому +1

      It depends on the question (the question should mention), if not generally most of the studies are confined to 0.05

    • @farahilyana9964
      @farahilyana9964 4 роки тому

      @@jskeshminder4627 OK. thankyou dr

  • @abebesimion621
    @abebesimion621 Рік тому

    I am PhD holder on pure statistics

  • @varunprashad1921
    @varunprashad1921 4 роки тому +2

    Safe g

  • @shivamnahata7451
    @shivamnahata7451 3 роки тому

    will you provide me the excel sheet? please give me

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому

      sure - give me your email address

    • @shivamnahata7451
      @shivamnahata7451 3 роки тому

      @@jskeshminder4627 shivamnahata7@gmail.com these my email id at what time and what hour I will get please reply me

    • @amosgilchiong8982
      @amosgilchiong8982 3 роки тому

      @@jskeshminder4627 please provide me as well sir . amosgilc@gmail.com please sir

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому

      @@amosgilchiong8982 done check you email

    • @amosgilchiong8982
      @amosgilchiong8982 3 роки тому

      @@jskeshminder4627 thank you very much

  • @ussainthannikund7643
    @ussainthannikund7643 4 роки тому +1

    very sloooooooooooooooooooooooooow....

  • @tomasprokes7138
    @tomasprokes7138 3 роки тому +1

    Thank you so much !

  • @harishkumar5002
    @harishkumar5002 3 роки тому

    Please clarify, as per CV i have fail to reject whereas in p-value approach i have to reject . Is this correct ?

    • @jskeshminder4627
      @jskeshminder4627  3 роки тому

      You have to check you data and your analysis - it should not be that way

    • @harishkumar5002
      @harishkumar5002 3 роки тому

      @@jskeshminder4627 Thanks for your reply. I will re-check the data and calculate again.