Video není dostupné.
Omlouváme se.

Split-Half Reliability using Excel and SPSS (Spearman-Brown Prophecy Coefficient)

Sdílet
Vložit
  • čas přidán 18. 08. 2024
  • How to compute Split-Half Reliability using Excel and SPSS
    SUBSCRIBE to my channel: czcams.com/users/sh...
    This video demonstrates how to compute split-half reliability and the Spearman-Brown Coefficient using MS Excel. The Spearman-Brown Coefficient is a measure of inter-item reliability.
    Internal Consistency Reliability
    Spearman-Brown Split Half Reliability Coefficient also called the Spearman-Brown Prophecy Coefficient, is a form of split halves reliability measure. The Spearman-Brown Prophecy Coefficient is used to estimate full test reliability based on split-half reliability measures
    In this video (key moments):
    00:00 - Simple split method using Excel and SPSS
    07:59 - Odd-even split method using Excel and SPSS
    11:54 - Quarter split method using Excel and SPSS
    Reach out to me on:
    Email: shivanandthorat.yt@gmail.com
    Telegram: t.me/shivanand...
    Facebook: / shivanand.thorat.7
    Instagram: / shivanandthorat
    LinkedIn: / shivanand-thorat-021b7...
    #reliability #splithalfreliability #spearmanbrowncoefficient #spearmanbrownprophecycoefficient #psychometrics #psychology #psychologicaltesting #internalconsistencyreliability #spss #excel #shivanandthorat

Komentáře • 56

  • @ShivanandThorat
    @ShivanandThorat  Před 3 lety +2

    Visit the channel for more on psychology, psychometrics, psychological statistics, and research methodology.
    Subscribe to provide 'positive reinforcement' and press the 'bell' icon to express your 'unconditional' support!

  • @marufagulnaz396
    @marufagulnaz396 Před 2 lety +2

    lots of thanks......you provided very useful and benefial ways of odd even split half method which no any tutorial taught....

    • @ShivanandThorat
      @ShivanandThorat  Před 2 lety

      I am glad it helped you. Thank you for watching, subscribe the channel if you find content helpful

  • @Pravin_Khedkar
    @Pravin_Khedkar Před 4 lety +5

    Very Informative.
    It would be very fortunate to follow this man for psychology academics !!!

  • @renuguhadevi7877
    @renuguhadevi7877 Před rokem +1

    Very much useful !!

  • @DrYeol
    @DrYeol Před 3 lety +2

    This really saved me!
    Thank you very much :)

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      Thanks for watching. Subscription to the channel would be amazing.

  • @preetisharma9064
    @preetisharma9064 Před rokem

    Thanku so much n god bless u

  • @MamtaRani-oc6vo
    @MamtaRani-oc6vo Před 3 lety +1

    Nicely explained... Thank u

  • @researchramp436
    @researchramp436 Před 2 lety

    Very helpful!

  • @vishalthorat4037
    @vishalthorat4037 Před 4 lety +1

    Good one brother 🔥

  • @nainikahira5908
    @nainikahira5908 Před 3 lety

    Very helpful! Thankyou!

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      Thanks for watching. Consider subscribing to the channel if you find content helpful

  • @philjohnk.7129
    @philjohnk.7129 Před 3 lety +2

    Thank you very much. Very well explained. Congrats.
    My question is about a real case when you have maybe 5 sections in the questionnaire, do you calculate the reliability coefficient for each section. What about follow up questions (open-ended questions)?

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety +1

      Hi Phil John. Thanks for watching.
      Yes, if you have different domains/factors/sections in your test, you should compute different internal consistency reliability coefficient for each. For example, if you have 5 domains/sections, then 5 different reliability coefficients. And if your test is not a knowledge or speed test, and has Liker scale, I would recommend you to go for Cronbach's Alpha reliability. In case of dichotomous items, KR-20 is an option. However, in all cases, Split-Half reliability will be a good addition for the psychometric properties of your scale.

    • @philjohnk.7129
      @philjohnk.7129 Před 3 lety

      Wow, some people are so available for others. God bless you, Sir!
      May I have your email if you don't mind?

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      And yeah, about the follow-up questions, you can report those as qualitative inferences which would be a valuable qualitative addition to your scale. Also, these can be used as feedback too for further refinement of the tool.

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      @@philjohnk.7129 Mention not John. shivanandthoratresearch@gmail.com is my mail ID. Feel free to write.

  • @basavantdhudum1272
    @basavantdhudum1272 Před 3 lety

    Nice explanation

  • @silpas8748
    @silpas8748 Před 3 lety

    Thank you so much!!

  • @sarahkhrasi2893
    @sarahkhrasi2893 Před 3 lety

    Very helpful 👍👌

  • @TadalaMagelegele
    @TadalaMagelegele Před rokem

    How to calculate reliability index test using split half methods if given 8 items and total score in percentage

  • @kaiwingwong5263
    @kaiwingwong5263 Před 4 lety +2

    Hi sir, in the video you mentioned that the SBC>0.7 is acceptable, else it is not. May I know is it a Table of Spearman-Brown Coefficient to be referred?

    • @ShivanandThorat
      @ShivanandThorat  Před 4 lety +2

      Hello dear,
      No, there's no table to refer for Spearman-Brown Coefficient and it's not a correlation coefficient to see it's significance value by refering to critical values table.
      Generally, Spearman-Brown Coefficient value above 0.7 indicates an acceptable internal consistency reliability for a test.
      If the SBC value is > 0.8, it is considered as good international consistency reliability.
      SBC > 0.7 is the most frequent recommendation including the recent study by Mokkink et al., 2017.

  • @LoveIsNotits
    @LoveIsNotits Před 4 lety

    Really helpful! :)

  • @priyankatudu2657
    @priyankatudu2657 Před 3 lety +1

    How we can know the reliability value is accurate or not

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      Hello madam, I didn't get your question. Accurate as in we are using software, values will be accurate only unless you make any error in the formula that is employed in the Excel or SPSS. You can compute manually and check if the values appearing in the software are accurate or not

  • @priyankatudu2657
    @priyankatudu2657 Před 3 lety +1

    Is there any table for reliability value

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      There is as such no table for split-half reliability values. But generally any value above 0.7 is considered as acceptable and any value above 0.8 is considered as good. I hope this helps.

  • @preetisadolii9540
    @preetisadolii9540 Před 3 lety

    Sir will to tell me through manual that how we check the reliability of likert scale through split half method

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety +1

      Hi Preeti,
      Check psychometric properties section in the manual for reliability of the scale. Not all scale manuals mention split-half reliability

  • @MsHwang-tp4tk
    @MsHwang-tp4tk Před 3 lety

    Can you make another video how to interpret the result?

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      I'll make it in near future. Thanks for watching.
      Interpretation of the split-half reliability coefficient (Spearman-Brown Coefficient) is identical to other internal consistency reliability coefficients. SBC > 0.7 is acceptable, SBC > 0.8 is good. Higher the coefficient, better it is.

  • @thivyawincy.w4650
    @thivyawincy.w4650 Před 2 lety

    If we have 33 questions for 10 respondents , can we seperate first 11 and second 10 for average value and there by correlation?

    • @ShivanandThorat
      @ShivanandThorat  Před 2 lety +1

      You mean first 16 and second 17 items? There are 33 items to be split into two halves. So you can use odd even split which will result into 16 and 17 items in two halves. And then find correlation and follow further procedure as shown in the video. SPSS provide two Spearman-Brown Coefficients, one for equal halves, the other for unequal halves. You you will interpret unequal halves in this case.
      Hope this helps. Consider subscribing to the channel if you find content helpful.
      Best,
      Shivanand Thorat

  • @katy8791
    @katy8791 Před 3 lety

    @Shivanand Thorat Hello Thorat ! Nice video👍 I wish to know when do we use split half reliability is it when we have a small sample less than 30 so instead of using the normal cronbach alpha we use split half in that case?

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety +1

      Hi Katy, split-half reliability is generally used when there are large number of items in the test or if the test is timed. Split-half has nothing to do with the sample size as such. But it's always desirable to have sample size greater than 30. Hope this helps.
      Thanks for watching. Consider subscribing to the channel if you find the content helpful.

    • @katy8791
      @katy8791 Před 3 lety

      @@ShivanandThorat Hello Thorat🙋🏻‍♀️ thanks for your reply🙂 i wish to know what did you mean by test is timed? U mean repeated?
      Also, am I allowed to use cronbach alpha if i don't have another sample like a pilot sample?

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety +1

      By the term timed test I mean that the test has a time limit to complete.
      Cronbach alpha can be used even if you don't have pilot testing done before. In fact it can be used as a tool for item analysis. Please watch my another video on item analysis using Excel and SPSS to know how to use it for item analysis.
      In case of queries, feel free to write to me on shivanandthorat.yt@gmail.com

    • @katy8791
      @katy8791 Před 3 lety

      @@ShivanandThorat Thanks a lot Thorat 🙂 so if i am doing a pretest and a posttest in my research is it enough to show that cronbach alpha is 0.7 for the pretest or i should also do that for the posttest?
      Also, thanks for your contact details... what about shivanandthoratresearch@gmail.com can i contact you on that mail too?

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety +1

      No problem Katy. And you can contact me on shivanandthoratresearch@gmail.com. You can use any set that is pretest or posttest, compute cronbach for the one with larger sample size. If sample size is equal then go for any (pre or post)

  • @sowmyashree2161
    @sowmyashree2161 Před 3 lety

    Namaste sir is SPSS necessary to calculate split half odd even reliability ?

  • @TrishaLuna-ml7dl
    @TrishaLuna-ml7dl Před rokem

    thanks idol, bisita ka dito minsan samen. pameryenda ako

  • @philjohnk.7129
    @philjohnk.7129 Před 3 lety

    Sir, I saw your address, but another video came in, and now I can find back your e-mail. Sorry, I'm not really gifted in these technologies.

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      No problem. Technology is developing exponentially. We all learn with our need and pace 😊

  • @philjohnk.7129
    @philjohnk.7129 Před 3 lety

    Actually I'm asking your email again

    • @ShivanandThorat
      @ShivanandThorat  Před 3 lety

      Oops, I thought you found it back. Anyway. It's shivanandthoratresearch@gmail.com

  • @philjohnk.7129
    @philjohnk.7129 Před 3 lety

    I sent you an email