{"id":15536,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/dizey_ters\/"},"modified":"2021-02-25T16:31:53","modified_gmt":"2021-02-25T16:31:53","slug":"minverse","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/minverse\/","title":{"rendered":"D\u0130ZEY_TERS"},"content":{"rendered":"

Matris Ters \u00c7evirme S\u00fcreci: Excel ve Google E-Tablolar’da Pratik Uygulamalar<\/h1>\n

Microsoft Excel ve Google E-Tablolar, matriksel i\u015flemleri kolayla\u015ft\u0131ran \u00e7e\u015fitli fonksiyonlar sunar. Bunlardan biri de matrisin tersini almak i\u00e7in kullan\u0131lan fonksiyondur. \u0130ki platformda da bu i\u015flev, matrislerle yap\u0131lan \u00e7e\u015fitli hesaplamalarda \u00e7ok \u00f6nemli bir role sahiptir. Bu makalede, bu fonksiyonun hem Excel’de hem de Google E-Tablolar’da nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131, \u00f6rneklerle birlikte i\u015fleyece\u011fiz.<\/p>\n

S\u00f6zdiziminin Detayl\u0131 A\u00e7\u0131klamas\u0131 ve \u00d6rnekler<\/h2>\n

Matrisin tersini hesaplama i\u015flevi, MS Excel’de MINVERSE<\/code> ve Google E-Tablolar’da D\u0130ZEY_TERS<\/code> olarak adland\u0131r\u0131l\u0131r. Fonksiyonun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=MINVERSE(matris)<\/code><\/pre>\n
Burada “matris”, tersi al\u0131nacak kare matrisi belirtir. Matrisin tersi al\u0131nabilmesi i\u00e7in, belirtilen matrisin kare olmas\u0131 ve determinant\u0131n\u0131n s\u0131f\u0131r olmamas\u0131 gerekir.<\/p>\n
\u00d6rnek olarak, 2×2’lik bir matris d\u00fc\u015f\u00fcnelim:<\/p>\n
A B C D<\/code><\/pre>\n
Excel’de bu matrisin tersini almak i\u00e7in \u015fu form\u00fcl\u00fc kullan\u0131r\u0131z:<\/p>\n
=MINVERSE(A1:B2)<\/code><\/pre>\n
Google E-Tablolar’da ayn\u0131 i\u015flem i\u00e7in:<\/p>\n
=D\u0130ZEY_TERS(A1:B2)<\/code><\/pre>\n
Form\u00fclleri girdikten sonra, sonu\u00e7 olarak matrisin tersi elde edilir, bu matris yine 2×2\u2019lik bir yap\u0131dad\u0131r.<\/p>\n
Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    \n
  • \n
    Senaryo 1: Bir Sistem Denkleminin \u00c7\u00f6z\u00fcm\u00fc<\/h3>\n
    Lineer denklemler sistemi, m\u00fchendislik ve bilim alanlar\u0131nda s\u0131k\u00e7a kar\u015f\u0131la\u015f\u0131lan bir problemdir. E\u011fer sistem matris formunda AX = B \u015feklinde ifade edilebiliyorsa, X = A^-1B form\u00fcl\u00fc ile X matrisi (\u00e7\u00f6z\u00fcm) hesaplanabilir.<\/p>\n
    \u00d6rnek:<\/p>\n
    A = 1 2 3 4 B = 5 6<\/code><\/pre>\n
    Excel’de \u00e7\u00f6z\u00fcm i\u00e7in:<\/p>\n
    1. A matrisinin tersini hesapla =MINVERSE(A1:B2) 2. Sonra, A^-1 ile B'yi \u00e7arp =MMULT(sonu\u00e7, C1:C2)<\/code><\/pre>\n
    Google E-Tablolar’da ayn\u0131 i\u015flem:<\/p>\n
    1. A matrisinin tersini hesapla =D\u0130ZEY_TERS(A1:B2) 2. Sonra, D\u0130ZEY_TERS ile B'yi \u00e7arp =D\u0130Z\u00c7ARP(sonu\u00e7, C1:C2)<\/code><\/pre>\n<\/li>\n
  • \n
    Senaryo 2: \u0130statistiksel Veri Analizi<\/h3>\n
    \u00c7oklu do\u011frusal regresyon analizinde, ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerin (X) katsay\u0131lar\u0131 (\u03b2), (X’X)^-1X’Y form\u00fcl\u00fc ile hesaplanabilir. Burada X’ matris X’in transpozesidir ve Y ba\u011f\u0131ml\u0131 de\u011fi\u015fken vekt\u00f6r\u00fcd\u00fcr.<\/p>\n
    \u00d6rnek i\u015flem Excel’de:<\/p>\n
    1. X'X matrisini hesapla =MMULT(TRANSPOSE(X), X) 2. Sonra, bu matrisin tersini al =MINVERSE(sonu\u00e7) 3. Son olarak, sonu\u00e7 matris ile X'Y'yi \u00e7arp =MMULT(sonu\u00e7_2, MMULT(TRANSPOSE(X), Y))<\/code><\/pre>\n
    Google E-Tablolar’daki kar\u015f\u0131l\u0131\u011f\u0131 ise:<\/p>\n
    1. X'X matrisini hesapla =D\u0130Z\u00c7ARP(D\u0130ZEYDEV\u0130R(X), X) 2. Sonra, bu matrisin tersini al =D\u0130ZEY_TERS(sonu\u00e7) 3. Son olarak, sonu\u00e7 matris ile X'Y'yi \u00e7arp =D\u0130Z\u00c7ARP(sonu\u00e7_2, D\u0130Z\u00c7ARP(D\u0130ZEYDEV\u0130R(X), Y))<\/code><\/pre>\n<\/li>\n<\/ul>\n
    Bu fonksiyonlar, veri analizi, m\u00fchendislik problemleri ve ekonomi gibi bir\u00e7ok alanda matematiksel modellemeler yaparken s\u0131kl\u0131kla ba\u015fvurulan y\u00f6ntemlerdir. Kullan\u0131c\u0131lar\u0131n matris i\u015flemlerini kolayl\u0131kla yapmalar\u0131n\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Dizinin matris 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":[577],"tags":[],"class_list":["post-15536","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de MINVERSE (D\u0130ZEY_TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de MINVERSE (D\u0130ZEY_TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/\" \/>\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:31:53+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 MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/minverse\/\",\"name\":\"Excel'de MINVERSE (D\u0130ZEY_TERS) 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:31:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/minverse\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/minverse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematik ve trigonometri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"D\u0130ZEY_TERS\"}]},{\"@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 MINVERSE (D\u0130ZEY_TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MINVERSE (D\u0130ZEY_TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:31:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/","url":"https:\/\/functiontranslator.com\/tr\/minverse\/","name":"Excel'de MINVERSE (D\u0130ZEY_TERS) 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:31:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MINVERSE (D\u0130ZEY_TERS) 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\/minverse\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/minverse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/minverse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Matematik ve trigonometri","item":"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/"},{"@type":"ListItem","position":3,"name":"D\u0130ZEY_TERS"}]},{"@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\/15536","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=15536"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15536\/revisions"}],"predecessor-version":[{"id":26804,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15536\/revisions\/26804"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}