{"id":1077,"date":"2023-07-27T18:22:16","date_gmt":"2023-07-27T18:22:16","guid":{"rendered":"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/"},"modified":"2023-07-27T18:22:16","modified_gmt":"2023-07-27T18:22:16","slug":"dogrusal-regresyon-google-sayfalari","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/","title":{"rendered":"Google e-tablolar&#39;da do\u011frusal regresyon nas\u0131l ger\u00e7ekle\u015ftirilir?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Do\u011frusal regresyon,<\/strong> bir veya daha fazla <a href=\"https:\/\/statorials.org\/tr\/degiskenleri-aciklayici-yanitlar\/\" target=\"_blank\" rel=\"noopener noreferrer\">a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken<\/a> ile bir <a href=\"https:\/\/statorials.org\/tr\/degiskenleri-aciklayici-yanitlar\/\" target=\"_blank\" rel=\"noopener noreferrer\">yan\u0131t de\u011fi\u015fkeni<\/a> aras\u0131ndaki ili\u015fkiyi \u00f6l\u00e7mek i\u00e7in kullan\u0131labilen bir y\u00f6ntemdir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Yaln\u0131zca bir a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken oldu\u011funda basit do\u011frusal regresyon, iki veya daha fazla a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken oldu\u011funda \u00e7oklu do\u011frusal regresyon kullan\u0131r\u0131z.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Her iki regresyon t\u00fcr\u00fc de a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanan Google E-Tablolar <a href=\"https:\/\/support.google.com\/docs\/answer\/3094249?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">LINEST()<\/a> i\u015flevi kullan\u0131larak ger\u00e7ekle\u015ftirilebilir:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>DOT (bilinen_veriler_y, bilinen_veriler_x, hesapla_b, ayr\u0131nt\u0131l\u0131)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Alt\u0131n:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>bilinen_data_y:<\/strong> yan\u0131t de\u011ferleri dizisi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>bilinen_data_x:<\/strong> A\u00e7\u0131klay\u0131c\u0131 de\u011ferler tablosu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>hesapla_b:<\/strong> kesmenin hesaplan\u0131p hesaplanmayaca\u011f\u0131n\u0131 belirtir. Bu, varsay\u0131lan olarak DO\u011eRU&#8217;dur ve do\u011frusal regresyon i\u00e7in bunu bu \u015fekilde b\u0131rak\u0131yoruz.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>ayr\u0131nt\u0131l\u0131:<\/strong> Yaln\u0131zca e\u011fim ve kesi\u015fme noktas\u0131n\u0131n \u00f6tesinde ek regresyon istatistikleri sa\u011flan\u0131p sa\u011flanmayaca\u011f\u0131n\u0131 belirtir. Bu varsay\u0131lan olarak YANLI\u015e&#8217;t\u0131r ancak \u00f6rneklerimizde bunun DO\u011eRU oldu\u011funu belirtece\u011fiz.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekler bu fonksiyonun pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Google E-Tablolar&#8217;da basit do\u011frusal regresyon<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><em>\u00c7al\u0131\u015f\u0131lan saatlerle<\/em> <em>s\u0131nav sonu\u00e7lar\u0131 aras\u0131ndaki ili\u015fkiyi anlamak istedi\u011fimizi varsayal\u0131m.<\/em> S\u0131nava \u00e7al\u0131\u015fmak ve s\u0131navda al\u0131nan not.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu ili\u015fkiyi ara\u015ft\u0131rmak i\u00e7in, a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken olarak <em>\u00e7al\u0131\u015f\u0131lan saatleri<\/em> ve yan\u0131t de\u011fi\u015fkeni olarak <em>s\u0131nav puanlar\u0131n\u0131<\/em> kullanarak basit bir do\u011frusal regresyon ger\u00e7ekle\u015ftirebiliriz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc, D2 h\u00fccresinde kullan\u0131lan a\u015fa\u011f\u0131daki form\u00fclle 20 \u00f6\u011frenciden olu\u015fan bir veri k\u00fcmesini kullanarak basit bir do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SATIR<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">B2:B21<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #800080;\">A2:A21<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">DO\u011eRU<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">DO\u011eRU<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span> <\/p>\n<\/blockquote>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11055 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regressiongooglesheets.png\" alt=\"Google E-Tablolarda Do\u011frusal Regresyon\" width=\"492\" height=\"496\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc \u00e7\u0131kt\u0131 i\u00e7in ek a\u00e7\u0131klamalar sa\u011flar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11056 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regressiongooglesheets2.png\" alt=\"Google E-Tablolar'da regresyon \u00e7\u0131kt\u0131s\u0131\" width=\"667\" height=\"461\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sonu\u00e7taki en alakal\u0131 say\u0131lar\u0131 nas\u0131l yorumlayaca\u011f\u0131n\u0131z a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>R Kare:<\/strong> <strong>0,72725<\/strong> . Buna belirleme katsay\u0131s\u0131 denir. A\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken taraf\u0131ndan a\u00e7\u0131klanabilen, yan\u0131t de\u011fi\u015fkenindeki varyans\u0131n oran\u0131d\u0131r. Bu \u00f6rnekte s\u0131nav puanlar\u0131ndaki de\u011fi\u015fimin yakla\u015f\u0131k %72,73&#8217;\u00fc \u00e7al\u0131\u015f\u0131lan saat say\u0131s\u0131yla a\u00e7\u0131klanabilir.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Standart hata:<\/strong> <strong>5.2805<\/strong> . Bu, g\u00f6zlemlenen de\u011ferler ile regresyon \u00e7izgisi aras\u0131ndaki ortalama mesafedir. Bu \u00f6rnekte g\u00f6zlemlenen de\u011ferler regresyon do\u011frusundan ortalama 5,2805 birim sapmaktad\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Katsay\u0131lar:<\/strong> Katsay\u0131lar bize tahmini regresyon denklemini yazmak i\u00e7in gereken say\u0131lar\u0131 verir. Bu \u00f6rnekte tahmini regresyon denklemi \u015f\u00f6yledir:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>S\u0131nav puan\u0131 = 67,16 + 5,2503*(saat)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Saat katsay\u0131s\u0131n\u0131, \u00e7al\u0131\u015f\u0131lan her ek saat i\u00e7in s\u0131nav puan\u0131n\u0131n ortalama <strong>5,2503<\/strong> artmas\u0131 gerekti\u011fi \u015feklinde yorumluyoruz. Kesi\u015fme katsay\u0131s\u0131n\u0131, s\u0131f\u0131r saat okuyan bir \u00f6\u011frenci i\u00e7in beklenen s\u0131nav puan\u0131n\u0131n <strong>67,16<\/strong> oldu\u011fu \u015feklinde yorumluyoruz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu tahmini regresyon denklemini, \u00e7al\u0131\u015fma saati say\u0131s\u0131na ba\u011fl\u0131 olarak bir \u00f6\u011frencinin beklenen s\u0131nav puan\u0131n\u0131 hesaplamak i\u00e7in kullanabiliriz. \u00d6rne\u011fin \u00fc\u00e7 saat ders \u00e7al\u0131\u015fan bir \u00f6\u011frencinin s\u0131nav puan\u0131n\u0131n <strong>82,91<\/strong> olmas\u0131 gerekir:<\/span><\/p>\n<p> <span style=\"color: #000000;\">S\u0131nav puan\u0131 = 67,16 + 5,2503*(3) = 82,91<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Google E-Tablolarda \u00c7oklu Do\u011frusal Regresyon<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Diyelim ki, ders \u00e7al\u0131\u015fmak i\u00e7in harcanan saatlerin ve al\u0131nan haz\u0131rl\u0131k s\u0131navlar\u0131n\u0131n say\u0131s\u0131n\u0131n, bir \u00f6\u011frencinin belirli bir \u00fcniversiteye giri\u015f s\u0131nav\u0131ndan ald\u0131\u011f\u0131 notu etkileyip etkilemedi\u011fini bilmek istiyoruz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu ili\u015fkiyi ara\u015ft\u0131rmak i\u00e7in <em>\u00e7al\u0131\u015f\u0131lan saatleri<\/em> ve <em>al\u0131nan haz\u0131rl\u0131k s\u0131navlar\u0131n\u0131<\/em> a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fkenler olarak ve <em>s\u0131nav sonu\u00e7lar\u0131n\u0131<\/em> yan\u0131t de\u011fi\u015fkeni olarak kullanarak \u00e7oklu do\u011frusal regresyon ger\u00e7ekle\u015ftirebiliriz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc, E2 h\u00fccresinde kullan\u0131lan a\u015fa\u011f\u0131daki form\u00fclle 20 \u00f6\u011frenciden olu\u015fan bir veri k\u00fcmesini kullanarak \u00e7oklu do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SA\u011e<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">C2:C21<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #800080;\">A2:B21<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">DO\u011eRU<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"boolean\" dir=\"auto\" style=\"color: #3366ff;\">DO\u011eRU<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span> <\/p>\n<\/blockquote>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11058 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regressiongooglesheets3.png\" alt=\"Google E-Tablolarda \u00c7oklu Do\u011frusal Regresyon\" width=\"659\" height=\"500\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sonu\u00e7taki en alakal\u0131 say\u0131lar\u0131 nas\u0131l yorumlayaca\u011f\u0131n\u0131z a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\"><strong>R Kare:<\/strong> <strong>0,734<\/strong> . Buna belirleme katsay\u0131s\u0131 denir. A\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fkenler taraf\u0131ndan a\u00e7\u0131klanabilen yan\u0131t de\u011fi\u015fkeninin varyans\u0131n\u0131n oran\u0131d\u0131r. Bu \u00f6rnekte s\u0131nav puanlar\u0131ndaki farkl\u0131l\u0131\u011f\u0131n %73,4&#8217;\u00fc \u00e7al\u0131\u015f\u0131lan saat ve girilen haz\u0131rl\u0131k s\u0131nav\u0131 say\u0131s\u0131yla a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\"><strong>Standart hata:<\/strong> <strong>5,3657<\/strong> . Bu, g\u00f6zlemlenen de\u011ferler ile regresyon \u00e7izgisi aras\u0131ndaki ortalama mesafedir. Bu \u00f6rnekte g\u00f6zlemlenen de\u011ferler regresyon do\u011frusundan ortalama 5,3657 birim sapmaktad\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Tahmini regresyon denklemi:<\/strong> A\u015fa\u011f\u0131daki tahmini regresyon denklemini olu\u015fturmak i\u00e7in model \u00e7\u0131kt\u0131s\u0131ndaki katsay\u0131lar\u0131 kullanabiliriz:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>S\u0131nav puan\u0131 = 67,67 + 5,56*(saat) \u2013 0,60*(haz\u0131rl\u0131k s\u0131navlar\u0131)<\/strong><\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\">Bu tahmini regresyon denklemini, bir \u00f6\u011frencinin \u00e7al\u0131\u015fma saati ve girdi\u011fi deneme s\u0131navlar\u0131n\u0131n say\u0131s\u0131na ba\u011fl\u0131 olarak beklenen s\u0131nav puan\u0131n\u0131 hesaplamak i\u00e7in kullanabiliriz. \u00d6rne\u011fin \u00fc\u00e7 saat \u00e7al\u0131\u015f\u0131p haz\u0131rl\u0131k s\u0131nav\u0131na giren bir \u00f6\u011frencinin notunun <strong>83,75<\/strong> olmas\u0131 gerekir:<\/span><\/p>\n<p> <span style=\"color: #000000;\">S\u0131nav puan\u0131 = 67,67 + 5,56*(3) \u2013 0,60*(1) = 83,75<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar&#8217;da di\u011fer yayg\u0131n g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/polinom-regresyon-google-sayfalari\/\" target=\"_blank\" rel=\"noopener\">Google E-Tablolarda polinom regresyonu nas\u0131l ger\u00e7ekle\u015ftirilir?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/kalan-iz-google-sayfalari\/\">Google E-Tablolarda Art\u0131k Grafik Nas\u0131l Olu\u015fturulur<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do\u011frusal regresyon, bir veya daha fazla a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken ile bir yan\u0131t de\u011fi\u015fkeni aras\u0131ndaki ili\u015fkiyi \u00f6l\u00e7mek i\u00e7in kullan\u0131labilen bir y\u00f6ntemdir. Yaln\u0131zca bir a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken oldu\u011funda basit do\u011frusal regresyon, iki veya daha fazla a\u00e7\u0131klay\u0131c\u0131 de\u011fi\u015fken oldu\u011funda \u00e7oklu do\u011frusal regresyon kullan\u0131r\u0131z. Her iki regresyon t\u00fcr\u00fc de a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanan Google E-Tablolar LINEST() i\u015flevi kullan\u0131larak ger\u00e7ekle\u015ftirilebilir: DOT (bilinen_veriler_y, bilinen_veriler_x, [&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-1077","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>Google E-Tablolarda Do\u011frusal Regresyon Nas\u0131l Ger\u00e7ekle\u015ftirilir \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Google E-Tablolar&#039;da do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin \u00f6rneklerle 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\/dogrusal-regresyon-google-sayfalari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google E-Tablolarda Do\u011frusal Regresyon Nas\u0131l Ger\u00e7ekle\u015ftirilir \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Google E-Tablolar&#039;da do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin \u00f6rneklerle basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T18:22:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regressiongooglesheets.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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/\",\"url\":\"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/\",\"name\":\"Google E-Tablolarda Do\u011frusal Regresyon Nas\u0131l Ger\u00e7ekle\u015ftirilir \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-27T18:22:16+00:00\",\"dateModified\":\"2023-07-27T18:22:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Google E-Tablolar&#39;da do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin \u00f6rneklerle basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google e-tablolar&#39;da do\u011frusal regresyon nas\u0131l ger\u00e7ekle\u015ftirilir?\"}]},{\"@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":"Google E-Tablolarda Do\u011frusal Regresyon Nas\u0131l Ger\u00e7ekle\u015ftirilir \u2013 Statorials","description":"Google E-Tablolar&#39;da do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin \u00f6rneklerle 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\/dogrusal-regresyon-google-sayfalari\/","og_locale":"tr_TR","og_type":"article","og_title":"Google E-Tablolarda Do\u011frusal Regresyon Nas\u0131l Ger\u00e7ekle\u015ftirilir \u2013 Statorials","og_description":"Google E-Tablolar&#39;da do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin \u00f6rneklerle basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/","og_site_name":"Statorials","article_published_time":"2023-07-27T18:22:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regressiongooglesheets.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/","url":"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/","name":"Google E-Tablolarda Do\u011frusal Regresyon Nas\u0131l Ger\u00e7ekle\u015ftirilir \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-27T18:22:16+00:00","dateModified":"2023-07-27T18:22:16+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Google E-Tablolar&#39;da do\u011frusal regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin \u00f6rneklerle basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/dogrusal-regresyon-google-sayfalari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Google e-tablolar&#39;da do\u011frusal regresyon nas\u0131l ger\u00e7ekle\u015ftirilir?"}]},{"@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\/1077","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=1077"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/1077\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=1077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=1077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=1077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}