Ibala Isikhathi Sokuqiniseka ku-Excel

I-Excel isetshenziselwa ukwenza imisebenzi yezibalo eyahlukene, omunye wayo ukubala isikhathi sokuzithemba, esisetshenziswa njengokumiselela okufanele kakhulu kwesilinganiso sephoyinti ngosayizi omncane wesampula.

Sifuna ukuqaphela zisuka nje ukuthi yona kanye inqubo yokubala isikhathi sokuzethemba iyinkimbinkimbi, nokho, ku-Excel kunenani lamathuluzi aklanyelwe ukwenza lo msebenzi kube lula. Ake sizibheke.

Ukubalwa kwesikhawu sokuzithemba

Kudingeka isikhawu sokuzethemba ukuze unikeze isilinganiso sesikhathi kudatha ethile emile. Inhloso enkulu yalo msebenzi ukususa ukungaqiniseki kwesilinganiso samaphuzu.

Kunezindlela ezimbili zokwenza lo msebenzi ku-Microsoft Excel:

• I-Operator INKONZO YOKUZETHEMBA - esetshenziswa ezimeni lapho kwaziwa khona ukuhlakazeka;
• I-Operator THEMBELA.MFUNDIlapho ukuhluka kungaziwa.

Ngezansi sizohlaziya ngesinyathelo ngesinyathelo zombili izindlela ekusebenzeni.

Indlela 1: Isitatimende se-TRUST.NORM

Lo msebenzi wethulwa okokuqala ku-arsenal yohlelo ku-Excel 2010 edition (ngaphambi kwale nguqulo, yathathelwa indawo opharetha “bethenjiwe”). Umsebenzisi ufakiwe esigabeni "sezibalo".

Ifomula Yomsebenzi INKONZO YOKUZETHEMBA kubukeka kanjena:

=ДОВЕРИТ.НОРМ(Альфа;Станд_откл;Размер)

Njengoba singabona, umsebenzi unezimpikiswano ezintathu:

• "Alpha" iyinkomba yezinga lokubaluleka, elithathwa njengesisekelo sokubala. Izinga lokuzethemba libalwa ngale ndlela elandelayo:
  • 1-"Альфа". Lesi sisho sisebenza uma inani "Alpha" yethulwe njenge-coefficient. Ngokwesibonelo, 1-0,7 0,3 =, lapho 0,7=70%/100%.
  • (100-"Альфа")/100. Lesi sisho sizosetshenziswa uma sicabangela ileveli yokuzethemba nevelu "Alpha" ngamaphesenti. Ngokwesibonelo, (100-70) / 100 = 0,3.
• “Ukuchezuka okujwayelekile” - ngokulandelana, ukuchezuka okujwayelekile kwesampula yedatha ehlaziyiwe.
• "Usayizi" usayizi wesampula yedatha.

Qaphela: Kulo msebenzi, ukuba khona kwawo womathathu ama-agumenti kuyimfuneko.

Umsebenzisi "bethenjiwe”, eyasetshenziswa ezinguqulweni zangaphambili zohlelo, iqukethe izimpikiswano ezifanayo futhi yenza imisebenzi efanayo.

Ifomula Yomsebenzi UTHEMBEKILE Ngokulandelayo:

=ДОВЕРИТ(Альфа;Станд_откл;Размер)

Akukho mehluko kufomula ngokwayo, igama lomsebenzisi kuphela elihlukile. Ku-Excel 2010 kanye nezinhlelo zakamuva, lo opharetha usesigabeni sokuvumelana. Ezinguqulweni ezindala zohlelo, itholakala esigabeni semisebenzi emile.

Umngcele wesikhawu sokuzithemba unqunywa ifomula elandelayo:

X+(-)ДОВЕРИТ.НОРМ

lapho Х inani eliyisilinganiso ngaphezu kobubanzi obushiwo.

Manje ake sibone ukuthi singawasebenzisa kanjani la mafomula ekusebenzeni. Ngakho-ke, sinetafula elinedatha ehlukahlukene kusuka kuzilinganiso eziyi-10 ezithathiwe. Kulokhu, ukuchezuka okujwayelekile kwesethi yedatha ngu-8.

Umsebenzi wethu ukuthola inani lesikhawu sokuzithemba ngezinga lokuzethemba elingu-95%.

1. Okokuqala, khetha iseli ukuze ubonise umphumela. Bese sichofoza inkinobho "Faka umsebenzi" (ngakwesokunxele kwebha yefomula).
2. Iwindi le-Function Wizard liyavuleka. Ngokuchofoza esigabeni samanje semisebenzi, khulisa uhlu bese uchofoza umugqa kuwo "Izibalo".
3. Ohlwini oluhlongozwayo, chofoza ku-opharetha “INKOSI YOKUZEthemba”, bese ucindezela OK.
4. Sizobona iwindi elinezilungiselelo zezimpikiswano zomsebenzi, sigcwalisa esicindezela inkinobho OK.
   • ensimini "Alpha" khombisa izinga lokubaluleka. Umsebenzi wethu uthatha izinga lokuzethemba elingu-95%. Ukushintsha leli nani kufomula yokubala, esiyicabange ngenhla, sithola inkulumo ethi: (100-95)/100. Sibhala endaweni yokungqubuzana (noma ungabhala ngokushesha umphumela wokubala olingana no-0,05).
   • ensimini "std_off" ngokwemibandela yethu, sibhala inombolo yesi-8.
   • kunkambu ethi "Usayizi", cacisa inani lezinto okufanele zihlolwe. Esimweni sethu, kuthathwe izilinganiso eziyi-10, ngakho-ke sibhala inombolo engu-10.
5. Ukuze ugweme ukuhlela kabusha umsebenzi lapho idatha ishintsha, ungawenza ngokuzenzakalelayo. Kulokhu sisebenzisa umsebenzi "HLOLA”. Faka i-pointer endaweni yokufaka yolwazi lwe-agumenti "Usayizi", bese uchofoza isithonjana sikanxantathu ohlangothini lwesobunxele lwebha yefomula bese uchofoza entweni “Izici ezengeziwe…”.
6. Ngenxa yalokho, elinye iwindi le-Function Wizard lizovuleka. Ngokukhetha isigaba "Izibalo", chofoza umsebenzi "HLOLA”, bese KULUNGILE.
7. Isikrini sizobonisa elinye iwindi elinezilungiselelo zama-agumenti omsebenzi, elisetshenziselwa ukunquma inani lamaseli kububanzi obunikeziwe obuqukethe idatha yezinombolo.

   Ifomula Yomsebenzi HLOLA kubhalwe kanje: =СЧЁТ(Значение1;Значение2;...).

   Inani lama-agumenti atholakalayo walo msebenzi lingafika ku-255. Lapha ungabhala izinombolo ezithile, noma amakheli eseli, noma ububanzi bamaseli. Sizosebenzisa inketho yokugcina. Ukuze wenze lokhu, chofoza indawo yokufaka imininingwane yempikiswano yokuqala, bese, ucindezela inkinobho yegundane kwesokunxele, khetha wonke amaseli enye yamakholomu etafula lethu (ungabali unhlokweni), bese ucindezela inkinobho. OK.

8. Njengomphumela wezenzo ezithathiwe, umphumela wezibalo zo-opharetha uzovezwa kuseli ekhethiwe INKONZO YOKUZETHEMBA. Enkingeni yethu, inani layo liphenduke lalingana ne 4,9583603.
9. Kodwa lokhu akukabi umphumela wokugcina emsebenzini wethu. Okulandelayo, udinga ukubala inani elimaphakathi ngesikhathi esithile esinikeziwe. Ukuze wenze lokhu, udinga ukusebenzisa umsebenzi "INHLIZIYO”A eyenza umsebenzi wokubala isilinganiso phezu kwebanga elicacisiwe ledatha.

   Ifomula yomsebenzisi ibhalwe kanje: =СРЗНАЧ(число1;число2;...).

   Khetha iseli lapho sihlela ukufaka khona umsebenzi bese ucindezela inkinobho "Faka umsebenzi".

10. Esigabeni "Izibalo" khetha umqhubi oyisicefe “INHLIZIYO” bese uchofoza OK.
11. Kuma-agumenti omsebenzi enani lokungqubuzana "Inombolo" cacisa ububanzi, obuhlanganisa wonke amaseli anamanani azo zonke izilinganiso. Bese sichofoza KULUNGILE.
12. Njengomphumela wezenzo ezithathiwe, inani elimaphakathi lizobalwa ngokuzenzakalelayo futhi liboniswe kuseli ngomsebenzi osanda kufakwa.
13. Manje sidinga ukubala imingcele ye-CI (isikhawu sokuzithemba). Ake siqale ngokubala inani lomngcele ongakwesokudla. Sikhetha iseli lapho sifuna ukubonisa khona umphumela, bese senza ukungezwa kwemiphumela etholwe kusetshenziswa opharetha “INHLIZIYO” futhi "IMIGOMO YOKUZEthemba”. Esimweni sethu, ifomula ibonakala kanje: A14+A16. Ngemva kokuyithayipha, cindezela Faka.
14. Ngenxa yalokho, ukubala kuzokwenziwa futhi umphumela uzovezwa ngokushesha kuseli nefomula.
15. Bese, ngendlela efanayo, senza ukubala ukuze sithole inani lomngcele wesokunxele we-CI. Kulokhu kuphela inani lomphumela "IMIGOMO YOKUZEthemba” awudingi ukwengeza, kodwa ukhiphe kumphumela otholwe kusetshenziswa opharetha “INHLIZIYO”. Esimweni sethu, ifomula ibonakala kanje: =A16-A14.
16. Ngemva kokucindezela u-Enter, sizothola umphumela kuseli elinikeziwe ngefomula.

Qaphela: Ezigabeni ezingenhla, sizame ukuchaza ngemininingwane eminingi ngangokunokwenzeka zonke izinyathelo nomsebenzi ngamunye osetshenzisiwe. Nokho, wonke amafomula anqunyiwe angabhalwa ndawonye, ​​njengengxenye yeyodwa enkulu:

• Ukuze unqume umngcele olungile we-CI, ifomula evamile izobukeka kanje:

  =СРЗНАЧ(B2:B11)+ДОВЕРИТ.НОРМ(0,05;8;СЧЁТ(B2:B11)).

• Ngokufanayo, emngceleni wesokunxele, esikhundleni sokuhlanganisa kuphela, udinga ukubeka i-minus:

  =СРЗНАЧ(B2:B11)-ДОВЕРИТ.НОРМ(0,05;8;СЧЁТ(B2:B11)).

Indlela 2: TRUST.STUDENT opharetha

Manje, ake sijwayelane nomsebenzisi wesibili wokunquma isikhathi sokuzethemba − THEMBELA.MFUNDI. Lo msebenzi wethulwe ohlelweni maduze nje, kusukela enguqulweni ye-Excel 2010, futhi uhloselwe ukunquma i-CI yedathasethi ekhethiwe kusetshenziswa ukusatshalaliswa koMfundi, ngokuhluka okungaziwa.

Ifomula Yomsebenzi THEMBELA.MFUNDI Ngokulandelayo:

=ДОВЕРИТ.СТЬЮДЕНТ(Альфа;Cтанд_откл;Размер)

Ake sihlaziye ukusetshenziswa kwalo opharetha esibonelweni sethebula elifanayo. Kuphela manje asazi ukuphambuka okujwayelekile ngokwemibandela yenkinga.

1. Okokuqala, khetha iseli lapho sihlela ukubonisa umphumela. Bese uchofoza isithonjana "Faka umsebenzi" (ngakwesokunxele kwebha yefomula).
2. Iwindi le-Function Wizard elaziwa kakade lizovuleka. Khetha isigaba "Izibalo", bese ohlwini oluhlongozwayo lwemisebenzi, chofoza opharetha “MFUNDI OTHEMBEKILE”, bese - OK.
3. Ewindini elilandelayo, sidinga ukusetha izimpikiswano zomsebenzi:
   • In the "Alpha" njengasendleleni yokuqala, cacisa inani elingu-0,05 (noma “100-95)/100”).
   • Ake siqhubekele engxabano. "std_off". Ngoba ngokwemibandela yenkinga, inani layo alaziwa kithi, sidinga ukwenza izibalo ezifanele, lapho opharetha “STDEV.B”. Chofoza inkinobho ethi engeza umsebenzi bese entweni “Izici ezengeziwe…”.
   • Ewindini elilandelayo le-Function Wizard, khetha u-opharetha ".STDEV.B” esigabeni "Izibalo" bese uchofoza OK.
   • Singena efasiteleni lezilungiselelo zezingxabano zomsebenzi, ifomula yalo ebukeka kanje: =СТАНДОТКЛОН.В(число1;число2;...). Njengempikiswano yokuqala, sicacisa ububanzi obuhlanganisa wonke amaseli kukholamu “Yenani” (singabali unhlokweni).
   • Manje udinga ukubuyela efasiteleni ngezimpikiswano zomsebenzi "THEMBE.MFUNDI”. Ukuze wenze lokhu, chofoza ukubhaliswa kwegama elifanayo endaweni yokufaka ifomula.
   • Manje ake siqhubekele engxoxweni yokugcina ethi “Usayizi”. Njengendlela yokuqala, lapha ungavele ucacise uhla lwamaseli, noma ufake opharetha “HLOLA”. Sikhetha inketho yokugcina.
   • Uma zonke izimpikiswano sezigcwalisiwe, chofoza inkinobho OK.
4. Iseli elikhethiwe lizobonisa inani lesikhathi sokuzethemba ngokuya ngamapharamitha esiwashilo.
5. Okulandelayo, sidinga ukubala amanani emingcele ye-CI. Futhi kulokhu udinga ukuthola inani elimaphakathi lobubanzi obukhethiwe. Ukwenza lokhu, siphinda sisebenzise umsebenzi "INHLIZIYO”. I-algorithm yezenzo ifana naleyo echazwe endleleni yokuqala.
6. Ngemva kokuthola inani "INHLIZIYO”, ungaqala ukubala imingcele ye-CI. Amafomula ngokwawo awehlukile kulawo asetshenziswa ne-“IMIGOMO YOKUZEthemba”:
   • Umngcele wesokudla CI=I-AVERAGE+STUDENT CONFIDENT
   • Ababoshwe Kwesokunxele CI=UKUZETHEMBA OKULINGANISILE KOMFUNDI

Isiphetho

Iqoqo lamathuluzi e-Excel likhulu ngendlela emangalisayo, futhi kanye nemisebenzi evamile, uhlelo lunikeza inhlobonhlobo yemisebenzi ekhethekile ezokwenza ukusebenza ngedatha kube lula kakhulu. Mhlawumbe izinyathelo ezichazwe ngenhla zingase zibonakale ziyinkimbinkimbi kwabanye abasebenzisi ekuqaleni. Kodwa ngemva kocwaningo oluningiliziwe lwendaba kanye nokulandelana kwezenzo, konke kuzoba lula kakhulu.