Tazarar amincewa a cikin Excel. Hanyoyi 2 don ƙididdige tazarar amincewa a cikin Excel

Ana ƙididdige tazarar amincewa don warware tambayoyin ƙididdiga. Nemo wannan lambar ba tare da taimakon kwamfuta yana da wahala sosai ba, don haka ya kamata ku yi amfani da kayan aikin Excel idan kuna buƙatar nemo kewayon karkacewa daga ma'anar samfurin.

Ƙididdigar Tazarar Amincewa tare da Mai Aiwatar da CONFID.NORM

Mai aiki yana cikin nau'in "Kididdiga". A cikin sigar farko, ana kiranta “TRUST”, aikinta ya ƙunshi muhawara iri ɗaya.

Cikakken aikin yayi kama da haka: =AMINCI.NORM(Alpha,Standard,Size).

Yi la'akari da dabarar ma'aikaci ta gardama (kowannensu dole ne ya bayyana a cikin lissafin):

1. "Alpha" yana nuna matakin mahimmancin da aka dogara akan lissafin.

Akwai hanyoyi guda biyu don ƙididdige ƙarin matakin:

• 1- (Alpha) – dace idan gardama ne coefficient. Misali: 1-0,4=0,6 (0,4=40%/100%);
• (100-(Alpha))/100 - Ana amfani da dabarar lokacin ƙididdige tazara a matsayin kashi. Misali: (100-40)/100=0,6.

2. Ma'auni na ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun izini a cikin wani samfuri na musamman.
3. Girman - adadin bayanan da aka bincika

Kula! Ana iya samun ma'aikacin TRUST a cikin Excel. Idan kana buƙatar amfani da shi, nemi shi a cikin sashin "Compatibility".

Bari mu duba dabara a aikace. Kuna buƙatar ƙirƙirar tebur mai ƙididdige ƙididdiga masu yawa. Yi la'akari da cewa ma'auni na daidaituwa shine 7. Manufar ita ce ta ƙayyade tazara tare da matakin amincewa na 80%.

Ba lallai ba ne don shigar da ɓarna da matakin amincewa a kan takardar, ana iya shigar da waɗannan bayanan da hannu. Lissafin yana faruwa a matakai da yawa:

1. Zaɓi tantanin halitta mara komai kuma buɗe "Mai sarrafa ayyuka". Zai bayyana akan allon bayan danna alamar "F (x)" kusa da mashaya dabara. Hakanan zaka iya zuwa menu na ayyuka ta shafin "Formulas" akan ma'aunin kayan aiki, a bangaren hagu akwai maballin "Saka aikin" mai alamar iri ɗaya.

2. Zaɓi sashin "Kididdiga" kuma nemo cikin jerin abubuwan mai aiki TRUST.NORM. Kuna buƙatar danna shi kuma danna "Ok".

3. Tagan Cika Arguments zai buɗe. Layi na farko ya kamata ya ƙunshi dabara don ƙididdige hujjar "Alpha". Dangane da yanayin, an bayyana matakin amana azaman kashi, don haka muna amfani da dabara ta biyu: (100-(Alfa))/100.
4. An riga an san madaidaicin madaidaicin, bari mu rubuta shi a cikin layi ko zaɓi tantanin halitta tare da bayanan da aka sanya akan shafin. Layi na uku ya ƙunshi adadin rikodin a cikin tebur - akwai 10 daga cikinsu. Bayan cika dukkan filayen, danna "Enter" ko "Ok".

Ana iya sarrafa aikin ta atomatik ta yadda canza bayanin baya haifar da gazawar lissafin. Bari mu gano yadda za a yi shi mataki-mataki.

1. Lokacin da filin "Girman" bai riga ya cika ba, danna kan shi, sa shi aiki. Sa'an nan kuma mu buɗe menu na aiki - yana gefen hagu na allon akan layi ɗaya tare da ma'aunin dabara. Don buɗe shi, danna kan kibiya. Kuna buƙatar zaɓar sashin "Sauran ayyuka", wannan shine shigarwar ƙarshe a cikin jerin.

2. Mai sarrafa Aiki zai sake bayyana. Daga cikin ma'aikatan ƙididdiga, kuna buƙatar nemo aikin "Account" kuma zaɓi shi.

Muhimmin! Hujjojin aikin COUNT na iya zama lambobi, sel, ko ƙungiyoyin sel. A wannan yanayin, na karshen zai yi. A cikin duka, tsarin ba zai iya samun fiye da 255 muhawara ba.

3. Babban filin yakamata ya ƙunshi ƙimar da aka haɗa cikin kewayon tantanin halitta. Danna kan hujja ta farko, zaɓi ginshiƙi ba tare da taken ba, sannan danna maɓallin Ok.

Ƙimar tazara za ta bayyana a cikin tantanin halitta. An samo wannan lambar ta amfani da bayanan misali: 2,83683532.

Ƙaddamar da tazarar amincewa ta hanyar ARZIKI.DALILI

Hakanan ana nufin wannan ma'aikacin don ƙididdige kewayon karkata. A cikin lissafin, ana amfani da dabarun daban-daban - yana amfani da rarrabawar ɗalibi, muddin ba a san yaduwar ƙimar ba.

Tsarin ya bambanta da na baya kawai a cikin mai aiki. Ga alama kamar haka: =AMINCI.DALIBAN(Alpha;Ctand_off; size).

Muna amfani da tebur da aka ajiye don sababbin ƙididdiga. Madaidaicin karkata a cikin sabuwar matsala ta zama hujjar da ba a sani ba.

1. Bude "Mai sarrafa Ayyuka" a ɗayan hanyoyin da aka bayyana a sama. Kuna buƙatar nemo aikin CONFIDENCE.STUDENT a cikin sashin "Statistical", zaɓi shi kuma danna "Ok".

2. Cika muhawarar aikin. Layin farko iri ɗaya ne: (100-(Alfa))/100.
3. Ba a san karkacewar ba, gwargwadon yanayin matsalar. Don ƙididdige shi, muna amfani da ƙarin dabara. Kuna buƙatar danna filin na biyu a cikin taga muhawara, buɗe menu na ayyuka kuma zaɓi abu "Sauran ayyuka".

4. Yana buƙatar ma'aikacin STDDEV.B (ta samfurin) a cikin sashin ƙididdiga. Zaɓi shi kuma danna Ok.

5. Mun cika hujja ta farko na taga da aka buɗe tare da kewayon sel tare da ƙima ba tare da la'akari da taken ba. Ba kwa buƙatar danna Ok bayan haka.

6. Mu koma ga hujjar AMINCI.DALILI ta danna sau biyu akan wannan rubutun a cikin mashigin dabara. A cikin filin "Size", saita mai aiki COUNT, a matsayin lokacin ƙarshe.

Bayan latsa "Enter" ko "Ok" sabuwar darajar tazarar amincewa zata bayyana a cikin tantanin halitta. A cewar Student, ya zama ƙasa da - 0,540168684.

Ƙayyade iyakokin tazara a bangarorin biyu

Don ƙididdige iyakokin tazara, kuna buƙatar gano menene matsakaicin ƙimarsa, ta amfani da aikin AVERAGE.

1. Bude "Mai sarrafa Aiki" kuma zaɓi mai aiki da ake so a cikin sashin "Statistical".

2. Ƙara ƙungiyar sel masu ɗauke da ƙima zuwa filin muhawara na farko kuma danna maɓallin Ok.

3. Yanzu zaku iya ayyana iyakoki na dama da hagu. Zai ɗauki ɗan lissafi mai sauƙi. Lissafin iyakar dama: zaɓi tantanin halitta mara komai, ƙara sel a ciki tare da tazarar amincewa da matsakaicin ƙima.

4. Don tantance gefen hagu, dole ne a cire tazarar amincewa daga ma'anar.

5. Muna yin ayyuka iri ɗaya tare da tazarar amincewar ɗalibi. A sakamakon haka, muna samun iyakokin tazara a cikin nau'i biyu.

Kammalawa

“Mai sarrafa Aiki” na Excel yana sauƙaƙa samun tazarar amincewa. Ana iya ƙaddara ta hanyoyi biyu, waɗanda ke amfani da hanyoyi daban-daban na lissafi.