Ɗaya daga cikin shahararrun ayyukan da ba a haɓaka ba, wanda aka yi amfani da ilimin lissafi, a ka'idar bambancin bambanci, a cikin kididdiga da ka'ida mai yiwuwa shine aikin Laplace. Gyara matsala tare da shi yana buƙatar horo. Bari mu ga yadda za ku iya amfani da kayan aiki na Excel don tantance wannan alama.
Laplace aiki
Ayyukan Laplace yana da aikace-aikace mai ban sha'awa da fasaha. Alal misali, ana amfani da ita sau da yawa don magance nau'ikan ƙananan. Wannan kalma yana da wani nau'i daidai - da yiwuwar hade. A wasu lokuta, tushen dalilin shine gina tebur na dabi'u.
Mai gudanarwa NORM.ST.RASP
A cikin Excel, an warware matsalar tareda taimakon mai aiki NORMST.RASP. Sunan yana da gajere don kalmar "daidaitattun daidaitattun al'ada." Tun da babban aikinsa shi ne komawa cell da aka zaba na rarraba ta al'ada ta al'ada. Wannan afaretan yana cikin ɓangaren ƙididdiga na ayyuka na Excel.
A cikin Excel 2007 da kuma a cikin sassan farko na wannan shirin, ana kiran wannan sanarwa NORMSDIST. An bar shi don dacewa a cikin fasahar zamani. Duk da haka, suna bayar da shawarar yin amfani da wata mahimmanci analog - NORMST.RASP.
Mai amfani da haɗin gwiwar NORMST.RASP kama da wannan:
= NORM.STRAS (z; haɗin)
Mai sarrafa aiki mai ƙare NORMSDIST rubuta kamar haka:
= NORMSDIST (z)
Kamar yadda kake gani, a cikin sabon ɓangaren maganganu na yanzu "Z" an kara da cewa "Haɗaka". Ya kamata a lura cewa ana buƙatar kowace gardama.
Magana "Z" yana nuna ƙimar maɓallin da aka rarraba rarraba.
Magana "Haɗaka" yana da ma'ana mai ma'ana wanda za a iya wakilta "Gaskiya" ("1") ko "FALSE" ("0"). A cikin akwati na farko, ana rarraba aikin rarraba rarraba zuwa cell da aka ƙayyade, kuma a cikin na biyu - aiki na rarraba nauyi.
Matsalolin matsala
Domin yin lissafin da ake buƙata don m, ana amfani da wannan maƙirarin:
= NORM.STRAS (z; abu (1)) - 0.5
Yanzu bari mu ɗauki misali mai kyau don la'akari da amfani da mai aiki NORMST.RASP don magance wata matsala.
- Zaɓi tantanin halitta inda za a nuna sakamakon da aka kammala sannan ka danna gunkin "Saka aiki"located kusa da dabara bar.
- Bayan bude Ma'aikata masu aiki je zuwa kundin "Labarin lissafi" ko "Jerin jerin jerin sunayen". Zaɓi sunan "NORM.ST.RASP" kuma danna maballin "Ok".
- Ƙaddamarwa da taga mai gudanarwa NORMST.RASP. A cikin filin "Z" shigar da m zuwa abin da kake son lissafi. Har ila yau, wannan hujja za a iya wakilta a matsayin abin da ya dace da tantanin halitta wanda ya ƙunshi wannan madaidaicin. A cikin filin "Cigaba"shigar da darajar "1". Wannan yana nufin cewa mai aiki bayan ƙidayar ya dawo aikin rarraba haɗin kai azaman bayani. Bayan an kammala matakai na sama, danna maballin. "Ok".
- Bayan haka, sakamakon aikin sarrafa bayanai daga mai aiki NORMST.RASP za a nuna a tantanin salula wanda aka jera a sakin farko na wannan jagorar.
- Amma ba haka ba ne. Mun ƙidaya kawai daidaitattun tsari na al'ada. Domin yin lissafin darajar aikin Laplace, kana buƙatar cirewa lambar daga gare ta 0,5. Zaɓi tantanin halitta dauke da bayanin. A cikin takaddun tsari bayan mai aiki NORMST.RASP Ƙara darajar: -0,5.
- Don yin lissafi, danna kan maballin. Shigar. Sakamakon zai zama darajar da ake so.
Kamar yadda kake gani, yana da sauƙi a lissafin aikin Laplace don takamaiman lambar da aka bayar a Excel. An yi amfani da mai amfani na asali don wannan dalili. NORMST.RASP.
