\u0130statistiksel analizlerde s\u0131kl\u0131kla ba\u015fvurulan y\u00f6ntemlerden biri, t da\u011f\u0131l\u0131m\u0131n\u0131 kullanarak yap\u0131lan testlerdir. Excel ve Google E-Tablolar, t-testleri i\u00e7in bir dizi i\u015flev sunar. Bu i\u015flevlerden biri de \u00d6rne\u011fin, bir \u00fcniversite s\u0131n\u0131f\u0131n\u0131n final notlar\u0131 \u00fczerine yap\u0131lan bir hipotez testinde kullan\u0131labilir. Diyelim ki, bir \u00f6\u011frencinin final notu ortalamas\u0131 ile ilgili bir iddia test edilmektedir ve bu iddia, notlar\u0131n belirli bir de\u011ferden farkl\u0131 oldu\u011funu \u00f6ne s\u00fcrmektedir.<\/p>\n Bir \u00f6\u011fretmen, s\u0131n\u0131f\u0131n final notlar\u0131n\u0131n ortalaman\u0131n \u00fcst\u00fcnde oldu\u011funu iddia ediyor. Ortalama 70 ve standart sapma 10 olan bir da\u011f\u0131l\u0131m i\u00e7in, \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc 30 olan bir s\u0131n\u0131f\u0131n ortalamas\u0131n\u0131n 73 olup olmad\u0131\u011f\u0131n\u0131 test edelim.<\/p>\n Excel veya Google E-Tablolar\u2019da Bu \u00f6rnek, t-testinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ve t da\u011f\u0131l\u0131m\u0131n\u0131n sa\u011f kuyru\u011funun nas\u0131l de\u011ferlendirilece\u011fini g\u00f6stermektedir. Elde edilen p-de\u011fer, hipotezin reddedilip reddedilmeyece\u011fine karar vermek i\u00e7in kullan\u0131l\u0131r.<\/p>\n Bir \u00fcretim hatt\u0131ndan \u00e7\u0131kan \u00fcr\u00fcnlerin a\u011f\u0131rl\u0131klar\u0131 belirli bir standart\u0131 kar\u015f\u0131lamal\u0131d\u0131r. \u00d6rneklem alarak, \u00fcr\u00fcnlerin a\u011f\u0131rl\u0131\u011f\u0131n\u0131n belirtilen standarttan d\u00fc\u015f\u00fck olmad\u0131\u011f\u0131n\u0131 do\u011frulamam\u0131z gerekiyor.<\/p>\n Bu t-testi, \u00fcretim s\u00fcrecinin kontroll\u00fc olup olmad\u0131\u011f\u0131n\u0131 anlamam\u0131za yard\u0131mc\u0131 olur ve kalite kontrol s\u00fcre\u00e7lerine \u00f6nemli katk\u0131lar sa\u011flar.<\/p>\n Bu t\u00fcr i\u015flevler, bilimsel ara\u015ft\u0131rmalardan sosyal bilimlere, m\u00fchendislikten ekonomiye geni\u015f bir yelpazede kullan\u0131l\u0131r ve verilerin anlaml\u0131l\u0131\u011f\u0131n\u0131 test etmek i\u00e7in vazge\u00e7ilmez ara\u00e7lard\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":" Student t da\u011f\u0131l\u0131m\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15676","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nT.DIST.RT<\/code> veya T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 ile T.DA\u011e.SA\u011eK<\/code>‘d\u0131r. Bu i\u015flev, tek \u00f6rnekli t-testin bir \u00e7e\u015fidi olan sa\u011f taraf testi i\u00e7in kullan\u0131l\u0131r.<\/p>\n\u0130\u015flevin Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n
T.DIST.RT<\/code> i\u015flevi, belirlenen t de\u011feri ve serbestlik derecesine g\u00f6re, t da\u011f\u0131l\u0131m\u0131n\u0131n sa\u011f kuyru\u011fundaki alan\u0131 hesaplar. Yani, t istatisti\u011fi de\u011ferinin veya daha b\u00fcy\u00fck de\u011ferlerin rastgele olas\u0131l\u0131\u011f\u0131n\u0131 verir.<\/p>\n
Syntax: Excel: T.DIST.RT(x, serbestlik_derecesi) Google E-Tablolar: T.DIST.RT(x, serbestlik_derecesi) <\/code> <\/pre>\n\n
x<\/code>: t istatisti\u011finin de\u011feridir. Pozitif ya da negatif bir say\u0131 olabilir.<\/li>\nserbestlik_derecesi<\/code>: Deneyin serbestlik derecesidir. Say\u0131sal bir de\u011ferdir ve s\u0131f\u0131rdan b\u00fcy\u00fck olmal\u0131d\u0131r.<\/li>\n<\/ul>\nPratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
\u00d6rnek 1: \u00d6\u011frenci Notlar\u0131 \u00dczerine Hipotez Testi<\/h3>\n
Hesaplama: t = (Xbar - Mu) \/ (S\/sqrt(n)) = (73 - 70) \/ (10\/sqrt(30)) = 1.643 <\/code> <\/pre>\n\n
T.DIST.RT<\/code> i\u015flevini kullanarak p-de\u011ferini hesaplayabiliriz:<\/p>\n
Excel'de: =T.DIST.RT(1.643, 29) Google E-Tablolar\u2019da: =T.DIST.RT(1.643, 29) <\/code> <\/pre>\n\u00d6rnek 2: \u00dcr\u00fcn A\u011f\u0131rl\u0131klar\u0131 \u00dczerine Kalite Kontrol<\/h3>\n
Hesaplama: t = (Xbar - Mu) \/ (S\/sqrt(n)) = (Xbar - Belirlenen A\u011f\u0131rl\u0131k) \/ (Standard Sapma \/ sqrt(\u00d6rneklem B\u00fcy\u00fckl\u00fc\u011f\u00fc)) <\/code> <\/pre>\n