Eminye yemisebenzi edume kakhulu engeyona eyokuqala, esetshenziselwa izibalo, emcabangweni wokulinganisa okuhlukile, kwizibalo nakumbono wamathuba, ngumsebenzi weLaplace. Ukuxazulula izinkinga ngayo kudinga ukulungiselela okukhulu. Ake sibheke ukuthi ungawasebenzisa kanjani amathuluzi e-Excel ukubala le nkomba.
Umsebenzi weLaplace
Umsebenzi weLaplace usetshenziswe kabanzi kanye nezinhlelo zokusebenza ze-theoretical. Isibonelo, kuvame ukusetshenziselwa ukuxazulula i-equation tofauti. Leli gama linelinye igama elifanayo - okubalulekile okungenzeka. Kwezinye izimo, isisekelo sekhambi ukwakhiwa kwetafula lamanani.
I-Operator NORM.ST.RASP
Ku-Excel, le nkinga ixazululwa kusetshenziswa opharetha I-NORM.ST.RASP. Igama layo liyisifushaniso segama "ukwabiwa okujwayelekile okujwayelekile". Njengoba umsebenzi wayo oyinhloko ukubuyela kuseli elikhethiwe ukusatshalaliswa okujwayelekile okujwayelekile okujwayelekile. Lo opharetha unesigaba sesibalo semisebenzi ejwayelekile ye-Excel.
Ku-Excel 2007 nakwezinguqulo zangaphambili zohlelo, lesi sitatimende sabizwa I-NORMSTRASP. Kushiyelwa izinjongo zokuhambisana ezinhlotsheni zanamuhla zezicelo. Kepha, batusa ukusetshenziswa kwe-analogue ethuthuke kakhulu - I-NORM.ST.RASP.
ISyntax yokusebenza I-NORM.ST.RASP kubukeka kanjena:
= I-NORM.ST. I-RASP (z; ebalulekile)
Umsebenzi osetshenzisiwe I-NORMSTRASP Kubhalwe kanjena:
= NORMSTRASP (z)
Njengoba ubona, enguqulweni entsha kuya kungxabano ekhona "Z" kungeza impikiswano "Okuhlanganisiwe". Kumele kwaziwe ukuthi ukuphikisana ngakunye kuyadingeka.
Ukuxabana "Z" kubonisa inani lamanani okwabelwa ngalo ukwabiwa.
Ukuxabana "Okuhlanganisiwe" imelela inani elinengqondo elingase libe nomqondo "IQINISO" ("1") noma FALSE ("0"). Esimweni sokuqala, umsebenzi wokusabalalisa ohlanganisiwe ubuyiselwa kwiseli ekhonjisiwe, kuthi okwesibili, umsebenzi wokusabalalisa onesisindo.
Ukuxazululwa kwezinkinga
Ukuze wenze ukubalwa okudingekayo kokuguquguqukayo, kufakwa ifomula elandelayo:
= I-NORM.ST. I-RASP (z; ebalulekile (1)) - 0.5
Manje ake sibheke isibonelo esithile sisebenzisa opharetha I-NORM.ST.RASP ukuxazulula inkinga ethile.
- Khetha iseli lapho kuzoboniswa khona umphumela ophelile bese uqhafaza kusithonjana "Faka umsebenzi"eseduze komugqa wamafomula.
- Ngemuva kokuvula Umsebenzi Wizards iya esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi". Khetha igama I-NORM.ST.RASP bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana okusebenzayo liyasebenza I-NORM.ST.RASP. Ensimini "Z" sethula okuguquguqukayo ofuna ukubala kukho. Futhi, le ngxabano ingamelwa njengesethenjwa kuseli equkethe lokhu kuhluka. Ensimini "Okuhlanganisiwe"faka inani "1". Lokhu kusho ukuthi opharetha ngemuva kokubala bazobuyisela umsebenzi wokuhambisa wokusabalalisa njengesixazululo. Ngemuva kokuthi isenzo esingenhla sesiqediwe, chofoza inkinobho "Kulungile".
- Ngemuva kwalokho, umphumela wokucutshungulwa kwedatha ngu-opharetha I-NORM.ST.RASP izokhonjiswa ebhokisini elikhonjiswe esigabeni sokuqala sale ncwadi.
- Kepha akupheleli lapho. Sikubalile ukusabalalisa okujwayelekile okujwayelekile okujwayelekile. Ukuze ubale inani lomsebenzi weLaplace, udinga ukukhipha inombolo kuwo 0,5. Khetha iseli eliqukethe inkulumo. Ebhodini lefomula ngemuva kwesitatimende I-NORM.ST.RASP engeza inani: -0,5.
- Ukuze wenze ukubala, chofoza inkinobho Ngena. Umphumela otholakele uzoba inani elifunayo.
Njengoba ubona, ukubala umsebenzi weLaplace ngenani elithile lezinombolo elinikeziwe ku-Excel akunzima. Ngalezi zinhloso, kusetshenziswa opharetha abajwayelekile. I-NORM.ST.RASP.
