{"id":15487,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kesmenoktasi\/"},"modified":"2021-02-25T16:29:43","modified_gmt":"2021-02-25T16:29:43","slug":"intercept","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/intercept\/","title":{"rendered":"KESMENOKTASI"},"content":{"rendered":"

KESMENOKTASI (INTERCEPT) Fonksiyonunun A\u00e7\u0131klamas\u0131<\/h2>\n

KESMENOKTASI<\/code> veya \u0130ngilizce ad\u0131yla INTERCEPT<\/code> fonksiyonu, Y ba\u011f\u0131ml\u0131 de\u011fi\u015fkenler ile X ba\u011f\u0131ms\u0131z de\u011fi\u015fkenler aras\u0131ndaki do\u011frusal ili\u015fkiyi inceleyerek, do\u011frusal regresyon \u00e7izgisinin Y ekseni ile kesi\u015fti\u011fi noktay\u0131 hesaplar. Bu kesi\u015fme noktas\u0131, X de\u011ferleri s\u0131f\u0131r iken Y’nin alaca\u011f\u0131 de\u011feri g\u00f6sterir. Hem MS Excel hem de Google Sheets’te kullan\u0131labilir olan bu fonksiyon, finans, ekonomi, biyoloji gibi \u00e7e\u015fitli alanlarda veri analizi amac\u0131yla tercih edilir.<\/p>\n

Kullan\u0131m S\u00f6zdizimi ve Parametreler<\/h2>\n

KESMENOKTASI(y_de\u011ferleri, x_de\u011ferleri)<\/code><\/p>\n

    \n
  • y_de\u011ferleri:<\/strong> Ba\u011f\u0131ml\u0131 Y de\u011fi\u015fkenlerinin bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • x_de\u011ferleri:<\/strong> Ba\u011f\u0131ms\u0131z X de\u011fi\u015fkenlerinin bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131.<\/li>\n<\/ul>\n

    Y ve X de\u011fi\u015fkenleri say\u0131sal olmal\u0131 ve ayn\u0131 say\u0131da veri i\u00e7ermelidir; aksi halde fonksiyon bir hata mesaj\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n

    Fonksiyonun Kullan\u0131m \u00d6rnekleri<\/h2>\n
     Y De\u011ferleri X De\u011ferleri 3 2 4 5 6 7 <\/code><\/pre>\n
    Yukar\u0131daki veri seti i\u00e7in, =KESMENOKTASI(A2:A4, B2:B4)<\/code> form\u00fcl\u00fc ile Y eksenindeki kesi\u015fim noktas\u0131n\u0131 hesaplayabiliriz.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    \u00c7al\u0131\u015fanlar\u0131n Maa\u015f Tahmini<\/h2>\n
    Bir \u015firket, \u00e7al\u0131\u015fanlar\u0131n y\u0131llara g\u00f6re tecr\u00fcbeleri (X olarak) ve ald\u0131klar\u0131 maa\u015flar (bin TL cinsinden Y olarak) verileriyle, tecr\u00fcbesiz yeni bir \u00e7al\u0131\u015fan i\u00e7in \u00f6denecek ba\u015flang\u0131\u00e7 maa\u015f\u0131n\u0131 hesaplamak istiyor.<\/p>\n\n\n\n\n\n
    Tecr\u00fcbe (Y\u0131l)<\/td>\nMaa\u015f (Bin TL)<\/td>\n<\/tr>\n
    2<\/td>\n3<\/td>\n<\/tr>\n
    5<\/td>\n4.5<\/td>\n<\/tr>\n
    7<\/td>\n5.7<\/td>\n<\/tr>\n<\/table>\n
     =KESMENOKTASI(B2:B4, A2:A4) <\/code><\/pre>\n
    Bu \u00f6rnekte, verilen tecr\u00fcbe y\u0131llar\u0131 ve maa\u015f de\u011ferlerine dayanarak, tecr\u00fcbesiz bir \u00e7al\u0131\u015fan\u0131n alabilece\u011fi ba\u015flang\u0131\u00e7 maa\u015f\u0131n\u0131 tahmin edebiliriz.<\/p>\n
    Pazarlama Kampanyas\u0131 Etkile\u015fim Tahmini<\/h2>\n
    Bir \u015firket, y\u00fcr\u00fctt\u00fc\u011f\u00fc pazarlama kampanyalar\u0131na yap\u0131lan harcamalar (X olarak Bin TL) ve bu kampanyalardan elde edilen toplam etkile\u015fim say\u0131lar\u0131 (Y olarak) verilerini kullanarak, hi\u00e7 harcama yap\u0131lmad\u0131\u011f\u0131nda beklenen etkile\u015fim say\u0131s\u0131n\u0131 \u00f6\u011frenmek istiyor.<\/p>\n\n\n\n\n\n
    Harcama (Bin TL)<\/td>\nEtkile\u015fim<\/td>\n<\/tr>\n
    10<\/td>\n200<\/td>\n<\/tr>\n
    20<\/td>\n400<\/td>\n<\/tr>\n
    30<\/td>\n600<\/td>\n<\/tr>\n<\/table>\n
     =KESMENOKTASI(A2:A4, B2:B4) <\/code><\/pre>\n
    Bu veri setini kullanarak, KESMENOKTASI<\/code> fonksiyonu ile s\u0131f\u0131r harcama durumunda beklenen etkile\u015fim say\u0131s\u0131n\u0131 tahmin edebiliriz. Sonu\u00e7lar mant\u0131kl\u0131 de\u011filse, bu, modelin veri seti i\u00e7in uygun olmad\u0131\u011f\u0131 anlam\u0131na gelir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Do\u011frusal regresyon \u00e7izgisinin kesi\u015fme noktas\u0131n\u0131 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-15487","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de INTERCEPT (KESMENOKTASI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da INTERCEPT (KESMENOKTASI) 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\/intercept\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de INTERCEPT (KESMENOKTASI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da INTERCEPT (KESMENOKTASI) 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\/intercept\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:29:43+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 INTERCEPT (KESMENOKTASI) 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\/intercept\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/intercept\/\",\"name\":\"Excel'de INTERCEPT (KESMENOKTASI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:29:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da INTERCEPT (KESMENOKTASI) 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\/intercept\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/intercept\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/intercept\/#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\":\"KESMENOKTASI\"}]},{\"@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 INTERCEPT (KESMENOKTASI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da INTERCEPT (KESMENOKTASI) 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\/intercept\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de INTERCEPT (KESMENOKTASI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da INTERCEPT (KESMENOKTASI) 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\/intercept\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de INTERCEPT (KESMENOKTASI) 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\/intercept\/","url":"https:\/\/functiontranslator.com\/tr\/intercept\/","name":"Excel'de INTERCEPT (KESMENOKTASI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:29:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da INTERCEPT (KESMENOKTASI) 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\/intercept\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/intercept\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/intercept\/#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":"KESMENOKTASI"}]},{"@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\/15487","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=15487"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15487\/revisions"}],"predecessor-version":[{"id":26755,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15487\/revisions\/26755"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}