ID EN
…
#Statistical

NORM.S.DIST

Excel Functions 🇮🇩 Bahasa Indonesia

Dapatkan CDF dan PDF normal standar.

Syntax

EXCEL 
=NORM.S.DIST(z, cumulative)

Arguments

Parameter Deskripsi
z Numeric z-score value.
cumulative Logical value that determines the form of the function.

Return Value

Fungsi distribusi kumulatif normal standar

Details

Fungsi NORM.S.DIST mengembalikan nilai untuk fungsi distribusi kumulatif normal standar (CDF) dan fungsi kepadatan probabilitas normal standar (PDF). Misalnya, NORM.S.DIST(1,TRUE) mengembalikan nilai 0,8413 dan NORM.S.DIST(1,FALSE) mengembalikan nilai 0,2420. Parameternya, z, mewakili keluaran yang kita minati dan tanda kumulatif menunjukkan apakah fungsi CDF atau PDF digunakan. NORM.S.DIST mengharapkan masukan standar dalam bentuk nilai z-score. Nilai z-score menunjukkan seberapa jauh suatu nilai dari rata-rata suatu distribusi dalam hal deviasi standar distribusi tersebut. Untuk menghitung skor-z, kurangi nilai mean lalu bagi dengan simpangan baku atau gunakan fungsi STANDARDIZE seperti yang ditunjukkan pada dua rumus di bawah ini: Catatan, lihat NORM.DIS

Contoh

Example 1

The NORM.S.DIST function returns values for the standard normal cumulative distribution function (CDF) and the standard normal probability density fun

EXCEL 
=NORM.S.DIST(1,TRUE)=0.8413 // Returns the standard normal CDF
Example 2
EXCEL 
=NORM.S.DIST(1,FALSE)=0.2420 // Returns the standard normal PDF
NORM.S.DIST expects Standardized Input

NORM.S.DIST expects standardized input in the form of a z-score value. A z-score value represents how far a value is from the mean of a distribution i

EXCEL 
=(x-mean)/standard_deviation // calculates z-score
NORM.S.DIST expects Standardized Input
EXCEL 
=STANDARDIZE(x, mean, standard_deviation) // calculates z-score
Cumulative Flag

The cumulative flag determines which distribution function is used. If the flag is set to FALSE, the standard normal PDF is used. If the flag is set t

EXCEL 
=NORM.S.DIST(1,TRUE)=0.8413
Cumulative Flag

When the cumulative flag is set to FALSE, the standard normal PDF is used. The output of the CDF corresponds to the area under the PDF to the left of

EXCEL 
=NORM.S.DIST(1,FALSE)=0.242

See Also

NORM.DIST NORM.S.INV