Imodzi mwa ntchito zolemekezeka kwambiri zopanda maphunziro, zomwe zimagwiritsidwa ntchito mu masamu, mu lingaliro la kusiyana kosiyana, mu ziwerengero ndipo mwinamwake lingaliro ndi ntchito ya Laplace. Kuthetsa mavuto ake kumafuna kuphunzitsidwa kwakukulu. Tiyeni tione momwe mungagwiritsire ntchito zida za Excel kuti muwerenge chizindikiro ichi.
Ntchito ya Laplace
Ntchito ya Laplace ili ndi ntchito yaikulu komanso yongopeka. Mwachitsanzo, nthawi zambiri amagwiritsidwa ntchito pofuna kuthetsa kusiyana pakati. Liwu ili liri ndi dzina lina lofanana -lowekha lokhazikika. Nthawi zina, maziko a chisankho ndikumanga tebulo labwino.
Woyendetsa NORM.ST.RASP
Mu Excel, vuto ili limathetsedwa mothandizidwa ndi woyendetsa NORMST.RASP. Dzina lake ndi lalifupi kwa mawu akuti "kufalikira kwabwinobwino." Chifukwa chakuti ntchito yake yaikulu ndi kubwerera ku selo losankhidwa la kufalitsa kofunikira. Wogwiritsira ntchitoyi ali m'gulu la chiwerengero cha ntchito ya Excel.
Mu Excel 2007 komanso m'machitidwe oyambirira a pulogalamuyi, mawuwa adatchedwa NORMSDIST. Yatsalira kuti ikhale yogwirizana m'machitidwe amakono. Komabe, amalimbikitsa kugwiritsa ntchito analogue yapamwamba kwambiri - NORMST.RASP.
Opaleshoni yamagetsi NORMST.RASP zikuwoneka ngati izi:
= NORM.STRAS (z; integral)
Wopititsa nthawi NORMSDIST zinalembedwa monga izi:
= WODZIWA (z)
Monga momwe mukuonera, muzokambirana kwatsopano "Z" Ndemanga yowonjezera "Osagwirizana". Tiyenera kukumbukira kuti kutsutsana kulikonse n'kofunika.
Kutsutsana "Z" imasonyeza kuchuluka kwa chiwerengero chomwe kugawidwa kukupangidwira.
Kutsutsana "Osagwirizana" ndi mtengo wapatali womwe ungayimiridwe "WOONA" ("1") kapena "ZINTHU" ("0"). Pachiyambi choyamba, ntchito yogawa ntchitoyi imabweretsedwa ku selo yeniyeni, ndipo yachiwiri - ntchito yogawa zolemera.
Kuthetsa mavuto
Kuti tichite mawerengedwe oyenera kuti azitha kusintha, njirayi ikugwiritsidwa ntchito:
= NORM.STRAS (z; integral (1)) - 0.5
Tsopano tiyeni titenge chitsanzo cha konkire kuti tiganizire kugwiritsa ntchito woyendetsa NORMST.RASP kuti athetse vuto linalake.
- Sankhani selo komwe zotsatira zake ziwonetsedwe ndikusindikiza pazithunzi "Ikani ntchito"ili pafupi ndi bar.
- Atatsegula Oyang'anira ntchito pitani ku gulu "Zotsatira" kapena "Mndandanda wathunthu wa alfabeti". Sankhani dzina "NORM.ST.RASP" ndipo dinani pa batani "Chabwino".
- Kugwiritsa ntchito zenera zotsutsana ndiwindo NORMST.RASP. Kumunda "Z" lowetsani kusintha komwe mukufuna kuwerenga. Ndiponso, kukangana kumeneku kungawonetsedwe ngati kutchulidwa kwa selo yomwe ili ndi kusinthaku. Kumunda "Integral"lowetsani mtengo "1". Izi zikutanthawuza kuti wogwira ntchitoyo atatha kuwerengera akubwezeretsanso ntchito yogawa yofunikira monga yankho. Pambuyo pa mapepala apamwambawa, tambani pa batani. "Chabwino".
- Pambuyo pake, zotsatira za kugwiritsira ntchito deta ndi wogwiritsira ntchito NORMST.RASP adzawonetsedwa mu selo yomwe ili mu ndime yoyamba ya bukhuli.
- Koma sizo zonse. Tinawerengera kokha kufalitsa kwabwino koyenera. Kuti muwerenge kufunika kwa ntchito ya Laplace, muyenera kuchotsa chiwerengerocho 0,5. Sankhani selo yomwe ili ndi mawu. Mu barangidwe lazitsulo pambuyo pa oyendetsa NORMST.RASP onjezerani mtengo: -0,5.
- Kuti muwerengere, dinani pa batani. Lowani. Chotsatira chidzakhala chofunika.
Monga mukuonera, n'zosavuta kuwerengera ntchito ya Laplace kwa mtengo wapadera woperekedwa ku Excel. Ogwiritsa ntchito amagwiritsidwa ntchito pazinthu izi. NORMST.RASP.
