Kuwerengera muyeso wa Student mu Excel

Mulingo wa ophunzira ndi dzina lodziwika bwino la gulu la mayeso owerengera (nthawi zambiri, chilembo chachilatini "t" chimawonjezedwa liwu loti "choyimira") lisanayambike). Nthawi zambiri amagwiritsidwa ntchito kuwunika ngati njira za zitsanzo ziwiri ndizofanana. Tiyeni tiwone momwe tingawerengere izi mu Excel pogwiritsa ntchito ntchito yapadera.

Timasangalala

Kuwerengera kwa mayeso a t

Kuti tichite mawerengedwe ofanana, timafunikira ntchito “MAYESO OPHUNZIRA”, m'matembenuzidwe akale a Excel (2007 ndi achikulire) - "TEST", yomwe ilinso m'mabuku amakono kuti ikhale yogwirizana ndi zolemba zakale.

Ntchitoyi ingagwiritsidwe ntchito m'njira zosiyanasiyana. Tiyeni tiwunike njira iliyonse padera pogwiritsa ntchito chitsanzo cha tebulo lomwe lili ndi mizere iwiri-mizere ya manambala.

Kuwerengera kwa Ophunzira mu Excel

Njira 1: Kugwiritsa Ntchito Wizard

Njira imeneyi ndi yabwino chifukwa simuyenera kukumbukira chilinganizo cha ntchito (mndandanda wa mfundo zake). Choncho, algorithm ya zochita ndi motere:

  1. Timayima mu cell iliyonse yaulere, kenako dinani chizindikirocho "Isert ntchito" kumanzere kwa formula bar.Kuwerengera kwa Ophunzira mu Excel
  2. Pa zenera lotseguka Ntchito Wizards sankhani gulu “Mndandanda wa zilembo zonse”, pamndandanda womwe uli pansipa timapeza woyendetsa “MAYESO OPHUNZIRA”, ikani chizindikiro ndikudina OK.Kuwerengera kwa Ophunzira mu Excel
  3. Zenera lidzawonekera pazenera momwe timadzaza mfundo za ntchitoyo, pambuyo pake timasindikiza OK:
    • "Masiv1"Ndipo "Massive2" - tchulani ma cell omwe ali ndi manambala angapo (kwa ife, izi ndi "A2:A7" и "B2:B7"). Titha kuchita izi pamanja polowetsa zolumikizira kuchokera pa kiyibodi, kapena kungosankha zomwe mukufuna patebulo lokha.
    • "Michira" - Ndikulemba nambala "1"ngati mukufuna kuwerengera njira imodzi yogawa, kapena "2" - kwa mbali ziwiri.
    • "Tip" - mu gawo ili wonetsani: "1" - ngati chitsanzocho chili ndi mitundu yodalira; "2" - kuchokera paokha; "3" - kuchokera pamakhalidwe odziyimira pawokha ndi kupatuka kosagwirizana.Kuwerengera kwa Ophunzira mu Excel
  4. Zotsatira zake, mtengo wowerengeredwa wa muyeso udzawonekera mu selo lathu ndi ntchitoyo.Kuwerengera kwa Ophunzira mu Excel

Njira 2: ikani ntchito kudzera mu "Formulas"

  1. Sinthani ku tabu "Mitundu", yomwe ilinso ndi batani "Isert ntchito", zomwe ndi zomwe timafunikira.Kuwerengera kwa Ophunzira mu Excel
  2. Zotsatira zake, zidzatsegulidwa Wizard ntchito, zochita zina zomwe zikufanana ndi zomwe tafotokozazi.

Kudzera pa tabu "Mitundu" ntchito “MAYESO OPHUNZIRA” akhoza kuyendetsedwa mosiyana:

  1. Mu gulu la zida "Function Library" dinani chizindikirocho “Zina Zina”, pambuyo pake mndandanda udzatsegulidwa, momwe timasankha gawo "Statistical". Poyang'ana mndandanda womwe waperekedwa, titha kupeza woyendetsa yemwe tikufuna.Kuwerengera kwa Ophunzira mu Excel
  2. Chophimbacho chidzawonetsa zenera kuti mudzaze mikangano, yomwe takumana nayo kale.

Njira 3: Kulowetsa fomula pamanja

Ogwiritsa odziwa bwino angathe kuchita popanda Ntchito Wizards ndipo mu cell yofunikira nthawi yomweyo lowetsani chilinganizo chokhala ndi maulalo amitundu yomwe mukufuna ndi magawo ena. Ma syntax a ntchito nthawi zambiri amawoneka motere:

= STUDENT.TEST(Array1;Array2;Michira;Mtundu)

Kuwerengera kwa Ophunzira mu Excel

Tasanthula mkangano uliwonse mu gawo loyamba la zofalitsa. Zomwe zimatsala kuti zichitike mutalemba fomula ndikusindikiza Lowani kuti awerenge.

Kutsiliza

Chifukwa chake, mutha kuwerengera mayeso a Wophunzira ku Excel pogwiritsa ntchito ntchito yapadera yomwe imatha kukhazikitsidwa m'njira zosiyanasiyana. Komanso, wogwiritsa ntchito ali ndi mwayi wolowetsa nthawi yomweyo ndondomeko ya ntchito mu selo yomwe mukufuna, komabe, mu nkhani iyi, muyenera kukumbukira mawu ake, omwe angakhale ovuta chifukwa chakuti sagwiritsidwa ntchito nthawi zambiri.

Siyani Mumakonda