A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, Google E-Tablolar’da lojistik regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir.<\/span><\/span><\/p>\n Google E-Tablolar’da lojistik regresyon ger\u00e7ekle\u015ftirmek i\u00e7in \u00f6ncelikle \u00fccretsiz XLMiner Analiz Ara\u00e7 Paketi’ni<\/strong> y\u00fcklememiz gerekiyor.<\/span><\/p>\n Bunu yapmak i\u00e7in Eklentiler > Eklentileri Al’a<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Daha sonra arama \u00e7ubu\u011funa XLMiner Analiz Ara\u00e7 Paketi<\/strong> yaz\u0131n ve beliren simgeye t\u0131klay\u0131n:<\/span> <\/p>\n Son olarak mavi Y\u00fckle<\/strong> d\u00fc\u011fmesine t\u0131klay\u0131n.<\/span> <\/p>\n Daha sonra a\u015fa\u011f\u0131daki verileri Google E-Tablolar’a girece\u011fiz:<\/span> <\/p>\n Puanlar\u0131 kullanan ve bir basketbolcunun NBA’e al\u0131n\u0131p al\u0131nmayaca\u011f\u0131n\u0131 tahmin etmeye yard\u0131mc\u0131 olan bir lojistik regresyon modeli uygulayaca\u011f\u0131z (0 = Hay\u0131r, 1 = Evet).<\/span><\/p>\n Lojistik regresyon modeline uyum sa\u011flamak i\u00e7in Uzant\u0131lar<\/strong> sekmesine t\u0131klay\u0131n, ard\u0131ndan XL Miner Analizi Ara\u00e7 Paketi’ne<\/strong> ve ard\u0131ndan Ba\u015flat’a<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Ekran\u0131n sa\u011f taraf\u0131nda g\u00f6r\u00fcnen panelde Lojistik Regresyon’un<\/strong> yan\u0131ndaki a\u00e7\u0131l\u0131r oka t\u0131klay\u0131n ve a\u015fa\u011f\u0131daki bilgileri girin:<\/span> <\/p>\n Tamam’a<\/strong> t\u0131klad\u0131\u011f\u0131n\u0131zda lojistik regresyon modelinin \u00f6zeti g\u00f6r\u00fcnt\u00fclenecektir:<\/span> <\/p>\n Sonu\u00e7taki katsay\u0131lar, draft edilme ihtimalindeki g\u00fcnl\u00fck ortalama de\u011fi\u015fimi g\u00f6sterir.<\/span><\/p>\n \u00d6rne\u011fin, bir puanl\u0131k<\/b> birimlik art\u0131\u015f, draft edilme ihtimalinde ortalama 0,212’lik<\/b> bir art\u0131\u015fla ili\u015fkilidir.<\/span><\/p>\n Katsay\u0131lar\u0131n \u00fczerindeki i\u015faret bize her yorday\u0131c\u0131 de\u011fi\u015fken ile yan\u0131t de\u011fi\u015fkeni aras\u0131nda pozitif veya negatif bir ili\u015fki olup olmad\u0131\u011f\u0131n\u0131 s\u00f6yler.<\/span><\/p>\n \u00d6rne\u011fin, puanlar\u0131n katsay\u0131s\u0131 pozitif bir i\u015farete sahip oldu\u011fundan, bu, puanlar\u0131n de\u011ferinin artt\u0131r\u0131lmas\u0131n\u0131n bir oyuncunun draft edilme \u015fans\u0131n\u0131 artt\u0131rd\u0131\u011f\u0131 anlam\u0131na gelir (asistlerin sabit kald\u0131\u011f\u0131 varsay\u0131larak).<\/span><\/p>\n Tersine, asistlerin katsay\u0131s\u0131 negatif bir i\u015farete sahip oldu\u011fundan, bu, asistlerin de\u011ferinin artt\u0131r\u0131lmas\u0131n\u0131n bir oyuncunun draft edilme \u015fans\u0131n\u0131 azaltt\u0131\u011f\u0131 anlam\u0131na gelir (puanlar\u0131n sabit kald\u0131\u011f\u0131 varsay\u0131larak).<\/span><\/p>\n Sonu\u00e7taki p de\u011ferleri ayn\u0131 zamanda her bir yorday\u0131c\u0131 de\u011fi\u015fkenin taslak olas\u0131l\u0131\u011f\u0131n\u0131 tahmin etmede ne kadar etkili oldu\u011funa dair bize bir fikir veriyor:<\/span><\/p>\n Puanlar\u0131n p de\u011feri 0,05’ten k\u00fc\u00e7\u00fck oldu\u011fu i\u00e7in istatistiksel olarak anlaml\u0131 bir yorday\u0131c\u0131 de\u011fi\u015fken gibi g\u00f6r\u00fcnd\u00fc\u011f\u00fcn\u00fc, ancak asistlerin p de\u011feri 0,05’ten k\u00fc\u00e7\u00fck olmad\u0131\u011f\u0131 i\u00e7in istatistiksel olarak anlaml\u0131 g\u00f6r\u00fcnmedi\u011fini g\u00f6rebiliyoruz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar’da di\u011fer yayg\u0131n g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Google E-Tablolar’da polinom regresyonu nas\u0131l ger\u00e7ekle\u015ftirilir?<\/a> Lojistik regresyon, yan\u0131t de\u011fi\u015fkeni ikili oldu\u011funda bir regresyon modeline uymak i\u00e7in kullanabilece\u011fimiz bir y\u00f6ntemdir. A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, Google E-Tablolar’da lojistik regresyonun nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir. Ad\u0131m 1: XLMiner Analiz Ara\u00e7 Paketini y\u00fckleyin Google E-Tablolar’da lojistik regresyon ger\u00e7ekle\u015ftirmek i\u00e7in \u00f6ncelikle \u00fccretsiz XLMiner Analiz Ara\u00e7 Paketi’ni y\u00fcklememiz gerekiyor. Bunu yapmak i\u00e7in Eklentiler > Eklentileri Al’a t\u0131klay\u0131n: Daha […]<\/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-3622","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n Ad\u0131m 1: XLMiner Analiz Ara\u00e7 Paketini y\u00fckleyin<\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles0.png\")
<\/p>\n![\"XLMiner](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles1.png\")
<\/p>\n![\"Google](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles2.png\")
<\/p>\n 2. Ad\u0131m: Verileri girin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/journal1.jpg\")
<\/p>\n 3. Ad\u0131m: Lojistik regresyon ger\u00e7ekle\u015ftirin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/journal2.jpg\")
<\/p>\n![\"Google](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/journal3.jpg\")
<\/p>\n![\"Google](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/journal4.jpg\")
<\/p>\n\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
Google E-Tablolarda do\u011frusal regresyon nas\u0131l ger\u00e7ekle\u015ftirilir?<\/a>
Google E-Tablolarda R-kare nas\u0131l hesaplan\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"