Microsoft Excel ve Google E-Tablolar, veri analizi ve hesaplama i\u015flemleri i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lar sunmaktad\u0131r. Bu ara\u00e7lardaki fonksiyonlardan biri de HYPGEOM.DIST (H\u0130PERGEOM.DA\u011e) i\u015flevi olup, istatistiksel analizlerde \u00f6nemli bir yere sahiptir. Hipergeometrik da\u011f\u0131l\u0131m, bir n\u00fcfus i\u00e7inde belirli bir \u00f6zelli\u011fe sahip \u00f6gelerin, rastgele se\u00e7ilen \u00f6rnekler \u00fczerindeki da\u011f\u0131l\u0131m\u0131n\u0131 modellemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n
Bir \u00fcretim hatt\u0131ndan rastgele se\u00e7ilen 15 \u00fcr\u00fcn \u00fczerinde yap\u0131lan kalite kontrol testinde, 4 \u00fcr\u00fcn kusurlu \u00e7\u0131km\u0131\u015ft\u0131r. \u00dcretim hatt\u0131 genelinde bu kusurlu \u00fcr\u00fcn oran\u0131n\u0131n etkisini de\u011ferlendirmek i\u00e7in H\u0130PERGEOM.DA\u011e i\u015flevini kullanabiliriz.<\/p>\n Burada Bir \u015fehirde yap\u0131lan bir anket sonucunda, 100 ki\u015filik bir \u00f6rneklem i\u00e7inden 30 ki\u015fi yeni bir yasay\u0131 destekledi\u011fini belirtmi\u015ftir. \u015eehir genelinde 1000 ki\u015fi aras\u0131nda 450 ki\u015finin bu yasay\u0131 destekledi\u011fini varsayarsak, \u00f6rneklemin bu oran\u0131 temsil etme olas\u0131l\u0131\u011f\u0131n\u0131 H\u0130PERGEOM.DA\u011e ile hesaplayabiliriz.<\/p>\n Bu form\u00fcl, se\u00e7ilen 100 ki\u015filik \u00f6rneklem i\u00e7inde tam olarak 30 ki\u015finin yasay\u0131 destekleme olas\u0131l\u0131\u011f\u0131n\u0131 verecektir.<\/p>\n H\u0130PERGEOM.DA\u011e i\u015flevi, \u00f6zellikle kalite kontrol, se\u00e7im tahminleri, anket sonu\u00e7lar\u0131 gibi alanlarda olduk\u00e7a faydal\u0131d\u0131r. K\u00fcm\u00fclatif de\u011ferin TRUE olarak ayarlanmas\u0131 durumunda, en fazla ‘sample_s’ ba\u015far\u0131s\u0131na kadar olan toplam olas\u0131l\u0131\u011f\u0131 hesaplar, FALSE ayar\u0131 ise belirli bir say\u0131da ba\u015far\u0131 olas\u0131l\u0131\u011f\u0131n\u0131 verir.<\/p>\n","protected":false},"excerpt":{"rendered":" Hipergeometrik da\u011f\u0131l\u0131m\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-15452","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nHYPGEOM.DIST(sample_s, number_sample, number_success_population, population, cumulative)<\/code> fonksiyonu be\u015f parametre al\u0131r:<\/p>\n\n
\u00d6rnek Kullan\u0131m: Excel'de:
=HYPGEOM.DIST(2, 5, 7, 30, FALSE)<\/code> Google E-Tablolar'da: =HYPGEOM.DIST(2, 5, 7, 30, FALSE)<\/code> <\/pre>\nPratik Uygulamalar<\/h2>\n
\u00d6rnek 1: Kalite Kontrol<\/h3>\n
Kullan\u0131lacak Form\u00fcl:
=HYPGEOM.DIST(4, 15, number_success_population, population, TRUE)<\/code> <\/pre>\nnumber_success_population<\/code> ve population<\/code> de\u011fi\u015fkenleri, \u00fcretim hatt\u0131ndaki toplam kusurlu ve \u00fcr\u00fcn say\u0131s\u0131na g\u00f6re ayarlanmal\u0131d\u0131r.<\/p>\n\u00d6rnek 2: Anket Sonu\u00e7lar\u0131 De\u011ferlendirmesi<\/h3>\n
Kullan\u0131lacak Form\u00fcl:
=HYPGEOM.DIST(30, 100, 450, 1000, FALSE)<\/code> <\/pre>\nYorumlar ve \u0130pu\u00e7lar\u0131<\/h2>\n