Omunye wemisebenzi edumile kakhulu engeyona eyisiqalo, esetshenziselwa izibalo, embonweni wokulinganisa okuhlukile, kuzibalo kanye nangokwakho okungenzeka ukuthi yi-Laplace. Ukuxazulula izinkinga nazo kudinga ukuqeqeshwa okujulile. Ake sithole ukuthi ungasebenzisa kanjani ama-Excel amathuluzi ukubala le nkhomba.
Umsebenzi we-Laplace
Umsebenzi we-Laplace unesicelo esibanzi esiwusizo nesayensi. Isibonelo, kuvame ukusetshenziselwa ukuxazulula ukulinganisa okulinganayo. Leli gama linelinye igama elilingana - okungenzeka ukuthi kuyingxenye. Kwezinye izimo, isisekelo sesinqumo ukwakha itafula lamagugu.
I-Operator NORM.ST.RASP
Ku-Excel, le nkinga ixazululwa ngosizo lomqhubi NORMST.RASP. Igama layo lifushane kulelo gama "ukusatshalaliswa okujwayelekile okuvamile." Kusukela umsebenzi wayo oyinhloko ukubuyela esitokisini esikhethiwe sokusabalalisa okuvamile okujwayelekile. Lo opharetha ungokwesigaba sesibalo semisebenzi ejwayelekile ye-Excel.
Ku-Excel 2007 nakuzinguqulo zangaphambili zalolu hlelo, lesi sitatimende sabizwa NORMSDIST. Ishiyelwe ukuhambisana nezihumusho zanamuhla zezicelo. Noma kunjalo, batusa ukusetshenziswa kwe-analogue ethuthukile kakhulu - NORMST.RASP.
I-syntax ye-Operator NORMST.RASP kubukeka kanje:
= NORM.STRAS (z; ebalulekile)
Opharetha okwedlule NORMSDIST ebhaliwe kanje:
= NORMSDIST (z)
Njengoba ungabona, kunguqulo entsha yezingxabano ezikhona "Z" ingxabano ingeziwe "Okuphelele". Kumele kuqashelwe ukuthi zonke izingxabano ziyadingeka.
Ukuphikisana "Z" ibonisa inani lezinombolo lapho ukusatshalaliswa kukwakhiwa khona.
Ukuphikisana "Okuphelele" iyinzuzo enengqondo engamelwa "TRUE" ("1") noma "FALSE" ("0"). Esikhathini sokuqala, umsebenzi wokusabalalisa ohlangene ubuyiselwa esitokisini esicacisiwe, futhi okwesibili - umsebenzi wokusabalalisa isisindo.
Ukuxazulula izinkinga
Ukuze wenze isibalo esidingekayo sokuguquguquka, ifomula elandelayo isetshenziswa:
= NORM.STRAS (z; okubalulekile (1)) - 0.5
Manje ake sithathe isibonelo sokhonkolo sokucabangela ukusebenzisa opharetha NORMST.RASP ukuxazulula inkinga ethile.
- Khetha iseli lapho umphumela ophelile uzoboniswa bese uchofoza kwisithonjana "Faka umsebenzi"itholakala eduze kwebha yefomula.
- Ngemuva kokuvula Amakhosi omsebenzi iya kusigaba "Isitatimende" noma "Uhlu oluphelele lwe-alfabhethi". Khetha igama "NORM.ST.RASP" bese uchofoza inkinobho "Kulungile".
- Ukuqalisa ifasitelana lokuphikisana lomqhubi NORMST.RASP. Ensimini "Z" faka okuguquguqukayo ofuna ukubala. Futhi, le mpikiswano ingamelwa njengokubhekisela kuseli equkethe lokhu okuguquguqukayo. Ensimini "Okuhlanganisiwe"faka inani "1". Lokhu kusho ukuthi opharetha emva kokubala ubuyisela umsebenzi wokusabalalisa oyingxenye njengesixazululo. Emva kwezinyathelo ezingenhla ziqedile, chofoza inkinobho. "Kulungile".
- Emva kwalokho, umphumela wokucutshungulwa kwedatha ngu-opharetha NORMST.RASP izoboniswa esitokisini efakwe esigabeni sokuqala salesi siqondiso.
- Kodwa akusikho konke. Sasibala kuphela ukusatshalaliswa okujwayelekile okujwayelekile. Ukuze ubale ukubaluleka komsebenzi we-Laplace, udinga ukukhipha inombolo kuyo 0,5. Khetha iseli eliqukethe inkulumo. Ku-bar yefomula ngemuva kopharetha NORMST.RASP engeza inani: -0,5.
- Ukuze wenze isibalo, chofoza inkinobho. Ngena. Umphumela uzoba yinani elifunayo.
Njengoba ubona, kulula ukubala umsebenzi we-Laplace ngenani elithile elinikeziwe lokubalwa ku-Excel. Umqhubi ojwayelekile usetshenziselwa le njongo. NORMST.RASP.
