HOW TO ORGANIZE AND INTERPRET LIKERT SCALE RESULT IN EXCEL

[@ronaacharon2614]

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.

[@sciencewithdrtess]

Welcome po.

[@teachershy267]

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

[@sciencewithdrtess]

Welcome

[@adrianreyp.maderal4425]

one of the best teacher

[@sciencewithdrtess]

Thank you

[@joanjimenez4125]

Thank you so much po ma'am!

[@sciencewithdrtess]

Welcome

[@rolizagwenmagnawa6973]

Thank you so much for this vid :) :)

[@sciencewithdrtess]

Welcome

[@MohamedIbrahimEid]

Thank you so much, you have illustrated very precisely.

[@sciencewithdrtess]

Welcome

[@nationaltv3308]

Can you do a example using a mini tab?

[@markjohnbaseemia1120]

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

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

[@schooldocuments4454]

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

[@sciencewithdrtess]

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]

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

[@AndreChan0921]

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

[@sciencewithdrtess]

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

[@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]

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

[@yvonnedomantay7481]

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

[@sciencewithdrtess]

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

[@trishaagraam6284]

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

[@sciencewithdrtess]

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

[@cinnamonrollz7152]

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

[@sciencewithdrtess]

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

[@captaindoge9213]

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]

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

[@reiyaaaaa]

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]

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

[@mariangutierrezrosales7088]

In which literature can this method be found?

[@sciencewithdrtess]

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

[@mariangutierrezrosales7088]

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

[@sciencewithdrtess]

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/

[@leangelamiranda3624]

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

[@sciencewithdrtess]

What is your SOP?

[@ainmartinez8186]

pwede rin po ba ito sa pearson r?

[@AndreChan0921]

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

[@sciencewithdrtess]

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

[@AndreChan0921]

@@sciencewithdrtess per question po maam

[@emmalynoliva3763]

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

[@schooldocuments4454]

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

[@sciencewithdrtess]

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

[@schooldocuments4454]

@@sciencewithdrtess THANK YOU PO!!

[@wendycabangon217]

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]

May I know your SOPs.

[@wendycabangon217]

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

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]

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

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

[@wendycabangon217]

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

[@sciencewithdrtess]

Eto po: kzbin.info/www/bejne/gpyrnX2pr9F4pbc

[@BitteranangBitter]

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]

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]

google forms ka sana

[@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]

Puwede

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

[@chellseadownarong1675]

Hello! How to get the overall mean po?

[@sciencewithdrtess]

Nasa video po sya mam.

[@dexterabad3196]

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]

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

[@dexterabad3196]

@@sciencewithdrtess Got it. Thank you so much

[@ma.angelikacasimiro7779]

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

[@sciencewithdrtess]

Ano po yung research title at SOPs ninyo?

[@ma.angelikacasimiro7779]

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

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]

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?

[@ibanezshannencharm3544]

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

[@sciencewithdrtess]

Hindi po. Only in quantitative research ang likert scale.

[@Vinny7709]

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]

Di po. Qualitative research questions must be open ended.

[@Vinny7709]

Thank u po ma'am! 🥰

[@markjosephcapulong5616]

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

[@sciencewithdrtess]

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.

[@mz6953]

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

[@sciencewithdrtess]

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

[@mz6953]

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

[@sciencewithdrtess]

@@mz6953 for the interpretation and how to create range. Pls check thiskzbin.info/www/bejne/ZnS2inmjiLCKhc0

[@lanashadesofcool5386]

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]

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

[@princessdianes]

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]

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

[@htmlnica]

Bakit po may pron sa downloads nyo huhu

[@allanabejuela6960]

This is too much ma'am😣 ty

[@sciencewithdrtess]

Welcome

[@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]

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.

[@abbyfloresita]

THANK YOUUUUU

[@sciencewithdrtess]

Welcome