Shanda nemapurogiramu espredishiti senge Excel inopa mikana isingaperi nekuda kwekushandisa mafomula akasiyana uye equations. Iwo aripo mabasa anovhara chero chero chinodikanwa chatinacho chedu chedzidzo nehunyanzvi magwaro. Nhasi tichatarisa zvakanyanya pamubvunzo we maitiro ekuverenga kutsauka kwakazara mukugona.
Ndeupi musiyano wakatsauka?
Pfungwa iyi yakakosha kwazvo kana uchiita manhamba ekuverenga. Inozivikanwawo nemazita ekutsauka kwakazara kana kutsauka kwakazara, ichimiririrwa nenzira yakapfupikiswa nechepasi pezasi tsamba reGreek sigma (σ) kana tsamba yechiLatin "s". Iyo inowanzo kuve inomiririrwa nechidimbu SD, kubva kuChirungu kutsauka kwakaringana.
Iyi mita inoshandiswa kuyera mutsauko kana Kupararira kweiyo seti kana sampuro yehuwandu hwenhamba. Kutsauka kwakajairika kunogara kwakakura kupfuura kana kuenzana zero. Kana mwero wekutsauka wakadzikira (padhuze ne zero), zvinoreva kuti yakawanda yedata inoiswa padhuze nechinoreva; Kune rimwe divi, mwero wepamusoro wekutsauka unoratidza kuti iyo data yakapararira uye inovhara huwandu hwakawanda hwetsika.
Iko kuverenga kwekutsauka kwakazara kunogona kuve nako chaizvo anoshanda mafomu mune zvimwe zvidzidzo zvinoverengeka. Chinhu chayo chikuru chinoshandiswa kutibvumidza isu kuziva iyo chiyero chepakati pekupararira kwekusiyana, ndiko kuti, kureba kwakadii kwakasiyana tsika dzeboka kubva paavhareji kukosha.
Mienzaniso mitatu yakasiyana yehukama pakati pezvinoreva uye kutsauka kwakazara
El graphic pamitsetse iyi inoratidza mienzaniso mitatu yakasiyana yekutsauka kwakasarudzika: yakakwira, yepakati nepasi, imwe neimwe iine hukama nehuremu hunoreva.
Nzira yakashata yekuitsanangura iri nemuenzaniso unotevera. Mhosva mbiri dzakasiyana:
- Nyaya 1: Ngatimbofungidzirai boka revane makore makumi matatu nemasere, makumi mana nemasere ekuberekwa. Ivhareji ndeye makumi mana, asi iyo kutsauka kwakajairika kushoma, sezvo kukosha kwese kuri padyo nayo, nemitengo iri makore maviri chete kunze kweiyo avhareji kukosha.
- Nyaya 2Zvino ngatifungidzire kuti mazera evana vababa ane makore makumi maviri nemashanu, makumi mana nemakumi mashanu nemashanu. Zvinoreva zvicharamba zviri makumi mana, asi kupararira kuri kukuru. Sezvinei, kutsauka kwakajairika kwakakura, nemitengo iri makore gumi nemashanu kubva paavhareji kukosha.
Kuziva izvo zvinorehwa uye zvakajairika kutsauka kwekuparadzirwa kwedatha dzakateedzana, zvinokwanisika kuverenga mukana wekuwana yakakwira kana yakaderera mhedzisiro maererano nehumwe kukosha. Kunyangwe ichitaridzika kunge isinganzwisisike kune vakawanda, kuverenga uku kune zvakakosha mukuenzanisira kwemari, semuenzaniso.
Asi pachinzvimbo chekumisa njodzi yekurasika mumasvomhu mazes, ngatitarisei pamubvunzo mukuru uye wepakati dingindira reposvo yedu: maitiro ekuverenga kutsauka kwakazara muExcel.
Maitiro ekuverenga mwero kutsauka muExcel
Kuita iyi masvomhu kuverenga mune yeexcel pepa iri nyore uye nekukurumidza. Kuti tiite izvi isu tinofanirwa kutevera matanho aya:
- Pakutanga pachena zvichave zviripo pinda Microsoft Excel uye shandisa pepanhau Izvo zvine iyo data kubva kwatinoda kuwana iyo yakasarudzika kutsauka.
- Tevere tinofanirwa kuunza hunhu hwatinoda kushandisa. Kune izvi isu tinosarudza ikholamu uye isu tinonyora kukosha kwedata rega rega mune rimwe remasero.
- Kana tangopinza data rese mukoramu yakasarudzwa, danho rinotevera ndere kudzvanya pane a isina chinhu sero. Ndiro sero rakasarudzirwa mhedzisiro umo kukosha kwekutsauka kwakazara kuchazoonekwa.
- Kumusoro pabhawa isu tichaunza fomu yekutsauka kwakazara kwesero risina chinhu ratakasarudza. Iyo fomula ndeiyi:
= KUSVIRA.P (XX: XX)
STDEV ipfupi ne "kutsauka kwakazara," nepo P inomirira huwandu hwevanhu, "ndokuti," sampuro. " Maitiro anoenda mumabhureki anoenderana nemaseru akasarudzwa ayo ane zvimiro zvakasiyana zveiyo sampuli.
- Nhanho inotevera ndeiyi ipa huwandu hwetsika pane iyo Excel ichaita kuverenga. Izvi zvinofanirwa kuiswa nemazvo pakati pevabereki. Ikoko unofanirwa kunyora tsamba uye nhamba yesero rega rega. Kana iwo maseru ari ehukama, semuenzaniso, kubva paA2 kusvika paA20, isu tinongonyora yekutanga neyekupedzisira yakaparadzaniswa nekoloni (:). Kutevedzera uyu muenzaniso, kwaizoita kunge seizvi: = STDEV.P (A2: A20).
- Nhanho yekupedzisira kudzvanya kiyi «Pinda» yeExcel yekushandisa fomu uye kuratidza mhedzisiro muchitokisi chakasarudzwa pakutanga.
Iyo STDE inoshanda muMicrosoft Excel inoshandisa inotevera fomula.
Iko "x" inotora kukosha kweiyo average sampuro inoreva (value1, value2, ...) uye iyo "n" inomiririra saizi yayo.
Dzimwe nhamba dzekuverenga neExcel
Kunze kwekuziva maitiro ekuverenga kutsauka kwakazara muExcel, zvinonyanya kuitika kuti pakuronga dhata mumashizha edu ekushandira tichafanirwa kuenda kune mamwe mafomula. Iwo akajairika ndeaya anotibvumidza kuverenga kukosha senge zvinoreva, median, maitiro, uye mutsauko.
Media
Sezvinozivikanwa nemunhu wese, iyo vezvenhau (inonzi zvakare arithmetic kureva) ndiwo mhedzisiro yekuwedzera akasiyana manhamba uye kuigovanisa nenhamba yezvinhu zvakateedzana. Kuti uwane zvinoreva, iyo sisitimu inenge yakafanana neiya inoshandiswa kuverenga kutsauka kwakazara muExcel. Musiyano chete ndiyo nzira inoshandiswa, mune ino kesi ndeiyi: = KUDZIDZA (kukoshaX: kukoshaY).
WeMedhia
La svikiro ye seti yenhamba, iyo inowanzo kanganiswa neyakarehwa, ndiyo kukosha iyo iri muchinzvimbo chinoreva chakateedzana. Izvo hazvifanirwe kuenzanisa zvinorehwa. Fomura iyo inoshandiswa pakuverenga kwayo muExcel ndeiyi: = MEDIAN (kukoshaX: kukoshaY).
fashoni
La Moda ye seti yenhamba kukosha uko kunodzokororwa nguva zhinji. Uye hazvidi kuti zvifananidze chero zvinorehwa kana zvemukati. Iyo nzira yekuiverenga muExcel ndeiyi: = MODE (kukoshaX: kukoshaY).
makakava
Pfungwa iyi yakati rebei kupfuura iya yapfuura. Iyo kusiyanisa yakanyatsobatanidzwa kune zvinoreva uye kutsauka kwakazara. Iyo imwe nzira yekuyera kupararira kweiyo seti yehunhu hwenhamba, ichingoreva "daro" umo seti yemitengo inosuduruka kubva pane zvinoreva. Fomura: = VAR (kukoshaX: kukoshaY).