{"id":15726,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/z-test\/"},"modified":"2021-02-25T16:39:28","modified_gmt":"2021-02-25T16:39:28","slug":"z-test","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/z-test\/","title":{"rendered":"Z.TEST"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, geni\u015f i\u015flevsellikleri ile bilgi i\u015flem ve veri analizi i\u00e7in \u00e7ok y\u00f6nelimli ara\u00e7lar sunar. \u0130statistiksel fonksiyonlar aras\u0131nda \u00f6ne \u00e7\u0131kan <strong>Z.TEST<\/strong> i\u015flevi, belirli bir de\u011ferin pop\u00fclasyon ortalamas\u0131na g\u00f6re ne kadar farkl\u0131l\u0131k g\u00f6sterdi\u011fini test etmek i\u00e7in kullan\u0131l\u0131r. G\u00f6zlemlenen bir \u00f6rneklem setinin ortalamas\u0131 ile kar\u015f\u0131la\u015ft\u0131r\u0131larak yap\u0131lan bu test, ilgili de\u011ferin standart normal da\u011f\u0131l\u0131ma g\u00f6re ne kadar standart sapma uzakl\u0131kta oldu\u011funu hesaplar.<\/p>\n<h2>Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n<p><strong>Z.TEST<\/strong> i\u015flevinin temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<ul>\n<li><strong>Excel:<\/strong> <code>=Z.TEST(array, x, [sigma])<\/code><\/li>\n<li><strong>Google Sheets:<\/strong> <code>=Z.TEST(data, value)<\/code><\/li>\n<\/ul>\n<table>\n<tr>\n<th>Parametre<\/th>\n<th>Tan\u0131m<\/th>\n<\/tr>\n<tr>\n<td><code>array\/data<\/code><\/td>\n<td>Z-testi yap\u0131lacak veri dizisidir.<\/td>\n<\/tr>\n<tr>\n<td><code>x\/value<\/code><\/td>\n<td>Pop\u00fclasyon ortalamas\u0131yla kar\u015f\u0131la\u015ft\u0131r\u0131lmak \u00fczere test edilen de\u011fer.<\/td>\n<\/tr>\n<tr>\n<td><code>[sigma]<\/code><\/td>\n<td>(Opsiyonel) Pop\u00fclasyonun standart sapmas\u0131. E\u011fer bu parametre sa\u011flanmazsa, \u00f6rneklem standart sapmas\u0131 kullan\u0131l\u0131r.<\/td>\n<\/tr>\n<\/table>\n<h2>Pratik Uygulamalar<\/h2>\n<p><strong>Z.TEST<\/strong> i\u015flevi, \u00f6zellikle istatistiksel veri analizinde \u00f6nemli bir ara\u00e7t\u0131r. Bu i\u015flev, bir \u00fcr\u00fcn\u00fcn kalitesi veya hizmetin performans\u0131 gibi pop\u00fclasyon parametreleri hakk\u0131nda varsay\u0131mlar yaparken kullan\u0131l\u0131r. A\u015fa\u011f\u0131da, bu i\u015flevin pratik kullan\u0131m \u00f6rnekleri yer almaktad\u0131r.<\/p>\n<h2>Anl\u0131k \u0130statistiksel Test<\/h2>\n<p>Kalite kontrol departman\u0131, \u00fcretilen bir \u00fcr\u00fcn\u00fcn ortalama uzunlu\u011funun 10 cm oldu\u011funu iddia eder. Yap\u0131lan son \u00f6l\u00e7\u00fcmde 30 \u00fcr\u00fcnde ortalama uzunluk 9.8 cm olarak \u00f6l\u00e7\u00fcld\u00fc ve standart sapma 0.4 cm olarak hesapland\u0131.<\/p>\n<pre><code><strong>\u00d6rneklem verisi:<\/strong> [9.7, 9.8, 10, 9.9, 9.6, 10.1, 9.8, 9.7, 10, 9.5, ...] (30 veri noktas\u0131) <strong>Pop\u00fclasyon mu (x):<\/strong> 10 cm <strong>\u00d6rneklem sigma:<\/strong> 0.4 cm<\/code><\/pre>\n<p> <code>=Z.TEST(B2:B31, 10, 0.4)<\/code> <\/p>\n<p>Bu form\u00fcl, \u00f6l\u00e7\u00fclen ortalama de\u011ferin pop\u00fclasyon ortalamas\u0131 olan 10 cm&#8217;den istatistiksel olarak anlaml\u0131 bir \u015fekilde farkl\u0131 olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirir.<\/p>\n<h2>\u00dcr\u00fcn A\u011f\u0131rl\u0131klar\u0131n\u0131n De\u011ferlendirilmesi<\/h2>\n<p>Bir \u00fcretici, paketlenmi\u015f g\u0131da \u00fcr\u00fcnlerinin ortalama a\u011f\u0131rl\u0131\u011f\u0131n\u0131n 500 gram olmas\u0131 gerekti\u011fini belirtir. Rastgele se\u00e7ilen 40 paketin a\u011f\u0131rl\u0131klar\u0131 \u00f6l\u00e7\u00fcld\u00fc\u011f\u00fcnde \u00f6rneklem ortalamas\u0131 498 gram, standart sapma ise 3 gram olarak bulunmu\u015ftur.<\/p>\n<pre><code><strong>\u00d6rneklem verisi:<\/strong> [495, 499, 500, 498, 497, ...] (40 veri noktas\u0131) <strong>Pop\u00fclasyon mu (x):<\/strong> 500 gram <strong>\u00d6rneklem sigma:<\/strong> 3 gram<\/code><\/pre>\n<p> <code>=Z.TEST(A2:A41, 500, 3)<\/code> <\/p>\n<p>Bu i\u015flem, elde edilen a\u011f\u0131rl\u0131k de\u011ferlerinin iddia edilen pop\u00fclasyon ortalamas\u0131ndan istatistiksel olarak \u00f6nemli \u00f6l\u00e7\u00fcde ayr\u0131l\u0131p ayr\u0131lmad\u0131\u011f\u0131n\u0131 test eder. Test sonucu, p-de\u011feri olarak yorumlan\u0131r ve genellikle %5 (0.05) e\u015fi\u011finden k\u00fc\u00e7\u00fck oldu\u011funda, \u00f6rneklem ortalamas\u0131n\u0131n pop\u00fclasyon ortalamas\u0131ndan anlaml\u0131 \u015fekilde farkl\u0131 oldu\u011fu sonucuna var\u0131l\u0131r.<\/p>\n<p>Bu \u00f6rnekler, <strong>Z.TEST<\/strong> i\u015flevinin pratik kullan\u0131m\u0131n\u0131 ve istatistiksel analizdeki de\u011ferini vurgulamaktad\u0131r. Bu t\u00fcr testler, \u00f6nemli kararlar\u0131 desteklemek amac\u0131yla g\u00fcvenilir sonu\u00e7lar sa\u011flamada kritik bir role sahiptir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Z-testinin tek kuyruklu olas\u0131l\u0131k de\u011ferini hesaplar<\/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-15726","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da Z.TEST fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/z-test\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da Z.TEST fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/z-test\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:39:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/z-test\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/z-test\/\",\"name\":\"Excel'de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:39:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da Z.TEST fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/z-test\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/z-test\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/z-test\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Z.TEST\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da Z.TEST fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/tr\/z-test\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da Z.TEST fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/z-test\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:39:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/z-test\/","url":"https:\/\/functiontranslator.com\/tr\/z-test\/","name":"Excel'de Z.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:39:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da Z.TEST fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/z-test\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/z-test\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/z-test\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"Z.TEST"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15726"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15726\/revisions"}],"predecessor-version":[{"id":26994,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15726\/revisions\/26994"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}