Indlela yokulinganisa ukuphambuka okuqhelekileyo nge-Excel ye-STDEV Umsebenzi

01 ngo 01

I-Excel ye-STDEV (Ukuphambuka okuMgangatho) Umsebenzi

Ukuphambukiswa okuqhelekileyo kuyisitatisti esichazela ngokucacileyo ukuba kude kangakanani, ngokwenani, inamba nganye kwiluhlu lwamanani eenkcukacha iyahluka ukusuka kwixabiso eliqhelekileyo okanye i-arithmetic ithetha ngokwalo uluhlu ngokwayo.

Umzekelo, ukwenzela amanani 1, 2

• Ixabiso eliqhelekileyo li-1.5 (kubalwa ngokufaka amanani amabini kunye nokuhlula ngo-2: (1 + 2) / 2)
• ukuphambuka okuqhelekileyo okanye umgama kude nale nto ithetha ukuba 1.5 kuba inani 1 no-2 ngu-0.5 - kuba inani ngalinye liba likhulu okanye lixabiso elingaphantsi kwe-1.5

Umsebenzi we-STDEV, nangona kunjalo, unikela kuphela ukuqikelela kokuphambuka okuqhelekileyo. Umsebenzi uthatha ukuba amanani angenisiweyo amele isahlulo esincinane okanye isampula yabantu bonke abafundiswayo.

Ngenxa yoko, umsebenzi we-STDEV awubuyiseli ukuchithwa okuthe ngqo. Umzekelo, kuba inani 1, 2 umsebenzi we-STDEV kwi-Excel ubuyisela ixabiso eliqikelelweyo le-0.71 kunokuba uphambuke ngokuthe ngqo kwi-0.5.

Usetyenziso lweSDVV

Nangona liqikelela kuphela ukuphambukiswa okuqhelekileyo, umsebenzi usasebenzisa xa kuphela inxalenye encinci yabemi bonke abavavanywayo.

Ngokomzekelo, xa uvavanyo lweemveliso zenziwe ngokuhambelana nenjongo - ngokuba imilinganiselo enjengobungakanani okanye ukuzinza - akuyiyo yonke into ehlolwayo. Kuphela inani elithile livavanywa kwaye ukusuka kuloku kuqikelelwa ukuba ubuninzi beyunithi nganye kubemi bonke abantu bahluka kwiintetho banokufumaneka nge-STDEV.

Ukubonisa ukuba iziphumo ezikufutshane ze-STDEV zingaba njani ukuphambuka okusemgangathweni, kumfanekiso ongentla, isayizi yesampula esetyenziselwa umsebenzi yayingaphantsi kweyesithathu yesamba semali, kodwa ke umahluko phakathi kokulinganisa nokulinganisa okuqhelekileyo kuphela 0.02.

I-Syntax yeMisebenzi kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .

I-syntax yoMsebenzi wokuPhambukisa oPhezulu ngu:

= STDEV (Inani1, Inani2, ... Inani255)

Inombolo1 - (efunekayo) - ingaba ngamanani ngokwenene, udidi olukhethiweyo okanye iiferensi zeeselferensi kwindawo yendawo kwiphepha lokusebenzela.
- ukuba izitenferensi zesetyenzisiweyo zisetyenzisiwe, iiseli ezingenanto, ixabiso le-Boolean , idata yombhalo, okanye iimpawu zephutha kwimiba yeeferensi zesalathisi.

Inombolo2, ... Inani255 - (ukhetho) - ukuya kwii-255 iinombolo zingeniswa

Umzekelo Ukusebenzisa i-Excel ye-STDEV

Kulo mfanekiso ngasentla, umsebenzi we-STDEV usetyenziselwa ukuqikelela ukuphambuka okuqhelekileyo kwedatha kwiiseli A1 ukuya kwi-D10.

Isampuli yedatha esetyenziselwa ingxabano yenombolo ikhona kwiiseli A5 ukuya kwi-D7.

Ngenjongo yokuthelekisa, ukuphambuka okuqhelekileyo kunye nomyinge wefayile epheleleyo ye-A1 ukuya kwi-D10 ifakiwe

Ingcaciso engezantsi ihlanganisa amanyathelo asetyenziswa ukufaka umsebenzi we-STDEV kwiseli D12.

Ukufaka umsebenzi we-STDEV

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

1. Ukuthayipha umsebenzi opheleleyo: = STDEV (A5: D7) kwi-cell D12
2. Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yebhokisi ye -STDEV

Nangona kunokwenzeka ukuba uthayiphe nje umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko yababini ukufaka iingxabano zomsebenzi.

Qaphela, ibhokisi yencoko yalo msebenzi ayitholakali kwi-Excel 2010 kunye neenguqulelo zexesha elizayo leprogram. Ukuyisebenzisa kwezi nguqulelo, umsebenzi kufuneka ungenwe ngesandla.

Amanyathelo angezantsi agcina usebenzisa ibhokisi yencoko yencoko yomsebenzi ukufaka i-STDEV kunye neengxoxo zayo kwisitokisi se-D12 usebenzisa i-Excel 2007.

Ukulinganisa ukuPhambuka okuMgangatho

1. Cofa kwiseli D12 ukwenzela ukuba yenze iseli esebenzayo - indawo apho iziphumo ze-STDEV ziza kuboniswa
2. Cofa kwiThebhu yefomula.
3. Khetha Imisebenzi Engakumbi> Isitatisti kwibhebhoni ukuvula uluhlu lokuhla kwehla.
4. Cofa kwi- STDEV kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi.
5. Gqamisa iiseli ezi-A5 ukuya kwi-D7 kwiphepha lokusebenzela ukufaka uluhlu kwibhokisi yencoko njengombambano wenombolo
6. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela .
7. Impendulo 2.37 kufuneka ifake kwi-cell D12.
8. Le nombolo ibonisa ukuphambuka okuqhelekileyo kwinqanaba ngalinye kwinani ukusuka kwixabiso eliqhelekileyo le-4.5
9. Xa ucofa kwi-cell E8 umsebenzi opheleleyo = STDEV (A5: D7) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela

Izizathu zokusebenzisa iBhokisi yeeNgcaciso zeeNkcazo ziquka:

1. Ibhokisi yencoko ibinakekisa i-syntax yomsebenzi - yenza kube lula ukufaka iingxabano zomsebenzi omnye ngexesha ngaphandle kokungena uphawu olulinganayo, iibakaki, okanye ii-commas ezenza njengabahluli phakathi kweengxabano.
2. Iingqinisiso zeselula zingangeniswa kwifom usebenzisa ukukhomba , oku kuquka ukucofa kwiiseli ezikhethiweyo kunye nemouse kunokuba uzifake. Kukho nje ukubonisa okulula, kunceda ekunciphiseni amaphutha kwiimfomula ezibangelwa zikhombisi zeseli ezingalunganga.