{"id":787,"date":"2023-07-28T18:28:57","date_gmt":"2023-07-28T18:28:57","guid":{"rendered":"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/"},"modified":"2023-07-28T18:28:57","modified_gmt":"2023-07-28T18:28:57","slug":"kismi-korelasyon-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/","title":{"rendered":"Excel'de k\u0131smi korelasyon nas\u0131l hesaplan\u0131r"},"content":{"rendered":"

<\/p>\n

\n

\u0130statistikte, iki de\u011fi\u015fken aras\u0131ndaki do\u011frusal ili\u015fkiyi \u00f6l\u00e7mek i\u00e7in<\/span> s\u0131kl\u0131kla Pearson korelasyon katsay\u0131s\u0131n\u0131<\/a> kullan\u0131r\u0131z<\/span> . Ancak bazen \u00fc\u00e7\u00fcnc\u00fc bir de\u011fi\u015fkeni kontrol ederken<\/strong> iki de\u011fi\u015fken aras\u0131ndaki ili\u015fkiyi anlamak isteriz.<\/span><\/p>\n

\u00d6rne\u011fin, \u00f6\u011frencinin s\u0131n\u0131ftaki mevcut notunu kontrol ederken, \u00f6\u011frencinin ders \u00e7al\u0131\u015fma saati ile final s\u0131nav notu aras\u0131ndaki ili\u015fkiyi \u00f6l\u00e7mek istedi\u011fimizi varsayal\u0131m. Bu durumda \u00e7al\u0131\u015f\u0131lan saat ile final s\u0131nav notu aras\u0131ndaki ili\u015fkiyi \u00f6l\u00e7mek i\u00e7in k\u0131smi korelasyonu<\/strong> kullanabiliriz.<\/span><\/p>\n

Bu e\u011fitimde Excel’de k\u0131smi korelasyonun nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n

\u00d6rnek: Excel’de k\u0131smi korelasyon<\/strong><\/h3>\n

Diyelim ki 10 \u00f6\u011frenci i\u00e7in a\u015fa\u011f\u0131daki bilgileri g\u00f6r\u00fcnt\u00fcleyen bir veri k\u00fcmemiz var:<\/span><\/p>\n

    \n
  • Bir s\u0131n\u0131ftaki mevcut not<\/span><\/li>\n
  • Final s\u0131nav\u0131na \u00e7al\u0131\u015fmak i\u00e7in harcanan saatler<\/span><\/li>\n
  • Final s\u0131nav puan\u0131<\/span> <\/li>\n<\/ul>\n

    \"\"<\/p>\n

    Ge\u00e7erli notu kontrol ederken \u00e7al\u0131\u015f\u0131lan saat ile s\u0131nav notu aras\u0131ndaki k\u0131smi korelasyonu bulmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n.<\/span><\/p>\n

    Ad\u0131m 1: Her ikili korelasyonu hesaplay\u0131n.<\/strong><\/span><\/p>\n

    \u0130lk olarak, de\u011fi\u015fkenlerin her ikili kombinasyonu aras\u0131ndaki korelasyonu hesaplayaca\u011f\u0131z:<\/span> <\/p>\n

    \"\"<\/p>\n

    Ad\u0131m 2: Saatler ile s\u0131nav puan\u0131 aras\u0131ndaki k\u0131smi korelasyonu hesaplay\u0131n.<\/strong><\/span><\/p>\n

    C de\u011fi\u015fkenini kontrol ederken A de\u011fi\u015fkeni ile B de\u011fi\u015fkeni aras\u0131ndaki k\u0131smi korelasyonu hesaplamak i\u00e7in kullan\u0131lan form\u00fcl a\u015fa\u011f\u0131daki gibidir:<\/span><\/p>\n

    \n

    K\u0131smi korelasyon = (r A,B<\/sub> \u2013 r A,C<\/sub> *r B,C<\/sub> ) \/ \u221a((1-r 2<\/sup> A,B<\/sub> )(1-r 2<\/sup> B,C<\/sub> ))<\/span><\/p>\n<\/blockquote>\n

    A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc, mevcut notu kontrol ederek saatler ile s\u0131nav notu aras\u0131ndaki k\u0131smi korelasyonu hesaplamak i\u00e7in bu form\u00fcl\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n

    \"Excel'de<\/p>\n

    K\u0131smi korelasyon 0,190626’d\u0131r<\/strong> . Bu korelasyonun istatistiksel olarak anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in kar\u015f\u0131l\u0131k gelen p de\u011ferini bulabiliriz.<\/span><\/p>\n

    Ad\u0131m 3: K\u0131smi korelasyonun p de\u011ferini hesaplay\u0131n.<\/strong><\/span><\/p>\n

    T-<\/em> testi istatisti\u011fi \u015fu \u015fekilde hesaplanabilir:<\/span><\/p>\n

    \n

    t = r\u221a(n-3) \/ \u221a(1-r 2<\/sup> )<\/span><\/p>\n<\/blockquote>\n

    A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc, test istatisti\u011fini ve kar\u015f\u0131l\u0131k gelen p de\u011ferini hesaplamak i\u00e7in bu form\u00fcl\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n

    \"Excel'de<\/p>\n

    T-<\/em> testi istatisti\u011fi 0,51377’dir<\/strong> . Toplam serbestlik derecesi say\u0131s\u0131 n-3 = 10-3 = 7’dir<\/strong> . Kar\u015f\u0131l\u0131k gelen p de\u011feri 0,623228’dir<\/strong> . Bu de\u011ferin 0,05’ten k\u00fc\u00e7\u00fck olmamas\u0131 ders saatleri ile s\u0131nav sonu\u00e7lar\u0131 aras\u0131ndaki k\u0131smi korelasyonun istatistiksel olarak anlaml\u0131 olmad\u0131\u011f\u0131 anlam\u0131na gelmektedir.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    \u0130statistikte, iki de\u011fi\u015fken aras\u0131ndaki do\u011frusal ili\u015fkiyi \u00f6l\u00e7mek i\u00e7in s\u0131kl\u0131kla Pearson korelasyon katsay\u0131s\u0131n\u0131 kullan\u0131r\u0131z . Ancak bazen \u00fc\u00e7\u00fcnc\u00fc bir de\u011fi\u015fkeni kontrol ederken iki de\u011fi\u015fken aras\u0131ndaki ili\u015fkiyi anlamak isteriz. \u00d6rne\u011fin, \u00f6\u011frencinin s\u0131n\u0131ftaki mevcut notunu kontrol ederken, \u00f6\u011frencinin ders \u00e7al\u0131\u015fma saati ile final s\u0131nav notu aras\u0131ndaki ili\u015fkiyi \u00f6l\u00e7mek istedi\u011fimizi varsayal\u0131m. Bu durumda \u00e7al\u0131\u015f\u0131lan saat ile final s\u0131nav notu […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-787","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de K\u0131smi Korelasyon Nas\u0131l Hesaplan\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de k\u0131smi korelasyonun nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de K\u0131smi Korelasyon Nas\u0131l Hesaplan\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de k\u0131smi korelasyonun nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T18:28:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\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:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/\",\"name\":\"Excel'de K\u0131smi Korelasyon Nas\u0131l Hesaplan\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-28T18:28:57+00:00\",\"dateModified\":\"2023-07-28T18:28:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de k\u0131smi korelasyonun nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de k\u0131smi korelasyon nas\u0131l hesaplan\u0131r\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de K\u0131smi Korelasyon Nas\u0131l Hesaplan\u0131r - Statorials","description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de k\u0131smi korelasyonun nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.","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:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de K\u0131smi Korelasyon Nas\u0131l Hesaplan\u0131r - Statorials","og_description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de k\u0131smi korelasyonun nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T18:28:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/","url":"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/","name":"Excel'de K\u0131smi Korelasyon Nas\u0131l Hesaplan\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-28T18:28:57+00:00","dateModified":"2023-07-28T18:28:57+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de k\u0131smi korelasyonun nas\u0131l hesaplanaca\u011f\u0131na dair basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/kismi-korelasyon-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de k\u0131smi korelasyon nas\u0131l hesaplan\u0131r"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=787"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/787\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}