Nguva yekuvimba muExcel. 2 Nzira dzeKuverengera Kuvimbika Kupindirana muExcel

Nguva yekuvimba inoverengerwa kugadzirisa mibvunzo yenhamba. Kuwana iyi nhamba pasina rubatsiro rwekombuta kwakaoma, saka iwe unofanirwa kushandisa maExcel maturusi kana iwe uchida kutsvaga inogamuchirika siyana yekutsauka kubva kumuenzaniso zvinoreva.

Kugadzira Nguva Yeruvimbo neCONFID.NORM Operator

Mushandisi ndewechikamu che "Statistical". Mune shanduro dzekare, inonzi "TRUST", basa rayo raisanganisira nharo dzakafanana.

Basa rakazara rinotaridzika seizvi: =CONFIDENCE.NORM(Alpha,Standard,Size).

Funga nezvemushandisi formula nemakakatanwa (imwe neimwe yadzo inofanirwa kuoneka mukuverenga):

1. "Alpha" inoratidza mwero wekukosha panobva kuverenga.

Pane nzira mbiri dzekuverenga nhanho yekuwedzera:

• 1-(Alfa) - yakakodzera kana nharo iri coefficient. Muenzaniso: 1-0,4=0,6 (0,4=40%/100%);
• (100-(Alpha))/100 - fomula rinoshandiswa pakuverengera nguva yacho sechikamu. Muenzaniso: (100-40)/100=0,6.

2. Kutsauswa kwechiyero ndiko kutsauka kunobvumirwa mune imwe sampuli.
3. Saizi - huwandu hweruzivo rwakaongororwa

Teerera! Iyo TRUST mushandisi anogona achiri kuwanikwa muExcel. Kana iwe uchida kuishandisa, tsvaga muchikamu che "Kuenderana".

Ngatitarisei fomula iri kuita. Iwe unofanirwa kugadzira tafura ine akawanda manhamba ekuverenga kukosha. Fungidzira kuti chiyero chekutsauka ndeye 7. Chinangwa ndechekutsanangura nguva ine chivimbo che80%.

Hazvina kudikanwa kupinda kutsauka uye chiyero chekuvimba pane pepa, idzi data dzinogona kuiswa nemaoko. Kuverenga kunoitika mumatanho akati wandei:

1. Sarudza sero isina chinhu uye vhura iyo "Function Manager". Ichaonekwa pachiratidziri mushure mekudzvanya pa "F (x)" icon padivi peformula bar. Iwe unogona zvakare kusvika kumenu yebasa kuburikidza ne "Formulas" tab pane toolbar, muchikamu chayo chekuruboshwe pane "Insert function" bhatani rine chiratidzo chimwe chete.

2. Sarudza chikamu che "Statistical" uye tsvaga pakati pezvinyorwa zvinhu mushandisi TRUST.NORM. Iwe unofanirwa kudzvanya pairi uye tinya "OK".

3. The Arguments Zadza hwindo richavhurwa. Mutsetse wekutanga unofanirwa kuve neformula yekuverenga iyo "Alpha" nharo. Zvinoenderana nemamiriro ezvinhu, danho rekuvimba rinoratidzwa sechikamu, saka isu tinoshandisa yechipiri fomula: (100-(Alpha))/100.
4. Kutsauka kwakajairika kwave kutozivikanwa, ngatinyore mumutsara kana kusarudza sero rine data rakaiswa papeji. Mutsara wechitatu une nhamba yezvinyorwa mutafura - pane gumi. Mushure mekuzadza minda yese, tinya "Enter" kana "OK".

Basa racho rinogona kuve rakagadzirwa kuitira kuti kushandura ruzivo kurege kuita kuti kuverenga kukundikana. Ngationei kuti tingazviita sei nhanho nhanho.

1. Kana iyo "Size" munda isati yazadzwa, tinya pairi, uchiita kuti ishande. Ipapo tinovhura menyu yebasa - iri kuruboshwe rwechidzitiro pamutsetse mumwechete neformula bar. Kuti uvhure, tinya museve. Iwe unofanirwa kusarudza chikamu che "Mamwe mabasa", iyi ndiyo yekupedzisira yekupinda mune iyo rondedzero.

2. Iyo Function Manager ichadzoka zvakare. Pakati pevashandi vehuwandu, iwe unofanirwa kuwana iyo "Account" basa uye sarudza iyo.

Zvinokosha! Iwo COUNT basa nharo dzinogona kuva nhamba, maseru, kana mapoka emaseru. Muchiitiko ichi, iyo yekupedzisira ichaita. Pakazara, iyo fomula haigone kuve inopfuura 255 nharo.

3. Nzvimbo yepamusoro inofanira kunge iine ma values ​​akaiswa muchikamu chesero. Dzvanya panharo yekutanga, sarudza koramu isina musoro, uye tinya bhatani raOK.

Iko kukosha kwepakati kuchaonekwa muchitokisi. Iyi nhamba yakawanikwa uchishandisa muenzaniso data: 2,83683532.

Kutsunga kwenguva yekuvimba kuburikidza neCONFIIDENCE.STUDENT

Uyu mushandisi anoitirwawo kuverenga kutsauswa kwemhando. Mukuverenga, imwe nzira inoshandiswa - inoshandisa kugovera kweMudzidzi, kunze kwekunge kupararira kweukoshi kusingazivikanwe.

Iyo fomula inosiyana neyekare chete mune opareta. Zvinoita seizvi: =TRUST.MUDZIDZO(Arufa;Ctand_off; size).

Isu tinoshandisa tafura yakachengetwa yekuverenga kutsva. Kutsauka kwakajairika mudambudziko idzva kunova nharo isingazivikanwe.

1. Vhura "Function Manager" mune imwe yenzira dzatsanangurwa pamusoro apa. Unofanira kuwana CONFIDENCE.STUDENT basa mu "Statistical" chikamu, sarudza uye baya "OK".

2. Zadzai basa nharo. Mutsetse wekutanga wakafanana fomula: (100-(Alpha))/100.
3. Kutsauka hakuzivikanwi, zvichienderana nemamiriro edambudziko. Kuti tiverenge, tinoshandisa imwe fomula. Iwe unofanirwa kudzvanya pachikamu chechipiri muhwindo rekupokana, vhura menyu yemabasa uye sarudza "Mamwe mabasa" chinhu.

4. Inoda STDDEV.B (nemuenzaniso) mushandisi muchikamu cheStatistical. Sarudza iyo uye tinya OK.

5. Isu tinozadza nharo yekutanga yehwindo rakavhurwa nehuwandu hwemasero ane kukosha pasina kufunga nezvemusoro. Haufanire kudzvanya OK mushure meizvozvo.

6. Ngatidzokerei kuTRUST.STUDENT nharo nekudzvanya kaviri pane ichi chinyorwa mubhawa remafomula. Muchikamu che "Size", isa COUNT mushandisi, senguva yekupedzisira.

Mushure mekudzvanya "Enter" kana "OK" kukosha kutsva kwenguva yekuvimba kuchaonekwa muchitokisi. Sekureva kweMudzidzi, zvakazove zvishoma - 0,540168684.

Kusarudza miganhu yepakati pamativi ose maviri

Kuti uverenge miganhu yepakati, iwe unofanirwa kuziva kuti ndeipi iyo avhareji kukosha kwayo, uchishandisa iyo AVERAGE basa.

1. Vhura iyo "Function Manager" uye sarudza yaunoda opareta muchikamu che "Statistical".

2. Wedzera boka remasero ane zvakakosha kune yekutanga nharo ndima uye tinya bhatani OK.

3. Iye zvino unogona kutsanangura miganhu yekurudyi uye kuruboshwe. Zvinotora mamwe masvomhu ari nyore. Kuverengera kwemuganhu wekurudyi: sarudza sero isina chinhu, wedzera maseru mairi neavhareji yekuvimba uye avhareji kukosha.

4. Kuti uone muganhu wekuruboshwe, nguva yekuvimba inofanira kubviswa kubva kune zvinoreva.

5. Isu tinoita maoparesheni mamwe chete nekanguva keMudzidzi. Nekuda kweizvozvo, tinowana miganhu yenguva mushanduro mbiri.

mhedziso

Excel's "Function Manager" inoita kuti zvive nyore kuwana nguva yekuvimba. Inogona kutsanangurwa nenzira mbiri, iyo inoshandisa nzira dzakasiyana dzekuverenga.