Ukubalwa kwesikhathi sokuzethemba ku-Microsoft Excel

Enye yezindlela zokuxazulula izinkinga zezibalo kubalwa kwesilinganiso sokuzethemba. Isetshenziswe njengendlela ekhethiwe yokukhomba iphuzu ngobukhulu besampula. Kumele kuqashelwe ukuthi inqubo yokubala isikhathi sokuzethemba ngokwayo iyinkimbinkimbi kakhulu. Kodwa amathuluzi ohlelweni lwe-Excel enza kube lula nakakhulu. Ake sithole ukuthi lokhu kwenziwa kanjani ngokusebenza.

Bheka futhi: Imisebenzi yesitatimende ku-Excel

Inqubo yokubala

Le ndlela isetshenziselwa ukulinganisa isikhathi sokulinganisa kwezibalo ezahlukene. Umsebenzi oyinhloko walesi sibalo ukukhipha ukungaqiniseki kokulinganiswa kwephuzu.

Ku-Excel, kunezinketho ezimbili eziyinhloko zokwenza izibalo ngokusebenzisa le ndlela: uma ukuhlukahluka kwaziwa futhi uma kungaziwa. Esikhathini sokuqala, umsebenzi usetshenziselwa izibalo. TRUST.NORM, futhi okwesibili - TRUST.STUDENT.

Indlela 1: Umsebenzi we-CONFIDENCE.NORM

I-Operator TRUST.NORMezihlobene neqembu lezibalo zamanani, zavela kuqala ku-Excel 2010. Kuzinguqulo zangaphambili zalolu hlelo, isilwane salo esifanayo sisetshenziswa TRUST. Umsebenzi walokhu opharetha ukubala isikhathi sokuzethemba nokusabalalisa okujwayelekile kubantu abaphakathi.

I-syntax yayo ilandelayo:

= TRUST. I-NORM (i-alpha; i-standard_off; usayizi)

"Alpha" - impikiswano ekhombisa izinga lokubaluleka elisetshenziselwa ukubala izinga lokuzethemba. Izinga lokuzethemba liyizwi elilandelayo:

(1- "Alpha") * 100

"Ukuphambuka okujwayelekile" - Le ngxabano, okuyisisekelo esicacile egameni. Lokhu ukuphambuka okujwayelekile kwesampula ehlongozwayo.

"Usayizi" - Iphikisana elawula usayizi wesampula.

Zonke izingxabano zalokhu opharetha ziyadingeka.

Umsebenzi TRUST Inamaphuzu afanayo kanye namathuba afanayo njengaphambilini. I-syntax yayo iwukuthi:

= UKUPHILA (i-alpha; i-standard_off; usayizi)

Njengoba ungabona, umehluko kuphela egameni lomqhubi. Umsebenzi ocacisiwe ushiyelwe ukuhambisana ne-Excel 2010 kanye nezinguqulo ezintsha kulesi sigaba esikhethekile. "Ukuhambisana". Ezinguqulo ze-Excel 2007 nangaphambili, ikhona eqenjini eliyinhloko labaqhubi bezinombolo.

Umngcele wekhasi lokuzethemba unqunywa usebenzisa ifomula elandelayo:

I-X + (-) TRUST

Kuphi X - isilinganiso sesampula esiphezulu, esitholakala phakathi kwebanga elikhethiwe.

Manje ake sibheke indlela yokubala isikhawu sokuzethemba kwesibonelo esithile. Izivivinyo ezingu-12 zenziwa, ngenxa yalokho imiphumela ehlukahlukene efakwe etafuleni yatholwa. Lokhu kungokwakho konke. Ukuphambuka okujwayelekile kuyisi-8. Sidinga ukubala isikhathi sokuzethemba esilinganisweni se-97%.

  1. Khetha iseli lapho umphumela wokucubungula idatha uzoboniswa khona. Chofoza inkinobho "Faka umsebenzi".

  2. Kubonakala Umsebenzi weWebhu. Iya kusigaba "Isitatimende" bese ukhetha igama DOVERT.NORM. Ngemuva kwalokho sichofoza inkinobho. "Kulungile".

  3. Iwindi lempikiswano ivuleka. Amasimu ayo ngokwemvelo afana namagama ezimpikiswano.
    Setha isikhangiso ensimini yokuqala - "Alpha". Lapha kufanele sibonise izinga lokubaluleka. Njengoba sikhumbula, izinga lethu lokuthembela liyi-97%. Ngesikhathi esifanayo, sathi kubalwa ngale ndlela elandelayo:

    (1- "Alpha") * 100

    Ngakho, ukubala izinga lokubaluleka, okungukuthi, ukucacisa inani "Alpha" Ifomula elilandelayo kufanele lisetshenziswe:

    (Izinga elilodwa lokuthembela) / 100

    Okusho ukuthi, esikhundleni sendawo, sithola:

    (1-97)/100

    Ngokubala okulula, sithola ukuthi ukuphikisana "Alpha" kufana 0,03. Faka le nzuzo emkhakheni.

    Njengoba uyazi, isimo sokuphambuka okujwayelekile kuyinto 8. Ngakho-ke, ensimini "Ukuphambuka okujwayelekile" vele ubhale le nombolo.

    Ensimini "Usayizi" udinga ukufaka inombolo yezakhi zohlolo. Njengoba sikhumbula 12. Kodwa ukuze uzenzele ifomula futhi ungazihleli njalo uma kuhlolwa isilwane esisha, ake sibeke leli nani hhayi ngenombolo ejwayelekile, kodwa ngosizo lomsebenzisi ACCOUNT. Ngakho, setha isikhangiso ensimini "Usayizi"bese uchofoza kunxantathu ehlala ngakwesokunxele kwebha yefomula.

    Uhlu lwemisebenzi esanda kusetshenziswa luvela. Uma opharetha ACCOUNT esetshenziswe nguwe maduze, kufanele kube kulolu hlu. Kulesi simo, udinga nje ukuchofoza egameni layo. Esimweni esiphikisanayo, uma ungayitholi, khona-ke hamba ngale nto "Ezinye izici ...".

  4. Kubonakala isijwayele kakade kithi Umsebenzi weWebhu. Hambisa eqenjini futhi "Isitatimende". Khetha igama "ACCOUNT". Sichofoza inkinobho "Kulungile".

  5. Iwindi lempikiswano yesitatimende esingenhla ivela. Lo msebenzi uhlose ukubala inani lamaseli ebangeni elichaziwe eliqukethe amanani wenombolo. I-syntax yayo ilandelayo:

    = COUNT (value1; value2; ...)

    Iqembu lokuphikisana "Amanani" libhekisela ebangeni lapho kudingeka khona ukubala inani lamaseli agcwele idatha yenombolo. Ingqikithi ingaba ngu-255 imibono enjalo, kodwa kithi kuphela okudingekayo.

    Setha isikhombisi emkhakheni "Inani1" Futhi, ubambe inkinobho yegundane lesokunxele, khetha uhla oluqukethe isethi yethu kushidi. Khona-ke ikheli layo lizoboniswa ensimini. Sichofoza inkinobho "Kulungile".

  6. Ngemuva kwalokho, isicelo sizokwenza ukubalwa futhi sibonise umphumela esitokisini lapho sitholakala khona. Esimweni sethu, ifomula yaba yile fomu elandelayo:

    = TRUST. I-NORM (0.03; 8; ACCOUNT (B2: B13))

    Umphumela jikelele wezibalo wawu 5,011609.

  7. Kodwa akusikho konke. Njengoba sikhumbula, umkhawulo wesikhathi sokuzithemba ubalwa ngokungeza nokukhipha kusukela esampula isilinganiso samanani umphumela wokubala TRUST.NORM. Ngale ndlela, imingcele engakwesokudla nangakwesobunxele yekhasi lokuzethemba libalwa ngokulandelanayo. Isilinganiso sesampula ngokwayo singabalwa ngokusebenzisa opharetha ISAVERAGE.

    Lo opharetha uklanyelwe ukubala isilinganiso sesibalo sezinombolo ezikhethiwe zezinombolo. Iqukethe i-syntax elula elula:

    = I-AVERAGE (inombolo1; inombolo2; ...)

    Ukuphikisana "Inombolo" ingaba yinani elihlukile lezinombolo, noma ireferensi yamaseli noma zonke izigaba eziqukethe zona.

    Ngakho, ukhethe iseli lapho kubalwa khona inani lokubala, bese uchofoza inkinobho "Faka umsebenzi".

  8. Ivula Umsebenzi weWebhu. Buyela emuva kusigaba "Isitatimende" bese ukhetha ohlwini ohlwini "SRZNACH". Njengoba njalo, sichofoza inkinobho "Kulungile".

  9. Iwindi lempikiswano iqala. Setha isikhombisi emkhakheni "Number1" futhi inkinobho yesinxele yesinxele icindezelekile, ukhethe lonke uhla lwamanani. Ngemuva kokuthi izixhumanisi zikhonjiswe ensimini, chofoza inkinobho "Kulungile".

  10. Emva kwalokho ISAVERAGE ibonisa umphumela wokubala esakhiweni seshidi.

  11. Sibala umngcele oqondile wekhasi lokuzethemba. Ukuze wenze lokhu, khetha iseli elihlukile, faka uphawu "=" futhi wengeze okuqukethwe kwezakhi zeshidi, lapho imiphumela yokubala yemisebenzi itholakala khona ISAVERAGE futhi TRUST.NORM. Ukuze wenze ukubalwa, cindezela ukhiye Ngena. Esikhathini sethu, sithole ifomula elandelayo:

    = F2 + A16

    Umphumela wokubala: 6,953276

  12. Ngendlela efanayo, sibala umngcele ongakwesokunxele wekhasi lokuzethemba, kuphela lesi sikhathi kusukela kumphumela wokubala ISAVERAGE susa umphumela wokubala we-opharetha TRUST.NORM. Kuvela ifomula yesibonelo sethu sohlobo olulandelayo:

    = F2-A16

    Umphumela wokubala: -3,06994

  13. Sazama ukuchaza ngokuningiliziwe zonke izinyathelo zokubala isikhathi sokuzethemba, ngakho sachaza ifomula ngayinye ngokuningiliziwe. Kodwa zonke izenzo zingenziwa zihlangene kwifomula eyodwa. Ukubalwa komngcele ongakwesokudla wezinga lokuzethemba kungabhalwa ngokuthi:

    = I-AVERAGE (B2: B13) + TRUST.NORM (0.03; 8; COUNT (B2: B13))

  14. Ukubalwa okufanayo komngcele ongakwesokunxele kuzobukeka kanje:

    = I-AVERAGE (B2: B13) - I-TRUST. I-NORM (0.03; 8; COUNT (B2: B13))

Indlela 2: Umsebenzi TRUST FESTUDENT

Ngaphezu kwalokho, ku-Excel kunomunye umsebenzi ohlotshaniswa nokubala kwesikhathi sokuzethemba - TRUST.STUDENT. Kubonakala nje kuqale kusukela ku-Excel 2010. Lo opharetha wenza isibalo sesikhathi sokuzethemba sabantu abasebenzisa ukusatshalaliswa kwabafundi. Kuyinto elula kakhulu ukuyisebenzisa uma kwenzeka umahluko futhi, ngokufanele, ukuphambuka okujwayelekile akungaziwa. I-syntax ye-Operator yile:

= Ukuhlolwa kwe-TRUST (i-alpha; i-standard_off; usayizi)

Njengoba ungabona, amagama opharetha kulokhu ahlala engashintshi.

Ake sibone ukuthi singabala kanjani imingcele yesikhathi sokuzethemba nokungaziphathi kahle okungaziwa usebenzisa isibonelo sobukhulu obufanayo esacubungula ngendlela yangaphambilini. Izinga lokuthembela, njengesikhathi sokugcina, kuthatha u-97%.

  1. Khetha iseli lapho ukubalwa kuzokwenziwa khona. Sichofoza inkinobho "Faka umsebenzi".

  2. Kuvuliwe Umsebenzi wizard iya kusigaba "Isitatimende". Khetha igama "DOVERT.STUUDENT". Sichofoza inkinobho "Kulungile".

  3. Iwindi lezingxabano zomqhubi ocacisiwe luqalisiwe.

    Ensimini "Alpha", sicabanga ukuthi izinga lokuthembela liyi-97%, sibhala phansi inombolo 0,03. Isikhathi sesibili ezimisweni zokubala le parameter ngeke zime.

    Emva kwalokho setha isikhangiso ensimini "Ukuphambuka okujwayelekile". Ngalesi sikhathi, lesi sibalo asiziwa kithi futhi kuyadingeka ukubala. Lokhu kwenziwa ngokusebenzisa umsebenzi okhethekile - I-STANDOWCLON.V. Ukushayela ifasitela yalolu opharetha, chofoza kunxantathu ngakwesokunxele kwebha yefomula. Uma kuhlu oluvulwe asiyitholi igama elifunayo, bese uhamba ngalutho "Ezinye izici ...".

  4. Iqala Umsebenzi weWebhu. Hambisa kusigaba "Isitatimende" bese uqaphela igama kulo "STANDOTKLON.V". Bese uchofoza inkinobho. "Kulungile".

  5. Iwindi lempikiswano ivuleka. Umsebenzi we-Operator I-STANDOWCLON.V ukuzimisela kokuphambuka okujwayelekile uma sampula. I-syntax yayo iwukuthi:

    = STDEV.V (inombolo1; inombolo2; ...)

    Akunzima ukuqagela ukuthi impikiswano "Inombolo" ikheli lezinto zokukhetha. Uma isampula efakwa kuhlu olulodwa, khona-ke, ungasebenzisa ukuphikisana okulodwa kuphela, unikeza inkomba kulolu hlu.

    Setha isikhombisi emkhakheni "Number1" futhi, njengoba njalo, ubambe inkinobho yegundane lesokunxele, khetha isethi. Ngemuva kokuthi izixhumanisi zitholwe ensimini, ungasheshi ukucindezela inkinobho "Kulungile", njengoba umphumela ungalungile. Okokuqala kudingeka sibuyele ewindini lokuphikisana ne-opharetha TRUST.STUDENTukwenza ingxabano yokugcina. Ukwenza lokhu, chofoza igama elifanele kubha yamatomu.

  6. Iwindi lempikiswano yomsebenzi ojwayelekile uvula futhi. Setha isikhombisi emkhakheni "Usayizi". Futhi, chofoza unxantathu owaziwa kakade ukuya ekukhethweni kwama-opharetha. Njengoba uqonda, sidinga igama. "ACCOUNT". Njengoba sisebenzise lo msebenzi ekubalweni ngendlela yangaphambilini, ukhona kulolu hlu, ngakho nje uchofoze kuso. Uma ungayitholi, ke uqhubeke ngokuvumelana ne-algorithm echazwe ngendlela yokuqala.

  7. Ukushaya iwindi lempikiswano ACCOUNTfaka isikhombisi ensimini "Number1" futhi inkinobho yegundane ibanjwe phansi, khetha isethi. Bese uchofoza inkinobho. "Kulungile".

  8. Ngemuva kwalokho, uhlelo lubala futhi lubonisa ukubaluleka kwesikhathi sokuzethemba.

  9. Ukuze sinqume imingcele, sizophinde sizodinga ukubala inani elilinganiselwe lesampula. Kodwa, kunikezwe ukuthi i-algorithm yokubala isebenzisa ifomula ISAVERAGE kufana neyindlela eyedlule, futhi ngisho nomphumela awukashintshi, ngeke sihlale kulokhu ngokuningiliziwe okwesibili.

  10. Ngokwengeza imiphumela yokubala ISAVERAGE futhi TRUST.STUDENT, sithola umngcele oqondile wesikhathi sokuzethemba.

  11. Ukususa emiphumeleni yokubalwa komsebenzisi ISAVERAGE umphumela wokubala TRUST.STUDENT, sinomngcele ongakwesokunxele wekhasi lokuzethemba.

  12. Uma isibalo sibhaliwe ngesifomula esisodwa, khona-ke ukubalwa komngcele oqondile endaweni yethu kuzobukeka kanje:

    = I-AVERAGE (B2: B13) + I-TRUST Test (0.03; STANDARD CLON. B (B2: B13); ACCOUNT (B2: B13))

  13. Ngakho-ke, ifomula yokubala umngcele wesokunxele izobukeka kanje:

    = I-AVERAGE (B2: B13) -I-DVERIT.TUDENT (0.03; I-STANDARD CLON. B (B2: B13); ACCOUNT (B2: B13))

Njengoba ungabona, amathuluzi we-Excel akuvumela ukuba wenze lula ukubala kokungena kokuzethemba nemingcele yayo. Ngale njongo, ama-operator ahlukene asetshenziselwa amasampuli lapho ukuhlukahluka kwaziwa khona futhi kungaziwa.

Okuthunyelwe Popular

https://termotools.com zu.termotools.com © I-Excel 2024