Mmene Mungayesere Kutsika Kwambiri Ndi Ntchito ya STDEV ya Excel

01 ya 01

Ntchito yotchedwa STDEV (Standard Deviation)

Kuyesa Kusiyana Kwambiri ndi Ntchito STDEV. © Ted French

Kusiyana kwa chikhalidwe ndi chida cha chiwerengero chomwe chimakuuzani mochuluka kuti, kutalika, chiwerengero chirichonse cha mndandanda wa chidziwitso cha deta chimasiyanasiyana ndi mtengo wamtengo wapatali kapena masamu kumatanthauza mndandanda wokha.

Mwachitsanzo, pa nambala 1, 2

Ntchito STDEV, komabe, imapereka chiwerengero chokhachokha. Ntchitoyi imaganiza kuti ziwerengero zomwe zilipo zikuimira gawo laling'ono chabe kapena chiwerengero cha anthu omwe akuphunzira.

Zotsatira zake, ntchito ya STDEV siibweretsanso ndondomeko yoyenerera. Mwachitsanzo, pakuti nambala 1, 2 STDEV ikugwira ntchito ku Excel ikubwezeretsanso mtengo wa 0.71 mmalo mochotsa chiwonongeko cha 0.5.

Ntchito STDEV Ntchito

Ngakhale kuti zimangoganizira zolephereka, ntchitoyo imagwiritsidwa ntchito pamene mbali yochepa chabe ya anthu ikuyesedwa.

Mwachitsanzo, poyesedwa zinthu zopangidwa kuti zigwirizane ndi zomwe zikutanthawuza - zayeso monga kukula kapena kupirira - sizomwe zimayesedwa. Nambala yeniyeni yokha imayesedwa ndipo kuchokera pa ichi kulingalira kwa kuchuluka kwa chigawo chirichonse mu chiwerengero chonse cha anthu chikusiyana kuchokera ku zenizeni chingapezeke pogwiritsa ntchito STDEV.

Pofuna kusonyeza momwe zotsatira za STDEV zimakhalira zingakhale zenizeni zenizeni, mu chithunzi pamwambapa, kukula kwazitsanzo zomwe zimagwiritsidwa ntchito pa ntchitoyi kunali zosachepera gawo limodzi mwa magawo atatu a chiwerengerocho koma kusiyana pakati pa kuwonongeka ndi kuyerekezera kwenikweni ndi 0.02 okha.

Syntax ndi Maganizo a Ntchito ya STDEV

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Mawu omasulidwa a Standard Deviation function ndi awa:

= STDEV (Namba1, Namba2, ... Number255)

Nambala1 - (yofunika) - ikhoza kukhala nambala yeniyeni, malo otchulidwa kapena ma selo omwe amapezeka pa deta.
- ngati mafotokozedwe a selo amagwiritsidwa ntchito, maselo opanda kanthu, maonekedwe a Boolean , deta ya malemba, kapena malingaliro olakwika m'magulu osiyanasiyana a ma selo amanyalanyazidwa.

Number2, ... Number255 - (zosankha) - mpaka manambala 255 akhoza kulowa

Chitsanzo Pogwiritsa ntchito Excel STDEV

Mu chithunzi pamwambapa, ntchito ya STDEV imagwiritsidwa ntchito kulingalira kusasintha kwapadera kwa deta m'maselo A1 mpaka D10.

Chitsanzo cha deta yogwiritsidwa ntchito pa ndondomeko ya Nambalayi ikupezeka m'maselo A5 mpaka D7.

Poyerekeza, kufotokozera kwapadera ndi chiwerengero cha deta yonse ya A1 mpaka D10 ikuphatikizidwa

Zomwe zili m'munsiyi zikutsegula njira zomwe zingagwiritsidwe ntchito STDEV mu selo D12.

Kulowa ntchito ya STDEV

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

  1. Kujambula ntchito yonse: = STDEV (A5: D7) mu selo D12
  2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito STDEV ntchito dialog box

Ngakhale kuti n'zotheka kungolemba ntchito yonseyo ndi dzanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo kuti ayambe kukambirana.

Onani, bokosi la ntchitoyi silipezeka mu Excel 2010 komanso pamapeto pake pulogalamuyi. Kuti muzigwiritse ntchito mu mawamasulidwe awa, ntchitoyo iyenera kulowa mwadongosolo.

Masitepe omwe ali m'munsimu chikugwiritsidwa ntchito pogwiritsa ntchito bokosi la bokosi kuti mulowetse STDEV ndi zifukwa zake mu selo D12 pogwiritsa ntchito Excel 2007.

Kuyesa Kusiyana Kwambiri

  1. Dinani pa selo D12 kuti mupange selo yogwira ntchito - malo pomwe zotsatira za STDEV ziwonetsedwe
  2. Dinani pa Fomu ya Fomu.
  3. Sankhani Ntchito Zambiri> Chiwerengero chochokera ku riboni kuti mutsegule ntchitoyi.
  4. Dinani pa STDEV mndandanda kuti mubweretse bokosi lazokambirana.
  5. Onetsetsani maselo A5 mpaka D7 mu tsamba lokuthandizani kuti mulowetse mndandanda mu bokosi la mafunso monga nambala ya Nambala
  6. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.
  7. Yankho 2.37 liyenera kupereka mu selo D12.
  8. Nambala iyi ikuimira kuwonongeka kwa chiwerengero cha nambala iliyonse mu mndandanda kuchokera ku mtengo wa 4.5
  9. Mukasindikiza pa selo E8 ntchito yonse = STDEV (A5: D7) ikuwoneka muzenera zamatabwa pamwamba pa tsamba

Zifukwa Zogwiritsira Ntchito Bokosi la Bokosi la Zilumikizo Phatikizani:

  1. Bukhuli limasamalira mgwirizano wa ntchito - kuti zikhale zosavuta kulowetsa ziganizo zomwe zimagwira ntchito imodzi pokha popanda kuika chizindikiro chofanana, mabakiteriya, kapena makasitomala omwe amachititsa kuti azikhala osiyana pakati pazitsutsano.
  2. Malingaliro a magulu angakhoze kulowetsedwa mwa njirayo pofotokoza , zomwe zimaphatikizapo kusindikiza maselo osankhidwa ndi mbewa mmalo mowasindikiza. Sikuti kumangosonyeza zosavuta, kumathandizanso kuchepetsa zolakwika m'mawu omwe amachitidwa ndi maumboni olakwika a selo.