Chimodzi mwazinthu zodziwika bwino zosakhala zoyambira, zomwe zimagwiritsidwa ntchito masamu, chiphunzitso cha kusiyanasiyana, mu ziwerengero komanso chiphunzitso choganiza, ndi ntchito ya Laplace. Kuthetsa mavuto ndi izi kumafuna kukonzekera kwambiri. Tiyeni tiwone momwe mungagwiritsire ntchito zida za Excel kuwerengera chizindikiro ichi.
Ntchito ya laplace
Ntchito ya Laplace yakhala ikugwiritsa ntchito kwambiri komanso njira zowerengera. Mwachitsanzo, nthawi zambiri amagwiritsidwa ntchito kuthetsa masiyanidwe osiyanasiyana. Mawuwa ali ndi dzina lofanana - kuthekera koyenera. Nthawi zina, maziko a yankho lake ndi kupanga tebulo la mfundo zofunika.
Wogwiritsa ntchito NORM.ST.RASP
Ku Excel, vutoli limathetsedwa pogwiritsa ntchito wothandizira NORM.ST.RASP. Dzinali ndi chidule cha mawu oti "kugawa nthawi zonse". Popeza ntchito yake yayikulu ndikubwerera ku cell yomwe idasankhidwayo gawo lofananira lolunjika. Wogulitsayo ndi wa gulu la manambala a zinthu za Excel.
Mu Excel 2007 komanso m'mbuyomu pulogalamuyi, mawu awa adayitanidwa NORMSTRASP. Amasiyidwa kuti agwirizane ndi njira zamakono zogwiritsira ntchito. Komabe, amalimbikitsa kugwiritsira ntchito ma analogue apamwamba kwambiri - NORM.ST.RASP.
Ntchito Syntax NORM.ST.RASP zikuwoneka ngati:
= NORM.ST. RASP (z; yofunika)
Wogwira Ntchito Wochotsedwayo NORMSTRASP zalembedwa motere:
= NORMSTRASP (z)
Monga mukuwonera, mu mtundu watsopano mpaka kutsutsana komwe kulipo "Z" mkangano unawonjezedwa "Wophatikizika". Tiyenera kudziwa kuti mkangano uliwonse ukufunika.
Kukangana "Z" chikuwonetsa kuchuluka kwa manambala komwe kugawa kumapangidwira.
Kukangana "Wophatikizika" imayimira mtengo womveka womwe ungakhale ndi lingaliro "ZOONA" ("1") kapena FALSE ("0"). Poyambirira, gawo lofunikira logawidwa limabwezeretsedwa ku selo lomwe lasonyezedwalo, ndipo chachiwiri, ntchito yolemetsa yolimbitsa thupi.
Kuthetsa mavuto
Kuti mupeze kuwerengera kofunikira pakusinthira, njira iyi ndi iyi:
= NORM.ST. RASP (z; yofunika (1)) - 0.5
Tsopano tiyeni tiwone chitsanzo china chogwiritsa ntchito opereshoni NORM.ST.RASP kuthetsa vuto linalake.
- Sankhani khungu lomwe zotsatira zomalizidwa ziwonetsedwa ndikudina chizindikiro "Ikani ntchito"ili pafupi ndi mzere wa fomula.
- Mutatsegula Ogwira Ntchito pitani pagawo "Zowerengera" kapena "Mndandanda wathunthu wa zilembo". Sankhani dzinalo NORM.ST.RASP ndipo dinani batani "Zabwino".
- Windo la wotsutsana likuyambitsidwa NORM.ST.RASP. M'munda "Z" timayambitsa kusintha komwe mukufuna kuwerengera. Komanso, mkanganowu ukhoza kuyimiridwa ngati cholozera ku foni yomwe ili ndi kusinthaku. M'munda "Wophatikizika"lowetsani mtengo wake "1". Izi zikutanthauza kuti wothandizirayo atatha kuwerengera abwezera gawo lofunikira logawa monga yankho. Mukamaliza kuchita zomwe zatchulidwa pamwambapa, dinani batani "Zabwino".
- Pambuyo pake, zotsatira za kusanjidwa kwa data ndi wothandizira NORM.ST.RASP idzawonetsedwa m'bokosi lomwe lasonyezedwa m'ndime yoyamba ya buku lino.
- Koma si zokhazo. Tidawerengera zokhazo zomwe zili zofunikira. Kuti muwerenge phindu la ntchito ya Laplace, muyenera kuchotsa manambala kuchokera pamenepo 0,5. Sankhani khungu lomwe lili ndi mawuwo. Mu barula yodutsa pambuyo pa mawuwo NORM.ST.RASP onjezerani mtengo: -0,5.
- Pofuna kuwerengera, dinani batani Lowani. Zotsatira zomwe zapezedwa ndizomwe mukufuna.
Monga mukuwonera, sizovuta kuwerengera ntchito ya Laplace pamtengo womwe mwapatsidwa mu Excel. Pazifukwa izi, woyendetsa aliyense amagwiritsidwa ntchito. NORM.ST.RASP.
