Veri analizinde, karar verme s\u00fcre\u00e7lerini desteklemek amac\u0131yla g\u00fcven aral\u0131klar\u0131n\u0131 belirlemek olduk\u00e7a \u00f6nemlidir. Excel ve Google E-Tablolar’da bu i\u015flem G\u00dcVEN\u0130RL\u0130K<\/strong> fonksiyonu kullan\u0131larak kolayl\u0131kla yap\u0131labilir. Bu fonksiyon, belirli bir g\u00fcven d\u00fczeyi i\u00e7in bir ortalaman\u0131n tahmini standart hatas\u0131 temel al\u0131narak hesaplanan g\u00fcven aral\u0131\u011f\u0131n\u0131n yar\u0131s\u0131n\u0131 verir.<\/p>\n G\u00dcVEN\u0130RL\u0130K<\/strong> fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n Diyelim ki bir \u00fcretim band\u0131nda \u00fcretilen \u00fcr\u00fcnlerin a\u011f\u0131rl\u0131klar\u0131 ile ilgili bir \u00f6rneklem al\u0131nd\u0131 ve 50 \u00fcr\u00fcn\u00fcn ortalamas\u0131n\u0131, 0.5 kg standart sapma ile g\u00f6zlemledik. %95 g\u00fcven d\u00fczeye g\u00f6re g\u00fcven aral\u0131\u011f\u0131n\u0131 hesaplamak istiyoruz.<\/p>\n Bu form\u00fcl, se\u00e7ilen g\u00fcven d\u00fczeyi ve verilen di\u011fer de\u011ferlerle \u00fcr\u00fcn a\u011f\u0131rl\u0131\u011f\u0131n\u0131n ortalamas\u0131n\u0131n g\u00fcven aral\u0131\u011f\u0131n\u0131n yar\u0131s\u0131n\u0131 hesaplayacakt\u0131r. \u00c7\u0131kan sonu\u00e7, \u00f6rne\u011fin 0.1 kg gibi bir de\u011fer olabilir. Bu, ortalama de\u011ferin +\/- 0.1 kg i\u00e7inde olaca\u011f\u0131 anlam\u0131na gelir.<\/p>\n Bir market ara\u015ft\u0131rmas\u0131 s\u0131ras\u0131nda, 200 m\u00fc\u015fterinin memnuniyet puanlar\u0131n\u0131 toplay\u0131p, 1.4 olarak hesaplanan standart sapmayla analiz etmek istiyoruz. G\u00fcven d\u00fczeyimiz yine %95 olsun.<\/p>\n Form\u00fcl, memnuniyet puanlar\u0131n\u0131n ortalamas\u0131n\u0131n g\u00fcvenilir bir \u015fekilde nas\u0131l varyasyon g\u00f6sterebilece\u011fini g\u00f6sterir. \u00c7\u0131kan de\u011fer, \u00f6rne\u011fin 0.2 gibi bir de\u011fer \u00e7\u0131kabilir, bu da memnuniyet puanlar\u0131n\u0131n %95 olas\u0131l\u0131kla ortalamadan +\/- 0.2 puan i\u00e7inde olaca\u011f\u0131 anlam\u0131na gelir.<\/p>\n Excel ve Google E-Tablolar\u2019daki G\u00dcVEN\u0130RL\u0130K<\/strong> fonksiyonu, \u00e7e\u015fitli veri setlerinden elde edilen sonu\u00e7lar\u0131n g\u00fcven aral\u0131klar\u0131n\u0131 hesaplamada etkilidir. Bu rehber, \u00f6zellikle veri analizi ve istatistik ile u\u011fra\u015fan her seviyeden kullan\u0131c\u0131n\u0131n, veriler \u00fczerinde daha do\u011fru ve g\u00fcvenilir sonu\u00e7lar \u00e7\u0131karmas\u0131na yard\u0131mc\u0131 olacak bilgiler sunmaktad\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":" Bir pop\u00fclasyon ortalamas\u0131 i\u00e7in g\u00fcvenirlik aral\u0131\u011f\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":[584],"tags":[],"class_list":["post-15319","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nDetayl\u0131 S\u00f6zdizimi A\u00e7\u0131klamas\u0131<\/h2>\n
MS Excel:<\/strong> =CONFIDENCE(alpha, standard_dev, size) Google E-Tablolar:<\/strong> =CONFIDENCE(alpha, standard_dev, size)<\/code><\/pre>\n\n
Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmler<\/h2>\n
G\u00f6rev 1: \u00dcr\u00fcn A\u011f\u0131rl\u0131klar\u0131 \u00dczerinde G\u00fcven Aral\u0131\u011f\u0131 Hesaplama<\/h3>\n
Excel veya Google E-Tablolar'da Form\u00fcl:<\/strong> =CONFIDENCE(0.05, 0.5, 50)<\/code><\/pre>\nG\u00f6rev 2: Anket Sonu\u00e7lar\u0131 \u0130\u00e7in G\u00fcven Aral\u0131\u011f\u0131 Bulma<\/h3>\n
Excel veya Google E-Tablolar'da Form\u00fcl:<\/strong> =CONFIDENCE(0.05, 1.4, 200)<\/code><\/pre>\nSonu\u00e7<\/h2>\n