Пікірлер
@SS-ft5vm
@SS-ft5vm 27 күн бұрын
Thank you very much ❤
@subodhkumarsuman5509
@subodhkumarsuman5509 2 ай бұрын
Thank you so much sir.
@ivanjohn3742
@ivanjohn3742 2 ай бұрын
Very well explained 🎉 Thanks
@abdulsameerkhan5465
@abdulsameerkhan5465 2 ай бұрын
Item discrimination index of a likert scale jo ap bta rahe hai woh kis formula se calculate kar rhe hai? Aur yeh formula kisne diya hai? Research mein hume justification dene hota hai k kisne formula diya hai.
@AbhishekKumarSingh-wl1oo
@AbhishekKumarSingh-wl1oo 5 ай бұрын
How to select the criteria to discriminate the items ..to select or reject any items
@abdulsameerkhan5465
@abdulsameerkhan5465 2 ай бұрын
For discrimination index of a test or likert scale as calculated in this video, You may use the reference table given by Ebel and Frisbie, 1986 for selecting and rejecting an item. For manual calculation of item analysis using the basic formula incorporating RU, RL, N for both item discrimination and item difficulty. You may use the criteria for accepting or rejecting an item given by Noll (1965). Discrimination index using t- Test you may simply use t-table for selecting and rejecting the item.
@shivangitiwari9777
@shivangitiwari9777 6 ай бұрын
Sir pls share pdf for likert scale
@ShivanandThorat
@ShivanandThorat 6 ай бұрын
Which pdf you want?
@shivangitiwari9777
@shivangitiwari9777 6 ай бұрын
Sir can you pls share in any pdf of this.pls.if yousay yes then i can share my email id
@priyankasahu1111
@priyankasahu1111 7 ай бұрын
good job bhaiyaaa and thanku so much
@madhurimagiridharan9590
@madhurimagiridharan9590 9 ай бұрын
How to chwck for large data ? I jave a sample soze of 1078
@ShivanandThorat
@ShivanandThorat 8 ай бұрын
By the same method no matter how large is the sample, method remains the same
@syedasameezahra6498
@syedasameezahra6498 11 ай бұрын
Very well explained 👍
@badiosogenyl4948
@badiosogenyl4948 11 ай бұрын
at the start you said P value should be greater than .05 " P>.05" to accept null hypothesis in which data is not different from normal, the ks value which is our p value is less than .05 which means null hypothesis should be rejected
@ShivanandThorat
@ShivanandThorat 11 ай бұрын
Yes. If p value is less than 0.05 then the null hypothesis is rejected, it means that the data is not normally distributed. The alternate hypothesis will be accepted which state that data is significantly different from the normal distribution
@PARVINDERSINGHSoan
@PARVINDERSINGHSoan Жыл бұрын
Your explanation was very informative and well-explained, sir. I'm revising the topics for my dissertation. Statistics was fun to learn and easy to understand when you were on campus
@awge6666
@awge6666 Жыл бұрын
Hi, can you explain why you chops alpha 0.05?
@ShivanandThorat
@ShivanandThorat 11 ай бұрын
I chop p value at 0.05, not alpha. p value is probability of error
@amritapal2
@amritapal2 Жыл бұрын
very well explained. Thank you. Found this video very helpful.
@ShivanandThorat
@ShivanandThorat Жыл бұрын
Thank you!
@darshikasp5901
@darshikasp5901 Жыл бұрын
🙏👍
@panda_whisper_tales
@panda_whisper_tales Жыл бұрын
Please upload how to perform chi square test using excel
@ShivanandThorat
@ShivanandThorat 8 ай бұрын
Alright. Will make one in the near future
@keralafury7478
@keralafury7478 Жыл бұрын
Bro can you demonstrate a 10 company profile data and 5 variables with a 10 year data
@ShivanandThorat
@ShivanandThorat 8 ай бұрын
It can be done using the similar method. Just columns in your datasheet will be more
@mayurj1934
@mayurj1934 Жыл бұрын
can u send output
@ShivanandThorat
@ShivanandThorat 8 ай бұрын
It is a hypothetical data. You may use real data
@TadalaMagelegele
@TadalaMagelegele Жыл бұрын
How to calculate reliability index test using split half methods if given 8 items and total score in percentage
@user-hm7cf3ns2u
@user-hm7cf3ns2u Жыл бұрын
Thank you for the explanation sir💜💜
@ShivanandThorat
@ShivanandThorat 8 ай бұрын
Glad it helped
@sangitaholmukhe2958
@sangitaholmukhe2958 Жыл бұрын
Thank you very much sir for your deepest guidance in the item analysis.
@kit9wana
@kit9wana Жыл бұрын
You didn’t compare the two
@ShivanandThorat
@ShivanandThorat Жыл бұрын
Which two?
@TrishaLuna-ml7dl
@TrishaLuna-ml7dl Жыл бұрын
thanks idol, bisita ka dito minsan samen. pameryenda ako
@ShivanandThorat
@ShivanandThorat Жыл бұрын
Could you please write in English?
@shameemashaban8257
@shameemashaban8257 Жыл бұрын
Hello sir my corrected item-Total correlation for 7 items is. 572,.811,.838,.702,.805,.722,.622 and cronbach alpha for these 7 items is.907 what to do in this matter will it created problem
@ShivanandThorat
@ShivanandThorat Жыл бұрын
Go ahead. No need to delete items as values are just slightly above 0.8
@Leomessii99
@Leomessii99 Жыл бұрын
Good one. Thanks mate🙌🏻
@khusikumari250
@khusikumari250 2 жыл бұрын
Thank you so much sir....very helpful and informative video....i learn many more new things 🙏
@luisfevel
@luisfevel 2 жыл бұрын
Thank you!!!
@renuguhadevi7877
@renuguhadevi7877 2 жыл бұрын
Very much useful !!
@NobixLee
@NobixLee 2 жыл бұрын
Not useful when you have thousands of outliers, excel needs to create a feature where you can just click to remove outliers.
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
It is a researcher's decision whether to continue with some outliers or not. So auto outliers removal is not a good choice. Researcher should remove outliers one or maximum 2 at a time and re-run analysis. Removing multiple outliers at the same time is not a good idea. Hope this helps.
@zee4958
@zee4958 2 жыл бұрын
Thank You so much sir 😍Subscribed!
@farahelhouari2411
@farahelhouari2411 2 жыл бұрын
please I have 4 points Likert scale I divided the ID by 3?
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Yes
@preetisharma9064
@preetisharma9064 2 жыл бұрын
Thanku so much n god bless u
@ShivanandThorat
@ShivanandThorat 8 ай бұрын
Thanks for watching
@ramneek4344
@ramneek4344 2 жыл бұрын
CAN YOU PLEASE TEACH HOW TO CALCULATE CRONBACH APLHA ON EXCEL
@ShivanandThorat
@ShivanandThorat 8 ай бұрын
I will upload a video on that, but as of now you can watch video of any other creator. It is easy to calculate
@AmalShafik
@AmalShafik 2 жыл бұрын
Tis is one of the best statistical explanation I have seen so far ! Thank you so much
@ramneek4344
@ramneek4344 2 жыл бұрын
HOW TO MAKE THE BELL CURVE NOW FROM HERE ONWARDS
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
I will cover that in a separate video. But there are screen cast videos available on KZbin.
@ramneek4344
@ramneek4344 2 жыл бұрын
will the outliers cause a flawed normal distribution curve?
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Yes. And outliers can also deviate mean and standard deviation resulting in an erroneous inference.
@evansthabethe
@evansthabethe 2 жыл бұрын
Thanks, Mr Thorat!😀
@jamilamir3449
@jamilamir3449 2 жыл бұрын
How to use this for descriptive questions or numerical problem teat
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
For numerical problem, you can use item difficulty index
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
And for descriptive questions, this method is not applicable. You can try other qualitative methods. Content validity ratio (CVR) can be calculated for descriptive questions validation
@prernamukhia6965
@prernamukhia6965 2 жыл бұрын
If the sample size is 125 what will be the number of upper and lower respondent?
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
27% of 125 is 33.75. You can take 34 respondents in upper and 34 respondents in lower group.
@prernamukhia6965
@prernamukhia6965 2 жыл бұрын
Thank you so much🙏💐
@sangitaholmukhe2958
@sangitaholmukhe2958 Жыл бұрын
For diactomus data 0-1 can use well for discrimination index. As you shown. But I maintained that i will use likert scale but I'm using now diactomus.
@kaushalgorle1203
@kaushalgorle1203 2 жыл бұрын
👍👍👍
@researchramp436
@researchramp436 2 жыл бұрын
Very helpful!
@RB_Insights
@RB_Insights 2 жыл бұрын
Sir my scale is 3 points ordinal ( Always=3, Sometimes =2, Never=1) . As ordinal cannot use parametric statistics. which statistics can I use to do item analysis?
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Hi, You can use the same procedure that I have used. 3 point Likert scale as you have mentioned can be considered as continuous. Hope this helps. -Shivanand
@vandanadaksh6619
@vandanadaksh6619 2 жыл бұрын
Hello sir, Sir, I have used three point likert scale for my tool. Is it possible to apply the same corrected item correlation method for the item analysis? Also, my supervisor has suggested to read a book, 'Techniques of Attitude Scale Construction' by Allen L. Edwards. Have you also referred that book ever?
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Yes. Corrected item total correlation can be applied. No idea about the book. I haven't referred it so far. Thanks for watching
@vandanadaksh6619
@vandanadaksh6619 2 жыл бұрын
@@ShivanandThorat thank you for the prompt response sir. Can I mail you if I face any further problem regarding the same?
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
@@vandanadaksh6619 sure. [email protected]
@KAadhya
@KAadhya 2 жыл бұрын
Pls. Explain quartiles in excel
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Please watch this video: kzbin.info/www/bejne/aHPSppWejcidbLM
@KAadhya
@KAadhya 2 жыл бұрын
You explain very nicely
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Thanks
@MattGarcyaDC
@MattGarcyaDC 2 жыл бұрын
it says "my input range contains non-numeric values." when I try to use data analysis tool
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Please check my data has headers option while doing data analysis. Try to have only first row as header. From the second row, numbers should start. Hope this helps.
@mohsena.s8633
@mohsena.s8633 2 жыл бұрын
Thank you for your useful video , could you please fully explain Data analytics tool in Excel
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Hi Mohsen, I am will upload more videos shortly. There is one workshop with Royal College, you can find it by searching my name Shivanand Thorat and add Royal College next to it in the search. On day 1 of the workshop, I have covered most of the options in data analysis using Excel.
@marufagulnaz396
@marufagulnaz396 2 жыл бұрын
lots of thanks......you provided very useful and benefial ways of odd even split half method which no any tutorial taught....
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
I am glad it helped you. Thank you for watching, subscribe the channel if you find content helpful
@riyachhabra4915
@riyachhabra4915 2 жыл бұрын
Thanku so much sir
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Thanks for watching. Consider subscribing the channel if you find content helpful.
@SatishJadhav-rr1oq
@SatishJadhav-rr1oq 2 жыл бұрын
Thank u sir nice video
@ShivanandThorat
@ShivanandThorat 2 жыл бұрын
Sir kay aree 😆