amanqaku

Imisebenzi yamanani e-Excel yokubala i-avareji: Isifundo esinemizekelo, inxalenye yesibini

I-Excel ibonelela ngoluhlu olubanzi lwemisebenzi yeenkcukacha-manani eyenza izibalo ukusuka kwintsingiselo esisiseko, i-median, kunye nemowudi ukuya kulwabiwo lwamanani oluntsonkothileyo kunye novavanyo olunokwenzeka.

Kweli nqaku siza kuphonononga imisebenzi yeenkcukacha-manani ye-Excel yokubala umndilili.

Nceda uqaphele ukuba eminye imisebenzi yamanani yaziswa kwiinguqulelo zamva nje ze-Excel kwaye ke ayifumaneki kwiinguqulelo ezindala.

Uluhlu lweziqulatho: Uluhlu lwemisebenzi

Imisebenzi yokubala i-avareji

`AVERAGE`

Umsebenzi AVERAGE ngomnye wemisebenzi yeenkcukacha-manani ye-Excel. Umsebenzi ubuyisela umndilili wamaxabiso angenisiweyo kumsebenzi. Ngamagama alula, yongeza onke amaxabiso achaziweyo kumsebenzi, emva koko uwahlule ngokubala kwaye abuyisele isiphumo.

syntax

= AVERAGE(number1,number2,…)

iingxoxo

numero1 : Inani lokuqala ofuna ukulisebenzisa ekubaleni umndilili.
[numero2] : Inombolo yesibini ofuna ukuyisebenzisela i-avareji.

umzekelo

Ukubona indlela umsebenzi osebenza ngayo AVERAGE makhe sibone umzekelo:

Kumzekelo wokuqala sifake iingxoxo ngqo kumsebenzi.

Kumzekelo wesibini, sibhekise uluhlu oluqulathe amanani. Ungabhekisa kwiseli engasikelwanga mda usebenzisa uluhlu oluqhubekayo kwaye ukuba ufuna ukubhekisa kuluhlu olutshintshayo ungasebenzisa itafile kulonto.

Ungabhekisa kwiseli engasikelwanga mda usebenzisa uluhlu oluqhubekayo kwaye ukuba ufuna ukubhekisa kuluhlu oluguqukayo ungasebenzisa itafile.

Kumzekelo wesithathu sibhekiselele kuluhlu apho iiseli zifomathwe njengamaxabiso abhaliweyo. Kule meko, ungaguqula loo manani okubhaliweyo ukuya kumanani okwenene ukubala umndilili.

Kumzekelo wesine sine-apostrophe phambi kwexabiso ngalinye kwiseli nganye kwaye ngoko ke singahoywa ngumsebenzi.

`AVERAGEA`

Umsebenzi AVERAGEA ye-Excel idweliswe kudidi lweMisebenzi yeNkcazo ye-Microsoft Excel. Ibuyisela umyinge wamanani achaziweyo kumsebenzi, kodwa ngokungafaniyo AVERAGE, iphatha amaxabiso e-Boolean kunye namanani afomathwe njengokubhaliweyo.

syntax

=AVERAGEA(valore1,valore2,…)

iingxoxo

value1 : Ixabiso elilinani, ixabiso eliqiqiweyo, okanye inani eligcinwe njengokubhaliweyo.
[valore2] : Ixabiso elilinani, ixabiso eliqiqiweyo, okanye inani eligcinwe njengokubhaliweyo.

umzekelo

Ukuqonda umsebenzi AVERAGEA kufuneka sibone umzekelo:

Ixabiso elibuyiswe ngumsebenzi ngu-10,17 othi "(0+0+1+10+20+30)/6".

`AVERAGEIF`

Umsebenzi AVERAGEIF ye-Excel idweliswe kudidi lweMisebenzi yeNkcazo ye-Microsoft Excel. Ibuyisela iavareji yamanani anelisa iimeko ezininzi ezikhankanyiweyo .

syntax

= AVERAGEIF( range, criteria, [average_range] )

Iingxabano

range: uluhlu lwamaxabiso (okanye uluhlu lweeseli eziqulathe amaxabiso) ukuvavanya ngokuchasene neenqobo ezinikiweyo.
criteria: Umqathango oza kuvavanywa ngokuchasene nexabiso ngalinye kuluhlu olunikiweyo.
[average_range]: Uluhlu olukhethiweyo lwamaxabiso amanani (okanye iiseli eziqulathe amanani) ekumele ukuba zibe ne-avareji ukuba ixabiso elihambelanayo kuluhlu liyahlangabezana neenqobo ezinikiweyo.

Ukuba isihloko [average_range] ayifakwanga, umndilili ubalelwa amaxabiso kuluhlu olunikiweyo lokuqala.

Iikhrayitheriya ezibonelelweyo zinoku:

ixabiso lamanani (libandakanya i-integers, decimals, dates, times, and logical values) (umzekelo, 10, 01/01/2008, TRUE)
O
umtya wokubhaliweyo (umzekelo, “uMbhalo”, “uLwesine”) – MAKUFANELE kubonelelwe ngokucaphula
O
intetho (umzk. ">12”, “<>0”) – KUFUNEKA kunikelwe kwizicatshulwa.
Kwakhona qaphela ukuba umsebenzi AVERAGEIF I-Excel ayiyongxaki. Ngoko, umzekelo, imitya yokubhaliweyo "TEXT"E"text” iya kuvavanywa ngokulinganayo.

umzekelo

Ukuqonda umsebenzi AVERAGEIF kufuneka sizame kumzekelo.

Iiseli A16-A20 kwesi sipredishithi silandelayo bonisa imizekelo emihlanu yomsebenzi AVERAGEIF ye-Excel.

Kumsebenzi ngamnye umnxeba AVERAGEIF ye-Excel, isihloko range (iya kuvavanywa ngokuchasene criteria) luluhlu lweeseli A1-A14 kunye nesihloko [average_range] (equlathe amaxabiso kufuneka abe yi-avareji) luluhlu lweeseli B1-B14.

Qaphela ukuba, kwiiseli A16, A18, kunye ne-A20 zespreadsheet apha ngasentla, ixabiso lombhalo “Lwesine” kunye namagama ">2” kunye “<>TRUE” zifakwe kumanqaku acatshulweyo. Oku kubalulekile kuzo zonke izicatshulwa okanye amabinzana.

`AVERAGEIFS`

Umsebenzi AVERAGEIFS ye-Excel idweliswe kudidi lweMisebenzi yeNkcazo ye-Microsoft Excel. Ibuyisela iavareji yamanani anelisa iimeko ezininzi ezikhankanyiweyo . Ngokungafaniyo AVERAGEIF, unokuseta iimeko ezininzi kwaye ubale umndilili kuphela kumanani ahlangabezana nazo zonke iimeko.

syntax

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

Iingxabano

average_range: Uluhlu lwamanani amanani (okanye iiseli eziqulathe amanani) afanele ukulinganiselwa.
criteria_range1, [criteria_range2], ...: Uluhlu lwamaxabiso (okanye uluhlu lweeseli eziqulathe amaxabiso) ukuvavanya ngokuchaseneyo enye kwenye criteria1, criteria2, … (Izintlu criteria_range onikiweyo kufuneka zonke zibenobude obufanayo).
criteria1, [criteria2], …: Iimeko eziza kuvavanywa ngokubhekiselele kumaxabiso kwi criteria_range1, [criteria_range2], …

umzekelo

Ngoku makhe sijonge umzekelo womsebenzi AVERAGEIFS:

Kulo mzekelo ulandelayo, sisebenzise umsebenzi AVERAGEIFS ukubala ubungakanani obuqhelekileyo obuthengiswa ngumthengisi "Pietro" kunye nemveliso "B". Sifake iinqobo zokugweba ngokuthe ngqo kumsebenzi kwaye sineengeniso ezimbini zentengiso kaPetros yemveliso B.

Kulo mzekelo ulandelayo, sisebenzise AVERAGEIFS nge asterisk ukubala ixabiso eliqhelekileyo lesiqhamo esinomthamo omkhulu kuneeyunithi ezingama-20 kwaye ino-B egameni.

Kwidatha engezantsi, sineziqhamo ezibini ezihlangabezana nale milinganiselo.

`MEDIAN`

Umsebenzi MEDIAN I-Excel ibuyisela i-statistical median (ixabiso eliphakathi) loluhlu lwamanani anikezelweyo.

syntax

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

Iingxabano

iingxoxo zamanani yiseti enye okanye ngaphezulu kwamaxabiso amanani (okanye uluhlu lwamanani), ofuna ukubala umdibaniso.

Qaphela oko:

Ukuba kukho inani elilinganayo lamaxabiso kwiseti yedatha enikiweyo, umndilili wamaxabiso aphakathi amabini uyabuyiswa;
Ukuba uluhlu olunikezelweyo luqulathe iiseli ezingenanto, okubhaliweyo, okanye amaxabiso anengqiqo, la maxabiso awahoywa xa kubalwa i-median.
Kwiinguqulelo zangoku ze-Excel (i-Excel 2007 nasemva koko), unokubonelela ukuya kuthi ga kwi-255 yeengxabano zamanani kumsebenzi we-Median, kodwa kwi-Excel 2003 umsebenzi unokwamkela kuphela ukuya kwi-30 iingxoxo zamanani. Nangona kunjalo, nganye yeengxoxo zamanani inokuba luluhlu lwamaxabiso amaninzi.

umzekelo

I-spreadsheet elandelayo ibonisa imizekelo emithathu yomsebenzi Median:

Qwalasela oko, kwimizekelo yangaphambili:

Umzekelo kwiseli B2 ifumana inani elilinganayo lamaxabiso kwaye ke ngoko umdibaniso ubalwa njengomndilili wamaxabiso aphakathi amabini, u-8 no-9;
Umzekelo kwiseli B3 iquka iseli engenanto A8. Le seli ayihoywa xa kubalwa i-median.

Ukufumana iinkcukacha ezithe vetshe ngomsebenzi MEDIAN ye-Excel, bona i Iwebhusayithi yeMicrosoft Office .

`MODE`

Umsebenzi MODE yeExcel ibuyisela i MODE izibalo (elona xabiso lixhaphakileyo) loluhlu lwamanani anikiweyo. Ukuba kukho 2 okanye ngaphezulu amaxabiso aphinda-phindayo kwidatha enikiweyo, umsebenzi ubuyisela elona xabiso liphantsi phakathi kwabo

syntax

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

Iingxabano

Ziseti yexabiso elinye okanye ngaphezulu (okanye uluhlu lwamaxabiso), ofuna ukubala ngalo. MODE izibalo.

Qaphela:

Kwiinguqulelo zangoku ze-Excel (i-Excel 2007 nasemva koko), unganikezela ukuya kuthi ga kwi-255 yeengxoxo zamanani kumsebenzi MODE, kodwa kwi-Excel 2003 umsebenzi unokwamkela ukuya kuthi ga kwi-30 yeengxoxo zamanani.
Okubhaliweyo kunye namaxabiso anengqiqo ngaphakathi koluhlu lwamanani olunikiweyo akahoywa ngumsebenzi Mode.

Imizekelo yomsebenzi MODE

Umzekelo 1

I-spreadsheet elandelayo ibonisa umsebenzi MODE Excel, esetyenziselwa ukubala i MODE izibalo zeseti yamaxabiso kwiiseli A1-A6.

Umzekelo 2

I-spreadsheet elandelayo ibonisa umsebenzi MODE, esetyenziselwa ukubala i MODE izibalo zeseti yamaxabiso kwiiseli A1-A10.

Qaphela ukuba kule meko kukho ezimbini mode kwidatha.

Kwimeko engasentla, apho idatha kwikholamu A yespredishithi sangaphambili inezimbini MODE izibalo (3 kunye 4), umsebenzi MODE ibuyisela asezantsi kula maxabiso mabini.

Ukufumana iinkcukacha ezithe vetshe kunye nemizekelo yomsebenzi MODE ye-Excel, bona i Iwebhusayithi yeMicrosoft Office .

`MODE.SNGL`

Umsebenzi MODE.SNGL yeExcel ibuyisela i MODE izibalo (elona xabiso lixhaphakileyo) loluhlu lwamanani anikiweyo. Ukuba kukho 2 okanye ngaphezulu amaxabiso aphinda-phindayo kwidatha enikezelweyo, umsebenzi ubuyisela elona xabiso liphantsi phakathi kwabo.

Umsebenzi Mode.Sngl intsha kwi-Excel 2010 kwaye ke ayifumaneki kwiinguqulelo zangaphambili ze-Excel. Nangona kunjalo, umsebenzi luguqulelo oluthiywe ngokutsha lomsebenzi MODE iyafumaneka kwiinguqulelo zangaphambili ze-Excel.

syntax

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

Iingxabano

Ziseti yexabiso elinye okanye ngaphezulu (okanye uluhlu lwamaxabiso), ofuna ukubala ngalo. MODE.SNGL izibalo.

Imizekelo yomsebenzi MODE.SNGL

Umzekelo 1

I-spreadsheet elandelayo ibonisa umsebenzi MODE.SNGL I-Excel, esetyenziselwa ukubala iMODE yamanani eseti yamaxabiso kwiiseli A1-A6.

Umzekelo 2

I-spreadsheet elandelayo ibonisa umsebenzi MODE.SNGL, esetyenziselwa ukubala imo yestatistical iseti yamaxabiso kwiiseli A1-A10.

Qaphela ukuba kule meko kukho ezimbini mode kwidatha.

Kwimeko engasentla, apho idatha kwikholamu A yespredishithi sangaphambili inezimbini MODE izibalo (3 kunye 4), umsebenzi MODE.SNGL ibuyisela asezantsi kula maxabiso mabini.

Ukufumana iinkcukacha ezithe vetshe kunye nemizekelo yomsebenzi MODE.SNGL ye-Excel, bona i Iwebhusayithi yeMicrosoft Office .

`GEOMEAN`

I-Geometric Mean ngumlinganiselo womyinge obonisa ixabiso eliqhelekileyo leseti yamanani. Lo mlinganiselo unokusetyenziswa kuphela kumaxabiso avumayo.

Intsingiselo yejiyometri iseti yamaxabiso, y ₁ , kwaye ₂ , …, Pha _n ibalwa kunye nefomula:

Qaphela ukuba intsingiselo yejometri ihlala ingaphantsi okanye ilingana ne-arithmetic mean.

Umsebenzi Geomean I-Excel ibala intsingiselo yejiyometri yeqela elinikiweyo lamaxabiso.

syntax

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

Iingxabano

ixabiso lamanani elinye okanye ngaphezulu avumayo (okanye uludwe lwamanani amanani), ofuna ukubala lona intsingiselo yejiyometri.

Kwiinguqulelo zangoku ze-Excel (i-Excel 2007 nasemva koko), umsebenzi unokwamkela ukuya kuthi ga kwiingxoxo zamanani ezingama-255, kodwa kwi-Excel 2003 umsebenzi unokwamkela ukuya kuthi ga kwi-30 yeengxoxo zamanani. Nangona kunjalo, ingxabano nganye inokuba luluhlu lwamaxabiso okanye uluhlu lweeseli, nganye kuzo inokuqulatha amaxabiso amaninzi.

umzekelo

Iseli B1 yespreadsheet ibonisa umzekelo olula womsebenzi geomean kwi-Excel, esetyenziselwa ukubala intsingiselo yejometri yamaxabiso kwiiseli A1-A5.

Kulo mzekelo, umsebenzi weGeomean ubuyisela ixabiso 1.622671112 .

`HARMEAN`

Intsingiselo ye-harmonic ngumlinganiselo wentsingiselo ebalwa njenge-reciprocal ye-arithmetic mean ye-reciprocals. Oku kungabalwa kuphela kumaxabiso avumayo.

Intsingiselo ye-harmonic yesethi yamaxabiso, y1, y2, ..., yn ke ngoko inikwa yifomula:

intsingiselo ye-harmonic isoloko ingaphantsi okanye ilingana nentsingiselo yejometri kwaye intsingiselo yejometri ihlala ingaphantsi okanye ilingana ne-arithmetic mean.

Umsebenzi Harmean I-Excel ibala intsingiselo ye-harmonic yoluhlu olunikiweyo lwamaxabiso.

syntax

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

Iingxabano

ixabiso lamanani elinye okanye ngaphezulu avumayo (okanye uludwe lwamanani amanani), ofuna ukubala lona intsingiselo ye-harmonic.

umzekelo

Iseli B1 kwi-spreadsheet ngasekunene ibonisa umzekelo olula womsebenzi Harmean kwi-Excel, esetyenziselwa ukubala intsingiselo ye-harmonic yamaxabiso kwiiseli A1-A5.

Kulo mzekelo, umsebenzi Harmean ibuyisela ixabiso 1.229508197.

`TRIMMEAN`

Umsebenzi TRIMMEAN (ekwaziwa ngokuba yintsingiselo echetyiweyo) ngumlinganiselo wentsingiselo ebonisa utyekelo olusembindini lweseti yamaxabiso.

Intsingiselo elungisiweyo ibalwa ngokulahla amaxabiso athile ekupheleni koluhlu lwamaxabiso, phambi kokubala i-arithmetic mean yamaxabiso aseleyo. Oku kuthintela umndilili obaliweyo ekubeni ugqwethwe ngamaxabiso agqithisileyo (ekwabizwa ngokuba zii-outliers, ngobuchule outliers).

syntax

= TRIMMEAN( array, percent )

Iingxabano

uluhlu -Uluhlu lwamanani amanani ofuna ukubala wona intsingiselo encitshisiweyo.
pesenti -Ipesenti yamaxabiso ofuna ukucima kuwoarray kubonelelwe.

Qaphela ukuba ixabiso lepesenti elikhankanyiweyo yipesenteji iyonke yamaxabiso anokukhutshelwa ngaphandle kubalo. Le pesenti yahlulwe ngamabini ukufumana inani lamaxabiso asusiweyo kwisiphelo ngasinye soluhlu.

Kufuneka kwakhona kuqatshelwe ukuba xa i-Excel ibala ukuba mangaphi amaxabiso acinyiweyo kwiarray amaxabiso anikiweyo, ipesenti ebalwayo irhangqwa ukuya kutsho kuphinda-phindo olukufutshane lwesi-2. Umzekelo, ukuba ufuna ukubala intsingiselo echetyiweyo ye array kumaxabiso ali-10, ke ngoko:

Ipesenti ye-15% ihambelana namaxabiso ayi-1,5, aya kuthi asondezwe ukuya kutsho ku-0 (o.k.t. akukho maxabiso aya kulahlwaarray phambi kokubala umyinge);
Ipesenti ye-20% ihambelana namaxabiso e-2, ngoko ke ixabiso le-1 liya kulahlwa ukusuka ekupheleni koluhlu ngaphambi kokulinganisa amaxabiso aseleyo;
Ipesenti ye-25% ihambelana nemilinganiselo ye-2,5, eya kujikelezwa phantsi ukuya kwi-2 (oko kukuthi, ixabiso le-1 liya kulahlwa ukusuka ekupheleni koluhlu ngaphambi kokulinganisa amaxabiso asele).

umzekelo

Iiseli B1-B3 kwi-spreadsheet engezantsi bonisa imizekelo emi-3 yomsebenzi trimmean kwi-Excel, zonke zisetyenziselwa ukubala intsingiselo elungisiweyo yamaxabiso kwiiseli A1-A10, ngokwepesenti yamaxabiso ahlukeneyo.

Gcina ukhumbula ukuba, esiseleni B1 yespredishithi esingentla, impikiswano yepesenti enikiweyo yi-15%. Ukusukela kwiarray Ukuba kukho amaxabiso ali-10, inani lamaxabiso ongahoywayo yi-1,5 isondezwe phantsi kuphinda-phindo olukufutshane luka-2 onguziro.

Imisebenzi yokubala iiPermutations

`PERMUT`

Inani leemvumelo zenani elinikiweyo lezinto linani lendibaniselwano kulo naluphi na ulandelelwano olunokwenzeka.

Iimvume zihluke kwiintlanganisela ukuba, kwi-permutation, umyalelo wezinto ezibalulekileyo, kodwa ngokudibeneyo umyalelo awukhathali.

Inani leemvumelwano ezinokubakho linikwa ngefomula:

ihobe k linani lezinto ezikhethiweyo e n linani lezinto ezinokubakho.

Umsebenzi we-Excel Permut ibala inani leemvumelwano zenani elichaziweyo lezinto ukusuka kwiseti yezinto.

syntax

= PERMUT( number, number_chosen )

Iingxabano

number: Inani lilonke lezinto ezikhoyo
number_chosen: Inani lezinto kwi-permutation nganye (okt inani lezinto ezikhethiweyo kwiseti)

Qaphela ukuba naziphi na iingxoxo ezinikiweyo njengamaxabiso edesimali, ziyakunqunyulwa zibe manani apheleleyo ngomsebenzi. Permut.

umzekelo

Kwi-spreadsheet elandelayo, i-Excel Permut isetyenziselwa ukubala inani leemvumelo zezinto ezintandathu, ezikhethwe kwiiseti zobukhulu obahlukeneyo:

`PERMUTATIONA`

Imisebenzi ye-Excel Utshintshiselwano kunye nePermutationa zombini zibala inani leemvumelwano zokhetho lwezinto ukusuka kwiseti.

Nangona kunjalo, le misebenzi mibini iyahluka ekubeni i Umsebenzi wemvume ayibala uphinda-phindo ngelixa iPermutationa umsebenzi ubala uphinda-phindo.

Umzekelo, kwiseti yezinto ezi-3, a , b , c , zingaphi iimvumelwano ezikhoyo kwizinto ezi-2?

La Umsebenzi wemvume ibuyisela isiphumo sesi-6 (iimvume: ab , ac , ba , bc , ca , cb );
Umsebenzi wePermutationa ubuyisela isiphumo 9 (iimvume: aa , ab , ac , ba , bb , bc , ca , cb , cc ).

Umsebenzi we-Excel Permutationa ibala inani leemvumelwano zenani elichaziweyo lezinto ukusuka kwiseti yezinto.

syntax

= PERMUTATIONA( number, number_chosen )

Iingxabano

number: Inani elipheleleyo lezinto kwisethi (kufuneka ibe ≥ 0).
number_chosen: Inani lezinto ezikhethiweyo kwisethi (kufuneka ibe ≥ 0).

Qaphela ukuba naziphi na iingxoxo ezinikiweyo njengamaxabiso edesimali, ziyakunqunyulwa zibe manani apheleleyo ngomsebenzi. PERMUTATIONA.

umzekelo

Kwi-spreadsheet elandelayo, i-Excel PERMUTATIONA isetyenziselwa ukubala inani leemvumelo zezinto ezintandathu, ezikhethwe kwiiseti zobukhulu obahlukeneyo:

Imisebenzi yokubala amaxesha okuzithemba

`CONFIDENCE`

Kwi-Excel 2010, umsebenzi CONFIDENCE ithathelwe indawo ngumsebenzi Confidence.Norm.

Nangona itshintshiwe, iinguqulelo zangoku ze-Excel zisenalo uphawu Confidence (igcinwe kuluhlu lwemisebenzi ehambelanayo), ukuvumela ukuhambelana neenguqulelo zangaphambili ze-Excel.

Nangona kunjalo, umsebenzi Confidence isenokungafumaneki kwiinguqulelo ezizayo ze-Excel, ngoko sicebisa ukuba usebenzise inqaku Confidence.Norm, ukuba kuyenzeka.

Umsebenzi Confidence I-Excel isebenzisa unikezelo oluqhelekileyo ukubala ixabiso lokuzithemba elinokuthi lisetyenziswe ukwakha isithuba sokuzithemba kwintsingiselo yabemi, ithuba elinikiweyo, kunye nobungakanani besampulu. Kucingelwa ukuba ukutenxa komgangatho wabantu kuyaziwa.

syntax

= CONFIDENCE( alpha, standard_dev, size )

Iingxabano

alfa: Inqanaba lokubaluleka (= 1 - inqanaba lokuzithemba). (Umzekelo, inqanaba lokubaluleka kwe-0,05 lilingana ne-95% yokuzithemba).
standard_dev: Ukutenxa umgangatho wabemi.
size: Ubungakanani besampulu yabemi.

Ukubala isithuba sokuzithemba kwintsingiselo yabemi, ixabiso lokuzithemba elibuyisiweyo kufuneka longezwe kwaye lithatyathwe kwisampulu yentsingiselo. Ithetha ntoni. kwisampulu ithetha x:

Confidence Interval = x ± CONFIDENCE

umzekelo

Kwi-spreadsheet engezantsi, umsebenzi wokuzithemba we-Excel usetyenziselwa ukubala ixesha lokuzithemba ngokubaluleka kwe-0,05 (oko kukuthi i-95% yenqanaba lokuzithemba), kwintsingiselo yesampulu ye-100 yamadoda aphakamileyo. Imilinganiselo yesampulu yimitha ye-1,8 kwaye ukuphambuka okusemgangathweni yi-0,07 yeemitha.

Umsebenzi wangaphambili ubuyisela ixabiso lokuzithemba le-0,013719748

Ngoko ke ixesha lokuzithemba liyi-1,8 ± 0,013719748, elilingana noluhlu oluphakathi kwe-1,786280252 kunye ne-1,813719748

`CONFIDENCE.NORM`

Kwizibalo, isithuba sokuzithemba luludwe apho iparamitha yabemi inokuwela khona, kumathuba anikiweyo.

Umzekelo. Kubantu abanikiweyo kunye ne-95% enokwenzeka, ixesha lokuzithemba luluhlu apho i-parameter yabemi i-95% inokwenzeka ukuba iwe.

Qaphela ukuba ukuchaneka kwexesha lokuzithemba kuxhomekeke ekubeni ngaba abantu banosasazo oluqhelekileyo.

Umsebenzi Confidence.Norm I-Excel isebenzisa unikezelo oluqhelekileyo ukubala ixabiso lokuzithemba elinokuthi lisetyenziswe ukwakha isithuba sokuzithemba kwintsingiselo yabemi, ithuba elinikiweyo, kunye nobungakanani besampulu. Kucingelwa ukuba ukutenxa komgangatho wabantu kuyaziwa.

syntax

= CONFIDENCE.NORM( alpha, standard_dev, size )

Iingxabano

alfa: Inqanaba lokubaluleka (= 1 - inqanaba lokuzithemba). (Umzekelo, inqanaba lokubaluleka kwe-0,05 lilingana ne-95% yokuzithemba).
standard_dev: Ukutenxa umgangatho wabemi.
size: Ubungakanani besampulu yabemi.

Ukubala isithuba sokuzithemba kwintsingiselo yabemi, ixabiso lokuzithemba elibuyisiweyo kufuneka longezwe kwaye lithatyathwe kwisampulu yentsingiselo. Ithetha ntoni. kwisampulu ithetha x:

Confidence Interval = x ± CONFIDENCE

umzekelo