Ko tetahi o nga tino mahinga kore-kura rongonui e whakamahia ana i roto i te pāngarau, i roto i te ariā o te whārite tauwehe, i roto i nga tatauranga me te ariā tūponotanga, ko te mahi a Laplace. Ko te whakariterite i nga raru ka hiahiatia he whakarite tino nui. Kia kite me pehea e whakamahi ai koe i nga taputapu Excel hei tātai i tenei tohu.
Paetahi mahi
Kua whakaputahia e te mahi Laplace nga tono me nga tono kaupapa. Hei tauira, he maha nga waahi ka whakamahia hei whakaoti i nga whārite tauwehe. He ingoa ano tenei kupu - ko te whakaurunga pea. I etahi waahi, ko te turanga mo te otinga ko te hanganga o te tepu uara.
Kaituku NORM.ST.RASP
I a Excel, ka whakatauhia tenei raru ma te whakamahi i te kaituku NORM.ST.RASP. Ko tona ingoa he whakarapopototanga o te kupu "tohatoha paerewa noa". I te mea ko tana mahi nui ko te hoki ki nga wa i tohua ko te tohatoha tuuturu paerewa noa. Ko tenei kaiwhakahaere kei roto i te waahanga taatai o nga mahi a te Paerewa paerewa.
I roto i te Excel 2007 me nga waahanga o mua o te hōtaka, i karangahia tenei korero NORMSTRASP. Ka waihohia mo nga kaupapa whakariterite i roto i nga putanga o enei ra. Engari tonu, ka tūtohu ratou ki te whakamahi i te taapiri ake o te taangata - NORM.ST.RASP.
Syntax Operator NORM.ST.RASP penei te ahua:
= NORM.ST. RASP (z; whakaurutanga)
Kaiwhakahaere Whakahaerehia NORMSTRASP kua penei te tuhituhi:
= NORMSTRASP (z)
Kei te kite koe, kei roto i te waahanga hou ki te tautohetohe o mua "Z" amuamu tapiritia "Whakauru". Me tohuhia ko ia tautohetohe e hiahiatia ana.
Taurekareka "Z" e tohu ana i te uara tiro e hangaia ana te tohatoha.
Taurekareka "Whakauru" e tohu ana i te uara arorau kei a ia pea tetahi whakaaro "TINO" ("1") ranei TENEI ("0"). I te keehi tuatahi, ka hoki mai te waahanga tohatoha whakauru ki te waarangi e tohuhia ana, a, i te tuarua, ko te mahinga tohatoha taumaha.
Te whakaoti rapanga
Hei mahi i te tatauranga e hiahiatia ana mo te taurangi, ka whakamahia te tikanga e whai ake nei:
= NORM.ST. RASP (z; whakaurunga (1)) - 0.5
Na, me titiro tatou ki tetahi tauira motuhake ma te whakamahi i te kaihokohoko NORM.ST.RASP ki te whakatau i tetahi raru motuhake.
- Tīpakohia te pūtau i reira ka whakaatuhia te huanga oti ka paatene ki te ata "Whakauruhia te mahi"kei te taha o te raina tātai.
- Ka mutu kua whakatuwherahia Nga Mahi Maakui haere ki te waahanga "Tatauranga" ranei "Whakaoti reta taaputa". Tīpakohia te ingoa NORM.ST.RASP kia paato atu te paapa "OK".
- Kei te whakahohehia te matapihi toha a te kaiwhakahaere NORM.ST.RASP. I te parae "Z" ka whakapuakihia e matou te rereketanga e hiahia ana koe ki te tatauranga. Ano, ko tenei tautohetohe ka taea te tohu hei tohutoro ki te pūtau e mau ana i tenei rereketanga. I te parae "Whakauru"whakauruhia te uara "1". Ko te tikanga ka hoki te kaiwhakahaere i muri i te tātai ka hoki mai te mahi tohatoha whakauru hei otinga. Ka oti nga mahi i runga ake nei, pawhiria te paatene "OK".
- I muri i tera, ko te hua o te tukatuka raraunga e te kaiwhakahaere NORM.ST.RASP ka whakaatuhia ki te pouaka e tohua ana i te whiti tuatahi o tenei pukapuka.
- Engari ehara i te mea noa. I whakauruhia e maatau anake te tohatoha whakauru tuuturu. Hei tātai i te uara o te mahi Laplace, me whakaweto e koe taua nama 0,5. Tīpakohia te pūtau kei roto te whakaaturanga. I roto i te paahinga tiro i muri i te korero NORM.ST.RASP tāpiri i te uara: -0,5.
- Ki te mahi i te tatauranga, paato i te paatene Whakaurua. Ko te hua ka riro ko te uara e hiahiatia ana.
Kei te kite koe, ehara i te mea uaua ki te tātai i te mahi Laplace mo tetahi uara tatau tau i roto i a Excel. Ka whakamahia te kaiwhakahaere paerewa mo enei kaupapa. NORM.ST.RASP.
