NORM.S.INV<\/strong> veya T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 ile NORM.S.TERS<\/strong>, Excel ve Google E-Tablolar’da kullan\u0131labilen bir istatistik fonksiyonudur. Bu fonksiyon, standart normal da\u011f\u0131l\u0131m\u0131n belirli bir y\u00fczdelik i\u00e7in z de\u011ferini (yani normal da\u011f\u0131l\u0131m e\u011frisinin alt\u0131nda kalan alan\u0131 hesaplayarak bunun tersini al\u0131r) geri d\u00f6nd\u00fcr\u00fcr. Kullan\u0131m amac\u0131 genellikle istatistiksel analizler ve veri bilimi projelerinde belirli olas\u0131l\u0131klar alt\u0131nda de\u011fi\u015fkenlerin de\u011ferlerinin ne olaca\u011f\u0131n\u0131 tahmin etmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n Burada “olas\u0131l\u0131k” parametresi, 0 ile 1 aras\u0131nda bir de\u011fer al\u0131r ve standart normal da\u011f\u0131l\u0131m\u0131n alt\u0131nda kalan alan\u0131n y\u00fczdesi olarak tan\u0131mlan\u0131r.<\/p>\n \u00d6rnek:<\/strong> E\u011fer bir m\u00fchendis, \u00fcretilen par\u00e7alar\u0131n %95’inin belirli bir \u00f6l\u00e7\u00fcm\u00fcn alt\u0131nda kalmas\u0131n\u0131 istiyorsa, bu \u00f6l\u00e7\u00fcm\u00fcn maksimum s\u0131n\u0131r\u0131n\u0131 bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir:<\/p>\n Bu form\u00fcl, yakla\u015f\u0131k 1.645 de\u011ferini d\u00f6nd\u00fcr\u00fcr. Bu, standart normal da\u011f\u0131l\u0131m alt\u0131nda kalan %95 alan\u0131n z-de\u011feridir.<\/p>\n Risk De\u011ferlendirmesi<\/strong>:<\/p>\n Bir finansal analist, bir yat\u0131r\u0131m\u0131n %10 olas\u0131l\u0131kla zarara u\u011frayaca\u011f\u0131n\u0131 varsayarsa, bu zarar\u0131n maksimum s\u0131n\u0131r\u0131n\u0131 belirlemek i\u00e7in NORM.S.INV i\u015flevini kullanabilir:<\/p>\n Bu, yakla\u015f\u0131k -1.282 de\u011ferini d\u00f6nd\u00fcr\u00fcr ki bu negatif z-de\u011fer, yat\u0131r\u0131m\u0131n zarara u\u011frama riskini istatistiksel olarak ifade eder.<\/p>\n<\/li>\n \u00dcretim Kalite Kontrol\u00fc<\/strong>:<\/p>\n Bir \u00fcretim y\u00f6neticisi, \u00fcretim s\u00fcrecinin sadece %1 hata oran\u0131na sahip olmas\u0131n\u0131 istedi\u011finde, bu hata limitini tan\u0131mlamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilir:<\/p>\n Bu hesaplama, yakla\u015f\u0131k -2.326 de\u011ferini verir. Bu de\u011fer, \u00fcretim s\u00fcrecinden beklenen maksimum hata oran\u0131n\u0131n s\u0131n\u0131rlar\u0131n\u0131 belirler.<\/p>\n<\/li>\n<\/ul>\n NORM.S.INV<\/strong> fonksiyonu, \u00f6zellikle m\u00fchendislik, finans ve \u00fcretim y\u00f6netimi gibi alanlarda, belirli bir g\u00fcven aral\u0131\u011f\u0131nda maksimum ve minimum de\u011ferleri tahmin etmek i\u00e7in \u00e7ok \u00f6nemlidir. Olas\u0131l\u0131klarla \u00e7al\u0131\u015f\u0131rken bu fonksiyon, teorik hesaplamalar\u0131 pratik ve uygulanabilir sonu\u00e7lara d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. Kullan\u0131c\u0131lar\u0131n bu fonksiyonu veri analizlerinde etkin bir \u015fekilde kullanmalar\u0131, daha sa\u011flam ve do\u011fru sonu\u00e7lar elde etmelerine olanak tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":" Standart normal k\u00fcm\u00fclatif da\u011f\u0131l\u0131m\u0131n tersini verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15560","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\n\u0130\u015flevin Kullan\u0131m S\u00f6zdizimi ve \u00d6rnekleri<\/h2>\n
NORM.S.TERS<\/code> fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n=NORM.S.INV(olas\u0131l\u0131k)<\/code><\/pre>\n=NORM.S.INV(0.95)<\/code><\/pre>\nPratik Uygulamalar ve \u00c7\u00f6z\u00fcmler<\/h2>\n
\n
=NORM.S.INV(0.1)<\/code><\/pre>\n=NORM.S.INV(0.01)<\/code><\/pre>\n\u00d6zet ve Yorumlar<\/h2>\n