Shivanand Thorat
Shivanand Thorat
  • Видео 12
  • Просмотров 118 783
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: ruclips.net/user/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: ruclips.net/video/z15_PUyNZ3M/видео.html
The second episode demonstrates how to compute descriptive statistics in Microsoft Excel.
Link for the second episode: ruclips.net/video/24Ar1yhfkBc/видео.html
The third episode elaborates on the descriptive statis...
Просмотров: 12 463

Видео

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: ruclips.net/user/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: ruclips.net/user/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: ruclips.net/user/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: ruclips.net/user/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: ruclips.net/user/shivanandthorat Day 1 Session: ruclips.net/video/jtkN1R96B9g/видео.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
Просмотров 5 тыс.3 года назад
Changes in the Seventh Edition APA Style 2020. (National Webinar: DAY 1) SUBSCRIBE to my channel: ruclips.net/user/shivanandthorat Link for DAY 2 Session: ruclips.net/video/5rCy1fGxfKU/видео.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): ruclips.net/video/jtkN1R96B9g/видео.html DAY 2 (Sat, 28th Nov 2020): ruclips.net/video/5rCy1fGxfKU/видео.html SUBSCRIBE to my channel: ruclips.net/user/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)
Просмотров 31 тыс.4 года назад
How to perform item analysis using MS Excel and SPSS. SUBSCRIBE to my channel: ruclips.net/user/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: ruclips.net/user/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...

Комментарии

  • @abdulsameerkhan5465
    @abdulsameerkhan5465 4 дня назад

    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 2 месяца назад

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

    • @abdulsameerkhan5465
      @abdulsameerkhan5465 4 дня назад

      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 4 месяца назад

    good job bhaiyaaa and thanku so much

  • @madhurimagiridharan9590
    @madhurimagiridharan9590 6 месяцев назад

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

    • @ShivanandThorat
      @ShivanandThorat 5 месяцев назад

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

  • @syedasameezahra6498
    @syedasameezahra6498 8 месяцев назад

    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 8 месяцев назад

      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 10 месяцев назад

    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 11 месяцев назад

    Hi, can you explain why you chops alpha 0.05?

    • @ShivanandThorat
      @ShivanandThorat 8 месяцев назад

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

  • @amritapal2
    @amritapal2 11 месяцев назад

    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 5 месяцев назад

      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 5 месяцев назад

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

  • @mayurj1934
    @mayurj1934 Год назад

    can u send output

    • @ShivanandThorat
      @ShivanandThorat 5 месяцев назад

      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 Год назад

    Thanku so much n god bless u

  • @ramneek4344
    @ramneek4344 2 года назад

    CAN YOU PLEASE TEACH HOW TO CALCULATE CRONBACH APLHA ON EXCEL

    • @ShivanandThorat
      @ShivanandThorat 5 месяцев назад

      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 RUclips.

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

  • @rbinsights2682
    @rbinsights2682 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: ruclips.net/video/2BoubhXcj6Q/видео.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

  • @jayasingh1407
    @jayasingh1407 2 года назад

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

    • @ShivanandThorat
      @ShivanandThorat 2 года назад

      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 2 года назад

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

    • @ShivanandThorat
      @ShivanandThorat 2 года назад

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