Zamkatimu
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.
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.
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:
- Timayima mu cell iliyonse yaulere, kenako dinani chizindikirocho "Isert ntchito" kumanzere kwa formula bar.
- Pa zenera lotseguka Ntchito Wizards sankhani gulu “Mndandanda wa zilembo zonse”, pamndandanda womwe uli pansipa timapeza woyendetsa “MAYESO OPHUNZIRA”, ikani chizindikiro ndikudina OK.
- 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.
- Zotsatira zake, mtengo wowerengeredwa wa muyeso udzawonekera mu selo lathu ndi ntchitoyo.
Njira 2: ikani ntchito kudzera mu "Formulas"
- Sinthani ku tabu "Mitundu", yomwe ilinso ndi batani "Isert ntchito", zomwe ndi zomwe timafunikira.
- Zotsatira zake, zidzatsegulidwa Wizard ntchito, zochita zina zomwe zikufanana ndi zomwe tafotokozazi.
Kudzera pa tabu "Mitundu" ntchito “MAYESO OPHUNZIRA” akhoza kuyendetsedwa mosiyana:
- 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.
- 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)
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.