HOW TO ORGANIZE AND INTERPRET LIKERT SCALE RESULT IN EXCEL

Поделиться
HTML-код
  • Опубликовано: 3 июн 2021
  • #research #statistics #likertscale #quantitativeresearch
  • НаукаНаука

Комментарии • 93

  • @ronaacharon2614
    @ronaacharon2614 7 месяцев назад +1

    Ma'am maraming maraming salamat po dito sa inyong explanation. Ako po ay isang grad student nag-aaral sa ibang bansa at hirap na hirap akong intindihin ang mga explanations in high-falluting words. Salamat po at may God bless you continuously with good health and more blessings po. Salamat po ulit Ma'am.

  • @teachershy267
    @teachershy267 Год назад +1

    Learned a lot on this video. Maraming salamat Dr. Tess! God bless you!

  • @adrianreyp.maderal4425
    @adrianreyp.maderal4425 2 года назад +1

    one of the best teacher

  • @MohamedIbrahimEid
    @MohamedIbrahimEid 3 года назад +2

    Thank you so much, you have illustrated very precisely.

  • @rolizagwenmagnawa6973
    @rolizagwenmagnawa6973 2 года назад +1

    Thank you so much for this vid :) :)

  • @joanjimenez4125
    @joanjimenez4125 3 года назад +3

    Thank you so much po ma'am!

  • @nationaltv3308
    @nationaltv3308 3 года назад +1

    Can you do a example using a mini tab?

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

    Ma'am, ano po yung formula na nilagay nyo diyan sa blue cell, yung sa dulo ng Mean per respondent at mean per question/item.

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

    pwede rin po ba ito sa pearson r?

  • @markjohnbaseemia1120
    @markjohnbaseemia1120 2 года назад +1

    Ma'am Can I ask po, what's the formula of highlighted cell color blue? Thank You poo

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

    hello po maam pano po iinterpret pag ang gagamitin na scale is median ?

  • @wendycabangon217
    @wendycabangon217 3 года назад

    mam may part 2 na po ba? need ko po kasi sa action research ko po.salanat po ng marami,,napakadaling intindihin po

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      Eto po: ruclips.net/video/LkHlJszlEoU/видео.html

  • @reiyaaaaa
    @reiyaaaaa 3 года назад

    I would like to ask po if the verbal interpretation always applies in the use of likert scale? What if po yung mean/s are generated from spss? Kailangan pa din po ba nun?
    -We use Likert scale for our questionnaire po, then we perform the descriptive stats (mean and SD lang po kinuha namin) on SPSS.

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      Im sorry I don’t understand what you mean. Can you clarify it further.

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

    Hello po! Okay lang po bang kunin yung total percentage coming from the answer of the respondents if I used descriptive quantitative method

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

    Hello maam, Can I ask if what statistical treatments is better to use for our study? This is our title "POLITICAL INVOLVEMENT AND CONSCIOUSNESS OF SAN ISIDRO COLLEGE FOURTH-YEAR STUDENTS" and this is our SOP
    1. What is the level of political involvement among San Isidro College Fourth-Year Students in terms of:
    a. Political Campaigning
    b. Voting; and
    c. Political Activism?
    2. What is the level of political consciousness among San Isidro College Fourth-Year Students in terms of:
    a. Political Leaders
    b. Political Parties
    c. Public Policies; and
    d. Political Issues?
    3. What is the significant relationship between political awareness and political involvement among San Isidro College Fourth-Year Students?
    Thank you poooo in adv

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

      SOP 1 and 2. Use likert scale on this.
      SOP 3 - Pearson r may be used

  • @dexterabad3196
    @dexterabad3196 3 года назад

    Hi, Ma'am! Thank you for sharing this video with us. I have a question po. Did you personally change po ba yong likert scale value (i. e. From (4) strongly agree to (4) high quality) to easily interpret the data? thank you po.

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад +2

      The points or values in the options will depend on the researcher as long as you are consistent with it.

    • @dexterabad3196
      @dexterabad3196 3 года назад

      @@sciencewithdrtess Got it. Thank you so much

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

    Hi ma'am thank you so much po for this informative video! Question lang po pwede po bang gamitin ang Likert Scale sa qualitative research and pa'no po interpret ang data kapag ganon?

    • @sciencewithdrtess
      @sciencewithdrtess  2 года назад +1

      Di po. Qualitative research questions must be open ended.

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

      Thank u po ma'am! 🥰

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

    Hello po. Can we use the same measurement po used in the survey sa mismong interpretation na po?

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

      Please clarify. I don’t understand what you’re saying.

  • @yvonnedomantay7481
    @yvonnedomantay7481 3 года назад

    good day ma'am! why are we not using median to interpret likert scale results?

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      Because mean is better. You can treat likert scale results like they’re continuous data.

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

    Hi maam ask ko lng po if pwede po ang likert scale sa qualitative?

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

      Hindi po. Only in quantitative research ang likert scale.

  • @abbyfloresita
    @abbyfloresita 3 года назад

    THANK YOUUUUU

  • @BitteranangBitter
    @BitteranangBitter 3 года назад

    Paano po kapag 50 respondents? Kailangang isa-isahin din iyong response ng respondents po? Thank you pala for this clear explanation. I hope you'll answer my question po.

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      Yes. Iisaisahin mo yan iienter sa excel. Kaya nga mas maganda, habang naghihintay na maisa uli sa iyo yung questionnaire. Magprepare ka na ng template sa excel. Tapos everytime may magsa uli ng questionnaire. Enter mo agad para di ka matambakan.

    • @schooldocuments4454
      @schooldocuments4454 3 года назад

      google forms ka sana

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

    Hi ma'am! May question lang po ako if gagana po ito sa ms excel? If automatic po sya mag ge-generate ng mean or dapat talaga is google excel? Thank u po in advance💗

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

      Hi. Pwd din po sya sa excel pero may pagkakaiba ng konti sa commands. Formula for sum and mean are the same

  • @schooldocuments4454
    @schooldocuments4454 3 года назад

    hindi na po ba need kunin yung standard deviation? if need pa po, anong formula ng sd po dapat gamitin?

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      It depends on the focus of your study but in most research, it’s not needed anymore.

    • @schooldocuments4454
      @schooldocuments4454 3 года назад

      @@sciencewithdrtess THANK YOU PO!!

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

    hi maam ask ko lang po kung pano nyo po nakuha yung mga number sa online? yung nasa 12:43

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

      through likert scale questionnaire na binigay sa respondents via google form.

  • @allanabejuela6960
    @allanabejuela6960 3 года назад +1

    This is too much ma'am😣 ty

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

    Ma'am, di ba po ordinal data po yan? Pero it can be treated as interval since may corresponding points po na binibigay ang researcher, tama po ba? At hindi nyo po kinuha ang SD. What if po n > 30 po? Di ba po required po sa z-test ang SD?
    Thank you po. Sana po mabasa nyo po ito 🙏

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

      Yes. I did not get the SD because it was not required.

  • @wendycabangon217
    @wendycabangon217 3 года назад

    mam can I ask po,what statistical test po kaya ang applicable if I have to test the relationship between age and the perception of the students towards the virtual flipped classroom approach? thank you so much po

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      May I know your SOPs.

    • @wendycabangon217
      @wendycabangon217 3 года назад

      @@sciencewithdrtess
      1. How may the students’ profile be described in terms of:
      a. Age
      b. Gender
      c. General weighted average?
      2.Is there a significant difference between the perception of the students across
      a. Age
      b. Gender
      c. General weighted average?
      3. Is there a significant relationship between the profile variables of the students and their attitude and perspective towards the virtual flipped classroom approach?
      Medyu naconfuse po kc ako ng konti,thanks po.

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      For SOP 2. Student perception on what? Are you referring to virtual flipped classroom approach? It would be good if you can include this in the statement.
      For SOP 2,
      in terms of age, how many age groups? If there are only 2, you can use t-test more than 2, use ANOVA
      In terms of gender since may 2 genders lang naman, male and female. Use ttest
      In terms of weighted average ( I am assuming these are the grades of students). How many categories? More than 2 categories, use ANOVA
      Redundant na po SOP 3
      SOP 3. You can scrap this. Because the result of your SOP 2 will already be enough to give you the relationship of each profiles
      Ex. What is the relationship of gender on the ….
      Sa result ng t test makikita mo kung may significant difference ba talaga ang gender o wala.

    • @wendycabangon217
      @wendycabangon217 3 года назад

      @@sciencewithdrtess thanks so much mam,,bale mam pwede ko n po pala idelete si SOP 3? No need na po na mag correlation analysis,,thanks so much mam, i love ur tutorials po..
      I am a science major din po pala..

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      Yes po. Pwd na. Bale 2 SOPs na lang. Very nice. Pareho tayong science major 👍😊

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

    Bakit po may pron sa downloads nyo huhu

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

    Ma'am, may I ask lng po If pwede Ang likert scale gamitin sa dalawang group (experimental and control group) sa pag determine Ng acceptability in terms of odor, taste, texture Ng product?

    • @sciencewithdrtess
      @sciencewithdrtess  Год назад +1

      Puwede

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

      @@sciencewithdrtess for example po itetest Yung herbal mouthwash and commercialized mouthwash in terms of taste, pano po iaassign Yung control group and experimental group as Respondents?

  • @schooldocuments4454
    @schooldocuments4454 3 года назад

    sabi po sa review center namin, u cannot get the mean of the means po.

    • @sciencewithdrtess
      @sciencewithdrtess  3 года назад

      Ah gets ko na yung ibig sabihin ng review center nyo. Yung ginawa ko sa video short cut (getting the mean of means). This is possible if each category has similar number of questions like my example. Pero kung magkaka iba yung number of questions in each category. Choose the long method. Kunin mo means from your raw data.

    • @schooldocuments4454
      @schooldocuments4454 3 года назад

      @@sciencewithdrtess opo, ito po hehe. thank you ulit po!!

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

    good afternoon maam how about effectiveness and effeiciency how do write the interpretation based on experience

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

      What do you mean? Sorry, your question is a bit vague.
      Interpretation will be based from the statistical result of your data.

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

      @@sciencewithdrtess sorry maam, ahhh i mean how about yung effectivness and efficiency. Tapos these two variables have sub variable t test lang po gagamitin kasi po, traditional and online recruitment po i compare namin. Which are Effectiveness and efficiency for traditional; and effectiveness and efficiency for online recruitment

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

      If it is comparison and you have 2 variables to compare you use t test. More than 2, you use ANOVA

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

    Ma'am panu po Ang analysis sa likert scale? Anu po gagamitin

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

      Diniscuss nya sa video. You can also browse my channel kasi meron pa akong video discussing how to analyze likert scale. Pls also check it.

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

    Hello! How to get the overall mean po?

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

    Hi, Maam question lang po is it okay po ba na gawin kong per strand na yong sa respondents?

    • @sciencewithdrtess
      @sciencewithdrtess  2 года назад +1

      Puwede. Ang pag organize sa excel / gsheet ay depende na sa researcher. In this video, this is just a sample

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

      @@sciencewithdrtess paano po yon sa mean aabot po kasi nya ng 30+ paano ko po yon maiinterpret?

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

      @@mz6953 for the interpretation and how to create range. Pls check thisruclips.net/video/0CSYFmSKWOk/видео.html

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

    In which literature can this method be found?

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

      A lot. Just google search - “how to analyze likert scale data”

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

      @@sciencewithdrtess Could you please mention one? I don't find any literature that shows the analysis based on the range that you calculated

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

      1. sciencing.com/average-likert-scales-6181662.html
      2. www.ombea.com/gb/resources/articles/5-point-likert-scale-the-key-to-easily-understanding-your-audience
      3. statisticsbyjim.com/hypothesis-testing/analyze-likert-scale-data/

  • @ma.angelikacasimiro7779
    @ma.angelikacasimiro7779 2 года назад

    Ma'am can I ask a statistical tool po na appropriate sa study po namin?

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

      Ano po yung research title at SOPs ninyo?

    • @ma.angelikacasimiro7779
      @ma.angelikacasimiro7779 2 года назад

      @@sciencewithdrtess
      Ito po yung title po ng research namin, "Analysis of Student's Vocabulary Learning Strategies According to their Profile: Basis for Proposed Specialized Learning Website"
      Ito naman po ang SOPs po namin:
      1. What is the Student's Profile in terms of the following:
      1.1 Age;
      1.2 sex; and,
      1.3 section
      2. What strategies are used in enriching vocabulary learning in terms of:
      2.1 beliefs about vocabulary learning;
      2.2 metacognition regulation;
      2.3 cognitive strategies;
      2.4 activation strategies; and
      2.5 memory strategies
      3. Is there are significant difference in the assessment of the students' vocabulary learning strategies when grouped according to their profile?
      Ayan po Ma'am.

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

      SOP 2 - paano kayo magde data gathering nito? Are you going to let them rank the strategies? Or sa questionnaire nyo may yes or no option?

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

      SOP 3 - significant difference. Are you going to compare the different strategies? Then correlate the result in the profile? O iisa isahin ninyong kukunin ang correlation?
      Ex.
      Strategy 1 to age
      Strategy 1 to gender
      Etc?
      Ganito ba gagawin nyo?

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

    Hello poooo. Thank you po sa tutorial napakadaling unawain. May tanong lang po ako kung baka po meron kayong reliable source ng 4 point likert scale na presented po dito.
    I've been struggling to find a 4 point likert scale na may interval na 0.75. pagnilalagay ko po yung difference palaging nagexceed. Ang ginagawa ko po kasi
    1 - 1.75 = 0.75
    1.76 - 2.50 = 0.74
    2.51 - 3.25 = 0.74
    3.26 - 4.00 = 0.74

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

      You’re doing it wrong. If the first interval is 1-1.75, the next interval is NOT 1.76. Its >1.75-2.5.And then the next interval is not 2.51. It should start with greater than 2.5. What if the value is 2.505? Under your scheme, 2.505 doesn’t fall into any of them.

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

    Maam what is purpose po why there is interpretation per qyestion?