Kuwerengetsa kwapang'onopang'ono kuwerengera ku Microsoft Excel

Njira imodzi yothanirana ndi mavuto owerengera ndikuwerengera nthawi yomwe idatsimikizire. Imagwiritsidwa ntchito ngati njira yomwe ingakonde kutsindika ndi mtundu wocheperako. Tiyenera kudziwa kuti njira yowerengera nthawi yolimba mtima ndiyovuta. Koma zida za Excel zitha kumveketsa pang'ono. Tiyeni tiwone momwe izi zimachitikira.

Werengani komanso: Ntchito za Statistical ku Excel

Mawerengeredwe

Njira iyi imagwiritsidwa ntchito pakuyerekeza kwapakati kwamanambala osiyanasiyana. Ntchito yayikulu yakuwerengera ndikuchotsa kusatsimikizika kwa kuyerekezera kwa mfundo.

Ku Excel pali njira ziwiri zazikulu zochitira kuwerengera pogwiritsa ntchito njira iyi: kusiyanasiyana ndikadziwika, komanso ndikosadziwika. Poyambirira, ntchito imagwiritsidwa ntchito kuwerengera KULUMIRA.NORMndipo chachiwiri - Khulupirirani.

Njira 1: ntchito ya TRUST.NORM

Wogwiritsa ntchito KULUMIRA.NORM, yomwe ili m'gulu la zantchito, imapezeka koyamba mu Excel 2010. M'mbuyomu zamapulogalamuyi, analogue yake imagwiritsidwa ntchito Khulupirirani. Ntchito ya wogwiritsa ntchito ntchitoyi ndi kuwerengera nthawi yolimba mtima komanso magawidwe antchito wamba.

Matchulidwe ake ndi awa:

= TRUST.NORM (alpha; standard_off; kukula)

Alefa - mkangano wowonetsa kufunika kwa gawo lomwe limagwiritsidwa ntchito kuwerengera mulingo wotsimikiza. Mulingo wotsimikiza ukufanana ndi mawu awa:

(1- "Alfa") * 100

"Kupatuka wamba" - Uku ndi kukangana, komwe kumveka bwino ndi dzinali. Uku ndiye kupatuka kwampangidwe wachitsanzo.

"Kukula" - mkangano womwe umatsimikizira kukula kwa zitsanzozo.

Zotsutsana zonse kwa opereshoni ndizofunikira.

Ntchito Khulupirirani ili ndi chimodzimodzi malingaliro ndi kuthekera kofanana ndi koyambirira. Matchulidwe ake ndi awa:

= TRUST (alpha; muyezo_off; kukula)

Monga mukuwonera, kusiyana kumangokhala mu dzina la wothandizira. Ntchito yomwe idatchulidwa idasiyidwa mu Excel 2010 komanso m'mitundu yatsopano mumagulu apadera kuti agwirizane. "Kugwirizana". M'mitundu ya Excel 2007 ndi m'mbuyomu, ilipo mu gulu lalikulu la opanga ziwerengero.

Malire a nthawi yakukhulupirira atsimikiza pogwiritsa ntchito njira zotsatirazi:

X + (-) TRUST.NORM

Kuti X ndi mtengo wapakati wachitsanzo womwe umapezeka pakati pazosankhidwa.

Tsopano tiyeni tiwone momwe titha kuwerengera nthawi yolimba mtima pogwiritsa ntchito chitsanzo. Mayeso 12 anachitika, chifukwa cha zomwe zotsatira zosiyanasiyana zalembedwa pagome. Izi ndi zathu zonse. Kupatuka kwofananira ndi 8. Tiyenera kuwerengera nthawi yolimba mtima pa chidaliro cha 97%.

1. Sankhani khungu lomwe zotsatira za kukonza deta ziwonetsedwa. Dinani batani "Ikani ntchito".



2. Chimawonekera Fotokozerani Wizard. Pitani ku gulu "Zowerengera" ndikusankha dzinalo KULUMIRA.NORM. Pambuyo pake, dinani batani "Zabwino".



3. Bokosi la mkangano likutseguka. Minda yake mwachilengedwe imafanana ndi mayina amatsutsidwe.
   Khazikitsani chotengera pamunda woyamba - Alefa. Apa tikuyenera kuwonetsa mtundu wa kufunika kwake. Monga momwe timakumbukira, mulingo wathu wa chidaliro ndi 97%. Nthawi yomweyo, tinanena kuti amawerengedwa motere:

   (1- "Alfa") * 100

   Chifukwa chake, kuwerengetsa kukula kwake, ndiye kuti, kuzindikira kufunika kwake Alefa muyenera kugwiritsa ntchito mtundu uwu:

   (Kudzidalira 1-level) / 100

   Ndiye kuti, m'malo mopindulitsa phindu, timalandira:

   (1-97)/100

   Mwa kuwerengera kosavuta timapeza kuti mkanganowu Alefa ndizofanana ndi 0,03. Lowani phindu ili m'munda.

   Monga mukudziwa, pamachitidwe ambiri kupatuka 8. Chifukwa chake m'munda "Kupatuka wamba" lembani manambala apa.

   M'munda "Kukula" muyenera kuyika kuchuluka kwa zinthu zoyeserera. Monga tikuwakumbukira 12. Koma pofuna kusinthitsa formula ndi kusasinthiratu nthawi iliyonse kuyesedwa kwatsopano, tiyeni tiyike phindu ili osati ndi nambala wamba, koma mothandizidwa ndi wothandizira ACCOUNT. Chifukwa chake, ikani cholozera m'munda "Kukula", kenako dinani patatu, yomwe ili kumanzere kwa mzere wamafomula.

   Mndandanda wazomwe wagwiritsidwa ntchito posachedwa ukuwoneka. Ngati wothandizira ACCOUNT ogwiritsidwa ndi inu posachedwa, ziyenera kukhala pamndandanda. Poterepa, muyenera kungodina nalo dzina. Mbali ina, ngati simuyipeza, pitani ku "Zina ...".



4. Zikuwoneka zodziwika kale kwa ife Fotokozerani Wizard. Apanso timasunthira ku gululo "Zowerengera". Timasankha dzinalo "ACCOUNT". Dinani batani "Zabwino".



5. Tsamba la mkangano pamwambapa likuwoneka. Ntchitoyi inakonzedwa kuwerengera kuchuluka kwa maselo omwe ali mumtundu womwe watchulidwa omwe ali ndi manambala. Matchulidwe ake ndi awa:

   = COUNT (mtengo1; mtengo2; ...)

   Gulu lazokangana "Makhalidwe" ndi cholumikizira mulingo momwe mumayenera kuwerengera kuchuluka kwa maselo odzazidwa ndi manambala. Pazonse, pakhoza kukhala kutsutsana mpaka 255, koma kwa ife kuli kofunikira kamodzi.

   Khazikitsani chotembezera m'munda "Mtengo1" , ndikugwira batani lamanzere lakumanzere, sankhani masanjidwewo papepala lomwe lili ndi anthu athu. Kenako adilesi yake iwonetsedwa kumunda. Dinani batani "Zabwino".



6. Pambuyo pake, pulogalamuyo ithandizire kuwerengera ndikuwonetsa zotsatira muchipinda chomwe chili. M'malo mwathu, njira iyi ndi iyi:

   = TRUST.NORM (0.03; 8; ACCOUNT (B2: B13))

   Zotsatira zonse zowerengera zinali 5,011609.



7. Koma si zokhazo. Monga momwe timakumbukira, malire a nthawi yak chidaliro amawerengedwa powonjezera ndikuchotsa pamtengo wamtengo wapatali wazotsatira KULUMIRA.NORM. Mwanjira imeneyi, malire kumanja ndi kumanzere kwa nthawi yodalirika amawerengedwa molingana. Mtengo wapakati wamasampulawo pawokha ungathe kuwerengedwa pogwiritsa ntchito wothandizira. NJIRA.

   Wogwiritsa ntchito adapangidwa kuti awerenge kuchuluka kwa masamu a manambala osankhidwa. Ili ndi syntax yosavuta:

   = AVERAGE (nambala1; nambala2; ...)

   Kukangana "Chiwerengero" itha kukhala yopatula kuwerengera, kapena yolumikizana ndi maselo kapenanso magulu onse omwe ali nayo.

   Chifukwa chake, sankhani khungu lomwe mawerengero apakati adzaonetsedwa, ndikudina batani "Ikani ntchito".



8. Kutsegula Fotokozerani Wizard. Kubwereranso ku gulu "Zowerengera" ndikusankha dzinalo mndandandandawo SRZNACH. Monga nthawi zonse, dinani batani "Zabwino".



9. Windo la mkangano liyamba. Khazikitsani chotembezera m'munda "Nambala1" ndi batani lakumanzere ndikanikizidwa, sankhani mtundu wonse wamakhalidwe. Pambuyo pazogwirizira zowonetsedwa m'munda, dinani batani "Zabwino".



10. Pambuyo pake NJIRA chikuwonetsa zotsatira za kuwerengera papepala.



11. Timawerengera malire oyenera a nthawi yolimba mtima. Kuti muchite izi, sankhani khungu lina, ikani chikwangwani "=" ndipo onjezani zamkati mwazomwe muli zotsatira za kuwerengera ntchito NJIRA ndi KULUMIRA.NORM. Pofuna kuwerengera, dinani batani Lowani. Kwa ife, njira yotsatirayi idapezeka:

    = F2 + A16

    Zotsatira za kuwerengera: 6,953276



12. Momwemonso, timawerengera malire akumanzere a chidaliro, nthawi iyi yokha kuchokera pazotsatira NJIRA chotsani zotsatira za kuwerengera wothandizira KULUMIRA.NORM. Potengera njira yathu yachitsanzo:

    = F2-A16

    Zotsatira za kuwerengera: -3,06994



13. Tidayesera kufotokoza mwatsatanetsatane njira zonse zowerengera chidaliro, kotero tidafotokozera mwatsatanetsatane njira iliyonse. Koma mutha kuphatikiza machitidwe onse munjira imodzi. Kuwerengera malire oyenera achidaliro akhoza kulembedwa motere:

    = AVERAGE (B2: B13) + TRUST.NORM (0.03; 8; ACCOUNT (B2: B13))



14. Kuwerengera kofananako kwa malire akumanzere kumawoneka ngati:

    = AVERAGE (B2: B13) - TRUST.NORM (0.03; 8; ACCOUNT (B2: B13))

Njira 2: DALIRA YOPHUNZITSA ANA

Kuphatikiza apo, ku Excel pali ntchito ina yomwe imalumikizidwa ndi kuwerengera kwa chidaliro chakudzidalira - Khulupirirani. Zinawoneka pokhapokha ku Excel 2010. Wogwiritsa ntchito iyi amawerengera nthawi yomwe anthu azigwiritsa ntchito zomwe ophunzira amagawa. Ndiosavuta kugwiritsa ntchito ngati kusiyanasiyana ndipo, mwakutero, kusiyanasiyana sikudziwika. Syntax yoyeserera ili motere:

= KUKHULUPIRIRA KWAMBIRI (alpha; standard_off; size)

Monga mukuwonera, mayina a ogwiritsa ntchito pamenepa sanasinthe.

Tiyeni tiwone momwe titha kuwerengera malire a chidutsitso chokhazikika ndi chosadziwika chazomwe tikugwiritsa ntchito chitsanzo cha zomwe taphatikizira momwe tidafotokozera kale. Mlingo wa chidaliro, monga nthawi yotsiriza, ndi 97%.

1. Sankhani khungu lomwe mawerengero apangidwe. Dinani batani "Ikani ntchito".



2. Potsegulidwa Ntchito wiz pitani pagawo "Zowerengera". Sankhani dzina DOVERIT.STUDENT. Dinani batani "Zabwino".



3. Zenera lotsutsa la wofotokozedwayo limayambitsidwa.

   M'munda Alefa, poganiza kuti gawo la chidaliro ndi 97%, timalemba nambala 0,03. Kachiwiri sitikhala pa mfundo zowerengera gawo ili.

   Pambuyo pake, ikani temberero m'munda "Kupatuka wamba". Pakadali pano chizindikiro ichi sichikudziwika kwa ife ndipo chikuyenera kuwerengedwa. Izi zimachitika pogwiritsa ntchito ntchito yapadera - STANDOTLON.V. Kuti mutsegule zenera la wogwiritsa ntchito, dinani patatu mpaka kumanzere kwa barula yamu formula. Ngati mndandanda suupeza dzina lomwe mukufuna, ndiye pitani "Zina ...".



4. Iyamba Fotokozerani Wizard. Timasunthira ku gululi "Zowerengera" ndipo lembani dzinalo STANDOTKLON.V. Kenako dinani batani "Zabwino".



5. Windo la mkangano likutseguka. Ntchito yothandizira STANDOTLON.V ndiko kutsimikiza kwa kupatuka kwampangidwe. Kapangidwe kake kamawoneka motere:

   = STD. B (nambala1; nambala2; ...)

   Ndikosavuta kulingalira kuti mkanganowu "Chiwerengero" ndi adilesi ya chinthu chosankhacho. Ngati kusankha kwayikidwa mndandanda umodzi, ndiye kuti, pogwiritsa ntchito lingaliro limodzi, perekani ulalo wambiri.

   Khazikitsani chotembezera m'munda "Nambala1" ndipo, monga nthawi zonse, ndikusunga batani lakumanzere, sankhani anthu. Ma processor ali m'munda, musathamangire kukanikiza batani "Zabwino", chifukwa zotsatira zake si zolondola. Choyamba tiyenera kubwerera pazenera la opareshoni Khulupiriranikuti mupange mkangano wotsiriza. Kuti muchite izi, dinani pazina loyenerera mu barula yokhazikitsidwa.



6. Zenera lazokambirana la ntchito yomwe idadziwika kale limatsegulanso. Khazikitsani chotembezera m'munda "Kukula". Apanso, dinani pazintatu zomwe zili zodziwika kale kwa ife kuti mupite kukasankha ogwiritsa ntchito. Monga mukumvetsetsa, timafunikira dzina "ACCOUNT". Popeza tinagwiritsa ntchito ntchitoyi kuwerengera momwe tinapangira m'mbuyomu, ilipo pamndandandawu, ndiye dinani pazomwezo. Ngati simukupeza, tsatirani ma algorithm omwe afotokozedwa mu njira yoyamba.



7. Kamodzi pazenera zotsutsa ACCOUNTikani otemberera m'munda "Nambala1" ndi batani la mbewa lomwe lakhala pansi, timasankha setiyo. Kenako dinani batani "Zabwino".



8. Pambuyo pake, pulogalamuyo imawerengera ndikuwonetsa kufunikira kwa chidaliro chakukhazikika.



9. Kuti tidziwe malire, tikufunikiranso kuwerengera mtengo wapamwamba. Koma, poganizira kuti kuwerengera kwa algorithm pogwiritsa ntchito njira NJIRA chimodzimodzi monga momwe tinalankhulira kale, ndipo ngakhale zotsatira sizinasinthe, sitikhala pa izi kachiwiri.



10. Kuphatikiza pazotsatira NJIRA ndi Khulupirirani, timapeza malire oyenera a chidaliro cholimba.



11. Kuchotsa ku mawerengero azotsatira za wothandizira NJIRA kuwerengetsa Khulupirirani, tili ndi malire kumanzere kwa chidaliro.



12. Ngati kuwerengera kwalembedwa mwanjira imodzi, ndiye kuwerengera kumalire oyenera mbali yathu kudzawoneka motere:

    = AVERAGE (B2: B13) + TRUST. STUDENT (0.03; STD CLIP. B (B2: B13); ACCOUNT (B2: B13))



13. Chifukwa chake, njira yowerengera kumanzere kumawoneka motere:

    = KUGWIRITSANI (B2: B13) - CHOKHALA. STUDENT. (0.03; STD CLIP. B (B2: B13); ACCOUNT (B2: B13)

Monga mukuwonera, zida za Excel zimatha kuyendetsa bwino kuwerengera kwa nthawi yolimba mtima komanso malire ake. Pazifukwa izi, opanga ogwiritsa ntchito amagwiritsidwa ntchito ngati zitsanzo zomwe kusiyanasiyana kumadziwika komanso kusadziwika.