Thank you for this excellent presentation. I was trying to get my head around Likert scale analysis in Excel but after watching this presentation it was straightforward and clear. Brilliant!
Hello. At 10.30 I am not really sure if you can find the mean of the ordinal data like that. Because those numbers of whom you took the mean are just codify representation of opinions (strongly agree, agree, neutral etc.) so we dont know if strongly disagree and disagree have the same distance as agree and strongle agree. The central tendency for non-parametirc ordinal data like this can be median and not mean. Could you please clarify on that? Thanks
Hello I would like to ask a question, can I use pearson R to find the correlation between two likert scale data? The first likert scale consists of two questions, and the second likert scale consists of six questions. If yes, should I just correlates the average just like you did in the video? Thank you
Getting the median or mode is more appropriate since likert scale is an example of ordinal data. How can you subtract categorical variable? You can use mean if you just want the verbal interpretation of the ordinal data. Lastly. Pearson R and T-test are use in numerical variables.
Hello, Maam Tess & Sir Levi! I would like to ask something about the appropriate statistical tool to use with my 5-point Likert Scale. In my study, I have three categories: physical health, mental health, and behavioral changes. And, each category has 5 questions. Can I use anova? If not, what can you recommend? Thank you!
What is the profile of the respondents in terms of: Age: 13-15 16-18 18+ Sex: Female Male Grade Level: Grade 7 Grade 8 Grade 9 Grade 10 Grade 11 Grade 12 2. At what extent does mass media campaigns about adolescent drug inhibition affects the respondents in terms of: 2.1 Physical Health 2.2 Mental Health 2.3 Behavioral Changes 3. Is there a significant difference in the effects of mass media campaigns about adolescent drug inhibition in terms of physical health, mental health, and behavioral changes of the respondents when grouped according to their profile?
Hi, what statistical tool should I use with this study 1. How may the profile of the respondents be described in terms of: 1.1 Years of experience in using accounting information system? 1.2 Age 2. How may the importance of Accounting Information System (AIS) be described in terms of: 2.1 People 2.2 Softwares 2.3 Data 2.4 Instructions and Procedures 2.5 Information Technology Infrastructure 2.6 Internal Controls 3. How may the management decision-making using accounting information system be described by the managers in terms of: 3.1 Relevance 3.2 Faithful Representation 4. Does the effectiveness of accounting information system have a significant effect on management decision making?
Your SOPs are constructed for Qualitative research. You need to paraphrase them. The last SOP is gearing towards correlation / looking into relationships. You need to fix your SOPs first to really have a suitable statistical tool
I love how this guy is saying: "But I think you know how to do that..." ---- NO I DON'TTTTT!!!! ahhahahahahha "I think you know what that is......" ------ ABSOLUTELY NO IDEA!!!! hahahahahha
Hii!! I have a question po, these are my research question: 1. How much allowance will be given by their parents per day? 2. How much students spend on their allowance per day? 3. How much students save on their allowance per day? 4. Is there any significant relationship between student's saving and how much they spend all day? What statistical Tool should I use? Thankyou po, btw we used Close-ended or multiple choice po as our instrument
Hey Arun and Dr. Tess. Even I had a similar doubt. I wanted to compare the leadership styles with performance and in place of grades here I want to put a performance and compare. Any idea how it is done?
If we have 60 respondents and just like in the video we use likert scale and want to know the significance using spearman rank test, or tha Pearson's correlation how are we going to conclude the overall significance???
Hi , I have more than one questions for each of my independent variables and also for my dependent variables (product packaging & consumer buying behavior) How do i correlate them over spss ? I heard we don't have to do em separately and do like one variable with DV but how ? which question do i have to pick from my variables and correlate with Dv ( which aslo has 3 questions i.e purchase intention) thankyou
It is acceptable for the computed p-value from a t-test to have E- notation (scientific notation), which is a way of expressing very large or very small numbers in a compact and standardized way. Sometimes, when the sample size is large or the effect size is very small, the p-value can be extremely small, resulting in a very large or very small number in decimal notation. In such cases, the p-value can be expressed in E- notation to make it easier to read and compare with the significance level. For example, a p-value of 0.0000000001 can be expressed as 1E-10, which means 1 multiplied by 10 to the power of -10. This p-value indicates that the observed results are statistically significant at a very high level of confidence.
It depends on what you want to find out in your study Mean /average - equal weights assigned to values Weighted mean / average - unequal weight assigned to values
Good day sir, can I ask if what is the appropriate statistical treatment that we can use if we want to identify if there is a significant difference between to groups of respondents using likert-scale?
your data is ordinal. is it wise to use mean and not the median or mode? Likert-type data is ordinal data. (Question and Questionnaire Design Jon A. Krosnick and Stanley Presser)
This is an elaborated example because in some research, you might need individual respondents mean. Some research you might need the mean of each questions. Some research, you might need both. Just compute the one you need in your research
@SCIENCE with DR. TESS In our research we are looking for the relationship of School Requirements and Students' Mental Health (our two variable) but the data we gathered from them are in Likert Scale. The first part of the survey are the open ended questions about School Requirements (in Likert Scale choices) and the other part is for Students' Mental Health (also in Likert Scale choices). But with the video, the other variable (Grades) is in nominal already. Does this mean that we have to get the average from the School Requirements survey part and also average from the Students' Mental Health survey part, so we could use both of their averages and apply it to Pearson?
@@sciencewithdrtess Thank you so much for your help!!! Your channel and content really help us, students, in creating our research paper. God bless to you!!!❤️❤️❤️
Hiiii Im a Psych Student. What statistical tool can I use for our research study 1. Demographic profile of the respondents in terms of: a) Age b) Gender c) Grade/Year/Academic Strand 2. What type of online video games does the senior high-school students play? a.) MMORPG - Massively Multiplayer Online Roleplaying Games • Fortnite • World of Warcraft b.) Mobile gaming • Player unknown Battlegrounds (PUBG) • Clash of Clans • Clash Royale • Fortnite Battle Royale • Minecraft c.) Social gaming • Animal Crossing • Candy Crush • Among Us d.) Cryptocurrency • GNation • Pixel Wars • Axie Infinity e.) eSPORTS • Call of Duty • Rocket League • Dota 2 3. How are the impacts of playing online games the respondents describe? 4. How are the student’s social communication skills was described? 5. What is the significant relationship between playing online video games and student’s social development?
sir applicable po ba to kung dalawang likert scale data ang hahanapan ng correlation, sa example nyo po kasi, likert scale data at grades, possible po ba na dalawang likert scale data?
@@sciencewithdrtess okay po ma'am, tanong ko lang po ulit kung my way po na pwedeng i-short cut ang process kasi po 84 po respondents namin at 22 naman po ang questions. Salamat po
7:20 - Sir, it does not work po on my Excel 'yung nilalagyan ng dollar sign at idadrag nalang to do the same process with others. Na work naman siya if manually inuulit 'yung =COUNTIF
Your conclusion will just be pattered from your Null hypothesis. As simple as that. Kung reject yung null hypothesis, di make the statement positive Kung accepted yung null Hypothesis, di it will remain as is
Hello po Dr. Tess!! ask lang po kung ano po ang tamang statistical test for question number 3 What is the students’ perception towards full in-person classes? What is the students’ level of readiness towards learning? Is the students’ perception towards full in-person class affect their level of readiness towards learning?
SOP 1 - how will you collect the data? Likert scale? SOP 2 - you will use likert scale? Simply analyze the likert scale result SOP 3 - correlational stat tool? But it will depend on how you gather data for SOP 1
Hi! I have a question. If these are my research questions: 1. What is the level of feminity of grade 12 female students? 2. What is the level of emotional expressiveness of grade 12 female students? 3. Does the level of feminity of grade 12 female students impact their emotional expressiveness? What statistical test should I use? For q1 and q2, the questionanires will be answered in 7point likert scale. Thank you!
SOP 1 & 2 - likert scale and just refer on my videos on how to compute and analyze a likert scale. SOP3 - this is looking into relationships. You can use correlation stat tool. The most common ond is pearson r SOP 3 State it in this way Is there a correlation between level of feminity and emotional aggressiveness?
Hi, may I ask po what statistical tool should I use for sop #3? 1. What is the level of financial knowledge of grade 12 ABM students in the following area; (Mean&Sd) a. Spending habits b. Budgeting c. Saving habits d. Financial Management 2. Is the following sub-variable influence student's saving behavior? (Im not sure here if mean or percentage po gagamitin ko kapag icocorellate) a. Parental Socialization b. Peer Influence c. Financial Literacy d. Self control e. Covid-19 Pandemic 3. Is there a significant relationship between the level of financial knowledge of students when grouped by the factors influencing their saving behavior?
SOP 2 - depende sa questionnaire ninyo. Kung likert scale (mean). Kung multiple choice / ranking (percentage) SOP3 - Pearson R kaya lang, kung gagamitin nyo yung factors, mas magandang likert scale din dapat sa SOP2.
Ano po statistical tools ang gagamitin sa SOP 3.. yun po profile variable ay naka range, tulad po ng age... 1. How may the teaching and non-teaching personnel be described in terms of: 1.1 age 1.2 gender 1.3 civil status 1.4 family structure 2. What is the status of teaching and non-teaching personnel’s well- being along the following components? 2.1 occupational wellness 2.2 emotional wellness 2.3 financial wellness 3. How does well-being statu relate to the profile variables? Are the relationships significant?
Hello po Dr. Tess I have a question, what statistical tools should I use for the following? 1. What is the profile of the respondents in terms of: Sex; Section; Height; Weight; BMI? 2. What are the common social media platforms subscribed by the participants? Facebook; Instagram; RUclips; Twitter; Pinterest? 3. How does social media affect the participants’ eating habits? 4. Is there a significant relationship between the eating habits and nutritional status of the participants? The eating habits are answered through a 5-point likert scale survey questionnaires and the nutritional status is based on the BMI of the participants which is one of their demographic profiles
SOP 1 & 2 - frequency count / percentage SOP 3 - frequency count / percentage if the question is close ended but if it is open ended, then it is qualitative. No stat tool needed. Analysis of qualitative output includes coding and knowing the common theme of responses. SOP 4 -correlational stat tool. Can be pearson r.
Hello po, these are the research questions po namin, ask ko lang po kung anong statistical tool ang pwedeng gamitin namin? salamat po. 1. What are the demographics profiles of the online customers that affect their purchasing decisions? age gender 2. Which platforms online are the most used by (company)‘s a customer? 3. What are the factors affecting consumer decisions when buying online? time spent using online platforms engagements ratings/reviews 4. How online marketing affects its customers' purchase decisions and serves as an advantage to the company's financial performance? 5. Is there a significant relationship between the factors in purchasing and customers' purchase decisions?
Good day mam/sir: here is our SOP: Ano po gagamitin for number four. Thank you in advance Specifically, the following questions are posited: 1. Is participatory decision making practiced in Public Elementary Schools in Masaguitsit, Lobo, Batangas? 2. To what extent do school administrators and teachers practiced participatory decision making in public elementary schools in Masaguitsit, Lobo, Batangas? 3. What is the level of Teachers’ Morale in Public Secondary Schools in Lobo as assessed by teachers? 4. Is there any relationship between Participatory Decision Making and Teachers’ Morale?
Thanks , but I have The question or the 5 rating likert scale Items are randomly assigned, now response are obtained for both positive and negatives items after administration ,how to calculate score for each item n each student score for all the items to do item analysis by using computer
Hi po, Thanks for sharing this. I have a question, I have to compare pre and post-survey results with T-test... So Do I need to calculate T-Test for all the questions individually?
It will depend on what you want to find out in your study. If your objective is to know if there is a significant diff between pre and post survey. You can compare the total score of pre survey vs total score of post survey of each respondent.
You did average of all questions of one respondent. How can we do calculation of average for all questions in one questionnaire? I think we have to do average of all respondents of one question. If I am wrong please let me know sir. 🙏
Hi po sir/ma'am can I ask po anong pwedeng gamitin na statistical treatment sa SOP na: 1. What is the profile of the respondents in terms of: 1.1 age 1.2 Gender 1.3 Average grade in english subject 2. What is the level of use on mobile phone of grade 6 pupils? 3. Is there any relationship between academic performance of grade 6 students and their use of cellphone? Hope I can get a reply po. Salamat
hello, can we correlate marketing strategies to sales? for example: marketing strategies (weighted mean: 3.5, agree) and sales is open ended question (10,500 PHP) correlate: 3.5 to 10,000 or if it is not possible, what alternative can I use? can we do 3.5 for weighted mean, and rating? like 1 is the representation of 10,000 PHP? so instead, we will correlate, 3.5 to 1?
What do you mean by sales open ended question? Di kayo nag bigay ng option sa respondents ng amount? Sila ang magbibigay ng amount? Yan ba ang ibig mong sabihin?
@@sciencewithdrtess And if ever po na kami ang maglalagay ng amount for example, rating: 1 - 0 to 10,000 2 - 10,001 - 20,000 3 - 20,001 -30,000 pwede po ba kapag na pinili ng respondents namin ang number 2 sa choices, pwede po ba siya ma-correlate sa weighted mean, using MS Excel? Accurate po ba ang lalabas na result? Correlate: 3.5 to 2
Good noon po. Likert scale din po ba yung mga pinasagutan na HEALTH SAFETY, FARE, UNDERSTAND EASILY? Yung question po namin is, THE ADVANTAGES OF ONLINE CLASS
@@sciencewithdrtess 1. What arr the students preferred form of learning, online or f2f? 2. What are the advantages and disadvantages of online class? 3. What are students' level of engagement and learning efforts during ol class 4. How much students want to return to f2f? 5. What are students online learning behaviors? Yan po
Eto pwd maging content ng questionnaire nyo SOP 1 Just give them option to choose kung online / F to F. Then percentaging lang ang analysis. Ilang % ang gusto ng F to F or online SOP2 Just like in SOP1 Give them options sa advantages and disadvantages based from your RRL. Either you let the respondents rank them or choose all that applies. Tapos frequency at percentaging lang pag data analysis SOP3 Dito ang likert scale to determine the degree / level SOP 4 Pwd ninyo din ito ilikert scale and have categories on behavior based from your RRL
Hi Dr. Tess, how can we explain to our students clearly that the Data is Ordinal (SA, A, D, SD) and does not have an additive properties. Na hindi sila pwedeng i average and will use a parametric test?. Please help po. Salamat. kasi ito yong palaging warning ng mga statistician. Instead use the non parametric equivalent and get the median instead of mean
Hi. The Likert scale is widely used in social work research, and is commonly constructed with 4 -7 points. It is usually treated as an interval scale, but strictly speaking it is an ordinal scale, where arithmetic operations cannot be conducted. There are pros and cons in using the Likert scale as an interval scale, but the controversy can be handled by increasing the number of points. Several researchers have suggested bringing the number up to eleven, on the basis of empirical data. Source: www.tandfonline.com/doi/abs/10.1080/01488376.2017.1329775
As far as I know, you should not use pearson correlation coefficient to analyze the correlation between ordinal and interval variables. Please refer to statistical books and published articles.
Hello, Good Morning! What if ang Data Pairs na iCcorrelate ko is almost 200+, nag try po kasi akong i correlate ang likert avrage nila per 5 questions then correlate it to their grades, sa 10 data pairs, positive relationship pa ang nakukuha mga 0.63423 pero once na sinama na ang buong 200 pairs, nagiging -0.0121334 po siyaa, any fix on this. Same na same po tayo ng research, pwede po ba patry sa 200+ na data pairs or ganun po ba tlga ang result? or may babaguhin po ba sa range ng interpretation kasi lahat ng factors is puro negative po ung pearson R niya huhuhu sana mahelp ako thankyou
@@sciencewithdrtess Thank you sir one more question If i analyze the questionnaire on the base of scale dimensions how i analyze If one dimension has 20 questions and 40 respondents.
Hello po, can you please help me on the statistical treatment best for my per SOP po? I hope you can reply asap. Thank you so much! 1. What are the profile of the respondents in terms of: 1.1 Age 1.2 Sex 1.3 Locality 1.4 Educational Attainment 1.5 Monthly Income 2. Determine the relationship between the level of education towards the perceived effectiveness of utilizing the traditional remedies and complementary treatment (In-house management) in alleviating mild to moderate signs and symptoms of COVID-19. 3. Determine the relationship between the level of household income towards the perceived effectiveness of utilizing the traditional remedies and complementary treatment (In-house management) in alleviating mild to moderate signs and symptoms of COVID-19.
Hello po. Can I asked what statistical tool can be used in these type of research question? Thank you 1. What is the demographic profile of the respondents in the terms of; a. Age; b. Sex; c. Civil status of parents; d. Employment status of parents; e. Educational attainment of parents; and f. Socioeconomic status; 2. What is the level of involvement of the parents Senior High School Students in terms of; a. Attendance; b. Homework; c. Schedule; d. Tests; and e. Career plans; 3.Is there a significant relationship between the demographic profile of the students and their parents' involvement level in the academic performance of the students?
SOP1 - frequency count /% SOP2- likert scale SOP3 - to correlate, 2 variables must have values. For gender, civil status and educational attainment, no values assigned, you can have a comparison of these variables instead. For socioeconomic status, if there will be values like salary for a year / month, correlation is possible
Paano po ipipearson testing kung yung grades ay nakarange type po? Halimbawa yung grade po ng respondent is ranging from 86-90? Paano po siya magiging isang value lang?
What if iyong variable mo may subvariable? Let's say si independent, may 4 tapos si dependent may 3. Paano po kunin ang correlation pati significance po.
Hi Dr. Tess. I have a question po. Meron po akong dalawang product na ipinag-cocompare in terms of: a) characteristic 1, b) characteristic 2, c) characteristic 3 and ni-rate po ng respondents itong mga characteristics na ito using likert scale. As far as I know po t-test po ang ginagamit para ma-compute yung significant difference kapag may dalawang variable na pinagcocompare, tama po ba? However naguguluhan po ako since need ko i-compare yung dalawang product sa 3 characteristics & that would give me 3 weighted means per product. Pano po kaya yun, ano pong next step? 😅 Unsure po kasi ako kung anong formula ng t-test ang gagamitin.
Hello po pwede po mag ask kung ano Ang need na statistical treatment ko sa SOP 1. What is the leadership style as per eived by the teacher ? Leadership style of the principal as perceived by the teacher? 2. What is the leadership skills of the principal as assess by the teacher? 3. Are there significance relationship between 1 and 2? Salamat po😇🙏
If there are more than 2 variables to compare use ANOVA Pero hindi kasi clear. Are you comparing the 3 Or you are looking for correlation / relationships?
Hi. I am confused. This data like strongly agree etc is count data(ordinal) .. Pearson requires at least interval variable and the variable should quantitative..
![Eminem - The Death of Slim Shady [Graveyard Album Trailer]](http://i.ytimg.com/vi/vOJD-6vQpXU/mqdefault.jpg)
Great help, Ma'am Tess and Sir Levi! Need to refresh my mind w/ these computations!
Thanks sir 🙏😊
Finally something relevant video on the Likert Scale with such nice examples.
Thank you for this simple tutorial! Helped me in my group's research project.
Welcome 🙏
Precise, simple, concise and beautifully presented! Thank you
Welcome. Glad that this video helps.
god you saved my college life, sir! thank you so much :"( our prof doesn't even helping us with our capstone. you're a big help sir!
Welcome
Awesome, easy to understand, thank you so much Dr. Tess
Welcome
👍 This has helped so much with my Uni Research Project - Thank You 🙌
Welcome
This is so helpful since I can't pay a statistician to do my chapter 4. Thank you very much!
Welcome 🙏
Thank you so much for this. I was looking for this for my survey study.
Welcome
Thank you. Simple and excellent easy to understand
Thank you for this excellent presentation. I was trying to get my head around Likert scale analysis in Excel but after watching this presentation it was straightforward and clear. Brilliant!
Glad that you like our video. 🙏
Useful content for students and Young researchers.
Thank you
very informative, this one i really understood
Thank you
Thank you so much for this useful video.
Welcome
thanks a lot, very helpful!!
Welcome
Hello. At 10.30 I am not really sure if you can find the mean of the ordinal data like that. Because those numbers of whom you took the mean are just codify representation of opinions (strongly agree, agree, neutral etc.) so we dont know if strongly disagree and disagree have the same distance as agree and strongle agree. The central tendency for non-parametirc ordinal data like this can be median and not mean. Could you please clarify on that? Thanks
www.statisticssolutions.com/can-an-ordinal-likert-scale-be-a-continuous-variable/
Thank you very much!
Welcome
thank you so much,very nformative
Welcome
Best video.. I'm subscribe
Thank you
Btw what's Is the next you computed after the mean like you put in the grade?
thank you so much hueheueheuehueuehuee i finally undertsand it thank you thank you
Welcome
Is this correct to use a parametric test to analyze Likert scale data? or should we go for a non-parametric test ...please ?
Easy to understand, i would like to ask about t-test
What is it?
Hello I would like to ask a question, can I use pearson R to find the correlation between two likert scale data? The first likert scale consists of two questions, and the second likert scale consists of six questions. If yes, should I just correlates the average just like you did in the video? Thank you
Yes. Correlate the mean of each respondent
@@sciencewithdrtess Thank you Dr. Tess
Welcome
Getting the median or mode is more appropriate since likert scale is an example of ordinal data. How can you subtract categorical variable? You can use mean if you just want the verbal interpretation of the ordinal data. Lastly. Pearson R and T-test are use in numerical variables.
Hello, Maam Tess & Sir Levi!
I would like to ask something about the appropriate statistical tool to use with my 5-point Likert Scale.
In my study, I have three categories: physical health, mental health, and behavioral changes. And, each category has 5 questions. Can I use anova? If not, what can you recommend? Thank you!
If info isn’t clear enough, I can send here my SOPs. 😊
What is the profile of the respondents in terms of:
Age:
13-15
16-18
18+
Sex:
Female
Male
Grade Level:
Grade 7
Grade 8
Grade 9
Grade 10
Grade 11
Grade 12
2. At what extent does mass media campaigns about adolescent drug inhibition affects the respondents in terms of:
2.1 Physical Health
2.2 Mental Health
2.3 Behavioral Changes
3. Is there a significant difference in the effects of mass media campaigns about adolescent drug inhibition in terms of physical health, mental health, and behavioral changes of the respondents when grouped according to their profile?
ANOVA for SOP 3
@@sciencewithdrtess - oh, so, in sop2, maam? I will be using likert scale but im not sure what statistical tool i will use to interpret it.
SOP 2. Descriptive stat. Interpretation of the mean scores of likert scale.
Thank you po ☺️
Welcome
Hi, what statistical tool should I use with this study
1. How may the profile of the respondents be described in terms of:
1.1 Years of experience in using accounting information system?
1.2 Age
2. How may the importance of Accounting Information System (AIS) be described in terms of:
2.1 People
2.2 Softwares
2.3 Data
2.4 Instructions and Procedures
2.5 Information Technology Infrastructure
2.6 Internal Controls
3. How may the management decision-making using accounting information system be described by the managers in terms of:
3.1 Relevance
3.2 Faithful Representation
4. Does the effectiveness of accounting information system have a significant effect on management decision making?
Your SOPs are constructed for Qualitative research. You need to paraphrase them.
The last SOP is gearing towards correlation / looking into relationships.
You need to fix your SOPs first to really have a suitable statistical tool
Ohh I see, thank you so much
I love how this guy is saying:
"But I think you know how to do that..." ---- NO I DON'TTTTT!!!! ahhahahahahha
"I think you know what that is......" ------ ABSOLUTELY NO IDEA!!!! hahahahahha
Hii!! I have a question po, these are my research question:
1.
How much allowance will be given by their parents per day?
2. How much students spend on their allowance per day?
3. How much students save on their allowance per day?
4. Is there any significant relationship between student's saving and how much they spend all day?
What statistical Tool should I use?
Thankyou po, btw we used Close-ended or multiple choice po as our instrument
thank you po!
Thank you 🙏
Welcome
Can i ask how I should table this as a significant relationship between two variables?
Hi. You can use t test. On how to table it. It is shown in the video.
Thank you
Welcome
Can you please explain how did you put the grades? Is it okay to put random grades? (Great explanation btw)
In actual research, you get the trades from your respondents or from the school registrar.
What do you mean by putting grades in random?
Hey Arun and Dr. Tess. Even I had a similar doubt. I wanted to compare the leadership styles with performance and in place of grades here I want to put a performance and compare. Any idea how it is done?
Can I use question 1 only for this?!
If we have 60 respondents and just like in the video we use likert scale and want to know the significance using spearman rank test, or tha Pearson's correlation how are we going to conclude the overall significance???
It was discussed in the video on how to do it. Pls watch it again
Hello po, puwede po ba kung ang average ay irerelate sa decimal numbers like sa college gwa (e.g. 1.50, 1.75, etc...)???
Hi mam/sir kapag po ba gagamitin ang t test does it require na hanggang 30 lang yung number or respondents or yung sample size po?
Thank you sir
Welcome
Hi , I have more than one questions for each of my independent variables and also for my dependent variables
(product packaging & consumer buying behavior)
How do i correlate them over spss ?
I heard we don't have to do em separately and do like one variable with DV
but how ? which question do i have to pick from my variables and correlate with Dv ( which aslo has 3 questions i.e purchase intention)
thankyou
Statistical tool to be used will depend on your SOPs. What are your SOPs?
Btw is this applicable for Pearson's:)
Great Video Po! Gusto ko lang Po itanong kung pwede ba e change yung data ng grades into their grade level to get the correlation and t-test Po?
Puwede. Depende sa SOP nyo
is it acceptable if the computed p-value from the t-test has E-? huhuhu or does it mean something wrong on computation process?
It is acceptable for the computed p-value from a t-test to have E- notation (scientific notation), which is a way of expressing very large or very small numbers in a compact and standardized way.
Sometimes, when the sample size is large or the effect size is very small, the p-value can be extremely small, resulting in a very large or very small number in decimal notation. In such cases, the p-value can be expressed in E- notation to make it easier to read and compare with the significance level.
For example, a p-value of 0.0000000001 can be expressed as 1E-10, which means 1 multiplied by 10 to the power of -10. This p-value indicates that the observed results are statistically significant at a very high level of confidence.
Good day. Can weighted mean be used instead of the mean only?
It depends on what you want to find out in your study
Mean /average - equal weights assigned to values
Weighted mean / average - unequal weight assigned to values
@@sciencewithdrtesswhat do you mean by this po?
salamat, captain levi. pa-slice naman ng nape.
You’re welcome. But first, you must “Give your Hearts!”
THANK YOU SO MUCH, SIR!🤍
Welcome
Hi, can you kindly show how to find mean and SD from the 5 point likert scale?
Pls check these
ruclips.net/video/5P0aZxYJ1yg/видео.html
ruclips.net/video/0CSYFmSKWOk/видео.html
ruclips.net/video/7KligWKHVKM/видео.html
Good day po,what should i use po if i am aiming po for the average level of English Proficiency of students?
hello po. ano po formula sa standard deviation for likert scale? thank you!
Sir what will happen po if negative ang result ng pearson r? Does it mean po na walang relationship ang two variables ng study?
Good day sir, can I ask if what is the appropriate statistical treatment that we can use if we want to identify if there is a significant difference between to groups of respondents using likert-scale?
T-test
@@sciencewithdrtess can we use Two Sample T-test Assuming Equal Variance? Thank you po
That depends on your study.
What is the reasoning for using Pearson R versus Spearman’s rank?
Pearson r for interval scale
Spearman for ordinal
Likert scale is treated as interval scale but it is also an ordinal scale
your data is ordinal. is it wise to use mean and not the median or mode? Likert-type data is ordinal data. (Question and Questionnaire Design Jon A. Krosnick and Stanley Presser)
You can use likert data as continuous data as long as certain conditions are met. Most student research papers do so.
@@sciencewithdrtess what are the conditions ma'am?
@@zaccblack103 you can read this article to help you- www.statisticssolutions.com/can-an-ordinal-likert-scale-be-a-continuous-variable/
I am so confused why you get the average horizontally instead of vertical average. Can you explain why?
This is an elaborated example because in some research, you might need individual respondents mean. Some research you might need the mean of each questions. Some research, you might need both. Just compute the one you need in your research
how do you reject and accept the null? and where to compare the t-test
It’s mentioned in the video
Hello! May I ask if would this be applicable if both of my independent and dependent variable are in likert scale data?
I don’t know what you mean.
@SCIENCE with DR. TESS In our research we are looking for the relationship of School Requirements and Students' Mental Health (our two variable) but the data we gathered from them are in Likert Scale. The first part of the survey are the open ended questions about School Requirements (in Likert Scale choices) and the other part is for Students' Mental Health (also in Likert Scale choices). But with the video, the other variable (Grades) is in nominal already. Does this mean that we have to get the average from the School Requirements survey part and also average from the Students' Mental Health survey part, so we could use both of their averages and apply it to Pearson?
Yes. Get the mean of each respondents in those 2 variables and use those data for pearson r to get the relationship.
@@sciencewithdrtess Thank you so much for your help!!! Your channel and content really help us, students, in creating our research paper. God bless to you!!!❤️❤️❤️
Welcome
Hiiii Im a Psych Student. What statistical tool can I use for our research study
1. Demographic profile of the respondents in terms of:
a) Age
b) Gender
c) Grade/Year/Academic Strand
2. What type of online video games does the senior high-school students play?
a.) MMORPG - Massively Multiplayer Online Roleplaying Games
• Fortnite
• World of Warcraft
b.) Mobile gaming
• Player unknown Battlegrounds (PUBG)
• Clash of Clans
• Clash Royale
• Fortnite Battle Royale
• Minecraft
c.) Social gaming
• Animal Crossing
• Candy Crush
• Among Us
d.) Cryptocurrency
• GNation
• Pixel Wars
• Axie Infinity
e.) eSPORTS
• Call of Duty
• Rocket League
• Dota 2
3. How are the impacts of playing online games the respondents describe?
4. How are the student’s social communication skills was described?
5. What is the significant relationship between playing online video games and student’s social development?
Hello. Can I ask what is the difference between Pearson's and Spearman's? Thank you!
Spearman uses ranked values for each varuable while Pearson uses the raw data
@@sciencewithdrtess thank you
Welcome
sir applicable po ba to kung dalawang likert scale data ang hahanapan ng correlation, sa example nyo po kasi, likert scale data at grades, possible po ba na dalawang likert scale data?
What are your SOPs?
Hello maam, can i ask if what statistical tool i would use if i would to determine the relationship between two variables?
I hope u reply asap maam
Pearson r for relationships but it will still depend on your SOPs
Could pearson correlation really be used in assessing data of a likert scale?
It was discussed in the video. Pls watch again.
@@sciencewithdrtess wala po ata e
@@zaccblack103 andyan kaya nga nasa title yung pearson r.
same thought. Spearman correlation should have been used.
@@joviereyes3208 pls read this article to correct your misconception
www.statisticssolutions.com/can-an-ordinal-likert-scale-be-a-continuous-variable/
Tanong ko lang po Ma'am Tess doon po sa example ni Sir Levi na grades. Okay lang po ba i-correlate kapag yung grades po eh naka 1.25, 1.5, 2.0 etc?
Puwede. Basta dapat ganyan sa lahat ng respondents. Hindi puwede mahaluan ng ibang grading system
@@sciencewithdrtess okay po ma'am, tanong ko lang po ulit kung my way po na pwedeng i-short cut ang process kasi po 84 po respondents namin at 22 naman po ang questions. Salamat po
7:20 - Sir, it does not work po on my Excel 'yung nilalagyan ng dollar sign at idadrag nalang to do the same process with others. Na work naman siya if manually inuulit 'yung =COUNTIF
Hi po, how can we conclude if there is a significant relationship between the variables based on the pearson's po at t-test
Your conclusion will just be pattered from your Null hypothesis. As simple as that.
Kung reject yung null hypothesis, di make the statement positive
Kung accepted yung null Hypothesis, di it will remain as is
Hello po Dr. Tess!! ask lang po kung ano po ang tamang statistical test for question number 3
What is the students’ perception towards full in-person classes?
What is the students’ level of readiness towards learning?
Is the students’ perception towards full in-person class affect their level of readiness towards learning?
SOP 1 - how will you collect the data? Likert scale?
SOP 2 - you will use likert scale? Simply analyze the likert scale result
SOP 3 - correlational stat tool? But it will depend on how you gather data for SOP 1
What is the basis on rejecting or accepting the hypothesis
P value
@@sciencewithdrtess thank you so much. This lecture help me a lot on my studies. God Bless and more power.
hello po, iverify ko lang po if pwede sya gamitin sa 5 hedonic scale po ng sensory analysis? thanks po
Yes
Pano po if ang sop number 3 namin is
Is there any significant relationship between selection of career strand and the factors affecting it?
For relationships / correlation: Pearson r or Spearman
what does Q1 stands for?
Question 1
Hi! I have a question. If these are my research questions:
1. What is the level of feminity of grade 12 female students?
2. What is the level of emotional expressiveness of grade 12 female students?
3. Does the level of feminity of grade 12 female students impact their emotional expressiveness?
What statistical test should I use?
For q1 and q2, the questionanires will be answered in 7point likert scale.
Thank you!
SOP 1 & 2 - likert scale and just refer on my videos on how to compute and analyze a likert scale.
SOP3 - this is looking into relationships. You can use correlation stat tool. The most common ond is pearson r
SOP 3
State it in this way
Is there a correlation between level of feminity and emotional aggressiveness?
Hi, may I ask po what statistical tool should I use for sop #3?
1. What is the level of financial knowledge of grade 12 ABM students in the following area; (Mean&Sd)
a. Spending habits
b. Budgeting
c. Saving habits
d. Financial Management
2. Is the following sub-variable influence student's saving behavior? (Im not sure here if mean or percentage po gagamitin ko kapag icocorellate)
a. Parental Socialization
b. Peer Influence
c. Financial Literacy
d. Self control
e. Covid-19 Pandemic
3. Is there a significant relationship between the level of financial knowledge of students when grouped by the factors influencing their saving behavior?
SOP 2 - depende sa questionnaire ninyo. Kung likert scale (mean). Kung multiple choice / ranking (percentage)
SOP3 - Pearson R kaya lang, kung gagamitin nyo yung factors, mas magandang likert scale din dapat sa SOP2.
@@sciencewithdrtess dapat po ba Correlational Research design gamitin ko or pwede rin pong descriptive survey?
It can be Descriptive Correlational
applicable pa rin po ba ito kung 4-point likert scale and gamit? thank you po
Yes
Ano po statistical tools ang gagamitin sa SOP 3.. yun po profile variable ay naka range, tulad po ng age...
1. How may the teaching and non-teaching personnel be described in terms of:
1.1 age
1.2 gender
1.3 civil status
1.4 family structure
2. What is the status of teaching and non-teaching personnel’s well- being along the following components?
2.1 occupational wellness
2.2 emotional wellness
2.3 financial wellness
3. How does well-being statu relate to the profile variables? Are the relationships significant?
Try Pearson R correlation.
where have you shown t-test for likert scale data?
Pls watch the video carefully, everything is there.
Hello po Dr. Tess I have a question, what statistical tools should I use for the following?
1. What is the profile of the respondents in terms of:
Sex;
Section;
Height;
Weight;
BMI?
2. What are the common social media platforms subscribed by the participants?
Facebook;
Instagram;
RUclips;
Twitter;
Pinterest?
3. How does social media affect the participants’ eating habits?
4. Is there a significant relationship between the eating habits and nutritional status of the participants?
The eating habits are answered through a 5-point likert scale survey questionnaires and the nutritional status is based on the BMI of the participants which is one of their demographic profiles
SOP 1 & 2 - frequency count / percentage
SOP 3 - frequency count / percentage if the question is close ended but if it is open ended, then it is qualitative. No stat tool needed. Analysis of qualitative output includes coding and knowing the common theme of responses.
SOP 4 -correlational stat tool. Can be pearson r.
How can we identify the P value from the T value? how did yo get 0.00000000078
If you use SPSS or online calculators. Instant na lalabas ang p value at t value sa t test.
Hello po, these are the research questions po namin, ask ko lang po kung anong statistical tool ang pwedeng gamitin namin? salamat po.
1. What are the demographics profiles of the online customers that affect their purchasing decisions?
age
gender
2. Which platforms online are the most used by (company)‘s a customer?
3. What are the factors affecting consumer decisions when buying online?
time spent using online platforms
engagements
ratings/reviews
4. How online marketing affects its customers' purchase decisions and serves as an advantage to the company's financial performance?
5. Is there a significant relationship between the factors in purchasing and customers' purchase decisions?
Good day mam/sir: here is our SOP: Ano po gagamitin for number four. Thank you in advance
Specifically, the following questions are posited:
1. Is participatory decision making practiced in Public Elementary Schools in Masaguitsit, Lobo, Batangas?
2. To what extent do school administrators and teachers practiced participatory decision making in public elementary schools in Masaguitsit, Lobo, Batangas?
3. What is the level of Teachers’ Morale in Public Secondary Schools in Lobo as assessed by teachers?
4. Is there any relationship between Participatory Decision Making and Teachers’ Morale?
You can use pearson r for #4
Hello po! Our study will correlate income and impulse buying (likert scale). What statistical analysis should we use po?
If it is correlation, use Pearson r or Spearman
@@sciencewithdrtess will it work po that our data for income is not specific (e.g. P 9,500) but rather in groups (e.g. P 10,000-P 20,000)?
You got a range for income. This is not possible.
Hi paano pag anova gamitin mo para malan if disrigard mo ang nul or hndi
Pls watch the video very well. It is in the discussion
How to calculate when positive and negatives are in random then the value also change from 5to1 or 1to5 scoring
I dont understand your question
If positive items and negative items are mixed randomly how to calculate it
Rewrite the negative to make iit positive. Or vice versa. Or you can reverse the points for the opposite items.
Thanks , but I have The question or the 5 rating likert scale Items are randomly assigned, now response are obtained for both positive and negatives items after administration ,how to calculate score for each item n each student score for all the items to do item analysis by using computer
As what I have said. Reverse the points for the opposite items so that they will not cancel out when you get the mean for each student / each item.
Hi po, Thanks for sharing this. I have a question, I have to compare pre and post-survey results with T-test... So Do I need to calculate T-Test for all the questions individually?
It will depend on what you want to find out in your study.
If your objective is to know if there is a significant diff between pre and post survey. You can compare the total score of pre survey vs total score of post survey of each respondent.
You did average of all questions of one respondent. How can we do calculation of average for all questions in one questionnaire?
I think we have to do average of all respondents of one question. If I am wrong please let me know sir. 🙏
Hi po sir/ma'am can I ask po anong pwedeng gamitin na statistical treatment sa SOP na:
1. What is the profile of the respondents in terms of:
1.1 age
1.2 Gender
1.3 Average grade in english subject
2. What is the level of use on mobile phone of grade 6 pupils?
3. Is there any relationship between academic performance of grade 6 students and their use of cellphone?
Hope I can get a reply po. Salamat
SOP 1 - frequency count and percentaging
SOP2 - use likert scale for this
SOP 3 - Pearson r or other stat tool to determine relationships
Thank you so much pooooo❤️
hello, can we correlate marketing strategies to sales?
for example:
marketing strategies (weighted mean: 3.5, agree) and sales is open ended question (10,500 PHP)
correlate:
3.5 to 10,000
or if it is not possible, what alternative can I use? can we do 3.5 for weighted mean, and rating? like 1 is the representation of 10,000 PHP? so instead, we will correlate, 3.5 to 1?
What do you mean by sales open ended question?
Di kayo nag bigay ng option sa respondents ng amount? Sila ang magbibigay ng amount? Yan ba ang ibig mong sabihin?
@@sciencewithdrtess Yes po. Ang respondents po ang magbibigay ng amount. Kung ilan ang sales nilang nakukuha in a month.
@@sciencewithdrtess And if ever po na kami ang maglalagay ng amount for example, rating:
1 - 0 to 10,000
2 - 10,001 - 20,000
3 - 20,001 -30,000
pwede po ba kapag na pinili ng respondents namin ang number 2 sa choices, pwede po ba siya ma-correlate sa weighted mean, using MS Excel? Accurate po ba ang lalabas na result?
Correlate:
3.5 to 2
Pwd mo yan icorrelate.
Mean value ng likert scale to the amount of sales that they gave
Wag ka na maglagay ng range. Yun na mismong value na binigay nila. Mas maganda nga yun kasi mas exact
Good noon po. Likert scale din po ba yung mga pinasagutan na HEALTH SAFETY, FARE, UNDERSTAND EASILY? Yung question po namin is, THE ADVANTAGES OF ONLINE CLASS
What are your SOPs?
@@sciencewithdrtess
1. What arr the students preferred form of learning, online or f2f?
2. What are the advantages and disadvantages of online class?
3. What are students' level of engagement and learning efforts during ol class
4. How much students want to return to f2f?
5. What are students online learning behaviors?
Yan po
Eto pwd maging content ng questionnaire nyo
SOP 1
Just give them option to choose kung online / F to F. Then percentaging lang ang analysis. Ilang % ang gusto ng F to F or online
SOP2
Just like in SOP1
Give them options sa advantages and disadvantages based from your RRL. Either you let the respondents rank them or choose all that applies. Tapos frequency at percentaging lang pag data analysis
SOP3
Dito ang likert scale to determine the degree / level
SOP 4
Pwd ninyo din ito ilikert scale and have categories on behavior based from your RRL
@@sciencewithdrtess maraming Salamat po 🤗♥️
Hi Dr. Tess, how can we explain to our students clearly that the Data is Ordinal (SA, A, D, SD) and does not have an additive properties. Na hindi sila pwedeng i average and will use a parametric test?. Please help po. Salamat. kasi ito yong palaging warning ng mga statistician. Instead use the non parametric equivalent and get the median instead of mean
Hi. The Likert scale is widely used in social work research, and is commonly constructed with 4 -7 points. It is usually treated as an interval scale, but strictly speaking it is an ordinal scale, where arithmetic operations cannot be conducted. There are pros and cons in using the Likert scale as an interval scale, but the controversy can be handled by increasing the number of points. Several researchers have suggested bringing the number up to eleven, on the basis of empirical data.
Source: www.tandfonline.com/doi/abs/10.1080/01488376.2017.1329775
@@sciencewithdrtess Thank You Dr. Tess
Welcome 🙏
As far as I know, you should not use pearson correlation coefficient to analyze the correlation between ordinal and interval variables. Please refer to statistical books and published articles.
Pls read this article to help you: www.statisticssolutions.com/can-an-ordinal-likert-scale-be-a-continuous-variable/
Hello, Good Morning! What if ang Data Pairs na iCcorrelate ko is almost 200+, nag try po kasi akong i correlate ang likert avrage nila per 5 questions then correlate it to their grades, sa 10 data pairs, positive relationship pa ang nakukuha mga 0.63423 pero once na sinama na ang buong 200 pairs, nagiging -0.0121334 po siyaa, any fix on this. Same na same po tayo ng research, pwede po ba patry sa 200+ na data pairs or ganun po ba tlga ang result? or may babaguhin po ba sa range ng interpretation kasi lahat ng factors is puro negative po ung pearson R niya huhuhu sana mahelp ako thankyou
The R value is going to be different if you use different sets of data. If it’s negative then it’s negative, assuming you did it right.
If there are options like always , often , sometime , very rarely , never
Any different method for this or same one
The same
@@sciencewithdrtess Thank you sir one more question If i analyze the questionnaire on the base of scale dimensions how i analyze If one dimension has 20 questions and 40 respondents.
@@crescentwrites4160 I’m sorry I don’t understand what you mean
Hello po, can you please help me on the statistical treatment best for my per SOP po? I hope you can reply asap. Thank you so much!
1. What are the profile of the respondents in terms of:
1.1 Age
1.2 Sex
1.3 Locality
1.4 Educational Attainment
1.5 Monthly Income
2. Determine the relationship between the level of education towards the perceived effectiveness of utilizing the traditional remedies and complementary treatment (In-house management) in alleviating mild to moderate signs and symptoms of COVID-19.
3. Determine the relationship between the level of household income towards the perceived effectiveness of utilizing the traditional remedies and complementary treatment (In-house management) in alleviating mild to moderate signs and symptoms of COVID-19.
SOP 1 - frequency count
SOP 2 & 3 - you can use Pearson r / spearman.
Sir good pm po how to compute pearson r with just standard deviation and mean only?
It’s impossible.
Hello po. Can I asked what statistical tool can be used in these type of research question? Thank you
1. What is the demographic profile of the respondents in the terms of;
a. Age;
b. Sex;
c. Civil status of parents;
d. Employment status of parents;
e. Educational attainment of parents; and
f. Socioeconomic status;
2. What is the level of involvement of the parents Senior High School Students in terms of;
a. Attendance;
b. Homework;
c. Schedule;
d. Tests; and
e. Career plans;
3.Is there a significant relationship between the demographic profile of the students and their parents' involvement level in the academic performance of the students?
SOP1 - frequency count /%
SOP2- likert scale
SOP3 - to correlate, 2 variables must have values. For gender, civil status and educational attainment, no values assigned, you can have a comparison of these variables instead. For socioeconomic status, if there will be values like salary for a year / month, correlation is possible
Paano po ipipearson testing kung yung grades ay nakarange type po? Halimbawa yung grade po ng respondent is ranging from 86-90? Paano po siya magiging isang value lang?
Hi. This is not possible for Pearson r.
Ano pong test ang pwede gamitin para maicorrelate yung grades sa determined factors?
Wala po kasi pag mag a-appply ka ng stat tools. Di pwd ang may range.
So better ask your research adviser / teacher. Kasi pwd na lang baguhin yung focus ng study at SOP nyo para hindi na kayo umulit
Hi. Use Spearman's rank order..
You cannot use pearson when your data is ordinal.
What if iyong variable mo may subvariable? Let's say si independent, may 4 tapos si dependent may 3. Paano po kunin ang correlation pati significance po.
What are your SOPs?
Hi Dr. Tess. I have a question po.
Meron po akong dalawang product na ipinag-cocompare in terms of: a) characteristic 1, b) characteristic 2, c) characteristic 3
and ni-rate po ng respondents itong mga characteristics na ito using likert scale.
As far as I know po t-test po ang ginagamit para ma-compute yung significant difference kapag may dalawang variable na pinagcocompare, tama po ba?
However naguguluhan po ako since need ko i-compare yung dalawang product sa 3 characteristics & that would give me 3 weighted means per product. Pano po kaya yun, ano pong next step? 😅 Unsure po kasi ako kung anong formula ng t-test ang gagamitin.
Iti test mo yung 2 products per characteristics
@@sciencewithdrtess Thank you po sa fast reply Dr. Tess! Thank you so much po! God bless po 🤍
Hello po pwede po mag ask kung ano Ang need na statistical treatment ko sa SOP
1. What is the leadership style as per eived by the teacher ? Leadership style of the principal as perceived by the teacher?
2. What is the leadership skills of the principal as assess by the teacher?
3. Are there significance relationship between 1 and 2?
Salamat po😇🙏
If there are more than 2 variables to compare use ANOVA
Pero hindi kasi clear.
Are you comparing the 3
Or you are looking for correlation / relationships?
@@sciencewithdrtess relationship po School Leaders Skills and Styles in the New Normal po ang title ko
9:14
Hi. I am confused. This data like strongly agree etc is count data(ordinal) .. Pearson requires at least interval variable and the variable should quantitative..
You can use Likert as continuous variable.
www.statisticssolutions.com/can-an-ordinal-likert-scale-be-a-continuous-variable/