Igikorwa cyo Laplace muri Excel

Imwe mu nshingano zizwi cyane zitari zidasanzwe zitari zifite imibare, zikoreshwa mu mibare, mu nyigisho y'ibinyabuzima bitandukanye, mu mibare no mu nyigisho y'ibishoboka. Gukemura imirimo hamwe bisaba kwitegura cyane. Reka tumenye uburyo ushobora kubara iki kimenyetso ukoresheje ibikoresho byoroshye.

Imikorere ya Laplas

Imikorere yo muri Laplace ifite gahunda yagutse kandi ikoreshwa. Kurugero, akenshi bikoreshwa mugukemura ibigereranyo bitandukanye. Iri jambo rifite irindi zina rihwanye - ibintu bya bishoboka. Rimwe na rimwe, ishingiro ryibisubizo nukubaka ameza yindangagaciro.

Umukoresha (.SP.

Muri Excel, umurimo wagenwe urakemuka ukoresheje ibisanzwe. STSP. Izina ryayo ni ukugabanya ijambo "kugabura bisanzwe". Kubera ko umurimo nyamukuru wacyo ugomba gusubira kuri selire yamuritswe yikigereranyo gisanzwe gisanzwe. Uyu mukoresha yerekeza ku cyiciro cy'ibarurishamibare cy'imirimo isanzwe idasanzwe.

Muri Excel 2007 no muri verisiyo zabanjirije iyi gahunda, uyu mukoresha yiswe arcstrap. Hasigaye mu guhuza muburyo bugezweho bwa porogaramu. Ariko nanone, barasabwa gukoresha mugenzi wawe wateye imbere - imiterere.s.s.

Syntax yumukoresha cyangwa.ras irasa nkiyi:

= Imiterere.st.sP (z; intergral)

Umukoresha wavuzwe haruguru wangiza yanditse ku buryo bukurikira:

= Bisanzwe (z)

Nkuko tubibona, muburyo bushya, "interabwoba" byongewe ku mpaka zihari. Twabibutsa ko buri mpaka ari itegeko.

Impaka "z" yerekana agaciro k'umubare ukwirakwizwa.

Impaka "Integral" ni agaciro kwumvikana gishobora kuba gifite "ukuri" ("1") cyangwa "ibinyoma" ("0"). Mu rubanza rwa mbere, imikorere yo gukwirakwiza ikora yasubijwe mu kagari kagenwe, no mu cya kabiri - imikorere y'uburemere bwo gukwirakwiza.

Igisubizo cyikibazo

Kugirango ukore kubara bisabwa kugirango bihinduka, formula ikurikira ikoreshwa:

= Imiterere.st.sP. (z; integral (1)) - 0.5

Noneho reka turebe gukoresha amahame. STR.SPPP kugirango ikemure umurimo runaka.

1. Turagaragaza selile aho ibisubizo byarangiye bizerekanwa hanyuma ukande kuri "shyiramo imikorere", uherereye hafi yumurongo wa formula.



2. Tumaze gufungura imikorere yimikorere, tujya mucyiciro "ibarurishamibare" cyangwa "Urutonde rwuzuye". Kugenera izina "Ihame.st.SPSP" hanyuma ukande buto "OK".



3. Gukora Idirishya ryimpaka zamakuru yumukoresha. STR.ASP. Muri "Z", twinjira muburyo burahinduka ushaka kubara. Nanone, iyi ngingo irashobora guhagararirwa nkibivugwa kuri selile irimo iyi mpinduka. Mu murima "ihuriweho", twinjije agaciro "1". Ibi bivuze ko umukoresha nyuma yo kubara azagaruka nkigisubizo cyimikorere yo gukwirakwiza ibintu. Nyuma y'ibikorwa bikurikijwe, kanda kuri buto "OK".



4. Nyuma yibyo, ibisubizo byo gutunganya amakuru numukozi.st.SPP izerekanwa mu Kagari, bigaragazwa mu gika cya mbere cyaki gihe.



5. Ariko ibyo sibyo byose. Twabaze gusa ibisanzwe bisanzwe bisanzwe. Kugirango ubare agaciro ka laplace, ugomba gukuramo umubare 0.5. Hitamo Akagari kigizwe nimvugo. Mu mugozi wa formula nyuma yibipimo bya albutor.st.Sp. Nkongerera agaciro kuri: -0.5.



6. Kugirango ubare kubara, kanda buto ya Enter. Igisubizo cyabonetse kandi kizaba agaciro kabishaka.

Nkuko mubibona, kubara imikorere ya laplace kumibare yihariye muri gahunda ya Excel ntabwo bigoye. Kuri izo ntego, imikoreshereze isanzwe. STR.ASP.