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

Поділитися
Вставка
  • Опубліковано 1 гру 2024

КОМЕНТАРІ • 38

  • @jctors4095
    @jctors4095 2 роки тому

    Thank you mayora.

  • @jeremybisco7968
    @jeremybisco7968 8 днів тому

    thank youuuuuuu po mAaaaaammm

  • @diannamagallon2515
    @diannamagallon2515 2 роки тому +2

    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
      @LearnWithMayora  2 роки тому

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

  • @HanikaUniz
    @HanikaUniz 6 місяців тому

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

  • @markanthonydominguez5290
    @markanthonydominguez5290 2 роки тому

    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
      @LearnWithMayora  2 роки тому

      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

  • @jethroolazo
    @jethroolazo 7 місяців тому

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

  • @johnlloydsaguan1217
    @johnlloydsaguan1217 7 місяців тому

    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
      @danielsardan3565 6 місяців тому

      Same question din maam kung pano po gawin

  • @biernesballonggay15
    @biernesballonggay15 2 роки тому

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

  • @kaylal.malabanan1549
    @kaylal.malabanan1549 2 роки тому

    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
      @LearnWithMayora  2 роки тому +1

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

    • @kaylal.malabanan1549
      @kaylal.malabanan1549 2 роки тому

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

    • @diannamagallon2515
      @diannamagallon2515 2 роки тому

      @@LearnWithMayora Ano po ang formula ma'am?

  • @marinellesamiley9191
    @marinellesamiley9191 2 роки тому

    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
      @LearnWithMayora  2 роки тому

      Hello. If significant relationship, pwede jan ang chi square (ua-cam.com/video/ppPE28gaWXA/v-deo.html)

  • @joanespinosa693
    @joanespinosa693 2 роки тому

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

    • @LearnWithMayora
      @LearnWithMayora  2 роки тому +1

      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
      @justinlargado432 2 роки тому

      @@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
      @LearnWithMayora  2 роки тому +1

      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.

  • @ignaciomarygrace2182
    @ignaciomarygrace2182 2 роки тому

    Paano po kapag nag negative ung F or anova value?

  • @RhenaSalazar-es6nq
    @RhenaSalazar-es6nq 7 місяців тому

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

  • @mariyanli9622
    @mariyanli9622 3 роки тому

    Sana po may multiple linear regression 🙏😭

  • @irmamillena2941
    @irmamillena2941 Рік тому

    Thank you po

  • @carloserquina4509
    @carloserquina4509 2 роки тому

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

  • @honeybaldesanso594
    @honeybaldesanso594 2 роки тому

    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
      @LearnWithMayora  2 роки тому +1

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

  • @lycaangeliegarcia7927
    @lycaangeliegarcia7927 Рік тому

    Wala pong data analysis sa excel ko po

    • @LearnWithMayora
      @LearnWithMayora  11 місяців тому

      Hi! May need pang i-install sa excel. This next video will guide you kung papano yun: ua-cam.com/video/s0h7nj4ecqc/v-deo.htmlsi=AS9nZUt4hNpCnx4S

  • @jheanayjoven5121
    @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
      @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!

  • @joecellemanalo4024
    @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
    @johnmichaeldelrosario4725 3 роки тому

    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
      @LearnWithMayora  3 роки тому +1

      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.

  • @jecillevelasco8734
    @jecillevelasco8734 2 роки тому

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

    • @LearnWithMayora
      @LearnWithMayora  2 роки тому

      Hello. Please watch this video on how to do it: ua-cam.com/video/s0h7nj4ecqc/v-deo.html