Indlela Yokulinganisa Ukuphambaniswa Okuvamile Ne-Excel sika-STDEV Umsebenzi

01 ka 01

Umsebenzi we-Excel STDEV (Ukuphambene Okujwayelekile)

Ukuphambuka okujwayelekile kuyithuluzi lokubala elikutshela ukuthi cishe kangakanani, ngokulinganiselwe, inombolo ngayinye kuhlu lwamanani we-data uhluka kusukela ku-value isilinganiso noma isithathi semqondo ohlwini loqobo.

Isibonelo, izinombolo 1, 2

• inani elilinganiselwe ngu-1.5 (kubalwa ngokungeza izinombolo ezimbili ndawonye futhi uhlukanise ngo 2: (1 + 2) / 2)
• ukuphambuka okujwayelekile noma ibanga kude nale ncazelo ye-1.5 ngoba izinombolo 1 no-2 zingu-0.5 - ngoba inombolo ngayinye ingu-0.5 enkulu noma encane kunenani eliphansi kune-1.5

Umsebenzi we-STDEV, noma kunjalo, unikeza kuphela ukulinganisa kokuphambuka okujwayelekile. Lo msebenzi uthatha ukuthi izinombolo ezifakiwe zimelela ingxenye encane kuphela noma isampula yendawo yonke ehlolwayo.

Ngenxa yalokho, umsebenzi we-STDEV awubuyiseli ukuphambuka okujwayelekile. Isibonelo, ngoba izinombolo 1, 2 umsebenzi we-STDEV ku-Excel ubuyisela inani elilinganisiwe le-0.71 kunokuba ukuphambuka okuqondile kwe-0.5.

Izinsiza zokusebenza ze-STDEV

Ngisho noma ihlola kuphela ukuphambuka okujwayelekile, umsebenzi usasebenza lapho kuphela ingxenye encane yabantu bonke ihlolwe.

Isibonelo, uma ukuhlolwa kwemikhiqizo eyenziwe ukuvumelanisa nesimo - ngezinyathelo ezifana nesayizi noma ukuqina - akuwona yonke into ehlolwe. Inombolo ethile kuphela ehlolwe futhi kusukela kulokhu ukulinganisa ukuthi inani ngalinye kuleso sonke isizwe lihlukahluka kunalutho lingatholakala ngokusebenzisa i-STDEV.

Ukuze ukhombise ukuthi imiphumela eseduze ye-STDEV ingaba kanjani ukuphambuka okujwayelekile, esithombeni esingenhla, usayizi wesampula osetshenziselwa umsebenzi wawungaphansi kwezingxenye eyodwa kwezintathu zedatha yonke idatha okwamanje umehluko phakathi kokuphambuka okulinganiselwe nokujwayelekile okujwayelekile ngu-0.02 kuphela.

I-syntax ye-Function ne-Arguments ye-STDEV

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .

I-syntax ye-Standard Deviation function iwukuthi:

= STDEV (Inombolo1, Inombolo2, ... Inamba255)

Inombolo1 - (edingekayo) - ingaba izinombolo zangempela, ububanzi obuqanjwe noma izingqikithi zamaseli endaweni yedatha kushidi lokusebenzela.
- uma izinkomba zeseli zisetshenzisiwe, amaseli angenalutho, amanani we-Boolean , idatha yombhalo, noma amanani wephutha ekubhekeni kwezingqamuzana zamangqamuzana alunaki.

Inombolo2, ... Inombolo255 - (okukhethwa kukho) - kuze kufinyelele kuzinombolo ezingu-255

Isibonelo Ukusebenzisa i-STDEV ye-Excel

Emfanekisweni ngenhla, umsebenzi we-STDEV usetshenziselwa ukulinganisa ukuphambuka okujwayelekile kwedatha kumaseli A1 kuya ku-D10.

Isampula yedatha esetshenziselwa ukuphikisana kwenombolo yomsebenzi itholakala kumaseli A5 kuya ku-D7.

Ngenhloso yokuqhathanisa, ukuphambuka okujwayelekile kanye nesilinganiso sebanga eliphelele ledatha A1 kuya ku-D10 kufakiwe

Ulwazi olungezansi luhlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-STDEV kuseli D12.

Ukufaka umsebenzi we-STDEV

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele: = STDEV (A5: D7) kuseli D12
2. Ukukhetha umsebenzi kanye neziphakamiso zayo usebenzisa ibhokisi lebhokisi lengxoxo ye- STDEV

Nakuba kungenzeka nje ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi.

Qaphela, ibhokisi lengxoxo yalo msebenzi alitholakali ku-Excel 2010 nezinguqulo zamuva zalolu hlelo. Ukuze uyisebenzise kulezi zinguqulo, umsebenzi kufanele ufakwe ngesandla.

Izinyathelo ezingezansi kwekhava usebenzisa ibhokisi lengxoxo lomsebenzi ukufaka i-STDEV nezimpikiswano zayo esitokisini D12 usebenzisa i-Excel 2007.

Ukulinganisa Ukuphambene Okujwayelekile

1. Chofoza kuseli D12 ukuze wenze iseli elisebenzayo - indawo lapho imiphumela ye-STDEV izoboniswa khona
2. Chofoza kuthebhu yefomula .
3. Khetha Imisebenzi Engaphezulu> Isitatimende kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza phansi.
4. Chofoza ku- STDEV kuhlu ukuze ulethe ibhokisi lengxoxo lomsebenzi.
5. Gqamisa amaseli A5 kuya ku-D7 ekhasini lokusebenzela ukuze ufake ibanga ebhokisini lebhokisi njengombhikisho wenombolo
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela .
7. Impendulo 2.37 kufanele ifakwe esitokisini D12.
8. Le nombolo ibonisa ukuphambuka okulinganiselwe okulinganiselwe kwenombolo ngayinye kuhlu oluvela kubaluleka obujwayelekile be-4.5
9. Uma uchofoza kweseli E8 umsebenzi ophelele = STDEV (A5: D7) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela

Izizathu Zokusebenzisa Ibhokisi Lebhokisi Lokuxoxa Faka:

1. Ibhokisi lebhokisi liyakhathalela i-syntax yomsebenzi - okwenza kube lula ukufaka izingxabano zomsebenzi ngesikhathi esisodwa ngaphandle kokufaka uphawu olulinganayo, amabakaki, noma amakhomishana enza njengabahlukanisi phakathi kwezimpikiswano.
2. Izinkomba zefoni zingangena kwifomula ngokukhomba , okubandakanya ukuchofoza amangqamuzana akhethiwe negundane kunokuba uthayiphe. Akusikho kuphela okukhomba ukuthi kulula, futhi kusiza ukunciphisa amaphutha kumafomula abangelwa ukubhekwa kwamangqamuzana angalungile.