Chimodzi mwa zizindikiro zazikulu za chiwerengero cha manambala owerengeka ndi coefficient of variation. Kuti mupeze izo, zowerengera zovuta zimakhala zopangidwa. Zida za Microsoft Excel zimapangitsa kukhala kosavuta kwa wogwiritsa ntchito.
Kuwerengera kuchuluka kwa coefficient
Chizindikiro ichi ndi chiŵerengero cha kusokonezeka kwachiwerengero ku masamu kumatanthauza. Chotsatira chikuwonetsedwa ngati peresenti.
Mu Excel, palibe ntchito yosiyana yowerengera chizindikiro ichi, koma pali mayina owerengera kusiyana kwa chiwerengero ndipo masamu amatanthauza manambala angapo, omwe, amagwiritsidwa ntchito kupeza coefficient of variation.
Khwerero 1: Lembani Kusiyana Koyima
Kusiyanitsa kwapadera, kapena, monga kumatchedwa mosiyana, kusokonezeka kofanana, ndilo mzere wozungulira wa kusiyana kwake. Ntchitoyi imagwiritsidwa ntchito kuwerengera zolepheretsa. STANDOWCLONE. Kuyambira ndi ndondomeko ya Excel 2010, igawidwa, malingana ndi kuti, malinga ndi chiŵerengero chonse cha anthu, kuwerengera kumachitika kapena mwachitsanzo, muzosankha ziwiri zosiyana: STANDOCLON.G ndi STANDOWCLON.V.
Chidule cha ntchito izi ndi izi:
= STDEV (Number1; Number2; ...)
= STDEV.G (Number1; Number2; ...)
= STDEV.V (Number1; Number2; ...)
- Kuti muwerenge kusintha kwapadera, sankhani selo iliyonse yaulere pa pepala, zomwe ziri zoyenera kuti muwonetse mmenemo zotsatira za kuwerengera. Dinani pa batani "Ikani ntchito". Ili ndi mawonekedwe a chizindikiro ndipo ili kumanzere kwa bar.
- Ntchito ikupitirira Oyang'anira ntchitochimene chimayenda ngati zenera losiyana ndi mndandanda wa zifukwa. Pitani ku gawo "Zotsatira" kapena "Mndandanda wathunthu wa alfabeti". Sankhani dzina "STANDOTKLON.G" kapena "STANDOTKLON.V", malinga ndi chiwerengero cha anthu kapena chitsanzo choyenera kuwerengedwa. Timakanikiza batani "Chabwino".
- Festile yotsutsana ya ntchitoyi imatsegulidwa. Ikhoza kukhala ndi minda 1 mpaka 255, yomwe ingakhale ndi nambala yeniyeni ndi mafotokozedwe a maselo kapena mzere. Ikani cholozera mmunda "Number1". Nkhumba imasankha pa pepala mfundo zambiri zomwe zimayenera kukonzedwa. Ngati pali malo oterowo ndipo sali pafupi ndi wina ndi mzake, ndiye makonzedwe a lotsatira akuwonetsedwa m'mundawu "Number2" ndi zina zotero Pamene deta yonse yofunikira idaikidwa, dinani pa batani "Chabwino"
- Selo yoyamba yosankhidwa imasonyeza zotsatira za kuwerengera kwa mtundu wosankhidwa wa kusokonekera.
Phunziro: Excel Standard Deviation Formula
Khwerero 2: Terengani Zomwe Ziwerengero Zikutanthauza
Chiwerengero cha masamu ndi chiŵerengero cha chiwerengero cha ziwerengero zonse za mndandanda wa nambala kwa nambala yawo. Kuti muwerenge chizindikiro ichi, palinso ntchito yosiyana - MALANGIZO. Timawerengera mtengo wake pachitsanzo.
- Sankhani selo pa pepala kuti muwonetse zotsatira. Timakanikiza pa batani yomwe tidziwa kale. "Ikani ntchito".
- Mu chiwerengero cha machitidwe a masters timayang'ana dzina. "SRZNACH". Mukasankha, dinani pa batani. "Chabwino".
- Kuwombera zenera kumayambira. MALANGIZO. Zokambirana zili zofanana ndi za ogwira ntchito. STANDOWCLONE. Izi zikutanthauza kuti ziwerengero komanso maumboni angakhale ngati iwo. Ikani cholozera mmunda "Number1". Monga momwe zinalili kale, timasankha pa pepala selo la maselo omwe timafunikira. Pambuyo pazigawo zawo zalowa muzenera la zenera, kanikizani pa batani "Chabwino".
- Chotsatira cha kuwerengera chiwerengero cha masamu chikuwonetsedwa mu selo yomwe idasankhidwa isanatsegulidwe Oyang'anira ntchito.
Phunziro: Momwe mungawerengere mtengo wamtengo wapatali ku Excel
Gawo 3: kupeza coefficient of variation
Tsopano tiri ndi deta yonse yofunikira kuti tidziŵe mwachindunji coefficient of variation palokha.
- Sankhani selo limene zotsatira zake zidzawonetsedwa. Choyamba, muyenera kuganizira kuti coefficient of variation ndi mtengo wa phindu. Pachifukwa ichi, muyenera kusintha mawonekedwe a selo kumodzi woyenera. Izi zikhoza kuchitika mukasankha, pokhala pa tab "Kunyumba". Dinani pamtundu wamtundu pa kaboni mu bokosi lazamasamba "Nambala". Kuchokera pandandanda wa zosankha, sankhani "Chidwi". Pambuyo pazimenezi, maonekedwe a chinthucho adzakhala oyenera.
- Bwererani ku selo kuti muwonetse zotsatira. Limbikitsani izo mobwereza kawiri pa batani lamanzere. Ife timayika mu chizindikiro chake "=". Sankhani chinthu chomwe zotsatira za chiwerengero cha zolepheretsa zipezeka. Dinani pa batani "ogawanika" (/) pabokosi. Kenaka, sankhani selo limene mawerengedwe a masamu a mndandanda wa nambalayo alipo. Kuti muwerenge ndi kusonyeza mtengo, dinani batani Lowani pabokosi.
- Monga mukuonera, zotsatira za mawerengedwe amawonetsedwa pawindo.
Motero, tinayesa kuchuluka kwa coefficient of variation, kutanthauza maselo omwe chiyero choyendayenda ndi chiwerengero cha masamu anali kale kuwerengedwa. Koma mukhoza kuchita pang'ono mosiyana, popanda kuwerengera mfundo izi mosiyana.
- Sankhani selo yoyeneretsedweratu kuti muyambe kufotokozera gawo lomwe zotsatira zake ziwonetsedwe. Ife timapereka mmenemo ndondomeko ya mtundu:
= STDEV.V (miyezo yamtengo wapatali) / AVERAGE (miyezo yambiri)Mmalo mwa dzina "Phindu Lalikulu" onetsetsani zolumikiza zenizeni za dera limene mawerengedwe a manambala alipo. Izi zikhoza kuchitika mwa kuwonetsa mwachidule izi. M'malo mochita STANDOWCLON.Vngati wogwiritsa ntchito akuwona kuti ndi koyenera, mungagwiritse ntchito ntchitoyi STANDOCLON.G.
- Pambuyo pake, kuti muwerenge mtengo ndi kusonyeza zotsatira pazenera, onani pa batani Lowani.
Pali kusiyana kovomerezeka. Zimakhulupirira kuti ngati coefficient of variation ndi zosakwana 33%, ndiye chiwerengero cha manambala ndi ofanana. Mulimonsemo, ndi chizoloŵezi chowonetsera kuti ndi yopanda malire.
Monga mukuonera, pulogalamu ya Excel ikukuthandizani kuti mukhale ochepa kwambiri kuwerengera kwa zowerengera zowerengeka zowerengeka monga kufufuza kwa kusiyana kwa coefficient. Tsoka ilo, ntchitoyi ilibenso ntchito yomwe ingawerengetse chizindikiro ichi mwachitapo chimodzi, koma mothandizidwa ndi ogwira ntchito STANDOWCLONE ndi MALANGIZO Ntchitoyi ndi yosavuta. Kotero, mu Excel izo zikhoza kuchitidwa ngakhale ndi munthu yemwe alibe chidziwitso chapamwamba chokhudzana ndi ziwerengero za ziwerengero.
