İstatistik Alıştırmaları 2

WEBVTT 00:00:01.981 --> 00:00:12.808 Im second part, we will look at how we can do statistical exercises from the fifth step onwards. If you are ready, let's start from the fifth step. 00:00:12.988 --> 00:00:25.075 In our fifth step, I did not write a formula that divides cell F4 by cell G4 into cell J19 as requested. I come back here again, I wrote equal to G4 cell, then I wrote F4 cell which is requested from us here, as you can see, I wrote the division sign G19, which is our KRV calculation factor, here, but what is requested from us 00:00:25.095 --> 00:00:41.513 is to fix the KRV calculation factor because it needs to remain constant as we will carry this to the next rows. 00:00:41.573 --> 00:00:49.100 Again, by pressing the F4 key here, I fixed the KRV calculation factor and pressed Enter. 00:00:55.626 --> 00:01:04.041 Here, we calculated our net expense by converting it from gross to net. 00:01:04.181 --> 00:01:07.467 Then I applied this to the other rows. 00:01:08.655 --> 00:01:11.056 As you can see, this was our first step. 00:01:12.356 --> 00:01:18.638 Our next step is to write a formula that multiplies cell F18 by cell G4 into cell H4. 00:01:19.038 --> 00:01:25.060 Again, here we need to calculate the current exchange rate, which is F18. 00:01:25.860 --> 00:01:31.242 Let's see how we can convert the expense from Euro to TL. 00:01:31.302 --> 00:01:31.842 Let's look at that. 00:01:32.639 --> 00:01:34.421 As you can see, I selected Gerord here. 00:01:34.861 --> 00:01:40.066 Ich habe den aktuellen Euro-Wechselkurs von 29,18 ausgewählt. 00:01:40.266 --> 00:01:46.551 Dann habe ich es fixiert, um es auf andere Zeilen anzuwenden, also möchte ich das noch einmal betonen. 00:01:46.932 --> 00:01:47.792 Ich habe F4 gedrückt. 00:01:48.633 --> 00:01:51.015 Und den aktuellen Euro-TL-Kurs fixiert. 00:01:51.255 --> 00:01:51.996 Ich habe Enter gedrückt. 00:01:52.717 --> 00:01:59.663 Wenn ich es von hier aus ziehe, wird es erfolgreich auf andere Zeilen angewendet. 00:01:59.663 --> 00:02:03.102 Wir haben Schritt 6 erfolgreich abgeschlossen. 00:02:03.102 --> 00:02:09.486 In Schritt 7 werden wir eine Formel schreiben, die U4 übersteigt, von H4 abzieht und dann auf den Bereich U5-U15 anwendet. 00:02:10.526 --> 00:02:13.568 Wir werden diese Formel erneut auf den Bereich U5-U15 anwenden. 00:02:14.309 --> 00:02:18.711 Wir haben zuerst ein Gleichheitszeichen für den Gewinn geschrieben. 00:02:20.012 --> 00:02:23.574 Außerdem haben wir den Nettowert von 0 TL geschrieben. 00:02:24.334 --> 00:02:37.717 Durch Auswahl der Nettokostenzelle in der Herald-Zelle in TL und Drücken von Gleichheit haben wir unseren Gewinn in TL erhalten. 00:02:37.737 --> 00:02:45.098 Wenn ich es von hier aus auf andere Monate anwende, sehen wir die Auswirkung unseres Gewinns in anderen Monaten. 00:02:46.699 --> 00:02:50.441 Unsere Arbeiten in diesem Abschnitt wurden erfolgreich abgeschlossen. 00:02:50.781 --> 00:02:53.185 Bis zum nächsten Abschnitt. 00:02:53.325 --> 00:02:54.186 Ich wünsche Ihnen alles Gute.

WEBVTT 00:00:01.981 --> 00:00:12.808 In the second part, we will look at how we can perform statistical exercises from the fifth step onwards. If you are ready, let's start from the fifth step. 00:00:12.988 --> 00:00:25.075 In our fifth step, I have not written a formula that divides cell G4 by cell F4 into cell J19 as requested. I wrote 'equals' to cell G4, then I wrote 'equals' to the value requested from us, which is cell F4. As you can see, I wrote the division sign and then I wrote our KRV calculation factor to cell G19, but what is required from us is to fix the KRV calculation factor because it needs to remain constant as we carry it to the next rows. 00:00:25.095 --> 00:00:41.513 Here, by pressing the F4 key, I fixed the KRV calculation factor and pressed Enter. 00:00:00.500 --> 00:00:54.625 Here, we calculated our net expense by converting it from gross to net. 00:00:55.626 --> 00:01:04.041 Then, I applied this to the other rows. 00:01:04.181 --> 00:01:07.467 As you can see, this was our first step. 00:01:08.655 --> 00:01:11.056 Our next step is to write a formula that multiplies cell F18 by cell G4 into cell H4. 00:01:19.038 --> 00:01:25.060 Here, we need to calculate the current exchange rate, which is cell F18. 00:01:25.860 --> 00:01:31.242 Let's see how we can convert the expense from Euro to TL. 00:01:31.302 --> 00:01:31.842 Let's look into that. 00:01:32.639 --> 00:01:34.421 As you can see, I selected 'Gerordu' here. 00:01:34.861 --> 00:01:40.066 I selected 29.18, which is the current exchange rate for Euro, from here. 00:01:40.266 --> 00:01:46.551 Then, I pressed F4 to fix it, meaning we need to fix it because we will apply this to other rows. 00:01:46.932 --> 00:01:47.792 I pressed Enter. 00:01:48.633 --> 00:01:51.015 And I fixed the current Euro to Turkish Lira exchange rate. 00:01:51.255 --> 00:01:51.996 I pressed Enter. 00:01:52.717 --> 00:01:59.663 When I dragged it from the corner here, it was successfully applied to other rows. 00:01:59.663 --> 00:02:03.102 We have successfully completed our 6th step. 00:02:03.102 --> 00:02:09.486 In our 7th step, we will write a formula that subtracts the value in U4 from the value in H4. 00:02:10.526 --> 00:02:13.568 We will apply this formula to the range U5-U15. 00:02:14.309 --> 00:02:18.711 What we need to do here is to write 'profit' to make a profit, I wrote an equal sign. 00:02:20.012 --> 00:02:23.574 Apart from this, we need to get the net value in TL currency, which is 0. 00:02:24.334 --> 00:02:37.717 Minus, selecting the net expense cell in TL currency in the Herald cell here, then pressing equal, gave us our profit in TL currency. 00:02:37.737 --> 00:02:45.098 When I applied this to other months by dragging it from the corner, we saw the reflection of our profit in other months. 00:02:46.699 --> 00:02:50.441 Our work in this section has been successfully completed. 00:02:50.781 --> 00:02:53.185 See you in the next section. 00:02:53.325 --> 00:02:54.186 Wishing you ease.

WEBVTT 00:00:01.981 --> 00:00:12.808 ikinci kısmında istatistik alıştırmalarını beşinci adımdan sonrasını nasıl yapabiliriz bunlara bakacağız hazırsanız gelin beşinci adımdan başlayalım beşinci 00:00:12.988 --> 00:00:25.075 adımızda g4 hücresine f4 hücresini j19 hücresine bölen bir formül yazmamış istenmiş yine geliyorum burada g4 hücresine eşittir yazdım ardından bizden istenen 00:00:25.095 --> 00:00:41.513 değer olan f4 hücresine buraya yine f4 dedim gördüğünüz üzere Bölü işareti G19 yani bizim KRV hesaplama faktörümüzü buraya yazdım fakat bizden istenilen 00:00:41.573 --> 00:00:49.100 son şey KRV hesaplama faktörünü sabitlememiz çünkü bunu bir sonraki satırlara taşıyacağımız için sabit kalması gerekiyor. 00:00:49.500 --> 00:00:54.625 Yine burada F4 tuşuna basarak KRV hesaplama faktörünü sabitledim ve Enter tuşuna bastım. 00:00:55.626 --> 00:01:04.041 Burada net giderimizi brute cinsinden net cinsine çevirerek hesaplamış olduk. 00:01:04.181 --> 00:01:07.467 Ardından bunu diğer satırlara uyguladım. 00:01:08.655 --> 00:01:11.056 Gördüğünüz üzere ilk adımımız buydu. 00:01:12.356 --> 00:01:18.638 Bir sonraki adımımız H4 hücresine, G4 hücresine F18 hücresi ile çarpan bir formül yazma. 00:01:19.038 --> 00:01:25.060 Yine burada F18'i, yani bizim güncel döviz kurumunu hesap almamız gerekiyor. 00:01:25.860 --> 00:01:31.242 Gelin burada gideri Euro, Euro cinsinden TL cinsini nasıl çevirebiliriz? 00:01:31.302 --> 00:01:31.842 Buna bakalım. 00:01:32.639 --> 00:01:34.421 Burayı gördüğünüz üzere Gerordu seçtim. 00:01:34.861 --> 00:01:40.066 Çarpı güncel avro kuru olan 29,18'i buradan seçtim. 00:01:40.266 --> 00:01:46.551 Ardından sabitlememiz, yani bunu diğer satırlara uygulayacağımız için sabitlememiz gerektiğini yine belirteyim. 00:01:46.932 --> 00:01:47.792 F4 dışına bastım. 00:01:48.633 --> 00:01:51.015 Ve güncel avro TL kurunu sabitledim. 00:01:51.255 --> 00:01:51.996 Enter'a bastım. 00:01:52.717 --> 00:01:59.663 Yine bunu buradan köşesinden tutup çektiğim zaman diğer satırlarda başarılı bir şekilde uygulanmış oldu. 00:01:59.663 --> 00:02:03.102 6. adımımızı başarılı bir şekilde yaptık. 00:02:03.102 --> 00:02:09.486 7. adımımızda ise U4 yücesine, H4 yücesine, H4 yücesinden çıkaran bir formül yazmak olacak. 00:02:10.526 --> 00:02:13.568 Bu formülü yine U5-U15 yüce aralığına uygulayacağız. 00:02:14.309 --> 00:02:18.711 Bizim burada yapmamız gereken kar, yani kar etablamak için önceki bir eşittir yazdım. 00:02:20.012 --> 00:02:23.574 Bunun haricinde yapmamız gereken net, 0, TL cinsindeki değeri. 00:02:24.334 --> 00:02:37.717 Eksi, bizim burada Herald hücresinde bulunan net gider TL cinsindeki hücreyi seçmek, ardından eştire basmak, burada bize TL cinsindeki karımızı verdi. 00:02:37.737 --> 00:02:45.098 Yine bunu köşesinden tutup diğer aylara uyguladığımda da karımızın diğer aylardaki yansımasını görmüş olduk. 00:02:46.699 --> 00:02:50.441 Bu kısımdaki alışmalarımız Başarılı bir şekilde tamamlandı. 00:02:50.781 --> 00:02:53.185 Bir sonraki kısımda görüşmek üzere. 00:02:53.325 --> 00:02:54.186 Kolaylıklar diliyorum.