Nzira yekufananidza kutsauka kwakakwana neEexcel basa re STDEV

01 ye 01

Excel STDEV (Standard Deviation) Basa

Chimiro chekutsauka ndicho chiziviso chechirwere chinokuudza zvishoma nezvishoma kusvika, pamwero wega, nhamba yega yega mune zvakarongwa zvehuwandu hwemashoko yakasiyana kubva kuhuwandu hwekukosha kana arithmetic zvinoreva zverwendo pacharo.

Somuenzaniso, nokuda kwenhamba 1, 2

• iyo yavhareji inokosha 1.5 (yakaverengwa nokuwedzera nhamba mbiri pamwe chete nekuparadzanisa 2: (1 + 2) / 2)
• chimiro chekutsauka kana kure kure kubva kune izvi zvinoreva 1.5 kune nhamba 1 uye 2 is 0.5 - sezvo nhamba imwe neimwe iri 0.5 yakawanda kana shoma inokosha kupfuura 1.5

Basa re STDEV, zvisinei, rinopa huwandu hwekutsauka kwakakwana. Basa racho rinotora kuti iyo inopinda nhamba inomiririra chikamu chiduku kana muenzaniso wehuwandu hwevanhu huri kuverengwa.

Somugumisiro, basa re STDEV haritauri zvakanyatsopera kukanganisa. Somuenzaniso, kune nhamba 1, 2 inonzi STDEV inowanikwa muExcel inodzorera kukosha kwekufungidzirwa kwe 0.71 panzvimbo pekutsauka kwakakwana kwe 0.5.

STDEV Kushanda Kwemabasa

Kunyange zvazvo inongotarisa kushayirwa kwemaitiro, basa racho rinoshandiswa iyo apo chikamu chiduku chevanhu vose chiri kuedzwa.

Semuenzaniso, apo kuedzwa kunogadzirwa michina kuti ienderane neanoreva - zvezviyero zvakadai sekukura kana kugadzikana - kwete zvisikwa zvose zvinoedzwa. Nhamba imwe chete inoshandiswa uye kubva kune ichi kuongororwa kwekuti chikamu chimwe nechimwe muhuwandu hwevanhu vose chinoparadzaniswa kubva kune chinangwa chinogona kuwanikwa kuburikidza nekushandisa STDEV.

Kuti aratidze kuti zvakagadziriswa sei zveSDEDEV zvinogona kunge zvakasvibiswa zvakakwana, mumufananidzo wepamusoro, shanduro yekuenzanisa yakashandiswa kwebasa yakanga isiri pasi peii chimwe chetatu chehuwandu hwemashoko asi musiyano pakati pekufungidzirwa uye chaiyo kupotsa kwakasiyana inongova 0.02 chete.

Iko Syntax yeMabasa uye Arguments

Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .

Izwi rechirevo cheStart Deviation function nderokuti:

= STDEV (Nhamba1, Nhamba2, ... Nhamba255)

Nhamba1 - (inofanirwa) - inogona kuva nhamba chaiyo, inonzi zita rakatarisa kana kuti zvinyorwa zvinoreva kunzvimbo yedhesi mune pepa rekushanda.
- kana zvinyorwa zvinoshandiswa zvinoshandiswa, masero asina chinhu, maitiro eBoolean , deta data, kana kuti maitiro ekukanganisa mumakero ezvinyorwa zvinyorwa hazvina hanya.

Number2, ... Number255 - ((kusarudzo) - kusvika ku 255 nhamba inogona kupinda

Muenzaniso Kushandisa Excel STDEV

Mumufananidzo wepamusoro, basa re STDEV rinoshandiswa kuenzanisa kuperevedza kwakakwana kune data mumasero A1 kusvika D10.

Muenzaniso we data wakashandiswa pakuita nharo Nhamba yenhamba iri mumasero A5 kusvika kuD7.

Nokuenzanisira zvinangwa, kushandiswa kwemazuva ose uye kuenzanisira kwekakwana kwedhayamisi yeA1 kusvika D10 inosanganiswa

Izwi iri pasi apa rinovhara matanho anoshandiswa kupinda mu STDEV mubasa D12.

Kupinda Basa re STDEV

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana: = STDEV (A5: D7) muchitokisi D12
2. Kusarudza basa uye mazano aro uchishandisa STDEV basa dialog box

Kunyange zvazvo zvichibvira kungonyora basa rakakwana riri muruoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa.

Cherechedza, bhokisi rebhokisi rebasa iri hariwanikwi muExcel 2010 uye mushure mekushandurwa kwepurogiramu. Kuti uishandise mumashanduro aya, basa racho rinofanira kupinda maune.

Matanho ari pasi apa anoshandisa sarudzo yebhokisi yebasa kuti uise STDEV uye nharo dzayo muchitokisi D12 uchishandisa Excel 2007.

Kufungidzira Kusiyana Kwekutevedzera

1. Dzvanyira pane sero D12 kuti uite sero rinoshanda - nzvimbo iyo migumisiro ye STDEV icharatidzwa
2. Dzvanya paMafomu eTom.
3. Sarudza Mamwe Mabasa> Statistical kubva kubhoni kuti uzarure basa rinoderera pasi.
4. Dzvanya pa STDEV mune urongwa kuti ubudise bhokisi rebasa rebasa.
5. Simbisai masero A5 kusvika kuD7 mubasa rekushanda kuti uise bhanhire mubhokisi rebhokisi seNhamba yenyaya
6. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda .
7. Mhinduro 2.37 inofanira kuiswa muchitokisi D12.
8. Iyi nhamba inomiririra kukanganisa kuenzaniswa kwenhamba imwe neimwe mune urongwa kubva pahuwandu hunokosha hwe4,5
9. Paunenge uchibvisa pane cell E8 zvakakwana basa = STDEV (A5: D7) inowanikwa mubhairi yepamusoro pane pepa rekushanda

Zvikonzero zvekushandisa Bhokisi reDhiyabhorosi Rokushandisa Itai kuti:

1. Bhokisi rebhokisi rinotarisira sangano rebasa - zvichiita kuti zvive nyore kupinda mhinduro dzebasa rimwe chete pane imwe nguva pasina kuisa chiratidzo chakaenzana, mabheji, kana kuti makasita anoita separarator pakati pezvakaitika.
2. Nhamba dzenhare dzinogona kuiswa mumushandisi uchishandisa kuratidza , izvo zvinobatanidza kuvhara masero akasarudzwa ane mouse kunze kwekuisa mukati. Haisi kungoerekana ichitaura nyore, inobatsirawo kuderedza mapurogiramu mumafomu anokonzerwa nemaitiro asina kukodzera masero.