İstatistik Alıştırmaları 3

WEBVTT 00:00:00.089 --> 00:00:03.653 Ja Leute, wir werden diesen Teil unseres Videos im 3. Abschnitt behandeln. 00:00:03.713 --> 00:00:06.776 Also werden wir den Teil nach der 8. Übung behandeln. 00:00:08.518 --> 00:00:10.319 Wenn ihr bereit seid, lasst uns gleich anfangen. 00:00:10.319 --> 00:00:18.688 Unser 8. Mann wurde gebeten, eine Formel einzugeben, die die Zellen C4 und C15 in Zelle C16 addiert. 00:00:19.268 --> 00:00:28.532 Also gehe ich direkt zu Zelle C16 und führe dies mit dem automatischen Summierungs-Tool durch. 00:00:28.592 --> 00:00:31.953 Wie ihr sehen könnt, habe ich die Summe von C4 bis C15 gemacht. 00:00:33.762 --> 00:00:35.263 Das ist ein ziemlich einfacher Vorgang. 00:00:35.963 --> 00:00:44.588 Unser nächster Schritt ist es, die Formel in Zelle C16 zu kopieren und dabei auf die Formatierungen zu achten, von Zelle D16 bis J16. 00:00:45.428 --> 00:00:55.293 Wie ihr sehen könnt, ziehe ich das sofort von der Ecke, damit unsere anderen Schritte abgeschlossen sind. 00:00:56.374 --> 00:00:59.856 Ein Punkt, auf den wir achten müssen, wenn ich das hier ziehe. 00:01:01.036 --> 00:01:08.860 Wenn ich diesen Vorgang auf die anderen Zeilen anwende, hat sich wie ihr sehen könnt auch die Währung auf sie ausgewirkt. 00:01:09.500 --> 00:01:16.812 Das heißt, die türkische Lira in dieser Spalte hat sich in Euro in der Summenzeile verwandelt. 00:01:16.852 --> 00:01:19.933 Wir müssen diese manuell korrigieren. 00:01:19.953 --> 00:01:22.034 Wieder die finanzielle türkische Lira. 00:01:22.455 --> 00:01:24.396 Hier Euro, Euro, türkische Lira. 00:01:27.297 --> 00:01:31.219 Hier habe ich es wieder auf türkische Lira korrigiert. 00:01:31.459 --> 00:01:34.561 Ich denke, alles ist jetzt an seinem Platz. 00:01:36.351 --> 00:01:38.873 Wir haben das wieder erfolgreich abgeschlossen. 00:01:40.114 --> 00:01:46.759 Unser nächster Schritt ist die Eingabe einer Formel, die die Zelle J4 durch die Zelle U4 und die Zelle U16 teilt. 00:01:47.279 --> 00:01:49.581 Diese Formel soll die Zelle U16 fixieren. 00:01:50.622 --> 00:01:52.583 Lass uns das gleich überprüfen. 00:01:53.704 --> 00:01:57.647 Ich habe U16 mit J4 gleichgesetzt. 00:02:00.498 --> 00:02:05.020 Ich habe einen Wert eingegeben, der U4 durch U16 teilt. 00:02:05.480 --> 00:02:12.404 Aber da wir den Gewinnanteil berechnen, dürfen wir nicht vergessen, dass wir diese Operation auch auf andere Zeilen anwenden müssen. 00:02:13.044 --> 00:02:22.710 In diesem Sinne müssen wir den Wert, der konstant bleiben soll, nämlich unseren Gesamtgewinn in türkischer Lira, die Zelle U16, fixieren. 00:02:22.730 --> 00:02:29.872 Dafür habe ich die Taste F4 auf meiner Tastatur gedrückt und die Zelle U16 fixiert. 00:02:30.133 --> 00:02:33.895 Wie Sie sehen können, wurde unser Gewinn hier festgelegt. 00:02:33.955 --> 00:02:38.417 Unser Gewinn im Januar entsprach 10% des Gesamtjahres. 00:02:38.597 --> 00:02:43.500 Wenn ich das hier ziehe, werden auch die DRIs berechnet. 00:02:43.700 --> 00:02:47.181 Durch Klicken auf die automatische Summierung kann ich dies bestätigen. 00:02:47.242 --> 00:02:53.686 Wie Sie sehen, haben wir 100% berechnet und auch diese Aufgabe erfolgreich abgeschlossen. 00:02:55.532 --> 00:03:02.222 In Schritt elf wurde von uns gefordert, die bereits durchgeführte Berechnung auf den anderen Bereich anzuwenden. 00:03:03.043 --> 00:03:06.046 Wir haben das auch erfolgreich gemeistert. 00:03:06.587 --> 00:03:10.572 Ich wünsche Ihnen viel Erfolg beim nächsten Treffen im vierten Teil.

WEBVTT 00:00:00.089 --> 00:00:03.653 Yes friends, we will also cover this part of our video in the 3rd section. 00:00:03.713 --> 00:00:06.776 In other words, we will cover the part after the 8th exercise. 00:00:08.518 --> 00:00:10.319 If you are ready, let's start right away. 00:00:10.319 --> 00:00:18.688 Our 8th person was asked to enter a formula that sums up cells C4 to C15 in cell C16. 00:00:19.268 --> 00:00:28.532 For this, I am going to cell C16 and performing this with the auto sum tool. 00:00:28.592 --> 00:00:31.953 As you can see, I have summed up the range C4-C15. 00:00:33.762 --> 00:00:35.263 This is a very simple process. 00:00:35.963 --> 00:00:44.588 Our next step is to copy the formula in cell C16 to the range of cells D16-J16 and pay attention to formatting while copying. 00:00:45.428 --> 00:00:55.293 As you can see, I am dragging it from the corner to ensure that our other steps are completed. 00:00:56.374 --> 00:00:59.856 One point we need to pay attention to when dragging here. 00:01:01.036 --> 00:01:08.860 As you can see, when I apply this process to other rows, the currency has also affected them. 00:01:09.500 --> 00:01:16.812 So, in this total row of Turkish lira, it has been converted to Euro. 00:01:16.852 --> 00:01:19.933 We will need to enter these manually. 00:01:19.953 --> 00:01:22.034 Again, financial Turkish lira. 00:01:22.455 --> 00:01:24.396 Here, Euro, Euro, Turkish lira. 00:01:27.297 --> 00:01:31.219 Here, I corrected it back to Turkish lira. 00:01:31.459 --> 00:01:34.561 I think everything has fallen into place now. 00:01:36.351 --> 00:01:38.873 We have successfully completed this once again. 00:01:40.114 --> 00:01:46.759 Our next step is to enter a formula that divides cell J4 by cell U4 by cell U16. 00:01:47.279 --> 00:01:49.581 Let's take a look at this formula and also fix cell U16. 00:01:50.622 --> 00:01:52.583 Let's look at it right away. 00:01:53.704 --> 00:01:57.647 I said U16 equals J4. 00:00:02:00.498 --> 00:02:05.020 I entered a value that divides U4 by U16. 00:02:05.480 --> 00:02:12.404 But since we are calculating the profit margin here, let's not forget that we need to apply this operation to other rows as well. 00:02:13.044 --> 00:02:22.710 In this sense, we need to fix the value that should remain constant here, which is the total profit in TL currency, cell U16. 00:02:22.730 --> 00:02:29.872 I pressed the F4 key on my keyboard and fixed cell U16. 00:02:30.133 --> 00:02:33.895 As you can see, our profit has been determined here. 00:02:33.955 --> 00:02:38.417 Our profit in January accounted for 10% of the total year. 00:02:38.597 --> 00:02:43.500 When I drag this, it also calculates the DRIs. 00:02:43.700 --> 00:02:47.181 I can confirm this by clicking on automatic sum. 00:02:47.242 --> 00:02:53.686 As you can see, we calculated it as 100% and successfully completed this task. 00:02:55.532 --> 00:03:02.222 In the eleventh step, we were asked to apply the calculation we did to the other range. 00:03:03.043 --> 00:03:06.046 We have also successfully handled this. 00:03:06.587 --> 00:03:10.572 I wish you success and look forward to meeting you in the fourth part.

WEBVTT 00:00:00.089 --> 00:00:03.653 Evet arkadaşlar, videomuzun bu kısmını da 3. kısmına ele alacağız. 00:00:03.713 --> 00:00:06.776 Yani 8. alışmadan sonraki kısmına ele alacağız. 00:00:08.518 --> 00:00:10.319 Hazırsanız gelin hemen başlayalım. 00:00:10.319 --> 00:00:18.688 8. adamımız da C16 hücresine C4, C15 hücre alını toplayan bir formül girilmesi istenmiş. 00:00:19.268 --> 00:00:28.532 Bunun için hemen C16 hücreme gidiyorum ve bunu otomatik toplam aracıyla gerçekleştiriyorum. 00:00:28.592 --> 00:00:31.953 C4-C15 aralığını gördüğünüz üzere toplamış oldum. 00:00:33.762 --> 00:00:35.263 Bu oldukça basit bir işlendi. 00:00:35.963 --> 00:00:44.588 Bir sonraki adımımız C16 hücresindeki formülü D16-J16 hücre aralığını kopyalayın ve kopyalarken biçimlendirmelere dikkat edin şeklinde. 00:00:45.428 --> 00:00:55.293 Gördüğünüz üzere bunu hemen köşesinden tutup çekiyorum ki diğer adımlarımız da tamamlanmış olsun. 00:00:56.374 --> 00:00:59.856 Burada çektiğim zaman yalnız dikkat etmemiz gereken bir nokta. 00:01:01.036 --> 00:01:08.860 Buradaki işlemi diğer satırlara uyguladığımda gördüğünüz üzere para birimi de onlara etki etmiş oldu. 00:01:09.500 --> 00:01:16.812 Yani burada Türk lirası çinsine olan bu sütün toplam satırında Euro'ya dönmüş oldu. 00:01:16.852 --> 00:01:19.933 Bunları girip el ile düzeltmemiz gerekecek. 00:01:19.953 --> 00:01:22.034 Yine finansal Türk lirası. 00:01:22.455 --> 00:01:24.396 Burada Euro, Euro, Türk lirası. 00:01:27.297 --> 00:01:31.219 Burada yine Türk lirası olacak şekilde düzelttim. 00:01:31.459 --> 00:01:34.561 Sanırım her şey yerli yerine oturdu şu anda. 00:01:36.351 --> 00:01:38.873 Bunu başarılı bir şekilde yine tamamladık. 00:01:40.114 --> 00:01:46.759 Bir sonraki adımımız J4 hücresine U4 hücresine U16 hücresine bölen bir formül girmek. 00:01:47.279 --> 00:01:49.581 Bu formülü ki U16 hücresini de sabitlemek. 00:01:50.622 --> 00:01:52.583 Gelin buna da hemen bakalım. 00:01:53.704 --> 00:01:57.647 U16 J4 hücresine eştir dedim. 00:02:00.498 --> 00:02:05.020 U4 hücresini, U16 hücresini bölen bir değer geldim. 00:02:05.480 --> 00:02:12.404 Fakat yine burada kar oranını hesapladığımız için bu işlemi diğer satırlara da uygulamamız gerektiğini unutmayalım. 00:02:13.044 --> 00:02:22.710 Bu anlamda burada sabit kalması gereken değer toplam karımızın TL cinsi olan U16 hücresini sabitlememiz gerekiyor. 00:02:22.730 --> 00:02:29.872 Bunun içine klabemle bulunan F4 tuşuna bastım ve U16 hücresini Sabitledim. 00:02:30.133 --> 00:02:33.895 Gördüğünüz üzere karımız burada belirlenmiş oldu. 00:02:33.955 --> 00:02:38.417 Ocak ayındaki karımız toplam yılının %10'unu oluşturmuş. 00:02:38.597 --> 00:02:43.500 Burada yine bunu tutup köşesinden çektiğimde DRI'leri de hesaplamış oldu. 00:02:43.700 --> 00:02:47.181 Burada otomatik toplama tıklayarak yine bunu teyit edebilirim. 00:02:47.242 --> 00:02:53.686 Gördüğünüz üzere %100 olarak hesapladık ve bu adamı da başarılı bir şekilde tamamladık. 00:02:55.532 --> 00:03:02.222 Bizden on birinci adımda da istenen şey zaten yaptığımız hesaplamayı diğer yani aralığına uygulamamızdı. 00:03:03.043 --> 00:03:06.046 Bunu da başarılı bir şekilde halletmiş olduk. 00:03:06.587 --> 00:03:10.572 Bu şekilde dördüncü kısmında görüşmek üzere başarılar diliyorum.