- 12
- 125 622
Shivanand Thorat
India
เข้าร่วมเมื่อ 8 ม.ค. 2018
Learning, cognizance, & education is the purpose of this channel. This is the channel where I try to enhance learning by integrating theory & practice.
I cover topics related to research methodology, statistics, psychometrics, psychology, SPSS, & Excel.
In every video, I try to share my learnings, insights, & understandings gained from teaching, various research projects, & experimental studies. It is an attempt to simplify the complex concepts in research methodology, statistics, psychology, & psychometrics with the help of innovative ideas and illustrative examples.
The presence of scholars & keen learners like you motivate me to provide better quality & content each time.
Subscribe to provide 'positive reinforcement' & press the 'bell' icon to express your 'unconditional' support!
ABOUT ME
Doctoral Researcher at IIT Delhi | Data Analyst | Industrial Psychologist | Former Assistant Professor of Psychology at Symbiosis College | UGC-NET | SET
I cover topics related to research methodology, statistics, psychometrics, psychology, SPSS, & Excel.
In every video, I try to share my learnings, insights, & understandings gained from teaching, various research projects, & experimental studies. It is an attempt to simplify the complex concepts in research methodology, statistics, psychology, & psychometrics with the help of innovative ideas and illustrative examples.
The presence of scholars & keen learners like you motivate me to provide better quality & content each time.
Subscribe to provide 'positive reinforcement' & press the 'bell' icon to express your 'unconditional' support!
ABOUT ME
Doctoral Researcher at IIT Delhi | Data Analyst | Industrial Psychologist | Former Assistant Professor of Psychology at Symbiosis College | UGC-NET | SET
Normality Test Using Excel: Kolmogorov-Smirnov Test & Skewness and Kurtosis in Excel & SPSS
Normality Test Using Excel: Kolmogorov-Smirnov Test & Skewness and Kurtosis in Excel | Data Analysis Using Excel Series E05
SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat
This episode demonstrates how to test normality using the Kolmogorov-Smirnov test of normality and skewness and kurtosis values in Microsoft Excel.
The first episode demonstrates how to enable the Data Analysis ToolPak in Microsoft Excel.
Link for the first episode: th-cam.com/video/z15_PUyNZ3M/w-d-xo.html
The second episode demonstrates how to compute descriptive statistics in Microsoft Excel.
Link for the second episode: th-cam.com/video/24Ar1yhfkBc/w-d-xo.html
The third episode elaborates on the descriptive statistics computed in Microsoft Excel using the Data Analysis option available under the Data tab.
Link for the third episode: th-cam.com/video/2BoubhXcj6Q/w-d-xo.html
The fourth episode demonstrates how to detect and remove outliers using the boxplot method also known as the interquartile method or IQR method in Microsoft Excel.
Link for the fourth episode: th-cam.com/video/1Y7Y7m6bZSs/w-d-xo.html
References:
George, D., & Mallery, M. (2010). SPSS for Windows step by step: A simple guide and reference, 17.0 update (10th Ed.). Pearson.
Critical Values Table for Kolmogorov-Smirnov Test Statistic:
docs.google.com/spreadsheets/d/13CFnTyaJMbO8o9G8McMp8uYFHgnHhi-c/edit?usp=sharing&ouid=116614408810004472235&rtpof=true&sd=true
Thanks for watching. See you soon.
Take good care,
Shivanand Thorat
Chapters in the Video (Key Moments):
00:00 What is Normal Distribution
00:50 What is the Normality Test
01:28 Kolmogorov Smirnov Test in Excel
09:03 Kolmogorov Smirnov Test in SPSS
10:33 Normality test using Skewness and Kurtosis
Reach out to me on:
Email: shivanandthorat.yt@gmail.com
Telegram: t.me/shivanand_thorat
Facebook: shivanand.thorat.7
Instagram: shivanandthorat
LinkedIn: www.linkedin.com/in/shivanand-thorat-021b7b1b6/
Music in this video:
Track 1: Parachute BGM
Track 2: Summer Time
Video Recorder: OBS Studio v27.0.1
Video Editor: Wondershare Filmora X v10.1.20
Audio Editor: Audacity v3.0.2
#normalitytestusingexcel #normality #kolmogorov-smirnovnormalitytestinexcel #skewnessinexcel #kurtosisinexcel #skewness #kurtosis #dataanalysis #splithalfreliabilityinexcel #psychometricsinexcel #shivanandthorat @ShivanandThorat
SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat
This episode demonstrates how to test normality using the Kolmogorov-Smirnov test of normality and skewness and kurtosis values in Microsoft Excel.
The first episode demonstrates how to enable the Data Analysis ToolPak in Microsoft Excel.
Link for the first episode: th-cam.com/video/z15_PUyNZ3M/w-d-xo.html
The second episode demonstrates how to compute descriptive statistics in Microsoft Excel.
Link for the second episode: th-cam.com/video/24Ar1yhfkBc/w-d-xo.html
The third episode elaborates on the descriptive statistics computed in Microsoft Excel using the Data Analysis option available under the Data tab.
Link for the third episode: th-cam.com/video/2BoubhXcj6Q/w-d-xo.html
The fourth episode demonstrates how to detect and remove outliers using the boxplot method also known as the interquartile method or IQR method in Microsoft Excel.
Link for the fourth episode: th-cam.com/video/1Y7Y7m6bZSs/w-d-xo.html
References:
George, D., & Mallery, M. (2010). SPSS for Windows step by step: A simple guide and reference, 17.0 update (10th Ed.). Pearson.
Critical Values Table for Kolmogorov-Smirnov Test Statistic:
docs.google.com/spreadsheets/d/13CFnTyaJMbO8o9G8McMp8uYFHgnHhi-c/edit?usp=sharing&ouid=116614408810004472235&rtpof=true&sd=true
Thanks for watching. See you soon.
Take good care,
Shivanand Thorat
Chapters in the Video (Key Moments):
00:00 What is Normal Distribution
00:50 What is the Normality Test
01:28 Kolmogorov Smirnov Test in Excel
09:03 Kolmogorov Smirnov Test in SPSS
10:33 Normality test using Skewness and Kurtosis
Reach out to me on:
Email: shivanandthorat.yt@gmail.com
Telegram: t.me/shivanand_thorat
Facebook: shivanand.thorat.7
Instagram: shivanandthorat
LinkedIn: www.linkedin.com/in/shivanand-thorat-021b7b1b6/
Music in this video:
Track 1: Parachute BGM
Track 2: Summer Time
Video Recorder: OBS Studio v27.0.1
Video Editor: Wondershare Filmora X v10.1.20
Audio Editor: Audacity v3.0.2
#normalitytestusingexcel #normality #kolmogorov-smirnovnormalitytestinexcel #skewnessinexcel #kurtosisinexcel #skewness #kurtosis #dataanalysis #splithalfreliabilityinexcel #psychometricsinexcel #shivanandthorat @ShivanandThorat
มุมมอง: 14 141
วีดีโอ
How to Remove Outliers Using Excel: Boxplot Method in Excel (Interquartile Range/IQR Method)
มุมมอง 10K3 ปีที่แล้ว
How to Remove Outliers Using Excel: Find Outliers Using Boxplot Method in Excel (Interquartile Range / IQR Method) | Data Analysis Using Excel Series E04 SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat This is the fourth episode in the Data Analysis Using Excel Series. This episode demonstrates how to detect and remove outliers using the boxplot method also known as the interquartile ...
Descriptive Statistics Explained in Excel: Understanding Descriptive Statistics
มุมมอง 23K3 ปีที่แล้ว
Descriptive Statistics Explained in 8 minutes | Data Analysis Using Excel Series E03 SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat This is the third episode in the Data Analysis Using Excel Series. This episode elaborates the descriptive statistics computed in Microsoft Excel using the Data Analysis option available under the Data tab. The first episode demonstrates how to enable th...
Calculate Descriptive Statistics in Excel: Easy Way to Compute 14 Descriptive Statistics in MS Excel
มุมมอง 1.6K3 ปีที่แล้ว
Calculating descriptive statistics in Microsoft Excel. SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat This is the second episode in the Data Analysis Using Excel Series. This episode demonstrates how to compute descriptive statistics in Microsoft Excel using the Data Analysis option available under the Data tab. The first episode demonstrates how to enable the Data Analysis ToolPak i...
Data Analysis ToolPak in Excel: How to Activate Data Analysis Add-in in MS Excel
มุมมอง 1.8K3 ปีที่แล้ว
How to Activate Data Analysis Add-in in MS Excel Data Analysis Using Excel Series: Data Analysis ToolPak in Excel (Episode 01) SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat Hi guys! Bringing this new series titled Data Analysis Using Excel. This video demonstrates how to enable data analysis ToolPak in MS Excel. There are quite a few options in this Excel Add-in. I will cover all po...
APA 7th Edition Paper Format in Microsoft Word: Paper Format, Tips, and Shortcuts
มุมมอง 3.7K4 ปีที่แล้ว
Paper format in APA 7th Edition, Tips and Shortcuts in MS Word to Speed-up Paper Writing Work (National Webinar: DAY 2) SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat Day 1 Session: th-cam.com/video/jtkN1R96B9g/w-d-xo.html Day 2 Session: Saturday, November 28, 2020 This video demonstrates how to set up the 7th Edition APA Style paper format in MS Word and also includes tips and short...
APA 6th Edition vs APA 7th Edition: Changes in the 7th Edition APA Style
มุมมอง 5K4 ปีที่แล้ว
Changes in the Seventh Edition APA Style 2020. (National Webinar: DAY 1) SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat Link for DAY 2 Session: th-cam.com/video/5rCy1fGxfKU/w-d-xo.html Day 1 Session: Friday, November 27, 2020 Link to download PPT used in the webinar: drive.google.com/file/d/14osSfXj5ZcHE1jNOpH7M1mAwFM_hbION/view?usp=sharing The Department of Students' Development, Dr...
Promo for Two-Day National Webinar on Introduction to the Basics of Seventh Edition APA Style
มุมมอง 4774 ปีที่แล้ว
DAY 1 (Fri, 27th Nov 2020): th-cam.com/video/jtkN1R96B9g/w-d-xo.html DAY 2 (Sat, 28th Nov 2020): th-cam.com/video/5rCy1fGxfKU/w-d-xo.html SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat Please feel free to share the session links with your friends, colleagues, and students. Dear Sir/Madam, Greetings from Dr. Homi Bhabha State University and Elphinstone College, Mumbai! The Department ...
Item Analysis using Excel and SPSS (Item Discrimination and Corrected Item-total Correlation Method)
มุมมอง 33K4 ปีที่แล้ว
How to perform item analysis using MS Excel and SPSS. SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat This video demonstrates how to carry out item analysis using MS Excel and SPSS. It includes item discrimination for dichotomous scale data, item discrimination for Likert scale data, and corrected item-total correlation method. Item analysis refers to statistical methods used for sele...
Split-Half Reliability using Excel and SPSS (Spearman-Brown Prophecy Coefficient)
มุมมอง 22K4 ปีที่แล้ว
How to compute Split-Half Reliability using Excel and SPSS SUBSCRIBE to my channel: th-cam.com/users/shivanandthorat 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 t...
Thanks
Glad it helped!
this is very helpful, thank u
Glad it was helpful!
Thank you very much ❤
Thank you so much sir.
Thanks for watching
Very well explained 🎉 Thanks
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.
How to select the criteria to discriminate the items ..to select or reject any items
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.
Sir pls share pdf for likert scale
Which pdf you want?
Sir can you pls share in any pdf of this.pls.if yousay yes then i can share my email id
good job bhaiyaaa and thanku so much
How to chwck for large data ? I jave a sample soze of 1078
By the same method no matter how large is the sample, method remains the same
Very well explained 👍
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
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
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
Hi, can you explain why you chops alpha 0.05?
I chop p value at 0.05, not alpha. p value is probability of error
very well explained. Thank you. Found this video very helpful.
Thank you!
🙏👍
Please upload how to perform chi square test using excel
Alright. Will make one in the near future
Bro can you demonstrate a 10 company profile data and 5 variables with a 10 year data
It can be done using the similar method. Just columns in your datasheet will be more
can u send output
It is a hypothetical data. You may use real data
How to calculate reliability index test using split half methods if given 8 items and total score in percentage
Thank you for the explanation sir💜💜
Glad it helped
Thank you very much sir for your deepest guidance in the item analysis.
You didn’t compare the two
Which two?
thanks idol, bisita ka dito minsan samen. pameryenda ako
Could you please write in English?
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
Go ahead. No need to delete items as values are just slightly above 0.8
Good one. Thanks mate🙌🏻
Thank you so much sir....very helpful and informative video....i learn many more new things 🙏
Thank you!!!
Very much useful !!
Not useful when you have thousands of outliers, excel needs to create a feature where you can just click to remove outliers.
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.
Thank You so much sir 😍Subscribed!
please I have 4 points Likert scale I divided the ID by 3?
Yes
Thanku so much n god bless u
Thanks for watching
CAN YOU PLEASE TEACH HOW TO CALCULATE CRONBACH APLHA ON EXCEL
I will upload a video on that, but as of now you can watch video of any other creator. It is easy to calculate
Tis is one of the best statistical explanation I have seen so far ! Thank you so much
HOW TO MAKE THE BELL CURVE NOW FROM HERE ONWARDS
I will cover that in a separate video. But there are screen cast videos available on TH-cam.
will the outliers cause a flawed normal distribution curve?
Yes. And outliers can also deviate mean and standard deviation resulting in an erroneous inference.
Thanks, Mr Thorat!😀
How to use this for descriptive questions or numerical problem teat
For numerical problem, you can use item difficulty index
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
If the sample size is 125 what will be the number of upper and lower respondent?
27% of 125 is 33.75. You can take 34 respondents in upper and 34 respondents in lower group.
Thank you so much🙏💐
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.
👍👍👍
Very helpful!
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?
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
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?
Yes. Corrected item total correlation can be applied. No idea about the book. I haven't referred it so far. Thanks for watching
@@ShivanandThorat thank you for the prompt response sir. Can I mail you if I face any further problem regarding the same?
@@vandanadaksh6619 sure. shivanandthorat.yt@gmail.com
Pls. Explain quartiles in excel
Please watch this video: th-cam.com/video/2BoubhXcj6Q/w-d-xo.html
You explain very nicely
Thanks
it says "my input range contains non-numeric values." when I try to use data analysis tool
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.
Thank you for your useful video , could you please fully explain Data analytics tool in Excel
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.
lots of thanks......you provided very useful and benefial ways of odd even split half method which no any tutorial taught....
I am glad it helped you. Thank you for watching, subscribe the channel if you find content helpful