{"id":1493,"date":"2023-07-26T04:22:36","date_gmt":"2023-07-26T04:22:36","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-normallik-testi\/"},"modified":"2023-07-26T04:22:36","modified_gmt":"2023-07-26T04:22:36","slug":"excel-normallik-testi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-normallik-testi\/","title":{"rendered":"Excel&#39;de normallik testi nas\u0131l yap\u0131l\u0131r (ad\u0131m ad\u0131m)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Bir\u00e7ok istatistiksel test, bir veri setindeki de\u011ferlerin normal da\u011f\u0131ld\u0131\u011f\u0131n\u0131 varsayar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu hipotezi test etmenin en basit yollar\u0131ndan biri, \u00f6rnek verilerin normal da\u011f\u0131l\u0131mla tutarl\u0131 \u00e7arp\u0131kl\u0131k ve bas\u0131kl\u0131k g\u00f6sterip g\u00f6stermedi\u011fini belirleyen bir uyum iyili\u011fi testi olan <strong>Jarque-Bera testi<\/strong> yapmakt\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu test a\u015fa\u011f\u0131daki varsay\u0131mlar\u0131 kullan\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\">H <sub>0<\/sub> : Veriler normal da\u011f\u0131l\u0131ma sahiptir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">H <sub>A<\/sub> : Veriler normal da\u011f\u0131l\u0131ma sahip <em>de\u011fil<\/em> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em><strong>JB<\/strong><\/em> test istatisti\u011fi \u015fu \u015fekilde tan\u0131mlan\u0131r:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><em><strong>JB<\/strong><\/em> =(n\/6) * (S <sup>2<\/sup> + (C <sup>2<\/sup> \/4))<\/span><\/p>\n<p> <span style=\"color: #000000;\">Alt\u0131n:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> numunedeki <a href=\"https:\/\/statorials.org\/tr\/istatistikte-gozlem\/\" target=\"_blank\" rel=\"noopener\">g\u00f6zlem<\/a> say\u0131s\u0131<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>S:<\/strong> numunenin asimetrisi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>C:<\/strong> gurur verici \u00f6rnek<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Normallik s\u0131f\u0131r hipotezi alt\u0131nda, <em>JB~<\/em> X <sup>2<\/sup> (2).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Test istatisti\u011fine kar\u015f\u0131l\u0131k gelen <a href=\"https:\/\/statorials.org\/tr\/p-degerleri-istatistiksel-anlamlilik\/\" target=\"_blank\" rel=\"noopener\">p de\u011feri<\/a> belirli bir anlaml\u0131l\u0131k d\u00fczeyinin alt\u0131ndaysa (\u00f6rne\u011fin \u03b1 = 0,05), o zaman s\u0131f\u0131r hipotezini reddedebilir ve verilerin normal da\u011f\u0131lmad\u0131\u011f\u0131 sonucuna varabiliriz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu e\u011fitimde, Excel&#8217;de belirli bir veri k\u00fcmesi i\u00e7in Jarque-Bera testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin ad\u0131m ad\u0131m bir \u00f6rnek sunulmaktad\u0131r.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>1. Ad\u0131m: Verileri olu\u015fturun<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">\u00d6ncelikle 15 de\u011fere sahip sahte bir veri k\u00fcmesi olu\u015ftural\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-14778 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel2.png\" alt=\"\" width=\"410\" height=\"483\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ad\u0131m 2: Test istatisti\u011fini hesaplay\u0131n<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Daha sonra JB test istatisti\u011fini hesaplay\u0131n. S\u00fctun E kullan\u0131lan form\u00fclleri g\u00f6sterir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14787 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliteexcel1.png\" alt=\"\" width=\"562\" height=\"440\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Test istatisti\u011fi <strong>1,0175<\/strong> olarak \u00e7\u0131k\u0131yor.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ad\u0131m 3: P de\u011ferini hesaplay\u0131n<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Normalli\u011fin s\u0131f\u0131r hipotezi alt\u0131nda, JB test istatisti\u011fi 2 serbestlik derecesine sahip bir Ki-kare da\u011f\u0131l\u0131m\u0131n\u0131 takip eder.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dolay\u0131s\u0131yla, testin p de\u011ferini bulmak i\u00e7in Excel&#8217;de a\u015fa\u011f\u0131daki i\u015flevi kullanaca\u011f\u0131z:<\/span> <span style=\"color: #000000;\"><strong>=K\u0130K\u0130RQ.DA\u011e.RT(JB test istatisti\u011fi, 2)<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14788 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normaliteexcel2.png\" alt=\"Excel'de normallik testi\" width=\"492\" height=\"442\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Testin p de\u011feri <strong>0,601244&#8217;t\u00fcr<\/strong> . Bu p de\u011feri 0,05&#8217;ten k\u00fc\u00e7\u00fck olmad\u0131\u011f\u0131ndan s\u0131f\u0131r hipotezini reddedemiyoruz. Veri setinin normal da\u011f\u0131lmad\u0131\u011f\u0131n\u0131 s\u00f6yleyecek yeterli kan\u0131t\u0131m\u0131z yok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ba\u015fka bir deyi\u015fle verilerin normal da\u011f\u0131ld\u0131\u011f\u0131 varsay\u0131labilir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/tr\/bazi-excel-grafigi\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de QQ Grafi\u011fi Nas\u0131l Olu\u015fturulur<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de Ki Kare Uyum Testi Nas\u0131l Yap\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir\u00e7ok istatistiksel test, bir veri setindeki de\u011ferlerin normal da\u011f\u0131ld\u0131\u011f\u0131n\u0131 varsayar. Bu hipotezi test etmenin en basit yollar\u0131ndan biri, \u00f6rnek verilerin normal da\u011f\u0131l\u0131mla tutarl\u0131 \u00e7arp\u0131kl\u0131k ve bas\u0131kl\u0131k g\u00f6sterip g\u00f6stermedi\u011fini belirleyen bir uyum iyili\u011fi testi olan Jarque-Bera testi yapmakt\u0131r. Bu test a\u015fa\u011f\u0131daki varsay\u0131mlar\u0131 kullan\u0131r: H 0 : Veriler normal da\u011f\u0131l\u0131ma sahiptir. H A : Veriler normal da\u011f\u0131l\u0131ma [&hellip;]<\/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-1493","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de Normallik Testi Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#039;de normallik testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/excel-normallik-testi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Normallik Testi Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#039;de normallik testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-normallik-testi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T04:22:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel2.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\/excel-normallik-testi\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-normallik-testi\/\",\"name\":\"Excel&#39;de Normallik Testi Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-26T04:22:36+00:00\",\"dateModified\":\"2023-07-26T04:22:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de normallik testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-normallik-testi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-normallik-testi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-normallik-testi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de normallik testi nas\u0131l yap\u0131l\u0131r (ad\u0131m ad\u0131m)\"}]},{\"@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&#39;de Normallik Testi Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m)","description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de normallik testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","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\/excel-normallik-testi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Normallik Testi Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m)","og_description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de normallik testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-normallik-testi\/","og_site_name":"Statorials","article_published_time":"2023-07-26T04:22:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/npp_excel2.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\/excel-normallik-testi\/","url":"https:\/\/statorials.org\/tr\/excel-normallik-testi\/","name":"Excel&#39;de Normallik Testi Nas\u0131l Yap\u0131l\u0131r (Ad\u0131m Ad\u0131m)","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-26T04:22:36+00:00","dateModified":"2023-07-26T04:22:36+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de normallik testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-normallik-testi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-normallik-testi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-normallik-testi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de normallik testi nas\u0131l yap\u0131l\u0131r (ad\u0131m ad\u0131m)"}]},{"@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\/1493","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=1493"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/1493\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=1493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=1493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=1493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}