Kuwerengera kogwirizana kwa kusintha kwa zinthu mu Microsoft Excel

Chimodzi mwazizindikiro zazikulu zowonetsera kuchuluka kwa manambala ndizogwirizana mosiyanasiyana. Kuti mupeze, kuwerengera zovuta. Zida za Microsoft Excel zimapangitsa kuti wosuta azivuta.

Kuwerengera kwa mgawo wosinthika

Chizindikirochi chikuyimira chiŵerengero cha kupatuka kwazomwe zimayimira masamu. Zotsatira zake zimawonetsedwa ngati peresenti.

Ku Excel palibe ntchito yapadera yowerengera chizindikirochi, koma pali njira zowerengera kupatuka ndi tanthauzo la masamu angapo angapo, omwe amagwiritsidwa ntchito kuti apeze mgwirizano wa kusiyanasiyana.

Gawo 1: kuwerengera kupatuka koyenera

Kupatuka kwofananira, kapena, monga momwe zimatchulidwira m'mawu ena, kupatuka kwokhazikika, ndiye muzu wokulirapo. Kuti mupeze kupatuka koyenera, gwiritsani ntchito ntchito STD. Kuyambira ndi mtundu wa Excel 2010, amagawidwa malinga ndi kuchuluka kwa anthu kapena kusankhidwa, m'magawo awiri osiyana: STANDOTLON.G ndi STANDOTLON.V.

Syntax ya ntchito izi ndi motere:


= STD (Nambala1; Nambala2; ...)
= STD.G (Nambala1; Nambala2; ...)
= STD. B (Nambala1; Nambala2; ...)

1. Kuti mupeze kupatuka koyenera, sankhani foni iliyonse yaulere pa pepala yomwe ili yabwino kwa inu kuti muwonetse zotsatira zake. Dinani batani "Ikani ntchito". Ili ndi mawonekedwe a chithunzi ndipo ili kumanzere kwa mzere wa fomula.



2. Kachitidwe kakuchitika Ogwira Ntchito, zomwe zimayamba ngati zenera losiyana ndi mndandanda wazokangana. Pitani ku gulu "Zowerengera" kapena "Mndandanda wathunthu wa zilembo". Sankhani dzina STANDOTKLON.G kapena STANDOTKLON.V, kutengera kuchuluka kwa anthu kapena chitsanzocho ayenera kuwerengera. Dinani batani "Zabwino".



3. Yenera kutsutsana pa ntchitoyi kutsegulidwa. Imatha kukhala ndi magawo 1 mpaka 255, omwe amatha kukhala ndi manambala komanso magawo awiri amomwe amathandizira maselo kapena mzere. Ikani wolemba m'munda "Nambala1". Pogwiritsa ntchito mbewa, sankhani mtundu wazikhalidwe zomwe ziyenera kukonzedwa pa pepalalo. Ngati pali madera angapo osakhala oyandikana, ndiye kuti zogwirizira zotsatirazi zikuwonetsedwa "Nambala2" etc. Datha yonse ikalowa, dinani batani "Zabwino"



4. Selo lomwe linasankhidwa limawonetsa zotsatira za kuwerengera kosankhidwa kwa mtundu wosankhidwa.

Phunziro: Fomu yokhazikika yokhazikika

Gawo 2: werengani tanthauzo la masamu

Kutanthauza Arithmetic ndiko kuwerengera kwa kuchuluka kwa mitengo yonse yamitundu yonseyo. Palinso ntchito yapadera yowerengera chizindikiro ichi - NJIRA. Timawerengera phindu lake pogwiritsa ntchito chitsanzo.

1. Sankhani foni papepala kuti muwonetse zotsatira. Dinani batani lomwe tikudziwa kale "Ikani ntchito".



2. Mu gawo la Statist Wizard tikufuna dzinalo SRZNACH. Mukasankha, dinani batani "Zabwino".



3. Kugundana Kwawindo la Window NJIRA. Zotsutsana ndizofanana ndendende ndi omwe amayendetsa gulu. STD. Ndiye kuti, mumkhalidwe wawo amatha kuchita zinthu monga maumwini, komanso maulalo. Khazikitsani chotembezera m'munda "Nambala1". Monga momwe zinalili m'mbuyomu, timasankha maselo omwe amafunikira pa pepalalo. Mapulogalamu awo atalowetsedwa pawindo la mkangano, dinani batani "Zabwino".



4. Zotsatira zakuwerengera tanthauzo la masamu zimawonetsedwa mu khungu lomwe lidasankhidwa lisanatsegulidwe Ogwira Ntchito.

Phunziro: Momwe mungawerengere mtengo wapakatikati mu Excel

Gawo 3: kupeza cholowa cha kusiyanasiyana

Tsopano tili ndi chidziwitso chonse chofunikira kuti tithe kuwerengera mwachindunji kuchuluka kwa kutalika.

1. Sankhani khungu lomwe zotsatira zikuwonetsedwa. Choyamba, muyenera kuwona kuti cholowa chosinthika ndichofunika peresenti. Pankhaniyi, muyenera kusintha mawonekedwe a cell kukhala oyenera. Izi zitha kuchitika mutasankha, kukhala tabu "Pofikira". Dinani pamunda wamtundu pa riboni mu chipangizo chida "Chiwerengero". Kuchokera pamndandanda wotsika pansi wa zosankha, sankhani "Chidwi". Pambuyo pa izi, mawonekedwe amtunduwo adzakhala oyenera.



2. Ndiponso, bweretsani foni kuti muwonetse zotsatira. Timayambitsa ndi kudina kawiri batani la mbewa. Timayika chikwangwani "=". Sankhani chinthu chomwe zotsatira za kuwerengera kupatuka kwapezeka. Dinani pa "kugawanitsa" batani (/) pa kiyibodi. Kenako, sankhani khungu lomwe masamu angapo masamu a manambala amapezeka. Kuti muwerengere ndikuwonetsa phindu, dinani batani Lowani pa kiyibodi.



3. Monga mukuwonera, zowerengera zikuwonetsedwa pazenera.

Chifukwa chake, tidawerengera kukwaniritsa kwakusiyana, kutanthauza ma cell momwe kupatuka kwofananira ndi tanthauzo la masamu kudali kuwerengedwa kale. Koma munthu atha kupitilira mosiyanako, osawerengera zotsatirazi.

1. Timasankha khungu lomwe lidapangidwa kale kuti liziwoneka bwino, momwe zotsatira zake zidzawonekere. Tikulembamo mawu akuti:

   = STDB.V (value_range) / AVERAGE (value_range)

   M'malo mwa dzina Mtengo Wokwera timayika zigwirizano zenizeni za chigawo momwe zigawenga zomwe zapezeka. Izi zitha kuchitika pongowunikira mtundu wapadera. M'malo mwa wothandizira STANDOTLON.Vngati wogwiritsa ntchito akuwona kuti ndikofunikira, mutha kugwiritsa ntchito ntchitoyo STANDOTLON.G.



2. Pambuyo pake, kuti muwerenge phindu ndikuwonetsa zotsatira zake pazenera, dinani batani Lowani.

Pali kuwongolera kwapang'onopang'ono. Amakhulupirira kuti ngati chogwirira ntchito zosinthika bwino ndizosakwana 33%, ndiye kuti kuchuluka kwa manambala sikokwanira. M'malo mwake, ndichizolowezi kuti anthuwa ndi opambana.

Monga mukuwonera, pulogalamu ya Excel ikhoza kusinthitsa kuwerengera kwa mawerengero ovuta kuwerengera ngati kusaka kogwirizana kwa kusiyana. Tsoka ilo, ntchitoyo ilibe ntchito yomwe ingawerengere chizindikirochi pochita chimodzi, koma ogwiritsa ntchito STD ndi NJIRA Ntchitoyi imakhala yosavuta. Chifukwa chake, mu Excel, imatha kuchitidwa ndi munthu yemwe alibe nzeru zambiri zokhudzana ndi malamulo owerengera.