Chimodzi mwa zida zodziŵika bwino kwambiri ndi chiwerengero cha Ophunzira. Amagwiritsidwa ntchito poyeza chiwerengero cha ziwerengero zosiyanasiyana za pawiri. Microsoft Excel ili ndi ntchito yapadera yowerengera chizindikiro ichi. Tiyeni tiphunzire momwe tingawerengere t-test test ya Ophunzira ku Excel.
Tanthauzo la nthawi
Koma, poyambira, tiyeni tipitirizebe kudziwa chomwe chimapangitsa ophunzira kukhala ndi chiwerengero. Chizindikiro ichi chimagwiritsidwa ntchito poyesa kulingana kwa chiwerengero choyenera cha zitsanzo ziwiri. Izi zikutanthauza kuti kusiyana pakati pa magulu awiri a deta. Pa nthawi imodzimodziyo, njira zambiri zimagwiritsidwa ntchito kuti mudziwe tsatanetsatane. Chizindikirocho chikhoza kuwerengedwa poganizira njira imodzi kapena njira ziwiri.
Kuwerengetsa chizindikiro cha Excel
Tsopano tikutembenukira ku funso la momwe tingawerengere chizindikiro ichi mu Excel. Ikhoza kupangidwa kudzera mu ntchitoyo KUYESERA KUYESA. M'masulidwe a Excel 2007 ndi poyamba, idatchedwa TESTEST. Komabe, izo zinatsalira mu matembenuzidwe a pambuyo pake kuti zikhale zofanana, koma akulimbikitsidwa kuti azigwiritsa ntchito zamakono - KUYESERA KUYESA. Ntchitoyi ingagwiritsidwe ntchito m'njira zitatu, zomwe zidzakambidwe mwatsatanetsatane.
Njira 1: Wachipangizo Wothandizira
Njira yosavuta yowerengera chizindikiro ichi ndi kupyolera mu ntchito ya wizara.
- Timapanga tebulo ndi mizere iwiri ya zinthu.
- Dinani pa selo iliyonse yopanda kanthu. Timakanikiza batani "Ikani ntchito" kutcha wizard ntchito.
- Pambuyo pa ntchito ya wizara yatsegulidwa. Kuyang'ana mtengo ku mndandanda TESTEST kapena KUYESERA KUYESA. Sankhani ndipo dinani pa batani. "Chabwino".
- Fesholo yotsutsana ikutsegula. M'minda "Massive1" ndi "Massiv2" lowetsani zigawo zogwirizana ndi mizere iwiri yofanana. Izi zikhoza kuchitika mophweka mwa kusankha maselo omwe mukufuna ndi chithunzithunzi.
Kumunda "Miyendo" lowetsani mtengo "1"ngati chiwerengerocho chimapangidwa ndi njira yogawa mbali imodzi, ndi "2" Pankhani ya kufalitsa njira ziwiri.
Kumunda Lembani " Zotsatira zotsatirazi zalowa:
- 1 - chitsanzocho chili ndi zowonjezera;
- 2 - chitsanzochi chimakhala ndi zoyenera;
- 3 - chitsanzochi chimakhala ndi zoyendetsera zokhazokha zomwe zimasiyanasiyana.
Deta yonse ikadzazidwa, dinani pa batani. "Chabwino".
Kuwerengera kumachitika, ndipo zotsatira zimasonyezedwa pazenera pa selo yoyamba yosankhidwa.
Njira 2: Gwiritsani ntchito tab "Ma formula"
Ntchito KUYESERA KUYESA Mukhozanso kuyitana pakupita ku tabu "Maonekedwe" pogwiritsa ntchito batani lapadera pa tepi.
- Sankhani selo kusonyeza zotsatira pa pepala. Pitani ku tabu "Maonekedwe".
- Dinani pa batani. "Ntchito Zina"ili pa tepi muzitali za zida "Laibulale ya Ntchito". M'ndandanda wotseguka, pitani ku gawolo "Zotsatira". Kuchokera pa zosankha zomwe mwasankha mungasankhe "STUEDENT.TEST".
- Zenera lazitsulo likuyamba, zomwe tinaphunzira mwatsatanetsatane pofotokoza njira yapitayi. Zochita zonse zoonjezera ziri chimodzimodzi ndi momwemo.
Njira 3: Kuwongolera Buku
Mchitidwe KUYESERA KUYESA Mukhozanso kulowamo pamanja pa pepala kapena mu chingwe. Mawu ake omasulira ndi awa:
= KUYESEDWA KWOPHUNZITSIRA (Mzere1; Array2; Miyendo; Mtundu)
Zomwe zifukwa zonse zimatanthauza zimaganiziridwa pofufuza njira yoyamba. Mfundo izi ziyenera kukhala m'malo mwa ntchitoyi.
Deta itatha, yesani batani Lowani kuti muwonetse zotsatirapo pawindo.
Monga mukuonera, mayesero a Excel a ophunzira amawerengedwa mosavuta komanso mwamsanga. Chinthu chachikulu ndi chakuti wogwiritsa ntchito amene akuwerengera ayenera kumvetsa zomwe iye ali ndi deta yomwe akuwunikira. Pulogalamuyo imakhala yowerengera mwachindunji.
