{"id":15727,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/ztest\/"},"modified":"2021-02-25T16:39:35","modified_gmt":"2021-02-25T16:39:35","slug":"ztest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/ztest\/","title":{"rendered":"ZTEST"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, istatistiksel analizler yap\u0131l\u0131rken \u00f6zellikle iki \u00f6rneklem \u00fczerinde yap\u0131lan testlerde kullan\u0131lan \u00f6nemli fonksiyonlardan biri olan Z.TEST’i sunar. Bu fonksiyon, bir veri k\u00fcmesinin ortalamas\u0131n\u0131n ba\u015fka bir \u00f6rneklemle kar\u015f\u0131la\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda anlaml\u0131 farkl\u0131l\u0131klar g\u00f6sterip g\u00f6stermedi\u011fini belirlemek i\u00e7in kullan\u0131l\u0131r. Bu yaz\u0131da, Z.TEST fonksiyonunun kullan\u0131m\u0131n\u0131, hangi senaryolarda i\u015fe yarayabilece\u011fini ve bu konular\u0131 \u00f6rneklerle a\u00e7\u0131klayaca\u011f\u0131z.<\/p>\n

Z.TEST Fonksiyonunun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

Z.TEST fonksiyonunun genel s\u00f6z dizimi \u015fu \u015fekildedir:<\/p>\n

  Z.TEST(array, x, [std_dev]) <\/code> <\/pre>\n
    \n
  • array<\/strong>: Analiz edilecek veri dizisidir.<\/li>\n
  • x<\/strong>: Test etmek istedi\u011fimiz hipotezin ortalamas\u0131d\u0131r.<\/li>\n
  • std_dev (iste\u011fe ba\u011fl\u0131)<\/strong>: Veri dizisinin standart sapmas\u0131d\u0131r. Bu de\u011fer sa\u011flanmazsa, \u00f6rnek standart sapmas\u0131 hesaplan\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
      =Z.TEST(A1:A20, 50) <\/code> <\/pre>\n
    Bu form\u00fcl, A1:A20 aral\u0131\u011f\u0131ndaki veri dizisinin ortalamas\u0131n\u0131n, hipotez ortalamas\u0131 50 olan bir Z testi yaparak, anlaml\u0131l\u0131k d\u00fczeyini p-de\u011feri olarak d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: \u00dcr\u00fcn Kalite Kontrol\u00fc<\/strong><\/p>\n
    Bir \u00fcretim \u015firketi, \u00fcrettikleri par\u00e7alar\u0131n a\u011f\u0131rl\u0131klar\u0131n\u0131n, belirlenen \u015fartnameye uygun olup olmad\u0131\u011f\u0131n\u0131 anlamak istiyor. Her bir par\u00e7an\u0131n ideal a\u011f\u0131rl\u0131\u011f\u0131 100 gramd\u0131r. Benzer \u00fcretim s\u00fcre\u00e7lerinden al\u0131nan 30 par\u00e7an\u0131n \u00f6l\u00e7\u00fcmleri Excel’e kaydedilmi\u015ftir:<\/p>\n
      =Z.TEST(B1:B30, 100) <\/code> <\/pre>\n
    Bu form\u00fcl, B1:B30 h\u00fccrelerindeki \u00f6rneklem verilerle yap\u0131lan test, par\u00e7alar\u0131n a\u011f\u0131rl\u0131klar\u0131n\u0131n pop\u00fclasyon ortalamas\u0131 100 gramdan anlaml\u0131 bir \u015fekilde farkl\u0131 olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirir.<\/p>\n
    \u00d6rnek 2: S\u0131nav Sonu\u00e7lar\u0131n\u0131n Analizi<\/strong><\/p>\n
    Bir \u00f6\u011fretmen, s\u0131n\u0131f\u0131n\u0131n bu y\u0131lki matematik s\u0131nav sonu\u00e7lar\u0131n\u0131n, ge\u00e7mi\u015f y\u0131llardaki s\u0131n\u0131flar\u0131n 70 puanl\u0131k ortalamas\u0131na g\u00f6re anlaml\u0131 bir farkl\u0131l\u0131k g\u00f6sterip g\u00f6stermedi\u011fini \u00f6l\u00e7mek istiyor. S\u0131n\u0131f\u0131n bu y\u0131lki sonu\u00e7lar\u0131 D1:D25 h\u00fccrelerine kaydedilmi\u015ftir:<\/p>\n
      =Z.TEST(D1:D25, 70) <\/code> <\/pre>\n
    Bu \u00f6rnekte, D1:D25 aral\u0131\u011f\u0131ndaki verilerle yap\u0131lan Z.TEST, bu y\u0131lki s\u0131n\u0131f\u0131n ortalamas\u0131n\u0131n ge\u00e7mi\u015f y\u0131llar\u0131n ortalamas\u0131ndan anlaml\u0131 bir \u015fekilde farkl\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n
    Bu fonksiyonlar sayesinde, Excel ve Google Sheets arac\u0131l\u0131\u011f\u0131yla \u00e7e\u015fitli istatistiksel analizleri kolayca ger\u00e7ekle\u015ftirerek veri i\u00e7g\u00f6r\u00fclerini geli\u015ftirebilirsiniz. Umar\u0131z bu \u00f6rnekler ve a\u00e7\u0131klamalar, Z.TEST fonksiyonunu etkin bir \u015fekilde kullanman\u0131za yard\u0131mc\u0131 olmu\u015ftur.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Z-testinin tek kuyruklu olas\u0131l\u0131k de\u011ferini verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[584],"tags":[],"class_list":["post-15727","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de ZTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ZTEST 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\/ztest\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ZTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ZTEST 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\/ztest\/\" \/>\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:35+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de ZTEST 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\/ztest\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/ztest\/\",\"name\":\"Excel'de ZTEST 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:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ZTEST 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\/ztest\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/ztest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/ztest\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uyumluluk\",\"item\":\"https:\/\/functiontranslator.com\/tr\/uyumluluk\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ZTEST\"}]},{\"@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 ZTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ZTEST 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\/ztest\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ZTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ZTEST 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\/ztest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:39:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ZTEST 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\/ztest\/","url":"https:\/\/functiontranslator.com\/tr\/ztest\/","name":"Excel'de ZTEST 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:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ZTEST 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\/ztest\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/ztest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/ztest\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Uyumluluk","item":"https:\/\/functiontranslator.com\/tr\/uyumluluk\/"},{"@type":"ListItem","position":3,"name":"ZTEST"}]},{"@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\/15727","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=15727"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15727\/revisions"}],"predecessor-version":[{"id":26995,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15727\/revisions\/26995"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}