HOW TO ORGANIZE AND INTERPRET LIKERT SCALE RESULT IN EXCEL

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ส.ค. 2024

ความคิดเห็น • 93

  • @ronaacharon2614
    @ronaacharon2614 8 หลายเดือนก่อน +2

    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

  • @joanjimenez4125
    @joanjimenez4125 3 ปีที่แล้ว +3

    Thank you so much po ma'am!

  • @MohamedIbrahimEid
    @MohamedIbrahimEid 3 ปีที่แล้ว +2

    Thank you so much, you have illustrated very precisely.

  • @rolizagwenmagnawa6973
    @rolizagwenmagnawa6973 2 ปีที่แล้ว +1

    Thank you so much for this vid :) :)

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

  • @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: th-cam.com/video/LkHlJszlEoU/w-d-xo.html

  • @markjohnbaseemia1120
    @markjohnbaseemia1120 2 ปีที่แล้ว +1

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

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

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

  • @emmalynoliva3763
    @emmalynoliva3763 2 ปีที่แล้ว

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

  • @ainmartinez8186
    @ainmartinez8186 ปีที่แล้ว

    pwede rin po ba ito sa pearson r?

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

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

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

  • @alexandramaedoblon297
    @alexandramaedoblon297 2 ปีที่แล้ว

    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  2 ปีที่แล้ว

      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.

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

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

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

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

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

  • @chellseadownarong1675
    @chellseadownarong1675 ปีที่แล้ว

    Hello! How to get the overall mean po?

  • @AndreChan0921
    @AndreChan0921 ปีที่แล้ว

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

    • @sciencewithdrtess
      @sciencewithdrtess  ปีที่แล้ว

      You mean the SOPs?
      Or per item in the questionnaire?

    • @AndreChan0921
      @AndreChan0921 ปีที่แล้ว

      @@sciencewithdrtess per question po maam

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

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

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

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

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

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

  • @AndreChan0921
    @AndreChan0921 2 ปีที่แล้ว

    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

  • @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 thisth-cam.com/video/0CSYFmSKWOk/w-d-xo.html

  • @htmlnica
    @htmlnica ปีที่แล้ว

    Bakit po may pron sa downloads nyo huhu

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

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

  • @allanabejuela6960
    @allanabejuela6960 3 ปีที่แล้ว +1

    This is too much ma'am😣 ty

  • @ma.angelikacasimiro7779
    @ma.angelikacasimiro7779 3 ปีที่แล้ว

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

    • @sciencewithdrtess
      @sciencewithdrtess  3 ปีที่แล้ว

      Ano po yung research title at SOPs ninyo?

    • @ma.angelikacasimiro7779
      @ma.angelikacasimiro7779 3 ปีที่แล้ว

      @@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  3 ปีที่แล้ว

      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  3 ปีที่แล้ว

      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?

  • @abbyfloresita
    @abbyfloresita 3 ปีที่แล้ว

    THANK YOUUUUU