[Tagalog] How to Compute Pearson r Using MS Excel
HTML-код
- Опубликовано: 21 авг 2024
- "Quick P Value from Pearson (R) Score Calculator"
www.socscistat...
How to use MS Excel to compute for Pearson correlation coefficient r? Paano kuhanin ang p-value ng Pearson r? Paano ireport ang result ng correlation?
Facebook page: / mayoraleksyonsamatemat...
To God be the glory!
![[Tagalog] How to Compute One-Way Analysis of Variance (ANOVA) Using MS Excel](http://i.ytimg.com/vi/s0yBgxdqhh0/mqdefault.jpg)
![[Tagalog] How to Compute One-Way Analysis of Variance (ANOVA) Using MS Excel](/img/tr.png)
![Pearson correlation [Simply explained]](http://i.ytimg.com/vi/k7IctLRiZmo/mqdefault.jpg)
![[Tagalog] How to Compute Weighted Mean in Excel | Research Study Chapter 4](http://i.ytimg.com/vi/pjQVE1mSMA0/mqdefault.jpg)
Sobrang thank you po, ma'am. Sobrang helpful po nung video. :>
Thank you so much ma'am laking tulong po ng video na to
Thank you so much po for this very elaborated discussion.🙏💖
Happy to help! God bless!
Sobrang thank you mam.. tinuro q rin sa students q itong video mo. Laking tulong po sakin.. salamat sa pag share mam🤗😊
Wow maam. Thank yyou po tlga d2. My natutunan po aco, now naintindihan co na bak8 kailangan in excel form pa ipalgay ang data co. 😍😍😍
Hala ito po yung pinakakailangan ko ma'am thanks po 💕
Thank you po sa link n nilagay mo mam! Laking tulong po! ❤
Ganda Po Ng video maam. Clear and easy to catch up. Thanks for this ma'am.
I really love your videos po. I learned a lot. Thank you po.
May ask lng po sana ako regarding sa p-value po ma'am, need pa rin po ba ilagay yun sa statistical tools/treatment po? Baka kasi tanungin kami ng panel po tapos wla kami masagot hehe.
Hello. P-values are usually placed sa chapter 4 as a footnote sa statistical tables. So there is no need to include it sa statistical treatment na part sa chapter 3.
Thank you for appreciating my videos. Good luck sa research mo!
Thank you po ma'am.
Thank you po very imformative at soooooo clear po, salamt
Ma'am, puwede po ba kung ang average ay irerelate sa decimal numbers like sa college gwa (e.g. 1.50, 1.75, etc...)???
Thank u for this one!
thank u so much po huhu you saved me
Hello po mam, great video po! Tanong ko lang din po if dapat po ba average lagi ang icocorrelate sa isa pang variable? Or pwede pong hindi average?
For example po, relationship sa satisfaction ng isang variable sa academic grade. If ang satisfaction ng bata ay 3 (Satisfactory), pwede po yung "3" ay icocorrelate sa kanyang academic grade via pearson r? Thanks.
Hello. Thank you for appreciating this!
For your question, hindi laging average ang icocorrelate. Nangyayari lang yung if yung isang variable ay may subparts pa. In your case, pwedeng yung "3" na lang mismo.
Thanks pi!!
Thankieee 🤍
Hi maam, sa interpretation po of the data, do we separately interpret looking at:
A.) If reject/accept null hypothesis
B.) If the pearson r has positive correlation?
What if, the pearson r is high in score but the decision is accept null hypothesis because the p-value is greater than 0.05 (alpha)?
thanks po mhsagisagshua
-cm nia to
Ma'am pwede po ba gamitin iyan if pag ganto po yong SOP. Correlation po kasi ang study ko
1. How may the academic technology-enabled learning of the 2nd year Bachelor of Science in Information System be described in terms of:
1.1 interactive engagement,
1.2. problem-solving skills,
1.3. interest, and
1.4. feedback?
2. How may the academic performance of the 2nd year Bachelor of Science in Information System be described in terms of general weighted average?
Hello po Ma'am. In our statement of the problem po, we had the question of "how do advertisement and buying behavior correlate", and to answer the question po, in the survey, we made it in a form of Strongly Agree, Agree, and the likes. Yung isa po sa mga statement po na ichochoose nila na strongly agree, etc. is like this po "I see online advertisements on my social media apps that urges me to buy things". Pwede po ba yan mainterpret using Pearson r? sana po masagot hehe. Thank you po
Hello. Yes, pwede. Just assign numeric codes for your choices. For example, 4 means "strongly agree", 3 means "agree", and so on. In that way, numeric ang data ninyo at pwedeng ma-apply-an ng Pearson.
Quick tip: If tapos na kayong magpasurvey and hindi kayo gumamit ng numeric codes, and very time consuming kung ipapaulit nyo pa ang survey just to follow my suggestion, what you can do is to follow this video about "vlookup" to code your data: ruclips.net/video/SJJ8gcgZ120/видео.html
Hope this helps!
Ma'am ask ko lang po if kaya pong iexecuter yung correlation sa SOP 3 po namin? Thank you po in advance❤️
1. What is the satisfaction of Kasiglahan Village Senior High School Students and teachers lemonade Drink, in terms of:
1.1 Price;
1.2 Taste;
1.3 Quality; and
1.4 Service?
2. What is the feasibility of Lemonade Drinks in school in congruence to following:
2.1 Profitability;
2.2 Viability; and
2.3 Government Regulations?
3. Is there a significant relationship on the satisfaction and feasibility of lemonade drink on the respondents?
Hello, Ma'am. Tanong ko lang po kung ano pong gamit mong analysis toolpack po? SPSS po ba? Hindi po ba ito pwedeng maaccess ng students?
Hi Mam. Magtatanong lang po kung saan pwede makakuha nung sa Data analysis po? May downloader po ba? Salamat po
Hello! It is already in our MS Excel by default. Bale i-o-on na lang natin ito. Here po yung video tutorial on how to turn it on: ruclips.net/video/s0h7nj4ecqc/видео.html
3:21
May content ka pag.gamit ng R and Rstudio?
Ma'am pano po kung yung dependent variable po nya is non-numeric po data? Like for example ma'am ratios such 10% and below, 21-30% . Mga ganun po? How to convert yan po ma'am in order to compute yung correlation po?
Good Day po pwede po mag ask pano po kapag sa relationship naman po ng profile po ng respondents sa mga factors po affecting their living satisfaction po?
hi po sana masagot, 0.234 po kasi yung lumabas sa'kin. tama naman po yung computation ko wala rin pong negative sign nakalagay nung i used the data analysis toolpak
Hello po! Paano po kapag naka-interval po yung data? (e.g Grades 90-94, 80-89...)
Hello. Kapag ganyan, lumalabas na categorical ang data. Ang categories ay ying mga interval. Kapag ganuan, di siya pwedeng i-pearson.
Good afternoon Ma'am how about nasa paper yong survey and the question is about the negative and positive effects of gadgets po
hello mam ask ko lang po pano kung 2 variables irerelate mo sa 1 variable tapos puro likert scale po ang gamit? thank you po
Ma'am paano po kung yung x variable 4 yung data tapos sa y variable po 3 lang?
Hello! Pwede pa rin yun. ☺️
Ma'am, saan po kayo pwedeng ireach out? For more deep questions🙁
Hello po Ma'am what if ganito po yung SOP:
5. Is there a significant relationship between the following variables:
5.1. Financial Management Skills and Time Management Skills;
5.2. Financial Management Skills and Academic Performance; and
5.3. Time Management Skills and Academic Performance?
Hello. Your variables are not in ratio level of measurement (ruclips.net/video/ymlp2tqPriI/видео.html) so hindi pwede ang pearson jan.
Sa Spearman rho pwede din po ba average likert scale pp gamit ko
Paano po kung yung SOP ay ganto:
1) What is the extent of relationship between social media addiction to the mental health conditio on Stem students?
Good day Ma'am. Ask ko lang po if may way din po para magawa po yung regression analysis sa excel po?
Hello Ma'am. Can I use Pearson R in this kind of SOP? We both used likert scale in sop #1 and #2. I'm confused po kung paano po gagawin ko.
Sa example niyo po, instead of Acad Grades, ano pong ipapalit ko? Likert scale po kasi yung sop #2. Average din po ba ang kukuhanin ko? Thank you po.
1. How do the respondents assess the Filipino in continues
patronizing lugaw businesses as to:
1.1. Affordability;
1.2. Food Quality;
1.3. Accessibility; and
1.4. Filipino Comfort Food
2. What is the perspective of Filipinos in lugaw businesses to
withstand the changes in our country?
3. Is there a significant difference between the Filipinos in
continues patronizing lugaw businesses and the perspective of
Filipinos in lugaw businesses to withstand the changes in our
country?
Hello. I don't think Pearson r is applicable here dahil your SOP is "Is there a significant difference..."
Pearson r only works if the SOP is about significant relationship.
@@LearnWithMayora Ma'am, if I'm going to change it into "significant relationship" pwede ko na pong gamitin ang pearson r?
Good day mam. Yung isang variable po namin is demographics like gender and age, pwede po ba yun dito? And if not ano pong pwedeng gamitin na statistical tool? Sana po masagot😔
Hello. Pwede naman ito. To be more guided, this another video may be helpful: ruclips.net/video/YgTH1G6NSl4/видео.html
Thank you po mam☺️
Ma'am saan niyo po kinuha yung data po sa academic grades po?
Does it change if the result of p value is significant?
Hello ma'am, what if may factors po both variables ? kukunin po ba ung average nilang dalawa bago isolve ung pearson r?
Hello. Hhhmmm... pwede naman. Kuhanin ang average for factors ng variable A, kuhanin ang average for factors ng variable B, then tsaka i-Pearson r.
Explore mo rin yung chi-square test for independence. Baka mas applicable yun for your data.
Pano po ung alpha, ung margin of error po ba yun sa pag gamit nf slovins formula sa pag compute ng sample size?
Hello! Hindi po, magkaiba po sila. Ang alpha ay level of significance. Usually, 0.05 ang value nito. Ask nyo ang thesis advisee nyo about this.
Hi ma'am, may ask po, likert scale po ba yung ginamit nyong questionnaire dito? TIA po ;))
hi maam pasuyo lang po ng research namin sana po manotice
Question po paano kapag yung other variable may sub variable po? Im confuse po
what type of questionnaire po ma'am ang ginamit mo ?
How to install the data analysis po?
hello po maam. the data po ba is from likert scale?
Kapag no significant relationship po ba wala na talagang relationship si 2 variables?
Hello. Maaaring may relationship sila, pero not significant enough para mameasure or para makagawa ng statistical implication.
What about naman po kapag buying behavior and online reviews and tatlong domain po each, how to use pearson po kapag ganyan? Nag sstruggle na po kasi kami jan T_T
Ma'am papaano po pag magkakaiba po ang result yung isa po ay accept the null hypothesis while yung dalawa ay reject the null?
Hello. It is acceptable. Hiwalayin nyo na lang ng conclusions sa Chapter 5.
Hi maam can I have an example interpretation for this po? Currently doing a research po
hello po ma'am! paano po if ang data po na i-cocorrelate ay likert scale at clustered data po (range po ng salary, e.g. 10k-20k). i hope may makatulong po, badly needed po for research. salamat po!
Hello. Kung naka-range ang data, pwede ninyong ayusin muna ang data in a way na ang isang range corresponds to one number. for example: 10k-19k = 1, 20k-29k = 2, 30k-39k = 3, and so on, bago ninyo gamitan ng Pearson r. Doing that manually sa inyong data will take time. So this video about vlookup in Excel may help: ruclips.net/video/SJJ8gcgZ120/видео.html
ma'am paano po kapag r = 0.120 p = 0.455 n = 41 i-aaccept po ba kapag ganito? not significant po yung lumabas. nalilito po ako if accepted ba agad kapag mas malaki yung p value sa r
Hello. Depende sa alpha yan. Icompare ninyo yung p-value sa alpha or sa level of significance. Nasa 2:33 yung guide as to when you will accept or reject the null hypothesis.
@@LearnWithMayora dun po sa sinabi ko ma'am 0.05 po yung alpha dun bale rejected po yung null hypothesis tama po ba?
hello po, paano po kung yung SOP ganito?
1. What is the demographic profile of the students in terms of:
a.1. age
b.1. gender
c.1. level of academic performance?
2. Is there significant relationship between study habits and respondents academic performance?
3. How does study habits affect the academic performances of Senior High School students?
and yung question po about sa level of academic performance is ganito po
1. What is your level of academic performance in terms of your general weight average?
a. 75 below
b. 75 - 79
c. 80 - 84
d. 85 - 89
e. 90 - 100
Hello ma'am pwede din po ba ito pag ang sop ay significant differences?
Hello. Unfortunately, hindi pwede ito. Here's a video that may help you expand your options for stat treatment ng significant difference:
ruclips.net/video/YgTH1G6NSl4/видео.html
hope this helps!
How about if Hindi po average?
Ma'am😭 sa research kasi namin bawat indicators kinocorrelate tapos pag na correlate na ang r-value ng lahat ng indicators kukunin na naman yung overall yan na yung p value!! Pano yunnnnn😭😭😭
Kumbaga yung mga r-value mam ay kinuha ang overall😭
Hello po. Paano po e cocompute ang total pagkatapos na interpret ang likert scale sa kada statement para makuha yung p-value?Thankyou po
Hello. Pwede ninyong iaverage ang mga responses per statement bago gamitan nitong Pearson r.
nice :)
Hello po Sir! I'm your previous student po! ☺️
@@LearnWithMayora yes, proud prof here!
Hello po. Sabi nyo po kapag "significat difference" hindi pwede ang pearson r.
Ano po kaya pwede gamitin kapag ang dinedescribe ay significant difference. Thank you po
Hello. This video may further help you: ruclips.net/video/YgTH1G6NSl4/видео.html
Hi mam san po makita link ng para sa p value po. ?
Hello po, tanong lang po ma'am, paano po kapag yung p value ay
Hello. Reject po the null hypothesis.
Hello po, may I ask po kung mayroon po bang sample textual paragraph/narrration po nito? Thank you very much po.
Hello. Unfortunately, wala pang video about textual presentation of pearson. What we have is the tabular presentation of it (ruclips.net/video/ymXfKJLwbOw/видео.html)
Hello po ma'am baka po pwede magtanong pano po kung tatlo din po yung subpart na ipagrerelate po sana po ma notice niyo salamat po. ☺️
Hello. If that is the case, then take 2 variables at a time. Bale 3 times ka magpe-pearson. I-pearson muna si variable 1 and 2, then yung variable 2 and 3, then finally yung variable 1 and 3.
Hello po mam. Paano po ang gagawin kapag kinuha ko po yung mean value ng response ng lahat ng respondents in question 1-10? Thank you po very much maam♥️
Hello. Kung mean value ang needed, you will just use the formula for mean. Here's the video for that: ruclips.net/video/f-FbAN43iT0/видео.html
Paano Naman Po kung likert scale salamat sana gawin ng video
pwede din po kung yung isang variable is gender?
Hello. Unfortunately, hindi. Kung gagamit ka ng test for relationship tapos ang isang variable ay gender, I suggest you use chi-square test.
Paano naman kung yung x variables ay sobra kaysa y variables
Hello po. good day~ what if gumamit ako ng pearson r but my N=150, pwede po ba yun? hehe
Hello. Yes, pwede naman ang value na iyan.
maam how po mag interpret po nyan?
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?
Hello. "significant relationship" so pwede ang pearson or chi-square. This video explains further the other statistical treatment of data based on SOP.
@@LearnWithMayora thankyou poo
@@LearnWithMayora ask ko lang po if yung hypothesis po ba dapat NULL ang itest ko kahit feel ko is may relationship sa dalawang variable?
Hello. Yes, null hypothesis ang itetest. Yung mga statistical treatment of data kasi ay pang-null hypothesis. Besides, kahit feel mo na may relationship, di pwedeng maging biased ang computations.
@@LearnWithMayora thankyou poooo❤️
Hello po mam. Paano po kubg puro not significant yung lumabas na result?
Hello. If not significant, then you accept your null hypothesis.
@@LearnWithMayora good pm mam. I mean yung result po na lumabas is puro not significant po, is it good po ba mam or bad?
Hello. Para sa akin, any result is good. Di porket not significant ay mali or bad na yung magiging conclusion. Ang maipapayo ko, kung yun talaga ang lumabas, make sure na tama ang computation at may related literature or study kayo from your chapter 2 na makakapagsupport dito.
@@LearnWithMayora okay po mam thank you so much po❤️
pano po kapag 3 or more than 3 po yung irerelate?
Hello. If that is the case, then take 2 variables at a time. Bale 3 times ka magpe-pearson. I-pearson muna si variable 1 and 2, then yung variable 2 and 3, then finally yung variable 1 and 3.
@@LearnWithMayora how about kung 5 po??
Hello. Ganun din, take 2 variables at a time. Kasi ang pearson ay 2 variables lang ang kinokonsider.
san po galing ung academic grade?
Hello! The data for academic grade" came from the survey.
How to get the size of correlation ma'am?
Hello. What do you mean "size of correlation"?
Hi Ma'am paano naman po ianalyze 'yung research question no.1? May gagawin rin po bang formula duon? Thank you po!
1. What are the perception of the students on the factors affecting their motivation in terms of:
a. Additional grades
b. Verbal praises
c. Peer appreciation
Hello. I assume ay sa questionnaire ninyo, may mga statements na ipapa-rate using likert scale. Thus, ang appropriate dito ay weighted mean.
Ma'am pwede po magpaturo po?
Hello po Ma’am ask ko lang po kung paano po kumuha ng Pearson’s r kapag po yung y variable po ay may 3 data. Pano ko po yung icocorrelate sa 3 data rin po ng x variable po?
Status of information dissemination strategies (x)
-printed material
-social media
-verbal campaign
Level of community awareness (y)
-effectivity
-eligibility
-availability
Hello. Kapag may sub-parts ang need mo icorrelate, I suggest gamit ka na lang ng chi-square. Mas applicable yun it is for significant relationship din naman.
Here's the video for the chi-square: ruclips.net/video/ppPE28gaWXA/видео.html
pahingi format plsssss