Ko tetahi o nga mahi tino-kore tino rongonui, e whakamahia ana i roto i te pangarau, i roto i te ariā o nga whārite rerekē, i roto i te tatauranga me te ariā tūponotanga ko te mahi Laplace. Ko te whakaoti i nga raruraru ka nui te whakangungu. Kia kitehia me pehea e taea ai e koe te whakamahi i nga taputapu Excel ki te tatau i tenei tohu.
Mahi Laplace
Ko te mahi a Laplace he nui te whakamahi me te tono. Hei tauira, he maha tonu te whakamahi hei whakaoti i nga whārite rerekē. He ingoa ano tenei waaanga - ko te tūponotanga he whakauru. I etahi wa, ko te kaupapa mo te whakatau ko te hanga i tetahi tepu o nga uara.
Kaiwhakahaere NORM.ST.RASP
I Excel, ka whakatauhia tenei raruraru me te awhina a te kaiwhakahaere NORMST.RASP. He poto tona ingoa mo te kupu "te tohatoha paerewa." Mai i tana mahi matua ko te hoki ki te waitohu kua tohua o te tohatoha paerewa tawhito. Ko tenei kaiwhakahaere kei te waahanga tatauranga o nga mahi Excel paerewa.
I Excel 2007 me nga putanga o mua o te papatono, i huaina tenei korero NORMSDIST. Ka waiho mo te whakaari i nga putanga hou o nga tono. Heoi, e taunaki ana ratou ki te whakamahinga o te korero whakaari ake - NORMST.RASP.
Kaiwhakahaere raupapa NORMST.RASP he penei:
= NORM.STRAS (z; he mea nui)
Kaiwhakahaere kua puta NORMSDIST i tuhia penei:
= NORMSDIST (z)
Ka taea e koe te kite, i roto i te putanga hou o te tautohetohe "Z" tautohetohe "Katoa". Me tohu me kii nga tautohe katoa.
Te tautohe "Z" tohuhia te uara tawhito e hangaia ana te tohatoha.
Te tautohe "Katoa" Ko te uara arorau ka taea te tohu "WHAKAMAHI" ("1") ranei "FALSE" ("0"). I te tuatahi o te take, ka hoki te mahi tuari ki te waea i tohua, a, i te tuarua - te mahi tohatoha taumaha.
Te whakaoti rapanga
Hei whakatutuki i te tatauranga e hiahiatia mo te taurangi, ka whakamahia te tauira e whai ake nei:
= NORM.STRAS (z; he nui (1)) - 0.5
Na, kia mau ki tetahi tauira tauira hei whakaaro ki te whakamahi i te kaiwhakahaere NORMST.RASP ki te whakaoti i tetahi raruraru motuhake.
- Tīpakohia te pūtau ka whakaatuhia te hua whakamutunga ka pāwhiri i te ata "Kōkuhu mahi"kei te taha o te pae tautuhinga.
- I muri i te whakatuwheratanga Kaiwhakahaere Mahi haere ki te kāwai "Tatauranga" ranei "Rārangi poutū katoa". Tīpakohia te ingoa "NORM.ST.RASP" a ka pāwhiri i te pātene "OK".
- Whakahoheatanga o te matapihi whakautu ope NORMST.RASP. I roto i te mara "Z" tomo ki te taurangi e hiahia ana koe ki te tatau. Ano hoki, ko tenei tautohe ka taea te tohu hei tohutoro ki te kamera kei roto i tenei taurangi. I roto i te mara "Katoa"whakauruhia te uara "1". Ko te tikanga ko te kaiwhakahaere i muri i te tatauranga ka whakahoki i te mahi tuakiri motuhake hei painga. I muri i nga waahanga o runga ake kua oti, pania te pihi. "OK".
- I muri mai, ko te hua o te tukatuka raraunga a te kaiwhakahaere NORMST.RASP ka whakaatuhia i roto i te puurongo e whakariteritehia ana i te waahanga tuatahi o tenei aratohu.
- Engari ehara i te mea katoa. Ka tohua e matou anake te tohatoha paerewa noa. Hei tautuhi i te uara o te mahi Laplace, me tango e koe te tau mai i taua mea 0,5. Tīpakohia te pūtau kei roto i te whakapuaki. I roto i te raupapa ture i muri i te kaiwhakahaere NORMST.RASP tāpiri uara: -0,5.
- Hei tautuhi, panui i te paatene. Tomo. Ko te hua ko te uara e hiahiatia ana.
Ka taea e koe te kite, he mea ngawari ki te tatau i te mahi Laplace mo tetahi uara tau kua tohua i Excel. Ka whakamahia te kaiwhakahaere paerewa mo tenei kaupapa. NORMST.RASP.
