Daya daga cikin shahararrun ayyukan da ba na farko ba, wanda ake amfani da shi wajen lissafi, a ka’idar bambance-bambancen lissafi, a cikin kididdiga da kuma ka’idar yiwuwa, ita ce aikin Laplace. Magance matsaloli tare da shi yana buƙatar shiri sosai. Bari mu bincika yadda zaku iya amfani da kayan aikin Excel don ƙididdige wannan alamar.
Aikin Laplace
Aikin Laplace ya yi amfani sosai da aikace-aikace na ka'ida. Misali, ana yawan amfani dashi don magance bambance banbanci. Wannan kalmar tana da wani suna daidai-da - yiwuwar haɗa shi. A cikin wasu halaye, tushen maganin shine gina tebur na dabi'u.
Mai aiki NORM.ST.RASP
A cikin Excel, ana magance wannan matsala ta amfani da mai aiki NORM.ST.RASP. Sunansa rikodin kalmar "daidaitaccen rarrabuwa". Tunda babban aikinsa shine komawa zuwa ga zaɓaɓɓen sel daidaitaccen aikin haɗin kai. Wannan afareta yana cikin nau'in ƙididdiga na daidaitattun ayyukan Excel.
A cikin Excel 2007 da a farkon sigogin shirin, an kira wannan sanarwa NORMSTRASP. An bar shi don dalilai masu dacewa a cikin sigogin aikace-aikacen zamani. Amma duk da haka, suna ba da shawarar yin amfani da karin magana ana - NORM.ST.RASP.
Syntax mai aiki NORM.ST.RASP ya yi kama da wannan:
= NORM.ST. RASP (z; haɗaɗɗe)
Mai Rarraba Operator NORMSTRASP an rubuta kamar haka:
= NORMSTRASP (z)
Kamar yadda kake gani, a sabuwar sigar zuwa hujja mai gudana "Z" kara da cewa "Hadakar". Ya kamata a lura cewa ana buƙatar kowace hujja.
Hujja "Z" yana nuna ƙimar adadin abin da ake gina aikin rarraba shi.
Hujja "Hadakar" yana wakiltar darajar ma'ana wanda zai iya samun ra'ayi "GASKIYA" ("1") ko KARYA ("0"). A farkon lamari, ana mayar da aikin rarraba kayan aiki zuwa sel da aka nuna, kuma a cikin na biyu, aikin rarraba nauyi.
Matsalar warware matsala
Don yin ƙididdigar da ake buƙata don m, ana amfani da tsari mai zuwa:
= NORM.ST. RASP (z; haɗaɗɗe (1)) - 0.5
Yanzu bari mu bincika takamaiman misali ta amfani da mai amfani NORM.ST.RASP don magance takamaiman matsala.
- Zaɓi wayar inda za a nuna sakamakon ƙarewa sai ka danna maballin "Saka aikin"wanda yake kusa da layin tsari.
- Bayan an bude Wizards na Aiki je zuwa rukuni "Na lissafi" ko "Cikakken jerin haruffa". Zaɓi suna NORM.ST.RASP kuma danna maballin "Ok".
- Ana kunna taga mai aiki na mai aiki NORM.ST.RASP. A fagen "Z" muna gabatar da mai canzawa wanda kake son lissafta. Hakanan, za'a iya wakilta wannan hujja azaman zance ga tantanin halitta wanda ya ƙunshi wannan m. A fagen "Hadin kai"shigar da darajar "1". Wannan yana nufin cewa mai aiki bayan yin lissafi zai dawo da aikin rarraba aiki azaman bayani. Bayan an gama ayyukan da ke sama, danna maballin "Ok".
- Bayan wannan, sakamakon sarrafawar mai aiki NORM.ST.RASP Za a nuna a akwatin da aka nuna a sakin farko na wannan littafin.
- Amma wannan ba duka bane. Mun ƙididdige daidaitaccen tsarin daidaituwa na al'ada Don yin ƙididdigar darajar aikin Laplace, kuna buƙatar cire lambar daga gare ta 0,5. Zaɓi tantanin da ke ɗauke da magana. A cikin mashaya dabara bayan sanarwa NORM.ST.RASP kara darajar: -0,5.
- Domin aiwatar da lissafin, danna maballin Shigar. Sakamakon da aka samu zai zama ƙimar da ake so.
Kamar yadda kake gani, ba shi da wahala a kirkiri aikin Laplace don takamaiman lambar ƙimar da aka bayar a cikin Excel. Don waɗannan dalilai, ana amfani da daidaitaccen mai aiki. NORM.ST.RASP.
