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!
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
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 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; RU-vid; 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.
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
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?
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 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
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?
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?
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.
Grateful Dr please my question is how do I group my items in Likert scale response into categorical variables such as Mindset (growth, fixed), coping strategies (adaptive, maladaptive) in the SPSS
Sir what if we are correlating grades in college? The result is always no correlation 😢. Should we change grades like 1.0 to it's equivalent in percentage like 95%? Thank you sir for this video.
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
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
Hello! Po 1.what is the impact of job satisfaction in remote working during pandemic I terms of: a. Working engagement b. Working Condition c. Organization Culture d. Career development e. Job claritu f. Work life balance 2. Is there signicant relationship between job satisfaction and remote working? Ano pong gagamitin ko. Especially in SOP 2.LIKERT PO QUESTIONNAIRE NAMIN.
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.
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. 🙏
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?
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.
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
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?
Hello po what should statistical treatment that i would be use? This is this is the sop po thank you pp 1. What are the profile of the students in terms of: 1.1 Age 1.2 Gender 1.3 Grade Level 2. What social media platforms students commonly use? 2.1 Facebook 2.2 RU-vid 2.3 Tiktok 2.4 Twitter 2.5 Instagram 3. What is the student's perception of the students on the use of social media?
@@sciencewithdrtess bale ganto po yung statement sa sop 3 naka likert scale po siya Do you feel irritated during online classes most of the time because you've been restricted to use social media accounts? Do you easily get distracted during online classes because of social media? Do the social media platforms affect your academic performance during online classes in a negative way? Do you experience losing the interest of listening and participating during online classes because of social media?
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
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
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.
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
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?
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?
@@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
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
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.
Hello po, okay lang po bang mag ask ano po pwede magamit na statistical treatment for our study po. Hope u could reply po, nalilito po kasi ako ano pwede magamit Eto po SOPs namen: 1. What is the perspective of the students towards the utilization of library resources in terms of: 1.2 Content 1.3 Accessibility 1.4 Awareness 2. How frequently do the students make use of the library? 3. How does the perspective of the students affect the Library? 4. What recommendation can be made to promote the use of library resources in school?
First of all, I need to know what data you have for these SOPs SOP 1- are you going to use likert scale here? SOP2 - how will you get the data for frequency here? SOP3 - how will you get the data for the effect. This SOP is more on qualitative. SOP4 - how will you get the data for this? This is more inclined to a qualitative data
@@sciencewithdrtess with the Sop1 po, we will be using 5 point likert scale Sop2 also a 5 point likert scale po (can we use weighted mean po here?) if not can u recommend one po? sop 3, still not sure with this one po Sop4 can we just recommend some strategies to the respondents and if they have other suggestion they can just specify it po? I think multiple choice po gagamitin namen dito if ever
@@sciencewithdrtess with the sop3 po pala, i think we will just remove nalang po para maging quanti-descriptive po study namen It is possible poba to do it?
SOP1 and 2 a likert scale indeed can be a good tool. Yes, weighted mean can be used. I have a video on how to interpret likert scale. You can check ot out - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0CSYFmSKWOk.html SOP 4 - if you will have multiple choice. You can interpret this using frequency count and percentaging. So if you will have these 3 SOPs, your research is just a descriptive research. None of your SOPs will need any other statistical tool
Example po pag maraming respondents 410 pede ko na gawin po yan? Isosolve po ang mean ng respondents tapos po hahanapin ko yung relatuonship nya betwen sa kanilang edad. Btw pearsons din po gamit namin since sop3 po namin ay correlations po
@@sciencewithdrtess DEMOGRAPHIC PROFILE 1.1 NAME 1.2 AGE 1.3 GENDER 1.4YEAR LEVEL 1.5 COURSE 2. HOW THE RESPONDENTS ASSESS THE LEVEL OF “The Youth perceptions in the importance of sexual education needs.” IN TERMS OF THE FOLLOWING ASPECTS: 2.1 MICROSYSTEM 2.1.2 FAMILY 2.1.3 PEERS 2.2 MESO-SYSTEM 2.2.1 SCHOOL 2.2.2 CHURCH 2.3 EXOSYSTEM 2.3.1 LOCAL SCHOOL BOARD 2.3.2 SOCIAL WELFARE SERVICES 2.4 MACROSYSTEM 2.4.1 ATTITUDES AND IDEOLOGIES OF CULTURE AND LAWS 3.) "Is there a significant correlation between the age of the respondents and their perception on the importance in the sex education?"
I am assuming that you used a likert scale for your SOP2. If you did. You can use Pearson R. Use the likert scale mean of each respondents and their respective age. BTW, what is the age range?
Basta tama yung raw data ninyo. At tama din yung questionnaire content ninyo. Kaya nga tinatanong ko kayo kung ano age range. Kasi kung 2 lang ba age differences. Di puwede Pearson r.
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)
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???
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
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
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.
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?
HI Dr. Tess, what statistical tool should I use with this SOP This study aims to determine the challenges in writing thesis encountered among Research 1 Students. Specifically, it seeks to answer: 1. What are the profile of the respondents with regards to their: a) Program b) Year level c) economic standing d) scholarship grant e) Language spoken 2. What are the challenges encountered in thesis writing in terms of? a) Personality aspect b) sociocultural background c) linguistic 3. How are these challenges encountered differ when grouped according to profile?
SOP 1 - frequency count / percentage SOP 2 - I guess, you will use likert scale on this SOP 3 - since you are looking for significant difference / comparing the variables Ttest - for 2 variables to compare ANOVA for more than 2 variables to compare
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.
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
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?
Hello! pwede po mag ask kung anong need na statistical treatment ang dapat kong gamitin for SOP 4 and 5? I am having a hard time to start on to this since I don't know what to start. 1.The demographic profile of the respondents according to: A. Age B. Gender C. Years/Months 2.What are the major issues they faced during the pandemic? 3.What are the changes in their business operations during the pandemic? 4. Is there a significant relationship between the issues faced during the pandemic and the respondent’s demographic profile? 5. Is there a significant relationship between the changes in the business operations and the respondent’s demographic profile?
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
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
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
@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!!!❤️❤️❤️
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..
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?
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
