{"id":3400,"date":"2023-07-17T16:50:56","date_gmt":"2023-07-17T16:50:56","guid":{"rendered":"https:\/\/statorials.org\/tr\/aylik-ortalama-google-e-tablolari\/"},"modified":"2023-07-17T16:50:56","modified_gmt":"2023-07-17T16:50:56","slug":"aylik-ortalama-google-e-tablolari","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/aylik-ortalama-google-e-tablolari\/","title":{"rendered":"Google e-tablolar'da ayl\u0131k ortalama nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"

<\/p>\n

\n

\u00c7o\u011fu zaman Google E-Tablolar’da aya g\u00f6re grupland\u0131r\u0131lm\u0131\u015f ortalama de\u011feri hesaplamak isteyebilirsiniz.<\/span><\/p>\n

\u00d6rne\u011fin, a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu ve aya g\u00f6re grupland\u0131r\u0131lm\u0131\u015f ortalama g\u00fcnl\u00fck sat\u0131\u015flar\u0131 hesaplamak istedi\u011fimizi varsayal\u0131m:<\/span> <\/p>\n

\"\"<\/p>\n

A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnekte bunun nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n

1. Ad\u0131m: Verileri girin<\/strong><\/span><\/h2>\n

\u00d6ncelikle veri de\u011ferlerini Google E-Tablolar’a girin:<\/span> <\/p>\n

\"\"<\/p>\n

2. Ad\u0131m: Aylar\u0131 tarihlerden \u00e7\u0131kar\u0131n<\/strong><\/span><\/h2>\n

Daha sonra, her tarihten ay\u0131 \u00e7\u0131karmak i\u00e7in =MONTH()<\/strong> fonksiyonunu kullanmam\u0131z gerekiyor.<\/span><\/p>\n

\u00d6rne\u011fimizde D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazaca\u011f\u0131z:<\/span><\/p>\n

 =MONTH( A2<\/span> )\n<\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc D s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyip dolduraca\u011f\u0131z:<\/span> <\/p>\n
\"\"<\/p>\n
 3. Ad\u0131m: Benzersiz aylar\u0131 bulun<\/strong><\/span><\/h2>\n
 Daha sonra, benzersiz aylar\u0131n bir listesini olu\u015fturmak i\u00e7in =UNIQUE()<\/strong> i\u015flevini kullanmam\u0131z gerekir.<\/span><\/p>\n
 \u00d6rne\u011fimizde F2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazaca\u011f\u0131z:<\/span><\/p>\n
 =SINGLE( D2:D10<\/span> )\n<\/strong><\/pre>\n
 Bu, benzersiz aylar\u0131n bir listesini \u00fcretecektir:<\/span> <\/p>\n
\"\"<\/p>\n
 4. Ad\u0131m: Ayl\u0131k ortalamay\u0131 hesaplay\u0131n<\/strong><\/span><\/h2>\n
 Daha sonra, aya g\u00f6re grupland\u0131r\u0131lm\u0131\u015f g\u00fcnl\u00fck sat\u0131\u015f de\u011ferlerinin ortalamas\u0131n\u0131 bulmak i\u00e7in ORTALAMA(aral\u0131k, \u00f6l\u00e7\u00fct, ortalama_aral\u0131k)<\/strong> fonksiyonunu kullanaca\u011f\u0131z.<\/span><\/p>\n
 \u00d6rne\u011fimizde G2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazaca\u011f\u0131z:<\/span><\/p>\n
 =AVERAGEIF( $D$2:$D$10<\/span> , F2<\/span> , $B$2:$B$10<\/span> )\n<\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc G s\u00fctunundaki kalan h\u00fccrelere s\u00fcr\u00fckleyip dolduraca\u011f\u0131z:<\/span> <\/p>\n
\"Ayl\u0131k<\/p>\n
 Bu bize \u015funu s\u00f6yl\u00fcyor:<\/span><\/p>\n