İstatistik Alıştırmaları 4

WEBVTT 00:00:00.189 --> 00:00:00.969 Hallo Freunde. 00:00:01.008 --> 00:00:06.691 In diesem Teil unseres Videos werden wir den Teil nach dem 4. Teil unserer statistischen Anpassungen behandeln. 00:00:07.352 --> 00:00:08.972 Wenn ihr bereit seid, lasst uns gehen. 00:00:08.972 --> 00:00:15.735 In Schritt 12 sagte er, dass wir die im Diagramm versteckten Zeilen 21, 22 und 23 wieder sichtbar machen sollen. 00:00:15.775 --> 00:00:17.055 Lass uns gleich mal sehen. 00:00:17.755 --> 00:00:25.278 Wie ihr sehen könnt, wenn wir hier schauen, werden wir feststellen, dass die Zeilen von 20 bis 24 nicht angezeigt werden. 00:00:25.758 --> 00:00:29.840 Hier müssen wir beide gleichzeitig auswählen und 20 bis 24 auswählen. 00:00:29.900 --> 00:00:31.401 Weil die dazwischen nicht sichtbar sind. 00:00:31.761 --> 00:00:34.362 Es wird sein, rechtsklicken und die Option "Anzeigen" auswählen. 00:00:35.203 --> 00:00:37.804 Wie ihr sehen könnt, wird es so sichtbar gemacht. 00:00:38.484 --> 00:00:44.547 Wenn ihr sie wieder ausblenden möchtet, könnt ihr die Zeilen auswählen, die ihr ausblenden möchtet, und auf "Ausblenden" klicken. 00:00:44.887 --> 00:00:50.690 Auf diese Weise könnt ihr weiterhin die Optionen zum Ausblenden und Anzeigen nach Belieben verwenden. 00:00:50.710 --> 00:00:53.931 Diese Optionen sind auch für Spalten verfügbar. 00:00:53.971 --> 00:00:56.873 Ich kann sagen, dass ich die ausgewählten hier ausblenden möchte. 00:00:57.533 --> 00:01:04.837 Dann, wenn ich wieder beide auswähle und auf "Anzeigen" klicke, werden die ausgeblendeten zurückkommen. 00:01:05.618 --> 00:01:08.179 Ich wollte euch diesen Schritt mitteilen. 00:01:08.399 --> 00:01:09.300 Sehr wichtig. 00:01:09.700 --> 00:01:13.302 Eine der häufig verwendeten Funktionen von Microsoft Excel. 00:01:15.472 --> 00:01:17.012 Lass uns nun die nächsten Schritte betrachten. 00:01:17.012 --> 00:01:22.354 Der 13. Schritt verlangt, dass wir den Durchschnittstext in Zelle C21 eingeben. 00:01:22.794 --> 00:01:24.455 Hier ist unsere Zelle C21. 00:01:24.635 --> 00:01:25.735 Lass uns hier den Durchschnitt eingeben. 00:01:27.235 --> 00:01:28.156 Durchschnitt eingegeben. 00:01:29.376 --> 00:01:39.899 Als nächstes müssen wir eine Formel in Zelle D21 eingeben, die den Durchschnitt des Zellbereichs D4-D15 berechnet. 00:01:41.962 --> 00:01:44.322 Lass uns auf Zelle D21 klicken. 00:01:45.264 --> 00:01:57.613 Hier müssen wir den Durchschnitt des Bereichs zwischen D4 und D15 in unsere Zelle D21 eingeben. 00:01:57.633 --> 00:02:00.675 Deshalb habe ich erneut auf Durchschnitt in den Funktionen geklickt. 00:02:02.196 --> 00:02:10.326 Es wurde automatisch ein Bereich für den Durchschnitt ausgewählt, aber ich möchte nur den Bereich von D4 bis D15 auswählen. 00:02:11.127 --> 00:02:18.956 Wie Sie sehen können, habe ich den gewünschten Bereich ausgewählt und den Durchschnitt berechnet. 00:02:20.931 --> 00:02:22.393 Das haben wir erfolgreich erledigt. 00:02:23.494 --> 00:02:37.485 Unser nächster Schritt ist es, den Maximalwert in Zelle C22 einzugeben und dann in Zelle D22 eine Formel einzugeben, die den höchsten Nettoumsatz im Bereich D4-D15 liefert. 00:02:38.466 --> 00:02:40.467 Hier gehe ich wieder zu C22. 00:02:41.388 --> 00:02:41.788 Hier ist C22. 00:02:42.369 --> 00:02:44.010 Hier muss ich Maximum eingeben. 00:02:45.951 --> 00:02:46.712 Wie Sie sehen können. 00:02:48.411 --> 00:02:56.335 Nachdem wir das Maximum eingegeben haben, habe ich erneut auf die größte Zahl in Zelle D23 geklickt. 00:02:56.535 --> 00:03:01.958 Wie Sie sehen können, wenn Sie auf den Pfeil direkt neben dem automatischen Gesamtwert klicken, werden Ihnen einige Optionen angezeigt. 00:03:02.618 --> 00:03:04.619 Ich habe den maximalen Wert ausgewählt. 00:03:05.139 --> 00:03:11.004 Dann habe ich diesen Bereich erneut auf D4-D15 festgelegt und ausgewählt. 00:03:11.624 --> 00:03:21.452 Dieser Vorgang findet das höchste Zahl in diesem Bereich und schreibt es hier, ich denke, das ist der Wert für den Monat März. 00:03:22.272 --> 00:03:25.335 Das war unser höchster Wert zwischen den Monaten. 00:03:26.256 --> 00:03:28.077 Wir haben das erfolgreich erledigt. 00:03:28.477 --> 00:03:30.559 Unser nächster Schritt ist das Minimum in C23. 00:03:30.579 --> 00:03:33.821 Diesmal wurde uns gesagt, das kleinste zu finden. 00:03:33.881 --> 00:03:34.462 Hier das Minimum. 00:03:35.615 --> 00:03:36.135 Ich schreibe es. 00:03:37.135 --> 00:03:37.535 Geschrieben. 00:03:38.015 --> 00:03:43.136 Dann klicken wir erneut hier und möchten dieses Mal das kleinste Minimum aus dem automatischen Gesamtwert finden. 00:03:43.536 --> 00:03:44.537 Ich habe das kleinste ausgewählt. 00:03:45.117 --> 00:03:47.317 Dann habe ich den ausgewählten Bereich festgelegt. 00:03:48.097 --> 00:03:48.857 Enter gedrückt. 00:03:49.717 --> 00:03:53.818 Diesmal haben wir eine Zahl von 34.283 gefunden. 00:03:53.858 --> 00:03:56.759 Das ist der Umsatz für den Monat April. 00:03:57.479 --> 00:04:04.300 Das bedeutet, dass der höchste Umsatz im März und der niedrigste Umsatz im April erzielt wurde. 00:04:06.309 --> 00:04:12.354 Auf diese Weise haben wir unseren vierten und letzten Schritt sowie unseren fünften und letzten Schritt abgeschlossen. 00:04:12.734 --> 00:04:18.519 Im nächsten Video werden wir den letzten Teil, also den fünften Teil, behandeln und unsere Gewohnheiten abschließen. 00:04:19.200 --> 00:04:22.002 Bis zum nächsten Video, ich wünsche Ihnen alles Gute.

WEBVTT 00:00:00.189 --> 00:00:00.969 Hello friends. 00:00:01.008 --> 00:00:06.691 In this part of our video, we will discuss the section after the 4th part of our statistical adjustments. 00:00:07.352 --> 00:00:08.972 If you are ready, let's take a look. 00:00:08.972 --> 00:00:15.735 In step 12, it says to make visible the hidden rows 21, 22, and 23 in the table. 00:00:15.775 --> 00:00:17.055 Let's take a look right here. 00:00:17.755 --> 00:00:25.278 As you can see, when we look here, we will notice that rows between 20 and 24 are not visible. 00:00:25.758 --> 00:00:29.840 What we need to do here is to select both and say 20 to 24. 00:00:29.900 --> 00:00:31.401 Because the ones in between are not visible. 00:00:31.761 --> 00:00:34.362 It will be to right-click and select the show option. 00:00:35.203 --> 00:00:37.804 As you can see, it will appear like this. 00:00:38.484 --> 00:00:44.547 If you want to hide them again, you can select the rows you want to hide and say hide. 00:00:44.887 --> 00:00:50.690 In this way, you can use the options to hide and show as you wish. 00:00:50.710 --> 00:00:53.931 Again, these options are within the columns. 00:00:53.971 --> 00:00:56.873 I can say Hide for the ones I selected here. 00:00:57.533 --> 00:01:04.837 Then, when I select these two again and say show, the hidden ones will come back. 00:01:05.618 --> 00:01:08.179 I wanted to explain this step to you. 00:01:08.399 --> 00:01:09.300 It's quite important. 00:01:09.700 --> 00:01:13.302 One of the most commonly used features of Microsoft Excel. 00:01:15.472 --> 00:01:17.012 Let's look at the next steps here. 00:01:17.012 --> 00:01:22.354 Our 13th step is to enter the average text into cell C21. 00:01:22.794 --> 00:01:24.455 Our cell C21 is here. 00:01:24.635 --> 00:01:25.735 Let's write the average here. 00:01:27.235 --> 00:01:28.156 We wrote the average. 00:01:29.376 --> 00:01:39.899 Next, what we need to do is enter a formula in cell D21 that calculates the average of the range D4-D15. 00:01:41.962 --> 00:01:44.322 Let's click on cell D21. 00:01:45.264 --> 00:01:57.613 What we need to do here is to enter the average of the range between D4 and D15 into our cell D21. 00:01:57.633 --> 00:02:00.675 So, I clicked on Average again from the functions. 00:02:02.196 --> 00:02:10.326 It automatically brought a selected range for average, but I only want to select the range between D4 and D15. 00:02:11.127 --> 00:02:18.956 As you can see, I have selected the range as I wanted and found the average. 00:02:20.931 --> 00:02:22.393 We have successfully completed this. 00:02:23.494 --> 00:02:37.485 Our next step is to enter the Maximum text into cell C22, and then we need to enter a formula in cell D22 that gives the highest net revenue of the D4-D15 cell range this time. 00:02:38.466 --> 00:02:40.467 I'm going to C22 again. 00:02:41.388 --> 00:02:41.788 Here is C22. 00:02:42.369 --> 00:02:44.010 What I need to write here is Maximum. 00:02:45.951 --> 00:02:46.712 As you can see. 00:02:48.411 --> 00:02:56.335 After entering the maximum, I clicked on cell D23 again to find the largest value. 00:02:56.535 --> 00:03:01.958 As you can see, when you click on the arrow right next to the automatic sum, it gives you a few options. 00:03:02.618 --> 00:03:04.619 I chose the maximum value. 00:03:05.139 --> 00:03:11.004 Then I determined and selected the range between D4-D15. 00:03:11.624 --> 00:03:21.452 This process finds the highest number in this selection and writes it here, I think this is the value for the month of March. 00:03:22.272 --> 00:03:25.335 This was our highest value among the months. 00:03:26.256 --> 00:03:28.077 We have successfully completed this. 00:03:28.477 --> 00:03:30.559 Our next step is to find the minimum in C23. 00:03:30.579 --> 00:03:33.821 This time we were asked to find the smallest. 00:03:33.881 --> 00:03:34.462 Minimum here. 00:03:35.615 --> 00:03:36.135 I'm writing. 00:03:37.135 --> 00:03:37.535 Written. 00:03:38.015 --> 00:03:43.136 Then I click here again and this time we want to find the smallest from the Automatic Sum. 00:03:43.536 --> 00:03:44.537 I clicked on the smallest. 00:03:45.117 --> 00:03:47.317 Then I determined the range I selected. 00:03:48.097 --> 00:03:48.857 I pressed Enter. 00:03:49.717 --> 00:03:53.818 This time it found a number, 34.283. 00:03:53.858 --> 00:03:56.759 This is the Revenue for the month of April. 00:03:57.479 --> 00:04:04.300 This means the highest sales were in March and the lowest sales were in April. 00:04:06.309 --> 00:04:12.354 In this way, we have completed our fourth and final step, our fifth and final step as well. 00:04:12.734 --> 00:04:18.519 In the next video, we will cover the last part, the fifth part, and conclude our unusualness. 00:04:19.200 --> 00:04:22.002 I wish you all the best until the next video.

WEBVTT 00:00:00.189 --> 00:00:00.969 Merhaba arkadaşlar. 00:00:01.008 --> 00:00:06.691 Videomuzun bu kısmında istatistik alışımalarımızın 4. kısmından sonraki kısmını ele alacağız. 00:00:07.352 --> 00:00:08.972 Hazırsanız gelin bakalım. 00:00:08.972 --> 00:00:15.735 12. adımımızda tablo içerisinde gizlenmiş 21. 22. 23. satırları tekrar görünür kılın demiş. 00:00:15.775 --> 00:00:17.055 Hemen buradan bir bakalım. 00:00:17.755 --> 00:00:25.278 Gördüğünüz üzere hemen buradan baktığımızda satırlarımızdan 24 arasındakilerin gözükmediğini fark edeceğiz. 00:00:25.758 --> 00:00:29.840 Burada yapmamız gereken ikisini aynı anda seçip 20 ile 24 diyor. 00:00:29.900 --> 00:00:31.401 Çünkü aradakiler gözükmüyor. 00:00:31.761 --> 00:00:34.362 Sağa tıklayıp göster seçeneğini tıklamak olacak. 00:00:35.203 --> 00:00:37.804 Gördüğünüz üzere bu şekilde görünür kılık. 00:00:38.484 --> 00:00:44.547 Eğer yine saklamak isterseniz, saklamak istediğiniz satırları seçip gizle diyebilirsiniz. 00:00:44.887 --> 00:00:50.690 Bu şekilde yine istediğiniz şekilde gizleyip göstermeye seçeneklerini kullanabilirsiniz. 00:00:50.710 --> 00:00:53.931 Yine bu seçenekler sütunlar içine geç hali. 00:00:53.971 --> 00:00:56.873 Buradan seçtiklerimi Gizle diyebiliyorum. 00:00:57.533 --> 00:01:04.837 Ardından yine şu ikisini birden seçip göster dediğimde saklananlar geri gelecektir. 00:01:05.618 --> 00:01:08.179 Bu adımızı size ifade etmek istedim. 00:01:08.399 --> 00:01:09.300 Oldukça önemli. 00:01:09.700 --> 00:01:13.302 Microsoft Excel'in çok sık kullanılan özelliklerinden bir tanesi. 00:01:15.472 --> 00:01:17.012 Gelin, burada diğer adımlara bakalım. 00:01:17.012 --> 00:01:22.354 13. adımımız da C21 hücresine ortalama metni girmemiz istenmiş. 00:01:22.794 --> 00:01:24.455 C21 hücremiz burada. 00:01:24.635 --> 00:01:25.735 Buraya ortalama yazalım. 00:01:27.235 --> 00:01:28.156 Ortalama yazdık. 00:01:29.376 --> 00:01:39.899 Ardından yapmamız gereken şey D21 hücresine D4-D15 hücre aralığının ortalamasını hesaplayan bir formül girmek olacak. 00:01:41.962 --> 00:01:44.322 D21 hücresini tıklayalım. 00:01:45.264 --> 00:01:57.613 Burada yapmamız gereken D4 ile D15 arasına kalan aralığın ortalamasını bizim buradaki D21 hücremize girmemiz gerekiyor. 00:01:57.633 --> 00:02:00.675 Bu yüzden yine işlemlerden ortalamaya tıkladım. 00:02:02.196 --> 00:02:10.326 Ortalama seçili bir aralık getirdi kendiliğinden fakat ben burada sadece D4 ile D15 aralığını seçmek istiyorum. 00:02:11.127 --> 00:02:18.956 Gördüğünüz üzere burada istediğim şekilde aralığı belirledim ve ortalamayı bulmuş oldum. 00:02:20.931 --> 00:02:22.393 Bunu başarıyla hallettik. 00:02:23.494 --> 00:02:37.485 Bir sonraki adımız C22 hücresine Maximum metnini ardından D22 hücresine yine D4-D15 hücre adalının bu sefer en yüksek net cirosunu veren bir formül girmemiz gerekiyor. 00:02:38.466 --> 00:02:40.467 Burada yine C22'ye gidiyorum. 00:02:41.388 --> 00:02:41.788 Burada C22. 00:02:42.369 --> 00:02:44.010 Buraya yazmam gereken şey Maximum. 00:02:45.951 --> 00:02:46.712 Gördüğünüz üzere. 00:02:48.411 --> 00:02:56.335 maksimumu girdikten sonra D23 hücreyi yine buradan en büyük değerini tıkladım. 00:02:56.535 --> 00:03:01.958 Gördüğünüz gibi otomatik toplamın hemen yanında kalan oka bastığınızda size bir kaç tane seçenek sunar. 00:03:02.618 --> 00:03:04.619 Ben maksimum değerini seçtim. 00:03:05.139 --> 00:03:11.004 Ardından bu aralığı Yine D4-D15 aralarını belirledim ve seçtim. 00:03:11.624 --> 00:03:21.452 Bu işlem bize bu seçki arasındaki en yüksek sayıyı bulur ve buraya yazar sanıyorum bu mart ayının değeri. 00:03:22.272 --> 00:03:25.335 Bu bizim en yüksek değerimizdi aylar arasındaki. 00:03:26.256 --> 00:03:28.077 Bunu da başarılı bir şekilde hallettik. 00:03:28.477 --> 00:03:30.559 Bir sonraki adımımız C23 üresinde minimum. 00:03:30.579 --> 00:03:33.821 Bu seferde en küçüğünü bulmamızı istemiş. 00:03:33.881 --> 00:03:34.462 Buraya minimum. 00:03:35.615 --> 00:03:36.135 Yazıyorum. 00:03:37.135 --> 00:03:37.535 Yazdım. 00:03:38.015 --> 00:03:43.136 Ardından yine buraya tıklayıp Otomatik Toplam'dan bu sefer en küçücükü minimumu bulmak istiyoruz. 00:03:43.536 --> 00:03:44.537 En küçüğü tıkladım. 00:03:45.117 --> 00:03:47.317 Ardından seçim yaptığım aralığı belirledim. 00:03:48.097 --> 00:03:48.857 Enter'a bastım. 00:03:49.717 --> 00:03:53.818 Bu sefer de 34.283 diye bir sayı buldu. 00:03:53.858 --> 00:03:56.759 Bu da Nisan ayının Ciro'su. 00:03:57.479 --> 00:04:04.300 Bu demektir ki en yüksek satış Mart ayında en düşük satış değine Nisan ayında olmuş. 00:04:06.309 --> 00:04:12.354 Bu şekilde dörüncü ve son adımımızı da, beşinci ve son adımımızı da bitirmiş olduk. 00:04:12.734 --> 00:04:18.519 Bir sonraki videodaysa son kısmı yani beşinci kısmı işleyip alışılmamızı sonlandıracağız. 00:04:19.200 --> 00:04:22.002 Bir sonraki videoda görüşmek üzere, kolaylıklar diliyorum.