Shivanand Thorat
Shivanand Thorat
  • 12
  • 118 651
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: czcams.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: czcams.com/video/z15_PUyNZ3M/video.html
The second episode demonstrates how to compute descriptive statistics in Microsoft Excel.
Link for the second episode: czcams.com/video/24Ar1yhfkBc/video.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: czcams.com/video/2BoubhXcj6Q/video.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: czcams.com/video/1Y7Y7m6bZSs/video.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
zhlédnutí: 12 432

Video

How to Remove Outliers Using Excel: Boxplot Method in Excel (Interquartile Range/IQR Method)
zhlédnutí 10KPřed 3 lety
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: czcams.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
zhlédnutí 22KPřed 3 lety
Descriptive Statistics Explained in 8 minutes | Data Analysis Using Excel Series E03 SUBSCRIBE to my channel: czcams.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
zhlédnutí 1,5KPřed 3 lety
Calculating descriptive statistics in Microsoft Excel. SUBSCRIBE to my channel: czcams.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
zhlédnutí 1,7KPřed 3 lety
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: czcams.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
zhlédnutí 3,7KPřed 3 lety
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: czcams.com/users/shivanandthorat Day 1 Session: czcams.com/video/jtkN1R96B9g/video.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
zhlédnutí 5KPřed 3 lety
Changes in the Seventh Edition APA Style 2020. (National Webinar: DAY 1) SUBSCRIBE to my channel: czcams.com/users/shivanandthorat Link for DAY 2 Session: czcams.com/video/5rCy1fGxfKU/video.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
zhlédnutí 471Před 3 lety
DAY 1 (Fri, 27th Nov 2020): czcams.com/video/jtkN1R96B9g/video.html DAY 2 (Sat, 28th Nov 2020): czcams.com/video/5rCy1fGxfKU/video.html SUBSCRIBE to my channel: czcams.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)
zhlédnutí 31KPřed 4 lety
How to perform item analysis using MS Excel and SPSS. SUBSCRIBE to my channel: czcams.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)
zhlédnutí 21KPřed 4 lety
How to compute Split-Half Reliability using Excel and SPSS SUBSCRIBE to my channel: czcams.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...

Komentáře

  • @abdulsameerkhan5465
    @abdulsameerkhan5465 Před 22 hodinami

    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 Před 2 měsíci

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

    • @abdulsameerkhan5465
      @abdulsameerkhan5465 Před 22 hodinami

      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 Před 3 měsíci

    Sir pls share pdf for likert scale

  • @shivangitiwari9777
    @shivangitiwari9777 Před 3 měsíci

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

  • @priyankasahu1111
    @priyankasahu1111 Před 4 měsíci

    good job bhaiyaaa and thanku so much

  • @madhurimagiridharan9590
    @madhurimagiridharan9590 Před 6 měsíci

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

    • @ShivanandThorat
      @ShivanandThorat Před 5 měsíci

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

  • @syedasameezahra6498
    @syedasameezahra6498 Před 8 měsíci

    Very well explained 👍

  • @badiosogenyl4948
    @badiosogenyl4948 Před 8 měsíci

    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 Před 8 měsíci

      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 Před 10 měsíci

    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 Před 11 měsíci

    Hi, can you explain why you chops alpha 0.05?

    • @ShivanandThorat
      @ShivanandThorat Před 8 měsíci

      I chop p value at 0.05, not alpha. p value is probability of error

  • @amritapal2
    @amritapal2 Před 11 měsíci

    very well explained. Thank you. Found this video very helpful.

  • @darshikasp5901
    @darshikasp5901 Před rokem

    🙏👍

  • @panda_whisper_tales

    Please upload how to perform chi square test using excel

  • @keralafury7478
    @keralafury7478 Před rokem

    Bro can you demonstrate a 10 company profile data and 5 variables with a 10 year data

    • @ShivanandThorat
      @ShivanandThorat Před 5 měsíci

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

  • @mayurj1934
    @mayurj1934 Před rokem

    can u send output

    • @ShivanandThorat
      @ShivanandThorat Před 5 měsíci

      It is a hypothetical data. You may use real data

  • @TadalaMagelegele
    @TadalaMagelegele Před rokem

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

  • @user-hm7cf3ns2u
    @user-hm7cf3ns2u Před rokem

    Thank you for the explanation sir💜💜

  • @sangitaholmukhe2958

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

  • @kit9wana
    @kit9wana Před rokem

    You didn’t compare the two

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

    thanks idol, bisita ka dito minsan samen. pameryenda ako

  • @shameemashaban8257
    @shameemashaban8257 Před rokem

    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 Před rokem

      Go ahead. No need to delete items as values are just slightly above 0.8

  • @Leomessii99
    @Leomessii99 Před rokem

    Good one. Thanks mate🙌🏻

  • @khusikumari250
    @khusikumari250 Před rokem

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

  • @luisfevel
    @luisfevel Před rokem

    Thank you!!!

  • @renuguhadevi7877
    @renuguhadevi7877 Před rokem

    Very much useful !!

  • @NobixLee
    @NobixLee Před rokem

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

    • @ShivanandThorat
      @ShivanandThorat Před rokem

      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 Před rokem

    Thank You so much sir 😍Subscribed!

  • @farahelhouari2411
    @farahelhouari2411 Před rokem

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

  • @preetisharma9064
    @preetisharma9064 Před rokem

    Thanku so much n god bless u

  • @ramneek4344
    @ramneek4344 Před rokem

    CAN YOU PLEASE TEACH HOW TO CALCULATE CRONBACH APLHA ON EXCEL

    • @ShivanandThorat
      @ShivanandThorat Před 5 měsíci

      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 Před 2 lety

    Tis is one of the best statistical explanation I have seen so far ! Thank you so much

  • @ramneek4344
    @ramneek4344 Před 2 lety

    HOW TO MAKE THE BELL CURVE NOW FROM HERE ONWARDS

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      I will cover that in a separate video. But there are screen cast videos available on CZcams.

  • @ramneek4344
    @ramneek4344 Před 2 lety

    will the outliers cause a flawed normal distribution curve?

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      Yes. And outliers can also deviate mean and standard deviation resulting in an erroneous inference.

  • @evansthabethe
    @evansthabethe Před 2 lety

    Thanks, Mr Thorat!😀

  • @jamilamir3449
    @jamilamir3449 Před 2 lety

    How to use this for descriptive questions or numerical problem teat

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      For numerical problem, you can use item difficulty index

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      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 Před 2 lety

    If the sample size is 125 what will be the number of upper and lower respondent?

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      27% of 125 is 33.75. You can take 34 respondents in upper and 34 respondents in lower group.

    • @prernamukhia6965
      @prernamukhia6965 Před 2 lety

      Thank you so much🙏💐

    • @sangitaholmukhe2958
      @sangitaholmukhe2958 Před rokem

      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 Před 2 lety

    👍👍👍

  • @researchramp436
    @researchramp436 Před 2 lety

    Very helpful!

  • @rbinsights2682
    @rbinsights2682 Před 2 lety

    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 Před 2 lety

      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 Před 2 lety

    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 Před 2 lety

      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 Před 2 lety

      @@ShivanandThorat thank you for the prompt response sir. Can I mail you if I face any further problem regarding the same?

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      @@vandanadaksh6619 sure. shivanandthorat.yt@gmail.com

  • @KAadhya
    @KAadhya Před 2 lety

    Pls. Explain quartiles in excel

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      Please watch this video: czcams.com/video/2BoubhXcj6Q/video.html

  • @KAadhya
    @KAadhya Před 2 lety

    You explain very nicely

  • @MattGarcyaDC
    @MattGarcyaDC Před 2 lety

    it says "my input range contains non-numeric values." when I try to use data analysis tool

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      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 Před 2 lety

    Thank you for your useful video , could you please fully explain Data analytics tool in Excel

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      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 Před 2 lety

    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

  • @riyachhabra4915
    @riyachhabra4915 Před 2 lety

    Thanku so much sir

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

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

  • @SatishJadhav-rr1oq
    @SatishJadhav-rr1oq Před 2 lety

    Thank u sir nice video

  • @rashmisrivastava4003
    @rashmisrivastava4003 Před 2 lety

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

  • @jayasingh1407
    @jayasingh1407 Před 2 lety

    Also I wanted to know do you give classes any other mode rather than CZcams I wanted to join

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      No ma'am, I don't. But you can have my email id where you can mail your queries shivanandthorat.yt@gmail.com

  • @jayasingh5156
    @jayasingh5156 Před 2 lety

    sir plz take a class about what is a dichotomous data, when to use biserial corelation and point biserial corelation

    • @ShivanandThorat
      @ShivanandThorat Před 2 lety

      Sure. I will try to cover that in my upcoming videos. Consider subscribing the channel for more. Thanks for watching