Shivanand Thorat
Shivanand Thorat
  • 12
  • 119 915
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: ua-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: ua-cam.com/video/z15_PUyNZ3M/v-deo.html
The second episode demonstrates how to compute descriptive statistics in Microsoft Excel.
Link for the second episode: ua-cam.com/video/24Ar1yhfkBc/v-deo.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: ua-cam.com/video/2BoubhXcj6Q/v-deo.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: ua-cam.com/video/1Y7Y7m6bZSs/v-deo.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
Переглядів: 12 806

Відео

How to Remove Outliers Using Excel: Boxplot Method in Excel (Interquartile Range/IQR Method)
Переглядів 10 тис.3 роки тому
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: ua-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
Переглядів 22 тис.3 роки тому
Descriptive Statistics Explained in 8 minutes | Data Analysis Using Excel Series E03 SUBSCRIBE to my channel: ua-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,5 тис.3 роки тому
Calculating descriptive statistics in Microsoft Excel. SUBSCRIBE to my channel: ua-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,7 тис.3 роки тому
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: ua-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,7 тис.3 роки тому
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: ua-cam.com/users/shivanandthorat Day 1 Session: ua-cam.com/video/jtkN1R96B9g/v-deo.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 shortc...
APA 6th Edition vs APA 7th Edition: Changes in the 7th Edition APA Style
Переглядів 5 тис.3 роки тому
Changes in the Seventh Edition APA Style 2020. (National Webinar: DAY 1) SUBSCRIBE to my channel: ua-cam.com/users/shivanandthorat Link for DAY 2 Session: ua-cam.com/video/5rCy1fGxfKU/v-deo.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
Переглядів 4713 роки тому
DAY 1 (Fri, 27th Nov 2020): ua-cam.com/video/jtkN1R96B9g/v-deo.html DAY 2 (Sat, 28th Nov 2020): ua-cam.com/video/5rCy1fGxfKU/v-deo.html SUBSCRIBE to my channel: ua-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 of...
Item Analysis using Excel and SPSS (Item Discrimination and Corrected Item-total Correlation Method)
Переглядів 31 тис.4 роки тому
How to perform item analysis using MS Excel and SPSS. SUBSCRIBE to my channel: ua-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)
Переглядів 21 тис.4 роки тому
How to compute Split-Half Reliability using Excel and SPSS SUBSCRIBE to my channel: ua-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...

КОМЕНТАРІ

  • @subodhkumarsuman5509
    @subodhkumarsuman5509 18 днів тому

    Thank you so much sir.

  • @ivanjohn3742
    @ivanjohn3742 20 днів тому

    Very well explained 🎉 Thanks

  • @abdulsameerkhan5465
    @abdulsameerkhan5465 28 днів тому

    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 3 місяці тому

    How to select the criteria to discriminate the items ..to select or reject any items

    • @abdulsameerkhan5465
      @abdulsameerkhan5465 28 днів тому

      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 4 місяці тому

    Sir pls share pdf for likert scale

  • @shivangitiwari9777
    @shivangitiwari9777 4 місяці тому

    Sir can you pls share in any pdf of this.pls.if yousay yes then i can share my email id

  • @priyankasahu1111
    @priyankasahu1111 5 місяців тому

    good job bhaiyaaa and thanku so much

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

    How to chwck for large data ? I jave a sample soze of 1078

    • @ShivanandThorat
      @ShivanandThorat 6 місяців тому

      By the same method no matter how large is the sample, method remains the same

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

    Very well explained 👍

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

    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 9 місяців тому

      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 11 місяців тому

    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 9 місяців тому

      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.

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

    🙏👍

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

    Please upload how to perform chi square test using excel

    • @ShivanandThorat
      @ShivanandThorat 6 місяців тому

      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 6 місяців тому

      It can be done using the similar method. Just columns in your datasheet will be more

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

    can u send output

    • @ShivanandThorat
      @ShivanandThorat 6 місяців тому

      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💜💜

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

    Thank you very much sir for your deepest guidance in the item analysis.

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

    You didn’t compare the two

  • @TrishaLuna-ml7dl
    @TrishaLuna-ml7dl Рік тому

    thanks idol, bisita ka dito minsan samen. pameryenda ako

  • @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 Рік тому

    Thank you so much sir....very helpful and informative video....i learn many more new things 🙏

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

    Thank you!!!

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

    Very much useful !!

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

    Not useful when you have thousands of outliers, excel needs to create a feature where you can just click to remove outliers.

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

      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 Рік тому

    Thank You so much sir 😍Subscribed!

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

    please I have 4 points Likert scale I divided the ID by 3?

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

    Thanku so much n god bless u

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

    CAN YOU PLEASE TEACH HOW TO CALCULATE CRONBACH APLHA ON EXCEL

    • @ShivanandThorat
      @ShivanandThorat 6 місяців тому

      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 UA-cam.

  • @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!

  • @rbinsights777
    @rbinsights777 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. shivanandthorat.yt@gmail.com

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

    Pls. Explain quartiles in excel

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

      Please watch this video: ua-cam.com/video/2BoubhXcj6Q/v-deo.html

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

    You explain very nicely

  • @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

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

    Sir, please tell how to calculate t test for every item in 5 pt. Likert scale