Esinye sezibonakaliso eziyinhloko zezibalo zokulandelana kwezinombolo yi-coefficient of variation. Ukuthola, kunalokho kubalwa okunzima okwenziwe. Amathuluzi we-Microsoft Excel enza kube lula kumsebenzisi.
Ibala ukulingana kokulingana
Lesi sibonakaliso siyisilinganiso sokuphambuka okujwayelekile kwisilinganiso se-arithmetic. Umphumela uboniswa njengephesenti.
Ku-Excel, akukho msebenzi ohlukile wokubala le nkhomba, kodwa kunamafomula wokubala ukuphambana okujwayelekile kanye nencazelo ye-arithmetic yochungechunge lwezinombolo, okungukuthi, lisetshenziselwa ukuthola ukulingana kokulingana.
Isinyathelo soku-1: Bala ukuhamba okujwayelekile
Ukuphambuka okujwayelekile, noma, njengoba kubizwe ngokuhlukile, ukuphambuka okujwayelekile, kuyisisekelo sendawo yokuhluka. Umsebenzi usetshenziselwa ukubala ukuphambuka okujwayelekile. STANDOWCLONE. Ukuqala ngenguqulo ye-Excel 2010, ihlukaniswe, kuye ngokuthi, ngokusho kwenani labantu, isibalo senzeke noma ngesampula, zibe yizinketho ezimbili ezihlukene: STANDOCLON.G futhi I-STANDOWCLON.V.
I-syntax yale misebenzi ilandelayo:
= STDEV (Inombolo1; Inombolo2; ...)
= STDEV.G (Inombolo1; Inombolo2; ...)
= STDEV.V (Inombolo1; Inombolo2; ...)
- Ukuze ubale ukuphambuka okujwayelekile, khetha noma iyiphi iseli yamahhala kushidi, okulula ukuthi ubonise kulo imiphumela yezibalo. Chofoza inkinobho "Faka umsebenzi". Inokubonakala kwesithonjana futhi itholakala ngakwesobunxele kwibha yefomula.
- Ukuqalisa kuqhubeka Amakhosi omsebenziokuyinto egijima njengewindi ehlukile nehlu lwezingxabano. Iya kusigaba "Isitatimende" noma "Uhlu oluphelele lwe-alfabhethi". Khetha igama "STANDOTKLON.G" noma "STANDOTKLON.V", kuye ngokuthi ngabe inani noma isampula kufanele ibalwe. Sicindezela inkinobho "Kulungile".
- Iwindi lempikiswano yomsebenzi ivula. Kungaba namasimu angu-1 kuya kwangu-255, angaqukatha kokubili izinombolo ezithile nezinkomba kumaseli noma kumabanga. Faka i-cursor ensimini "Number1". Igundane likhetha eshadini ububanzi bamanani adingeka ukucutshungulwa. Uma kunezindawo eziningana ezinjalo futhi zingekho eduze komunye nomunye, khona-ke izixhumanisi ezilandelayo zikhonjisiwe ensimini "Number2" nokunye Uma yonke imininingwane edingekayo ingenwe, chofoza inkinobho "Kulungile"
- Iseli elikhethiwe libonisa umphumela wokubala kohlobo olukhethiwe lokuphambuka okujwayelekile.
Isifundo: I-Excel Standard Forward Deviation
Isinyathelo sesibili: Bala isilinganiso sama-Arithmetic
Isilinganiso se-arithmetic yisilinganiso senani eliphelele lazo zonke izindinganiso zochungechunge lwamanani kunombolo yabo. Ukubala le nkhomba, kunomsebenzi ohlukile - ISAVERAGE. Sibala inani laso kusibonelo esithile.
- Khetha iseli kushidi ukuze ubonise umphumela. Sicindezela inkinobho esivele sijwayele kithi. "Faka umsebenzi".
- Esikhathini sesigaba sesibalo samakhosi omsebenzi sibheka igama. "SRZNACH". Ngemva kokukhetha, chofoza inkinobho. "Kulungile".
- Iwindi lokuvuvukala liqala. ISAVERAGE. Izimpikiswano zifana ncamashi nalabo bama-operators eqembu. STANDOWCLONE. Okokuthi, kokubili izindinganiso zamanani kanye nezinkomba zokubala zingenza njengabo. Setha isikhombisi emkhakheni "Number1". Njengalapho esedlule, sikhetha eshadini isethi yamaseli esiwadingayo. Ngemuva kokuthi izixhumanisi zabo zingene emkhakheni wewindi lempikiswano, chofoza inkinobho "Kulungile".
- Umphumela wokubala isilinganiso sesibalo se-arithmetic uboniswa esitokisini okhethiwe ngaphambi kokuvula Amakhosi omsebenzi.
Isifundo: Indlela yokubala inani elilinganiselwe ku-Excel
Isinyathelo sesi-3: ukuthola i-coefficient of variation
Manje sinayo yonke idatha edingekayo ukuze sibone ngokuqondile i-coefficient of variation ngokwayo.
- Khetha iseli lapho umphumela uzoboniswa khona. Okokuqala, udinga ukucabangela ukuthi i-coefficient of variation yi-value percentage. Kulokhu, kufanele ushintshe ifomethi yeseli kuleyo efanele. Lokhu kungenziwa ngemuva kokuyikhetha, ekubeni kuthebhu "Ikhaya". Chofoza kwenkomfa yefomathi ebhodini ebhokisini lamathuluzi "Inombolo". Kusukela ohlwini lokukhethwa kukho, khetha "Inzalo". Emva kwalezi zenzo, ifomethi yesici izoba efanelekile.
- Buyela esitokisini ukuze ubonise umphumela. Yenza kusebenze ngokuchofoza kabili inkinobho yegundane lesokunxele. Sibeka uphawu lwakhe "=". Khetha isici lapho umphumela wokubala wokuphambuka okujwayelekile kutholakala khona. Chofoza inkinobho "yokuhlukanisa" (/) kwikhibhodi. Okulandelayo, khetha iseli lapho isilinganiso se-arithmetic sochungechunge lwenombolo ecacisiwe sitholakala. Ukubala nokubonisa inani, chofoza inkinobho Ngena kwikhibhodi.
- Njengoba ubona, umphumela wokubala uboniswa esikrinini.
Ngakho-ke, sibalwa i-coefficient of variation, ebhekisela kumaseli lapho ukuphambuka okujwayelekile kanye nesilinganiso samathambo sekuvele kubalwa. Kodwa ungenza okuhlukile ngokuhlukile, ngaphandle kokubala lezi zimiso ngokuhlukile.
- Khetha iseli elifakwe kuqala kufomethi yephesenti lapho umphumela uzoboniswa khona. Sichaza kuwo ifomula ngohlobo:
= STDEV.V (ububanzi bamanani) / AVERAGE (ububanzi bamanani)Esikhundleni segama "Linganisa u-Range" faka izixhumanisi zangempela zendawo lapho uchungechunge lwamanani lukhona khona. Lokhu kungenziwa ngokumane uqokomise lolu hlu. Esikhundleni se-opharetha I-STANDOWCLON.Vuma umsebenzisi ebheka kuyadingeka, ungasebenzisa lo msebenzi STANDOCLON.G.
- Ngemuva kwalokho, ukubala inani futhi ubonise umphumela kusikrini sokuqapha, chofoza inkinobho Ngena.
Kukhona ukuhlukaniswa okunemibandela. Kukholelwa ukuthi uma i-coefficient of variation ingaphansi kwama-33%, inani lezinombolo lilingana. Esimweni esiphikisanayo, kuyisiko ukuveza ukuthi liyingqayizivele.
Njengoba ungabona, uhlelo lwe-Excel likuvumela ukuba wenze lula ukubala kokubala okubalwa okunzima njengokubalwa kwesilinganiso se-coefficient of variation. Ngeshwa, uhlelo lokusebenza alunayo umsebenzi olungabala le nkomba ngesenzo esisodwa, kodwa ngosizo lwabaqhubi STANDOWCLONE futhi ISAVERAGE Lo msebenzi ulula kakhulu. Ngakho-ke, ku-Excel kungenziwa ngisho nangomuntu ongenalo ulwazi oluphakeme lolwazi oluhlobene namaphethini wokubala.
