Neyse ki, Google E-Tablolar’\u0131n yerle\u015fik i\u015flevleri sayesinde bunu yapmak kolayd\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, pratikte Google E-Tablolar’da bir \u00f6zet tablosunun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n \u00d6ncelikle bir firman\u0131n \u00fcr\u00fcn sat\u0131\u015flar\u0131na ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri setini girece\u011fiz:<\/span> <\/p>\n Daha sonra, B s\u00fctunundaki benzersiz \u00fcr\u00fcn adlar\u0131n\u0131 tan\u0131mlamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanaca\u011f\u0131z:<\/span><\/p>\n Bu form\u00fcl\u00fc A17<\/b> h\u00fccresine yazabiliriz:<\/span> <\/p>\n Bu form\u00fcl\u00fcn B s\u00fctunundan \u00fc\u00e7 benzersiz \u00fcr\u00fcn ad\u0131n\u0131 \u00e7\u0131karabildi\u011fini g\u00f6rebiliriz.<\/span><\/p>\n Daha sonra a\u015fa\u011f\u0131daki form\u00fclleri kullanarak sat\u0131lan toplam adetleri, sat\u0131lan ortalama adetleri ve her bir \u00fcr\u00fcn i\u00e7in toplam geliri hesaplayabiliriz:<\/span><\/p>\n Sat\u0131lan toplam birim say\u0131s\u0131:<\/strong><\/span><\/p>\n Ortalama sat\u0131lan birim say\u0131s\u0131:<\/strong><\/span><\/p>\n Toplam gelir:<\/strong><\/span><\/p>\n Bu form\u00fclleri s\u0131ras\u0131yla B17<\/strong> , C17<\/strong> ve D17<\/strong> h\u00fccrelerine yazabiliriz:<\/span> <\/p>\n Art\u0131k orijinal veri k\u00fcmemizdeki \u00fc\u00e7 \u00fcr\u00fcn\u00fcn her biri i\u00e7in sat\u0131lan toplam birimleri, sat\u0131lan ortalama birimleri ve toplam geliri g\u00f6steren bir \u00f6zet tablomuz var.<\/span><\/p>\n Son olarak, \u00f6zet tablosunun her h\u00fccresinin etraf\u0131na kenarl\u0131k eklemekten ve \u00f6zet tablosunu daha estetik hale getirmek i\u00e7in arka plan renkleri eklemekten \u00e7ekinmeyin:<\/span> <\/p>\n \u00d6zet tablosunun okunmas\u0131 art\u0131k daha da kolay.<\/span><\/p>\n Not<\/strong> : \u00d6zet tablomuzda ortalama de\u011ferleri ve toplam de\u011ferleri hesaplamay\u0131 se\u00e7iyoruz, ancak minimum, maksimum, medyan, aral\u0131k ve di\u011fer metrikler gibi di\u011fer ilgi \u00e7ekici de\u011ferleri de hesaplamaktan \u00e7ekinmeyin.<\/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 be\u015f basamakl\u0131 bir \u00f6zet nas\u0131l hesaplan\u0131r?<\/a> \u00c7o\u011fu zaman bir veri k\u00fcmesindeki de\u011ferleri \u00f6zetlemek i\u00e7in Google E-Tablolar’da bir \u00f6zet tablosu olu\u015fturmak isteyebilirsiniz. Neyse ki, Google E-Tablolar’\u0131n yerle\u015fik i\u015flevleri sayesinde bunu yapmak kolayd\u0131r. A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, pratikte Google E-Tablolar’da bir \u00f6zet tablosunun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir. 1. Ad\u0131m: Veri k\u00fcmesi i\u00e7in de\u011ferleri girin \u00d6ncelikle bir firman\u0131n \u00fcr\u00fcn sat\u0131\u015flar\u0131na ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri […]<\/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-4650","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n 1. Ad\u0131m: Veri k\u00fcmesi i\u00e7in de\u011ferleri girin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommetable1.png\")
<\/p>\n Ad\u0131m 2: Benzersiz De\u011ferleri Bulun<\/strong><\/span><\/h2>\n
=SINGLE( B2:B13<\/span> )\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommetable2.png\")
<\/p>\n 3. Ad\u0131m: Her de\u011fi\u015fken i\u00e7in \u00f6zet istatistikleri hesaplay\u0131n<\/strong><\/span><\/h2>\n
=SUMIF( $B$2:$B$13<\/span> , A17<\/span> , $C$2:$C$13<\/span> )<\/strong><\/pre>\n =AVERAGEIF( $B$2:$B$13<\/span> , A17<\/span> , $C$2:$C$13<\/span> )<\/strong><\/pre>\n =SUMIF( $B$2:$B$13<\/span> , A17<\/span> , $D$2:$D$13<\/span> )<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/somme3-3.png\")
<\/p>\n 4. Ad\u0131m: \u00d6zet tablosunu bi\u00e7imlendirin (iste\u011fe ba\u011fl\u0131)<\/strong><\/span><\/h2>\n
![\"Google](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/somme4.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Google E-Tablolar’da gruba g\u00f6re ortalama nas\u0131l hesaplan\u0131r?<\/a>
Google E-Tablolar’da SUMIF i\u00e7eri\u011fi nas\u0131l kullan\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"