Reliability Analysis using MS Excel

In this video, Reliability Analysis or Cronbach Alpha is calculated and infer using MS Excel

[@niksitihajar6845]

SO USEFULLLL AND SIMPLEEE THANKKK YOUUU

[@ravishekhartiwari377]

Explained nicely

[@sadiyashah415]

much usefull, thank you so much

[@TheAmpleRein]

Thank you sir

[@afreenzafar6126]

Can you provide me with the link where you explained coding the data above in numbers form?

[@bharath3899]

Hello sir, is it better to use Excel or SPSS for finding Alpha ? Are both results accurate ?

[@economicaGBS]

Dear Bharath, if you are known to with SPSS, then use SPSS only; otherwise, EXCEL will also serve your purpose. Both ALPHA values are accurate.

[@PunarvasKini]

sir if we have dichotomous variable and likert variable in same questionnaire , which reliability test can be used..my sample size is 15

[@economicaGBS]

Test-Retest Reliability:
For Both Types: Test-retest reliability assesses the stability of measurements over time. It can be used for both Likert-type and dichotomous variables. For Likert-type variables, participants would respond to the same questionnaire twice, while for dichotomous variables, you'd calculate the agreement between responses at two different time points.
Intraclass Correlation Coefficient (ICC):
For Both Types: ICC is useful when you want to assess the reliability of measurements taken by multiple raters or on multiple occasions. It can be applied to both continuous and dichotomous data.

[@ravishekhartiwari377]

How can we overcome if Alfa value is poor ?

[@economicaGBS]

Answer is within video

[@parkashmagar8468]

what kind of subject is this unkowingly clicked here