Kuverengera kweChiyero cheMudzidzi muExcel

Chiyero chemudzidzi izita rakajairika reboka rebvunzo dzenhamba (kazhinji, vara rechiLatin "t" rinowedzerwa pamberi peizwi rekuti "chiyero"). Inonyanya kushandiswa kutarisa kana nzira dzemasampuli maviri dzakaenzana. Ngationei maverengero echiyero ichi muExcel uchishandisa basa rakakosha.

Yemudzidzi t-yedzo kuverenga

Kuti tiite masvomhu anoenderana, tinoda basa “MUDZIDZO bvunzo”, muzvinyorwa zvekare zveExcel (2007 nevakuru) - “TEST”, iyo iriwo muzvinyorwa zvemazuva ano kuchengetedza kuenderana nemagwaro ekare.

Basa racho rinogona kushandiswa nenzira dzakasiyana. Ngationgororei sarudzo imwe neimwe zvakasiyana tichishandisa muenzaniso wetafura ine mitsara miviri-makoramu enhamba dzenhamba.

Nzira 1: Kushandisa Basa Wizard

Iyi nzira yakanaka nekuti haufanire kuyeuka fomula yebasa (iyo rondedzero yenharo dzayo). Saka, iyo algorithm yezviito ndeyotevera:

1. Isu tinomira mune chero yemahara sero, tobva tadzvanya pane icon "Isa basa" kuruboshwe rweformula bar.
2. Mufafitera rakavhurwa Basa Wizards sarudza chikamu “Runyorwa ruzere rwearufabheti”, mune runyorwa pazasi tinowana mushandisi “MUDZIDZO bvunzo”, imaka uye tinya OK.
3. Iwindo richaonekwa pachiratidziro chatinozadza nharo dzebasa, mushure mezvo tinodzvanya OK:
   • "Masiv1“Uye "Massive2" - tsanangura huwandu hwemasero ane akateedzana manhamba (munyaya yedu, izvi ndizvo "A2:A7" и "B2:B7") Isu tinogona kuita izvi nemaoko nekupinda macoordinates kubva kukhibhodi, kana kungo sarudza izvo zvinodiwa mutafura pachayo.
   • “Miswe” – Ndinonyora nhamba "1"kana iwe uchida kuita imwe-nzira yekugovera kuverenga, kana "2" - yemativi maviri.
   • “Zano” -mundima iyi ratidza: "1" - kana sampuli iine zvinhu zvinotsamira; "2" - kubva kuzvimiririra; "3" - kubva kune yakazvimirira tsika nekutsauka kusina kuenzana.
4. Nekuda kweizvozvo, iyo yakaverengerwa kukosha kweiyo criterion ichaonekwa musero yedu ine basa.

Nzira 2: isa basa kuburikidza ne "Formulas"

1. Chinja kune tab "Nzira", iyo inewo bhatani "Isa basa", ndizvo zvatinoda.
2. Somugumisiro, ichazarura Basa wizard, zvimwe zviito zvakafanana nezvakatsanangurwa pamusoro apa.

Via tab "Nzira" basa “MUDZIDZO bvunzo” inogona kuitwa zvakasiyana:

1. Muboka rekushandisa "Function Library" tinya pane icon "Zvimwe Zvimwe", mushure mezvo runyoro ruchazarura, umo tinosarudza chikamu "Statistical". Nekupenya kuburikidza nerondedzero yakarongwa, tinogona kuwana mushandisi watinoda.
2. Iyo skrini icharatidza hwindo rekuzadza nharo, izvo zvatakatosangana nazvo kare.

Method 3: Kuisa fomula nemaoko

Vashandisi vane ruzivo vanogona kuita pasina Basa Wizards uye musero inodiwa pakarepo isa fomula ine zvinongedzo kune inodiwa data renji uye mamwe ma parameter. Iyo syntax yebasa kazhinji inotaridzika seizvi:

= STUDENT.TEST(Array1;Array2;Tails;Type)

Taongorora imwe neimwe yenharo muchikamu chekutanga chebhuku. Zvese zvasara kuti zviitwe mushure mekunyora fomula ndeyekudzvanya pinda kuita kuverenga.

mhedziso

Saka, unogona kuverenga t-bvunzo yeMudzidzi muExcel uchishandisa basa rakakosha rinogona kutangwa nenzira dzakasiyana. Zvakare, mushandisi ane mukana wekuti apinde mufomu yekushanda musero yaunoda, zvisinei, mune iyi kesi, iwe uchafanirwa kuyeuka syntax yayo, iyo inogona kunetsa nekuda kwekuti haina kushandiswa kakawanda.