Isikhawu sokuzithemba ku-Excel. Izindlela ezi-2 zokubala isikhawu sokuzithemba ku-Excel

Isikhawu sokuzethemba sibalwa ukuze kuxazululwe imibuzo yezibalo. Ukuthola le nombolo ngaphandle kosizo lwekhompyutha kunzima impela, ngakho-ke kufanele usebenzise amathuluzi e-Excel uma udinga ukuthola uhla olwamukelekayo lokuchezuka kuncazelo yesampula.

Ukwenza ikhompuyutha Isikhathi Sokuqiniseka Nge-CONFID.NORM Operator

Umsebenzisi uyingxenye "yezibalo". Ezinguqulweni zangaphambili, ibizwa ngokuthi "TRUST", umsebenzi wayo wawuhlanganisa izimpikiswano ezifanayo.

Umsebenzi ophelele ubukeka kanje: =CONFIDENCE.NORM(Alpha,Standard,Usayizi).

Cabangela ifomula yesisebenzisi ngama-agumenti (nganye yazo kufanele ivele esibalweni):

1. “I-Alpha” ibonisa izinga lokubaluleka okusekelwe kulo isibalo.

Kunezindlela ezimbili zokubala ileveli eyengeziwe:

• 1-(Alpha) - kufanelekile uma i-agumenti iyi-coefficient. Isibonelo: 1-0,4=0,6 (0,4=40%/100%);
• (100-(Alpha))/100 - ifomula isetshenziswa lapho kubalwa isikhawu njengephesenti. Isibonelo: (100-40)/100=0,6.

2. Ukuchezuka okujwayelekile ukuchezuka okuvumelekile kusampula ethile.
3. Usayizi - inani lolwazi oluhlaziywe

Nakani! Umsebenzisi we-TRUST usengatholakala ku-Excel. Uma udinga ukuyisebenzisa, yibheke esigabeni esithi “Ukuhambisana”.

Ake sihlole ifomula esebenzayo. Udinga ukudala ithebula elinamanani amaningi okubala ezibalo. Cabanga ukuthi ukuchezuka okujwayelekile kungu-7. Umgomo uwukuchaza isikhawu ngezinga lokuzethemba elingu-80%.

Akudingekile ukufaka ukuphambuka kanye nezinga lokuzethemba eshidini, le datha ingafakwa ngesandla. Ukubala kwenzeka ngezinyathelo ezimbalwa:

1. Khetha iseli elingenalutho bese uvula "Umphathi Womsebenzi". Izovela esikrinini ngemva kokuchofoza isithonjana esithi “F (x)” eduze kwebha yefomula. Ungakwazi futhi ukufinyelela kumenyu yomsebenzi ngokusebenzisa ithebhu ethi “Amafomula” kubha yamathuluzi, engxenyeni yayo engakwesokunxele kunenkinobho ethi “Faka umsebenzi” enophawu olufanayo.

2. Khetha ingxenye ethi "Izibalo" futhi uthole phakathi kwezinto zohlu u-opharetha ongu-TRUST.NORM. Udinga ukuchofoza kuyo bese uchofoza "OK".

3. Iwindi Lokugcwalisa Izingxabano lizovuleka. Umugqa wokuqala kufanele uqukathe ifomula yokubala i-agumenti ethi “Alpha”. Ngokusho kwesimo, izinga lokuthembela liboniswa njengephesenti, ngakho-ke sisebenzisa ifomula yesibili: (100-(Alpha))/100.
4. Ukuchezuka okujwayelekile sekuvele kwaziwa, masiyibhale emugqeni noma sikhethe iseli enedatha ebekwe ekhasini. Umugqa wesithathu uqukethe inani lamarekhodi etafuleni - kukhona angu-10 kuwo. Ngemva kokugcwalisa zonke izinkambu, cindezela "Enter" noma "OK".

Umsebenzi ungazenzakalela ukuze ukushintsha ulwazi kungabangeli ukubala kwehluleke. Ake sithole ukuthi sikwenza kanjani isinyathelo ngesinyathelo.

1. Uma inkambu ethi “Usayizi” ingakagcwaliswa, chofoza kuyo, uyenze isebenze. Bese sivula imenyu yomsebenzi - itholakala ngakwesokunxele kwesikrini kulayini ofanayo nebha yefomula. Ukuze uyivule, chofoza umcibisholo. Udinga ukukhetha ingxenye ethi "Eminye imisebenzi", lokhu okokugcina okufakwayo ohlwini.

2. Umphathi Womsebenzi uzophinde avele. Phakathi kwama-opharetha ezibalo, udinga ukuthola umsebenzi we- "Akhawunti" bese uwukhetha.

Kubalulekile! COUNT ama-agumenti omsebenzi angaba izinombolo, amaseli, noma amaqembu amaseli. Kulokhu, lokhu okulandelayo kuzokwenza. Sekukonke, ifomula ayikwazi ukuba nezimpikiswano ezingaphezu kuka-255.

3. Inkambu ephezulu kufanele iqukathe amanani aqoqwe ebangeni lamaseli. Chofoza ukuphikisana kokuqala, khetha ikholomu ngaphandle kweheda, bese uchofoza inkinobho ethi KULUNGILE.

Inani lesikhawu lizovela kuseli. Le nombolo itholwe kusetshenziswa idatha yesibonelo: 2,83683532.

Ukunqunywa kwesikhawu sokuzithemba nge-CONFIIDENCE.STUDENT

Lo opharetha futhi uhloselwe ukubala ububanzi bokuchezuka. Ezibalweni, kusetshenziswa isu elihlukile – lisebenzisa ukusatshalaliswa koMfundi, inqobo nje uma ukusabalala kwevelu kungaziwa.

Ifomula ihlukile kwedlule kuphela ku-opharetha. Kubukeka kanjena: =TRUST.SUDENT(Alpha;Ci-tand_off;usayizi).

Sisebenzisa ithebula elilondoloziwe ukuze sibe nezibalo ezintsha. Ukuchezuka okujwayelekile enkingeni entsha kuba impikiswano engaziwa.

1. Vula "Umphathi Womsebenzi" ngenye yezindlela ezichazwe ngenhla. Udinga ukuthola umsebenzi othi CONFIDENCE.STUDENT esigabeni esithi "Izibalo", yikhethe bese uchofoza okuthi "KULUNGILE".

2. Gcwalisa izimpikiswano zomsebenzi. Umugqa wokuqala uyifomula efanayo: (100-(Alpha))/100.
3. Ukuchezuka akwaziwa, ngokwesimo senkinga. Ukuyibala, sisebenzisa ifomula eyengeziwe. Udinga ukuchofoza inkambu yesibili efasiteleni lezimpikiswano, vula imenyu yemisebenzi bese ukhetha into ethi "Eminye imisebenzi".

4. Idinga i-STDDEV.B (ngesampula) u-opharetha esigabeni Sezibalo. Ikhethe bese uchofoza okuthi KULUNGILE.

5. Sigcwalisa ingxabano yokuqala yewindi elivuliwe ngohlu lwamaseli anamanani ngaphandle kokucabangela unhlokweni. Awudingi ukuchofoza okuthi KULUNGILE ngemva kwalokho.

6. Ake sibuyele emuva kuzimpikiswano ze-TRUST.STUDENT ngokuchofoza kabili kulo mbhalo kubha yefomula. Enkambini ethi "Usayizi", setha u-opharetha ongu-COUNT, njengokugcina.

Ngemva kokucindezela okuthi “Enter” noma “KULUNGILE” inani elisha lesikhawu sokuzethemba lizovela kuseli. Ngokusho koMfundi, kuvele ukuthi kuncane - 0,540168684.

Ukunquma imingcele yesikhawu kuzinhlangothi zombili

Ukuze ubale imingcele yesikhawu, udinga ukuthola ukuthi liyini inani elimaphakathi laso, usebenzisa umsebenzi othi AVERAGE.

1. Vula "Umphathi Womsebenzi" bese ukhetha u-opharetha oyifunayo esigabeni esithi "Izibalo".

2. Engeza iqembu lamaseli aqukethe amanani kunkambu yempikiswano yokuqala bese uchofoza inkinobho ethi KULUNGILE.

3. Manje usungakwazi ukuchaza imingcele yesokudla nesobunxele. Kuzothatha izibalo ezilula. Ukubalwa komngcele ongakwesokudla: khetha iseli elingenalutho, engeza amaseli kulo ngesikhawu sokuzithemba kanye nenani elimaphakathi.

4. Ukuze unqume imajini yesokunxele, isikhawu sokuzithemba kufanele sisuswe kuncazelo.

5. Senza imisebenzi efanayo ngesikhawu sokuzithemba soMfundi. Ngenxa yalokho, sithola imingcele yesikhawu ezinguqulweni ezimbili.

Isiphetho

"Umphathi Womsebenzi" we-Excel wenza kube lula ukuthola isikhawu sokuzithemba. Inganqunywa ngezindlela ezimbili, ezisebenzisa izindlela ezihlukene zokubala.