Imisebenzi yezibalo ye-Excel yokubala ama-avareji: Okokufundisa okunezibonelo, ingxenye yesibili

I-Excel inikeza ububanzi obubanzi bemisebenzi yezibalo eyenza izibalo kusukela kuncazelo eyisisekelo, i-median, nemodi ukuya ekusabalazweni kwezibalo okuyinkimbinkimbi kanye nokuhlolwa kwamathuba.

Kulesi sihloko sizohlola imisebenzi yezibalo ye-Excel yokubala isilinganiso.

Sicela uqaphele ukuthi eminye imisebenzi yezibalo yethulwe ezinguqulweni zakamuva ze-Excel ngakho-ke ayitholakali kuzinguqulo ezindala.

Imisebenzi yokubala okumaphakathi

AVERAGE

Umsebenzi AVERAGE ungomunye wemisebenzi yezibalo ye-Excel. Umsebenzi ubuyisela isilinganiso samanani ezinombolo afakwe kumsebenzi. Ngamagama alula, yengeza wonke amanani ashiwo kumsebenzi, bese iwahlukanisa ngokubala bese ibuyisela umphumela.

-syntax

= AVERAGE(number1,number2,…)

izifundo

• numero1 : Inombolo yokuqala ofuna ukuyisebenzisela ukubala isilinganiso.
• [numero2] : Inombolo yesibili ofuna ukuyisebenzisela ukwenza isilinganiso.

Ngokwesibonelo

Ukuze ubone ukuthi umsebenzi usebenza kanjani AVERAGE ake sibone isibonelo:

Esibonelweni sokuqala sifake ama-agumenti ngqo emsebenzini.

Esibonelweni sesibili, sibhekise ububanzi obuqukethe izinombolo. Ungabhekisela kuseli elinganqunyelwe usebenzisa ububanzi obuqhubekayo futhi uma ufuna ukubhekisela kububanzi obuguquguqukayo ungasebenzisa ithebula kulokho.

Ungabhekisela kuseli elinganqunyelwe usebenzisa ububanzi obuqhubekayo futhi uma ufuna ukubhekisela kububanzi obuguquguqukayo ungasebenzisa ithebula.

Esibonelweni sesithathu sibhekisele kububanzi lapho amaseli afomethwe khona njengamanani ombhalo. Kulokhu, ungakwazi ukuguqula lezo zinombolo zombhalo zibe izinombolo zangempela ukuze ubale isilinganiso.

Esibonelweni sesine sine-apostrophe ngaphambi kwevelu ngayinye kuseli ngalinye futhi ngenxa yalokho asishaywa indiva umsebenzi.

AVERAGEA

Umsebenzi AVERAGEA ye-Excel isohlwini lwesigaba se-Microsoft Excel Statistical Functions. Ibuyisela isilinganiso sezinombolo ezishiwo emsebenzini, kodwa ngokungafani AVERAGE, iphatha amanani e-Boolean nezinombolo ezifomethwe njengombhalo.

-syntax

=AVERAGEA(valore1,valore2,…)

izifundo

• value1 : Inani eliyinombolo, inani elinengqondo, noma inombolo egcinwe njengombhalo.
• [valore2] : Inani eliyinombolo, inani elinengqondo, noma inombolo egcinwe njengombhalo.

Ngokwesibonelo

Ukuze uqonde umsebenzi AVERAGEA sidinga ukubona isibonelo:

Inani elibuyiswe umsebenzi ngu-10,17 okungukuthi “(0+0+1+10+20+30)/6”.

AVERAGEIF

Umsebenzi AVERAGEIF ye-Excel isohlwini lwesigaba se-Microsoft Excel Statistical Functions. Ibuyisela isilinganiso sezinombolo ezenelisa izimo eziningi ezishiwo . 

-syntax

= AVERAGEIF( range, criteria, [average_range] )

Izimpikiswano

• range:  amanani afanayo (noma ububanzi bamaseli aqukethe amanani) azohlolwa ngokuqhathaniswa nemibandela enikeziwe.
• criteria:  Umbandela ozohlolwa ngokumelene nenani ngalinye kububanzi obunikeziwe.
• [average_range]:  Uhlu olungakhethwa lwamanani ezinombolo (noma amaseli aqukethe izinombolo) okufanele alinganisele uma inani elihambisanayo kububanzi lihlangabezana nemibandela enikeziwe.

Uma isihloko [average_range] ayifakiwe, isilinganiso sibalwa ngamavelu ebangeni lokuqala elinikeziwe.

Imibandela enikeziwe ingaba:

inani lezinombolo (okuhlanganisa izinombolo eziphelele, amadesimali, izinsuku, izikhathi, namanani anengqondo) (isibonelo, 10, 01/01/2008, TRUE)
O
iyunithi yezinhlamvu yombhalo (isb. “Umbhalo”, “ULwesine”) – KUMELE unikezwe ngezingcaphuno
O
isisho (isb. ">12”, “<>0”) – KUMELE kunikelwe ngezingcaphuno.
Qaphela futhi ukuthi umsebenzi AVERAGEIF I-Excel ayizwela kakhulu. Ngakho, ngokwesibonelo, amayunithi ezinhlamvu zombhalo “TEXT"E"text” izolinganiswa njengelinganayo.

Ngokwesibonelo

Ukuze uqonde umsebenzi AVERAGEIF kufanele sikuzame ngesibonelo.

Amaseli A16-A20 kuspredishithi esilandelayo bonisa izibonelo ezinhlanu zomsebenzi AVERAGEIF kwe-Excel.

Ngocingo ngalunye lomsebenzi AVERAGEIF ye-Excel, isihloko range (ezohlolwa ngokumelene criteria) ububanzi bamaseli A1-A14 kanye nesihloko [average_range] (equkethe amanani azolinganiswa) ububanzi bamaseli B1-B14.

Qaphela ukuthi, kumaseli A16, A18, kanye no-A20 esipredishithi esingenhla, inani lombhalo elithi “Lwesine” kanye nezinkulumo “>2” kanye “<>TRUE” afakwe ezimpawu zokucaphuna. Lokhu kubalulekile kuwo wonke amathekisthi noma izinkulumo.

AVERAGEIFS

Umsebenzi AVERAGEIFS ye-Excel isohlwini lwesigaba se-Microsoft Excel Statistical Functions. Ibuyisela isilinganiso sezinombolo ezenelisa izimo eziningi ezishiwo . Ngokungafani AVERAGEIF, ungasetha izimo eziningi futhi ubale isilinganiso kuphela sezinombolo ezihlangabezana nayo yonke imibandela.

-syntax

= AVERAGEIFS( average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... )

Izimpikiswano

• average_range:  Uhlu lwamanani ezinombolo (noma amaseli aqukethe izinombolo) azolinganiswa.
• criteria_range1, [criteria_range2], ...: Izinhlu zamanani (noma ububanzi bamaseli aqukethe amanani) azohlolwa ngokumelene namanye criteria1, criteria2, … (Amalungu criteria_range okunikeziwe kumele zonke zibe nobude obufanayo).
• criteria1, [criteria2], …: Izimo okufanele zihlolwe maqondana namanani aku- criteria_range1, [criteria_range2], …

Ngokwesibonelo

Manje ake sibheke isibonelo somsebenzi AVERAGEIFS:

Esibonelweni esilandelayo, sisebenzise umsebenzi AVERAGEIFS ukubala inani elimaphakathi elithengiswa umdayisi “Pietro” kanye nomkhiqizo “B”. Sifake umbandela ngqo emsebenzini futhi sinezikhalo ezimbili zokuthengiswa kukaPeter komkhiqizo B.

Esibonelweni esilandelayo, sisebenzise AVERAGEIFS ngenkanyezi ukubala inani elimaphakathi lesithelo ubuningi balo bungaphezu kwamayunithi angama-20 futhi lino-B egameni.

Kudatha engezansi, sinezithelo ezimbili ezihlangabezana nalezi zindlela.

MEDIAN

Umsebenzi MEDIAN I-Excel ibuyisela i-median yezibalo (inani eliyisilinganiso) lohlu lwezinombolo ezinikeziwe.

-syntax

= MEDIAN( number1, [number2], ... )

Izimpikiswano

ama-agumenti ezinombolo ayisethi yenani lenombolo eyodwa noma ngaphezulu (noma amalungu afanayo amanani ezinombolo), ofuna ukubala imidiyeni

Qaphela ukuthi:

• Uma kukhona inani elilinganayo lamanani kudathasethi enikeziwe, isilinganiso samanani amaphakathi amabili siyabuyiswa;
• Uma amalungu afanayo anikeziwe aqukethe amaseli angenalutho, umbhalo, noma amanani anengqondo, lawa manani ayazitshwa lapho kubalwa i-median.
• Ezinguqulweni zamanje ze-Excel (i-Excel 2007 nakamuva), ungakwazi ukunikeza ama-agumenti ezinombolo angafika kwangu-255 kumsebenzi we-Median, kodwa ku-Excel 2003 umsebenzi ungamukela kuphela ama-agumenti ezinombolo angu-30. Nokho, impikiswano ngayinye yezinombolo ingaba uxhaxha lwamanani amaningi.

Ngokwesibonelo

Isipredishithi esilandelayo sibonisa izibonelo ezintathu zomsebenzi Median:

Cabanga ngalokho, ezibonelweni ezedlule:

• Isibonelo esitokisini B2 ithola inani elilinganayo lamanani ngakho-ke i-median ibalwa njengesilinganiso samanani asho amabili, u-8 no-9;
• Isibonelo esitokisini B3 ihlanganisa iseli elingenalutho A8. Leli seli lizitshwa uma kubalwa i-median.

Ukuze uthole imininingwane eyengeziwe ngomsebenzi MEDIAN kwe-Excel, bheka i- Iwebhusayithi ye-Microsoft Office .

MODE

Umsebenzi MODE ye-Excel ibuyisela i- MODE izibalo (inani elivame kakhulu) lohlu lwezinombolo ezinikeziwe. Uma kukhona 2 noma ngaphezulu amanani avelayo kudatha enikeziwe, umsebenzi ubuyisela inani eliphansi kakhulu phakathi kwawo

-syntax

= MODE( number1, [number2], ... )

Izimpikiswano

ayisethi yenani lenombolo eyodwa noma ngaphezulu (noma ukuhlelwa kwamanani ezinombolo), ofuna ukubala MODE izibalo.

Nota:

• Ezinguqulweni zamanje ze-Excel (i-Excel 2007 nakamuva), unganikezela ngama-agumenti ezinombolo angama-255 emsebenzini. MODE, kodwa ku-Excel 2003 umsebenzi ungamukela kuphela ama-agumenti ezinombolo angama-30.
• Amanani ombhalo nanengqondo phakathi kwezinombolo eziningi ezinikeziwe azitshwa umsebenzi Mode.

Izibonelo zomsebenzi MODE

Isiqephu 1

Isipredishithi esilandelayo sibonisa umsebenzi MODE I-Excel, esetshenziselwa ukubala i- MODE izibalo zesethi yamanani kumaseli A1-A6.

Isiqephu 2

Isipredishithi esilandelayo sibonisa umsebenzi MODE, esetshenziswa ukubala i MODE izibalo zesethi yamanani kumaseli A1-A10.

Qaphela ukuthi kulesi simo kukhona ezimbili mode kudatha.

Esimweni esingenhla, lapho idatha ekukholomu A yesipredishithi sangaphambilini inamabili MODE izibalo (3 no-4), umsebenzi MODE ibuyisela okuphansi kwalawa manani amabili.

Ukuze uthole imininingwane eyengeziwe kanye nezibonelo zomsebenzi MODE kwe-Excel, bheka i- Iwebhusayithi ye-Microsoft Office .

MODE.SNGL

Umsebenzi MODE.SNGL ye-Excel ibuyisela i- MODE izibalo (inani elivame kakhulu) lohlu lwezinombolo ezinikeziwe. Uma kukhona 2 noma ngaphezulu amanani avelayo kudatha enikeziwe, umsebenzi ubuyisela inani eliphansi kakhulu phakathi kwawo.

Umsebenzi Mode.Sngl yintsha ku-Excel 2010 ngakho ayitholakali ezinguqulweni zangaphambili ze-Excel. Nokho, umsebenzi umane uyinguqulo eqanjwe kabusha yomsebenzi MODE iyatholakala kuzinguqulo zangaphambili ze-Excel.

-syntax

= MODE.SNGL( number1, [number2], ... )

Izimpikiswano

ayisethi yenani lenombolo eyodwa noma ngaphezulu (noma ukuhlelwa kwamanani ezinombolo), ofuna ukubala MODE.SNGL izibalo.

Izibonelo zomsebenzi MODE.SNGL

Isiqephu 1

Isipredishithi esilandelayo sibonisa umsebenzi MODE.SNGL I-Excel, esetshenziselwa ukubala i-MODE yezibalo yesethi yamanani kumaseli A1-A6.

Isiqephu 2

Isipredishithi esilandelayo sibonisa umsebenzi MODE.SNGL, esetshenziselwa ukubala imodi yezibalo yesethi yamanani kumaseli A1-A10.

Qaphela ukuthi kulesi simo kukhona ezimbili mode kudatha.

Esimweni esingenhla, lapho idatha ekukholomu A yesipredishithi sangaphambilini inamabili MODE izibalo (3 no-4), umsebenzi MODE.SNGL ibuyisela okuphansi kwalawa manani amabili.

Ukuze uthole imininingwane eyengeziwe kanye nezibonelo zomsebenzi MODE.SNGL kwe-Excel, bheka i- Iwebhusayithi ye-Microsoft Office .

GEOMEAN

I-Geometric Mean isilinganiso sesilinganiso esibonisa inani elivamile lesethi yezinombolo. Lesi silinganiso singasetshenziswa kuphela ngamavelu amahle.

Incazelo yejiyomethri yesethi yamanani, y ₁ , futhi ₂ , …, Lapho _n kubalwa ngefomula:

Qaphela ukuthi incazelo yejiyomethri ihlala incane noma ilingana nencazelo ye-arithmetic.

Umsebenzi Geomean I-Excel ibala incazelo yejiyomethri yesethi yamanani enikeziwe.

-syntax

= GEOMEAN( number1, [number2], ... )

Izimpikiswano

inombolo eyodwa noma ngaphezulu ephozithivu yezinombolo (noma amalungu afanayo amanani ezinombolo), ofuna ukubala yona incazelo yejiyomethri.

Ezinguqulweni zamanje ze-Excel (i-Excel 2007 nakamuva), umsebenzi ungamukela amaphuzu ezinombolo angafika kwangu-255, kodwa ku-Excel 2003 umsebenzi ungamukela kuphela ama-agumenti ezinombolo angafika kwangu-30. Nokho, i-agumenti ngayinye ingaba amanani afanayo noma ububanzi bamaseli, ngalinye elingaqukatha amanani amaningi.

Ngokwesibonelo

Iseli B1 yesipredishithi sibonisa isibonelo esilula somsebenzi geomean ku-Excel, esetshenziselwa ukubala incazelo yejometri yamanani kumaseli A1-A5.

Kulesi sibonelo, umsebenzi we-Geomean ubuyisela inani 1.622671112 .

HARMEAN

Incazelo ye-harmonic iyisilinganiso sencazelo ebalwa njengokuphindaphinda kwencazelo ye-arithmetic yama-reciprocals. Lokhu kungabalwa kuphela ngamavelu angamaphozithivu.

Incazelo ye-harmonic yesethi yamanani, y1, y2, ..., yn inikezwa ifomula:

incazelo ye-harmonic ihlale ingaphansi noma ilingana nencazelo yejometri futhi incazelo yejometri ihlale ingaphansi noma ilingana nencazelo ye-arithmetic.

Umsebenzi Harmean I-Excel ibala incazelo ye-harmonic yesethi yamanani enikeziwe.

-syntax

= HARMEAN( number1, [number2], ... )

Izimpikiswano

inombolo eyodwa noma ngaphezulu ephozithivu yezinombolo (noma amalungu afanayo amanani ezinombolo), ofuna ukubala yona incazelo ye-harmonic.

Ezinguqulweni zamanje ze-Excel (i-Excel 2007 nakamuva), umsebenzi ungamukela amaphuzu ezinombolo angafika kwangu-255, kodwa ku-Excel 2003 umsebenzi ungamukela kuphela ama-agumenti ezinombolo angafika kwangu-30. Nokho, i-agumenti ngayinye ingaba amanani afanayo noma ububanzi bamaseli, ngalinye elingaqukatha amanani amaningi.

Ngokwesibonelo

Iseli B1 kusipredishithi esingakwesokudla libonisa isibonelo esilula somsebenzi Harmean ku-Excel, esetshenziselwa ukubala incazelo ye-harmonic yamanani kumaseli A1-A5.

Kulesi sibonelo, umsebenzi Harmean ibuyisela inani 1.229508197.

TRIMMEAN

Umsebenzi TRIMMEAN (eyaziwa nangokuthi incazelo esikiwe) isilinganiso sencazelo ebonisa ukuthambekela okumaphakathi kwesethi yamanani.

Incazelo esikiwe ibalwa ngokulahla amanye amanani ekugcineni kobubanzi bamanani, ngaphambi kokubala incazelo ye-arithmetic yamanani asele. Lokhu kuvimbela isilinganiso esibaliwe ekubeni sihlanekezelwe ngamavelu eqisayo (owaziwa nangokuthi ama-outliers, ngokobuchwepheshe outliers).

-syntax

= TRIMMEAN( array, percent )

Izimpikiswano

• i-array - Uhlu lwamanani ezinombolo ofuna ukubala lona incazelo encishisiwe.
• amaphesenti - Iphesenti lamanani ofuna ukususa kuwoarray enikeziwe.

Qaphela ukuthi inani lephesenti elishiwo yisamba sephesenti lamanani okufanele likhishwe esibalweni. Leli phesenti lihlukaniswa ngamabili ukuze kutholwe inani lamanani asusiwe ekugcineni ngakunye kobubanzi.

Kufanele futhi kuqashelwe ukuthi lapho i-Excel ibala ukuthi mangaki amanani asusiwe ku-array wamanani anikeziwe, iphesenti elibaliwe lifinyezwa lifike kokuphindaphindeka okuseduze kuka-2. Isibonelo, uma ufuna ukubala incazelo efinyeziwe ye-a array ngamavelu angu-10, ngakho-ke:

• Iphesenti lika-15% lihambisana namanani angu-1,5, azokwehliswa aze afike ku-0 (okungukuthi awekho amanani azolahlwa ku-array ngaphambi kokubala isilinganiso);
• Iphesenti elingu-20% lihambisana namanani angu-2, ngakho inani elingu-1 lizolahlwa ekupheleni ngakunye kobubanzi ngaphambi kokulinganisa amanani asele;
• Iphesenti elingu-25% lihambisana namanani angu-2,5, azofinyezwa kwehle kube ngu-2 (okungukuthi, inani elingu-1 lizolahlwa ekugcineni ngalunye lobubanzi ngaphambi kokulinganisa amanani asele).

Ngokwesibonelo

Amaseli B1-B3 kusipredishithi esingezansi khombisa izibonelo ezi-3 zomsebenzi trimmean ku-Excel, konke kusetshenziselwa ukubala incazelo esikiwe yamanani kumaseli A1-A10, ngamavelu ahlukene wamaphesenti.

Khumbula ukuthi, esitokisini B1 kuspredishithi esingenhla, iphesenti lokuphikisa elinikeziwe lingu-15%. Kusukela kuarray inqobo nje uma kunamanani angu-10, inani lamanani okufanele lizitshwe lingu-1,5 lifinyezwa lize lifike kokuphindaphindeka okuseduze kuka-2 okunguziro.

Imisebenzi yokubala izimvume

PERMUT

Inombolo yezimvume zenani elinikeziwe lezinto inombolo yezinhlanganisela nganoma iyiphi indlela okungenzeka ngayo.

Izimvume zihlukile kuzinhlanganisela ngokuthi, ekuvumeleni, ukuhleleka kwezinto kubalulekile, kodwa ekuhlanganisweni ukuhleleka akunandaba.

Inani lezimvume ezingaba khona linikezwa ifomula:

ijuba k inani lezinto ezikhethiwe e n inani lezinto ezingenzeka.

Umsebenzi we-Excel Permut ibala inani lezimvume zenani elishiwo lezinto eqoqweni lezinto.

-syntax

= PERMUT( number, number_chosen )

Izimpikiswano

• number: Isamba senani lezinto ezitholakalayo
• number_chosen: Inani lezinto kumvume ngayinye (okungukuthi inani lezinto ezikhethiwe kusethi)

Qaphela ukuthi uma noma imaphi ama-agumenti anikezwa njengamavelu edesimali, azoncishiswa abe izinombolo ngomsebenzi Permut.

Ngokwesibonelo

Kuspredishithi esilandelayo, i-Excel Permut isetshenziselwa ukubala inani lezimvume zezinto eziyisithupha, ezikhethwe kumasethi osayizi abahlukene:

PERMUTATIONA

Imisebenzi ye-Excel Ukuhwebelana kanye ne-Permutationa zombili zibala inani lezimvume zokukhethwa kwezinto kusethi.

Nokho, le misebenzi yomibili iyehluka ngokuthi i- Umsebenzi we-Permut ayibali izimpinda kuyilapho umsebenzi we-Permutationa ubala izimpinda.

Isibonelo, kusethi yezinto ezi-3, a , b , c , zingaki izimvume zezinto ezi-2?

• La Umsebenzi we-Permut ibuyisela umphumela 6 (izimvume: ab , ac , ba , bc , ca , cb );
• Umsebenzi wePermutationa ubuyisela umphumela 9 (izimvume: aa , ab , ac , ba , bb , bc , ca , cb , cc ).

Umsebenzi we-Excel Permutationa ibala inani lezimvume zenani elishiwo lezinto eqoqweni lezinto.

-syntax

= PERMUTATIONA( number, number_chosen )

Izimpikiswano

• number: Isamba senani lezinto ezisesethi (kumele libe ngu-≥ 0).
• number_chosen: Inani lezinto ezikhethiwe kusethi (kumele libe ngu-≥ 0).

Qaphela ukuthi uma noma imaphi ama-agumenti anikezwa njengamavelu edesimali, azoncishiswa abe izinombolo ngomsebenzi PERMUTATIONA.

Ngokwesibonelo

Kuspredishithi esilandelayo, i-Excel PERMUTATIONA isetshenziselwa ukubala inani lezimvume zezinto eziyisithupha, ezikhethwe kumasethi osayizi abahlukene:

Imisebenzi yokubala izikhawu zokuzethemba

CONFIDENCE

Ku-Excel 2010, umsebenzi CONFIDENCE ithathelwe indawo umsebenzi Confidence.Norm.

Nakuba ishintshiwe, izinguqulo zamanje ze-Excel zisenaso isici Confidence (igcinwe ohlwini lwemisebenzi ehambisanayo), ukuvumela ukuhambisana nezinguqulo zangaphambilini ze-Excel.

Nokho, umsebenzi Confidence ingase ingatholakali kuzinguqulo ezizayo ze-Excel, ngakho-ke sincoma ukusebenzisa isici Confidence.Norm, uma kwenzeka.

Umsebenzi Confidence I-Excel isebenzisa ukusatshalaliswa okuvamile ukubala inani lokuzethemba elingasetshenziswa ukwakha isikhawu sokuzithemba senani labantu, ithuba elinikeziwe, kanye nosayizi wesampula. Kucatshangwa ukuthi ukuchezuka kwezinga labantu kuyaziwa.

-syntax

= CONFIDENCE( alpha, standard_dev, size )

Izimpikiswano

• alfa: Izinga lokubaluleka (= 1 – izinga lokuzethemba). (Isibonelo, izinga lokubaluleka lika-0,05 lilingana nezinga lokuzethemba elingu-95%).
• standard_dev: Ukusuka emgomeni wabantu.
• size: Usayizi wesampula labantu.

Ukuze ubale isikhawu sokuzithemba senani labantu, inani lokuthenjwa elibuyiswayo kumelwe lingezwe kulo futhi likhishwe kuncazelo yesampula. Okusho ukuthini. ngesampula isho ukuthi x:

Confidence Interval =   x   ±   CONFIDENCE

Ngokwesibonelo

Kuspredishithi esingezansi, umsebenzi wokuzethemba we-Excel usetshenziswa ukubala isikhawu sokuzithemba ngokubaluleka kuka-0,05 (okungukuthi izinga lokuzethemba elingu-95%), ngokwesilinganiso sesampula yobude bamadoda ayi-100 . Isampula incazelo ingamamitha angu-1,8 futhi ukuchezuka okujwayelekile ngamamitha angu-0,07.

Umsebenzi wangaphambilini ubuyisela inani lokuthenjwa elingu-0,013719748

Ngakho-ke isikhawu sokuzithemba singu-1,8 ± 0,013719748, okulingana nobubanzi obuphakathi kuka-1,786280252 no-1,813719748

CONFIDENCE.NORM

Ezibalweni, isikhawu sokuzethemba yibanga lapho ipharamitha yabantu okungenzeka yehle khona, ngamathuba athile.

Ngokwesibonelo. Kubantu abathile kanye namathuba angu-95%, isikhawu sokuzethemba ububanzi lapho ipharamitha yesibalo sabantu okungenzeka yehle ngo-95%.

Qaphela ukuthi ukunemba kwesikhawu sokuzithemba kuncike ekutheni inani labantu linokusabalalisa okuvamile.

Umsebenzi Confidence.Norm I-Excel isebenzisa ukusatshalaliswa okuvamile ukubala inani lokuzethemba elingasetshenziswa ukwakha isikhawu sokuzithemba senani labantu, ithuba elinikeziwe, kanye nosayizi wesampula. Kucatshangwa ukuthi ukuchezuka kwezinga labantu kuyaziwa.

-syntax

= CONFIDENCE.NORM( alpha, standard_dev, size )

Izimpikiswano

• alfa: Izinga lokubaluleka (= 1 – izinga lokuzethemba). (Isibonelo, izinga lokubaluleka lika-0,05 lilingana nezinga lokuzethemba elingu-95%).
• standard_dev: Ukusuka emgomeni wabantu.
• size: Usayizi wesampula labantu.

Ukuze ubale isikhawu sokuzithemba senani labantu, inani lokuthenjwa elibuyiswayo kumelwe lingezwe kulo futhi likhishwe kuncazelo yesampula. Okusho ukuthini. ngesampula isho ukuthi x:

Confidence Interval =   x   ±   CONFIDENCE

Ngokwesibonelo

Kuspredishithi esingezansi, umsebenzi wokuzethemba we-Excel usetshenziswa ukubala isikhawu sokuzithemba ngokubaluleka kuka-0,05 (okungukuthi izinga lokuzethemba elingu-95%), ngokwesilinganiso sesampula yobude bamadoda ayi-100 . Isampula incazelo ingamamitha angu-1,8 futhi ukuchezuka okujwayelekile ngamamitha angu-0,07.

Umsebenzi wangaphambilini ubuyisela inani lokuthenjwa elingu-0,013719748

Ngakho-ke isikhawu sokuzithemba singu-1,8 ± 0,013719748, okulingana nobubanzi obuphakathi kuka-1,786280252 no-1,813719748

Ercole Palmeri