[Tagalog] How to Compute One-Way Analysis of Variance (ANOVA) Using MS Excel

[@jctors4095]

Thank you mayora.

[@jeremybisco7968]

thank youuuuuuu po mAaaaaammm

[@diannamagallon2515]

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?

[@LearnWithMayora]

Hello. "significant relationship" so pwede ang pearson or chi-square. This video explains further the other statistical treatment of data based on SOP.

[@AngelMaisa-v5q]

Hello po ma'am!! About research po sana, sa analysis of variance po, i have 2 groups po (male and female) na naka likeret scale po, then ang table or questions ko po ay divided po sa two, fdm and mdf, t-test po ba ang gagamitin? Ang how po kaya? Thank you po

[@irmamillena2941]

Thank you po

[@HanikaUniz]

sadya po bang kulang ng isang respondents? 250 po respondents ko lumabas po sa anova 249 nalang

[@marinellesamiley9191]

Hello po, ma'am ano po proper statistical treatment if we are testing for significant relationship between profile variables of teachers and the teaching methods they use? Sana mapansin niyo po ako ma'am . Thank you po .

[@LearnWithMayora]

Hello. If significant relationship, pwede jan ang chi square (kzbin.info/www/bejne/pqGzdmVunMaKjqM)

[@jethroolazo]

Ma'am paano po pag 1-10 ang ginamit na scale?

[@markanthonydominguez5290]

Hi po ma'am good afternoon po, After ng Post Hoc using indepedent t-test, paano po makukuha ang group mean para sa comparison kung anong mas better samples/group?

[@LearnWithMayora]

Hello. If you used excel to compute the t-test, kasama sa summary if results yung mean. Or pwede naman gamitin mo yung function na =AVERAGE() to get the mean using excel

[@mariyanli9622]

Sana po may multiple linear regression 🙏😭

[@biernesballonggay15]

Pano Po Isa isa in na masolve yong ANOVA.. pag walang excel.. poe

[@johnlloydsaguan1217]

ma'am paano po kaya ito, yung data set po na meron kami halos same lang sainyo pero tatlong section lang po. ginawa ko po yung turo nyo pero sabi po ng professor mali raw po. ano po kaya solution doon?

[@danielsardan3565]

Same question din maam kung pano po gawin

[@ignaciomarygrace2182]

Paano po kapag nag negative ung F or anova value?

[@RhenaSalazar-es6nq]

ma'am paano po mag compute ng two way anova??

[@kaylal.malabanan1549]

Hello po Ma'am, ask ko lang po kung ano po ang formula na ginamit po dito sa excel na one way anova at independent t-test po. Need pa din po ba ilagay ang ang formula sa chapter 3 kahit excel po ginamit na pagcocompute. Sana masagot po.Salamat po☺❤

[@LearnWithMayora]

Hello. Yes, need pa ilagay ang formula nila sa chapter 3 even if excel ang ginamit sa pagcompute.

[@kaylal.malabanan1549]

@@LearnWithMayora Ma'am, paano po malalaman ang ginamit na formula po dito. Thank you so much po. Ma'am🥰❤

[@diannamagallon2515]

@@LearnWithMayora Ano po ang formula ma'am?

[@joanespinosa693]

Hello po ma'am :) pano po yung pos hoc po ma'am, since na reject po hypothesis ko po??

[@LearnWithMayora]

Hello. For post hoc, gagamit ka ng t-test for every pair of variables. For example, if ang demographic profile mo ay grade level sa JHS (Grade 7, 8, 9, and 10), bale mag-t-test ka for the responses ng 1st pair (Gr. 7 and 8); another t-test for the 2nd pair (Gr. 7 and 9): another t-test for the next pair (Gr. 7 and 10), and so on hanggang sa ma-t-test mo lahat ng possible pairs. Dito, dapat may makita kang 1 or more na reject din ang hypothesis to claim that your ANOVA computation is correct.

[@justinlargado432]

@@LearnWithMayora Hello, Ma'am anong t-test po gagmitin sa excel? A.Paired two sample for means B. Sample assuming equal variance, C. Sample Assuming unequal variance.

[@LearnWithMayora]

Hello. Depende sa SOP ninyo: A. Paired t-test if you have 2 groups and each respondent has an equivalent pair in the other group B. Sample t-test assuming equal variance if you saw that the variance of the groups are equal. C. Sample t-test assuming unequal variance if the variance is not known/given.

[@carloserquina4509]

Goodevening po maam, Pwedi po ba ako makahingi ng powertpoint po at nung data po? salamat po maam :)

[@joecellemanalo4024]

Hello po! Good day Ma'am, Paano po i eexplain ito? Since, nakapag ANOVA po ako, ang result po ay may significant dif. dumiretso po ako mag T-test para sa post-hoc. Ang problem ko po, paano po sya i explain? ex. G.7 to G.8 - Accept Null G.7 to G.9 - Accept Null G.7 to G.10 - Reject Null G.8 to G. 9 - Reject Null G.8 to G. 10 - Reject Null G.9 to G.10 - Reject Null Thank you in advance po

[@johnmichaeldelrosario4725]

Hello Ma'am :) What if po ang profile naman ang tinitignan kung may significant variations sa perception ng students? Paano po makuha iyon? Thank you po. New subscriber :)

[@LearnWithMayora]

Hello! Depende yun sa profile. If yung profile ay may 2 choices (for example: male/female para sa sex) then pwede kang mag-t-test for two sample mean or chi-square. Otherwise, if the profile ay may 3 or more choices (for example, Grade 7,8,9,10 for grade level), then you can use This one way ANOVA or use chi-square.

[@lycaangeliegarcia7927]

Wala pong data analysis sa excel ko po

[@LearnWithMayora]

Hi! May need pang i-install sa excel. This next video will guide you kung papano yun: kzbin.info/www/bejne/qWHLaKGgacqWp8Usi=AS9nZUt4hNpCnx4S

[@ScriptureSmarts28]

hello po ask ko lang po what if tatlo po yung variables ko pero 2 groups lang po, pwede pa rin ba akong gumamit ng one way anova?

[@LearnWithMayora]

Hello. Pwede naman, as long as "significant difference" ang nasa SOP.

[@jheanayjoven5121]

hello maam! sana po mapansin nyo ako ang experiment study kopo conducted using RCBD and ANOVA to determine the level of significance among treatments the results po wala po siyang significants ni isa pero the study was successful, lasi ang hinahanap ng panel pano maeexplain ng maayos po?

[@LearnWithMayora]

Hello. Finding no significant relationship/difference is okay. Tama ka na hindi yun sukatan if successful and research or hindi. Ang suggestion ko (tho baka late na ito, sorry) is to search for similar researches who arrived with the same result na insignificant. Then tingnan mo kung paano nila inexplain yung conclusion at recommmendations. Good luck!

[@jecillevelasco8734]

Hi ma'am, pano po magdownload ng one way ANOVA sa excel ma'am ,tnx po...

[@LearnWithMayora]

Hello. Please watch this video on how to do it: kzbin.info/www/bejne/qWHLaKGgacqWp8U