<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Hinda (힌다) Melliti (멜리티) on Medium]]></title>
        <description><![CDATA[Stories by Hinda (힌다) Melliti (멜리티) on Medium]]></description>
        <link>https://medium.com/@HindaMelliti?source=rss-a781e6fac771------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*xSVokeR4WyVHTGVYKc1T6w.png</url>
            <title>Stories by Hinda (힌다) Melliti (멜리티) on Medium</title>
            <link>https://medium.com/@HindaMelliti?source=rss-a781e6fac771------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 09:26:30 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@HindaMelliti/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Feeling hungry ?]]></title>
            <link>https://medium.com/@HindaMelliti/feeling-hungry-415beb078596?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/415beb078596</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Fri, 19 Jan 2024 18:13:48 GMT</pubDate>
            <atom:updated>2024-02-03T20:07:02.745Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Feeling hungry ? How about delving into Korean culture alongside our Korean friends by sharing a meal...</strong>😋</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/957/1*kJAvnKQCb1p9rjLoSxIERg.png" /></figure><p><strong>S</strong>eoul is known for its vibrant food scene, offering a wide variety of delicious Korean dishes and international cuisines. Here’s my favourite list of famous restaurants in Seoul recommend by few friends and my Korean language teacher that you might want to try if you happen to come .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/968/1*o8rwFQ8uFRrRfRpGI665tw.png" /></figure><p><strong>런던베이글뮤지엄</strong> : Reondeon Beigeul Myujieom might sound a bit puzzling at first, but it’s cool that some Korean words actually come from English. Nowadays, you can totally sprinkle in some English there since the younger generation is pretty fluent or at least familiar with a suffisant amount of English , So the London Bagel Museum is also a bagel shop that has been receiving a lot of love from people for several years. You can taste various types of bagels, including their signature bagels. This place is also known for having waiting times, so it’s recommended to go early during the shop’s opening hours. There are three locations in Seoul, but it’s important to note that they tend to be crowded. The main branch is located in Anguk, so if we base the description on the London Bagel Museum Anguk branch, you can find this shop by taking Line 3 to Anguk Station. Anguk is known for its traditional Hanok Village, making it a great place to enjoy a meal, explore traditional Korean architecture,and take a leisurely stroll.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*LNexS_grY60ywBL-UGkdQg.png" /></figure><p><strong>송계옥 Songgyeok </strong>: Another thing to try is 송계옥 Songgyeok a popular chicken restaurant that is why this place is always crowded and you’ll need to wait in line for a couple of minutes to be served , so it’s essential to go early and make a reservation to get a table. You can find it by taking Subway Line 9 and getting off at Songpa Naru Station.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/886/1*sGEwHF4YPBilM2uP0N1Z_g.png" /><figcaption>[ Image Source] <a href="https://messywitchen.com/dining/south-korea/seoul/samcheongdong-sujebi-seoul-south-korea/">삼청동 수제비 Samcheongdong Sujebi @ Seoul, South Korea — Messy Witchen</a></figcaption></figure><p><strong>삼청동 수제비 Samcheong-dong Sujebi </strong>: For someone who’s prefers to avoid waiting in line,I suggest you go to Samcheong-dong Sujebi 삼청동 수제비 .This restaurant has held its place steadily in history and consistently drawn both loyal local patrons and visitors who come based on word-of-mouth recommendations. The restaurant’s signature dish, thinly hand-pulled sujebi served in clean and clear anchovy broth without any unwanted odors, boasts a soft and delicate flavor.<br> <br>Additionally, their chewy potato pancakes, made exclusively from 100% potatoes, are another popular menu item. If you prefer to avoid waiting in line, it’s best to steer clear of the busiest hours between noon and 2 PM.Nonetheless, the quality remains unchanged at any time. In addition to this, there are countless varieties of delicious restaurants, cafes,<br>and more to explore. I recommend searching for your desired cuisine and visiting popular establishments, as there is a wide array of culinary options to discover.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/611/0*cqJ9pybD409AftL2.png" /><figcaption><em>This picture belongs to my Korean teacher and I have obtained permission to utilize it.</em></figcaption></figure><p>I’d like also to share how to find great restaurants using Instagram. When using Instagram’s search feature, you can enter hashtags like #건대맛집 (which means “Gangnam tasty restaurant” in English) or #건대맛집추천 (which means “Gangnam restaurant recommendations” in English). Many posts will appear, and from there, you can find promising places.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/588/0*R6MJz6iZ9ZY_RU-a.png" /><figcaption><em>This picture belongs to my Korean teacher and I have obtained permission to utilize it.</em></figcaption></figure><p>To do this, simply type # followed by the area you’re interested in and then add the word “맛집” (which means “tasty restaurant” or “hotspot” in English). This will help you discover delicious dining spots</p><ul><li>Now, Guess what? You’re in for a treat with the convenient delivery services! Let me share a bit about one of the most distinctive aspects of food culture in South Korea — the “delivery culture.” Get ready for a quick lesson about delivery ! 😌</li></ul><blockquote><em>Delivery services allow you to choose your desired food from nearby restaurants using a smartphone app, and they deliver it to your location without the need to visit the restaurant in person. In the past, people in Korea would order food from each restaurant by calling different phone numbers, but the emergence of delivery platforms has simplified the process, enabling orders with just a few taps on a single app.</em></blockquote><p>Korea’s delivery culture experienced explosive popularity during the COVID-19 pandemic, as it allowed people to enjoy restaurant food while minimizing personal contact, given the restrictions in place.</p><p>However, in recent times, South Korea’s delivery culture has faced social issues related to increasing intermediary fees. <strong>Hey, just a heads up — getting the lowdown on this will save you from any awkward moments when your delivery arrives! 🚚✨</strong></p><ul><li><em>What to say : “ Nothing ” just make sure to read what’s written below — it’s your secret to saving face! 😊📜</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/0*GssgiKUFbdOdvb7D.jpg" /><figcaption>[Image Source] <a href="https://biz.chosun.com/site/data/html_dir/2018/06/26/2018062603126.html">띵동… “2000원 주셔야죠” 공짜 배달 끝났다 — 조선비즈 (chosun.com)</a></figcaption></figure><blockquote>Here’s a handy tip to save some cash: <strong>coupons!</strong> Lots of restaurants offer coupons with discounts ranging from 15% to 25%. If you collect them, you could easily score yourself another meal for free. In Korea, people often win coupons in contests and use them regularly for their day-to-day shopping. I invite you to give it a try!</blockquote><p>There are two ways to use food delivery service are using Delivery Platforms or Calling the Restaurant Directly. By using Delivery Platforms While there is a downside of paying intermediary fees, the significant advantage is that you can compare various types of food, restaurants, and reviews all in one app.Some of the prominent delivery platforms in South Korea include:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/627/0*BbXlDuZenfvu75Rf.png" /><figcaption>[Image source] :edaily.co.kr | 배달통 밀어낸 쿠팡이츠…뒤에서 웃는 배민 왜?</figcaption></figure><p>These apps are user-friendly, even for foreigners or older individuals, as they use visual food icons. Additionally, they share a similar interface, making it easy to follow the basic rules for ordering through these platforms.To place an order through a food delivery app, you can follow these basic steps:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/692/0*8NTQlMQMBUH8yMtu.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/715/0*wUkjKn29MWHtfXHv.png" /></figure><p>As mentioned earlier, all the food delivery platforms provided receive delivery tips. Typically, the average delivery tip ranges from 3,000 to 4,000 won, but sometimes they may request even higher tips. Due to this, consumers have raised concerns, stating that “<em>the tip is bigger than the meal,</em>” highlighting that the delivery tips can sometimes be more expensive than the food itself.<br>Recently, due to the increased delivery tips, South Koreans have become reluctant to use delivery services. Nevertheless, apart from the tips, it remains a highly useful service.</p><p><strong>How to find a nice restaurant in Korea?</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/915/1*8HOQIDk93v25-Le-t3TWEw.png" /></figure><p>Calling the restaurants Directly is a very traditional method of ordering food for delivery. You find the phone number of the restaurant you want to order from, call them directly, provide your address, and state the menu items you want. The advantage of this method is that there are no intermediary fees, making it potentially cheaper compared to using a food delivery app.</p><p>What to eat is one of the important things during the travel. Compared to the United States or other Europe countries, Korean restaurant is not very expensive. So people frequently go out and eat and they leave some reviews on the Internet. Many people will search for restaurants on the Internet and see the reviews to pick the place. But be careful, because some food places make people write reviews and give some free food or pay money to write nice reviews.</p><p>The first recommendation will be the Naver Map. Naver is a website that Koreans use a lot rather than Google. For those reasons, there are the most reviews here. But as the amount of information gets larger, it becomes harder to find out the comments from real customers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/450/0*cUwiLU6XzZXkM-PB.png" /><figcaption>[Image source] 10wontips.blogspot.com|Naver Map now available in English (+ screenshots &amp; my review)</figcaption></figure><p>In this case, see the comments by the “latest” sort and read some comments more than 10. Find out some bad-rated comments and also the good ones to compare and see if you can afford it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/255/0*QsKYPHALy20Mxd3v.png" /><figcaption><em>This picture belongs to my Korean teacher and I have obtained permission to utilize it.</em></figcaption></figure><p>You can try using Kakao Maps. It is a Korean representative messenger like WhatsApp. Since people do not use this a lot, there aren’t a lot of comments. But the comments will be accurate. So if the restaurant doesn’t have it in Kakao Maps, use Naver Maps.</p><p><strong>T</strong>o conclude , Indulging in delicious meals at a fine restaurant is a must-try experience while traveling. However, venturing to sample unfamiliar cuisine in an obscure location with a menu devoid of English adds an adventurous touch to the journey;even if it’s not a restaurant. That will make your memories in Korea more special. Because life is an adventure!</p><p>[Resources]:<br><a href="https://www.ivisitkorea.com/how-to-order-food-delivery-in-korea/How">https://www.ivisitkorea.com/how-to-order-food-delivery-in-korea/How</a><a href="https://www.youtube.com/watch?v=9sixILkP4A4"> to Order Home Delivery in Korea | Innovative Korean (</a><a href="http://youtube.com/">youtube.com</a><a href="https://www.youtube.com/watch?v=9sixILkP4A4">)</a><a href="https://www.youtube.com/watch?v=y-XJFrHkUjk">How To Order Food Delivery Like Koreans Do! : 배달의 민족 (Baedal Minjok) Set-up Guide (</a><a href="http://youtube.com/">youtube.com</a><a href="https://www.youtube.com/watch?v=y-XJFrHkUjk">)</a><a href="https://inmykorea.com/how-to-order-food-in-korean-restaurant-phrases/">How To Order Food In Korean: Useful Korean Restaurant Phrases (</a><a href="http://inmykorea.com/">inmykorea.com</a><a href="https://inmykorea.com/how-to-order-food-in-korean-restaurant-phrases/">)</a><a href="https://edition.cnn.com/travel/article/best-korean-dishes/index.html">Korean food: 39 best dishes we can’t live without | CNN</a><br><a href="https://biz.chosun.com/site/data/html_dir/2018/06/26/2018062603126.html">Ding dong… “You have to give me 2,000 won” Free delivery is over — Chosun Biz</a></p><p>Written by<strong> Hinda Melliti</strong></p><p><em>“Henda is your Tunisian guide in Seoul who would love to share her bucket list along with some recommendations from her dearest Korean friends to enhance your travel experience. GRWM 🥢 to immerse yourself in love and relish every moment of your gastronomic journey in Seoul!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=415beb078596" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[عشرون عاماً من الحلم بالذهاب للدراسة في كوريا الجنوبية أدت إلى اتخاذ قرار بإنشاء سلسلة مقالات…]]></title>
            <link>https://medium.com/@HindaMelliti/%D8%B9%D8%B4%D8%B1%D9%88%D9%86-%D8%B9%D8%A7%D9%85%D8%A7%D9%8B-%D9%85%D9%86-%D8%A7%D9%84%D8%AD%D9%84%D9%85-%D8%A8%D8%A7%D9%84%D8%B0%D9%87%D8%A7%D8%A8-%D9%84%D9%84%D8%AF%D8%B1%D8%A7%D8%B3%D8%A9-%D9%81%D9%8A-%D9%83%D9%88%D8%B1%D9%8A%D8%A7-%D8%A7%D9%84%D8%AC%D9%86%D9%88%D8%A8%D9%8A%D8%A9-%D8%A3%D8%AF%D8%AA-%D8%A5%D9%84%D9%89-%D8%A7%D8%AA%D8%AE%D8%A7%D8%B0-%D9%82%D8%B1%D8%A7%D8%B1-%D8%A8%D8%A5%D9%86%D8%B4%D8%A7%D8%A1-%D8%B3%D9%84%D8%B3%D9%84%D8%A9-%D9%85%D9%82%D8%A7%D9%84%D8%A7%D8%AA-fac92f24546c?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/fac92f24546c</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Mon, 18 Dec 2023 15:59:14 GMT</pubDate>
            <atom:updated>2023-12-18T16:00:30.814Z</atom:updated>
            <content:encoded><![CDATA[<p><strong><em>عشرون عاماً من الحلم بالذهاب للدراسة في كوريا الجنوبية أدت إلى اتخاذ قرار بإنشاء سلسلة مقالات إرشادية حول كيفية السفر إلى كوريا الجنوبية و ما يجب القيام به (الجزء الأول : المواصلات العامة)</em></strong></p><p><strong>عندما تهبط في مطار إنشون؟ هل تتساءل عما إذا كان عليك ركوب سيارة أجرة أو تجربة وسائل النقل العامة الأخرى؟ 🤔 كيف ذلك …ومن أين تبدأ؟</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/377/0*qfcxMYfP-rNSVL85.png" /></figure><p>jتتمتع سيول بحركة سكانية عالية، وغالبًا ما يكون استخدام وسائل النقل العام، وخاصة مترو الأنفاق، وسيلة أسرع للوصول إلى وجهتك من استخدام السيارة<strong> تعالوا معي في هذا الجزء من السلسلة الارشادية لمشاركة تجربتي الخاصة في السفر مع أصدقائي وأستاذي بعد تجربة المواصلات العامة بسيول</strong></p><p><strong>: المواصلات العامة — مترو الانفاق</strong></p><p>أولا ,أود تقديم معلومات حول استخدام نظام مترو الأنفاق، مع التركيز على مترو أنفاق سيول، حيث أنه النظام الأكثر تعقيدًا واستخدامًا على نطاق واسع في كوريا الجنوبية</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/763/0*Peo-hG7hZtUeUXN-.png" /></figure><p><em>هذه الصورة تنتمي إلى السيد ديفيد هوانغ وقد أعطيت الإذن لاستخدامها (https://pin.it/5ZdpvUE)</em></p><p>إذا نظرت إلى الخريطة، سترى العديد من الخطوط الملونة المتقاطعة. تمثل هذه الخطوط طرق مترو الأنفاق المختلفة قيد التشغيل حاليًا. وهي تربط مدينة سيول بـ غيونغي دو، وإنتشون، وكانغ وون دو، وتشونغ تشيونغ دو، مما يجعلها شبكة واسعة .iالنطاق. إذا كنت تخطط لزيارة كوريا، فإن معرفة كيفية استخدام نظام مترو الأنفاق يمكن أن يجعل التنقل أسهل بكثير</p><p>.iلاستخدام مترو الأنفاق، سوف تحتاج إلى بطاقة النقل. تعتبر هذه البطاقات مناسبة لركوب الخيل والتحويلات المتعددة ويمكن استخدامها ليس فقط لمترو الأنفاق ولكن أيضًا للحافلات وبعض وسائل النقل الأخرى</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/675/0*TajbzsPWgpUst1ym.png" /></figure><p><em>هذه الصورة تنتمي لى التقطت هذه الصورة أثناء سفري </em><br> <br><strong>T-money</strong><br> <br>إحدى بطاقات النقل الأكثر استخدامًا في كوريا الجنوبية، ويمكن استخدامها في سيول والمنطقة الحضرية، وكذلك في معظم أنظمة مترو الأنفاق والحافلات<br>.Iعلى الصعيد الوطني , يمكن شراء بطاقات وإعادة شحنها في محطات مترو الأنفاق والمتاجر وآلات إعادة شحن البطاقات بحيث تسهل بطاقات النقل التنقل في مترو الأنفاق والحافلات، وتقوم تلقائيًا بخصم الأجرة عند الدخول والخروج</p><p>نظام النقل بمترو الأنفاق في كوريا الجنوبية هو نظام مصمم للاستفادة بكفاءة من خطوط مترو الأنفاق المتعددة وتطبيق أسعار أقل. إليكم معلومات مهمة عن<br>:iنظام النقل بمترو الأنفاق في كوريا الجنوبية</p><p>(1) تعريف النقل: يشير النقل إلى التغيير من خط مترو أنفاق إلى آخر في محطة مترو الأنفاق. لا يعتبر نقلاً إذا بقيت في<br>نفس الخط. على سبيل المثال، لا يعتبر النقل من قطار الخط الثاني إلى قطار الخط الثاني الآخر بمثابة نقل</p><p>(2) الحد الزمني للتحويل: معظم مترو الأنفاق الكورية لديها حد زمني للتحويل. عادةً، يُسمح بفترة انتقالات تتراوح من 30 دقيقة إلى ساعة واحدة. خلال هذه الفترة أنت<br>يمكن التحويل إلى خط آخر في محطة مختلفة دون دفع أجرة إضافية</p><p>(3). خصم الأجرة: يتيح لك نظام التحويل الحصول على خصم على الأجرة. بعد دفع الأجرة الأساسية في المحطة الأولى، ستدفع أجرة إضافية في محطة النقل، والتي تختلف حسب نظام النقل. بشكل عام، يكون النقل أرخص من دفع الأجرة الأساسية لرحلتين منفصلتين</p><p>(4). معلومات النقل: تحتوي محطات مترو الأنفاق على لافتات ولوحات معلومات توفر تفاصيل حول عمليات النقل. يساعدك التحقق من هذه العلامات في العثور على النظام الأساسي المناسب لعملية النقل الخاصة بك ويجعل العملية أكثر سلاسة.</p><p>(5). استخدام البطاقة: استخدام بطاقة النقل ، يجعل التحويل أكثر ملاءمة. بطاقات النقل تحسب تلقائيا وتقوم بخصم الأجرة عند التحويل، وهو أمر مريح وفعال</p><p>من خلال فهم واستخدام نظام النقل بمترو الأنفاق، يمكنك السفر بكفاءة إلى وجهات مختلفة بتكلفة أقل أثناء زيارتك لكوريا الجنوبية. فيما يتعلق بالخط 2، من المهم ملاحظة أنه يعمل كخط دائري، مما يعني أنه لا ينتهي عند نقاط النهاية ولكنه يستمر في الدوران. يمكن أن تكون معرفة ذلك مفيدة عند استخدام الخط 2 لرحلاتك. أيضًا، قد تكون هناك محطات لا يتوفر فيها حاضرون في المحطة. إذا كانت لديك أية أسئلة، فقد يكون من الأسرع أن تطلب المساعدة من الأشخاص القريبين. أنا شخصياً أستخدم <strong>Kakao Subway وNaver Maps</strong> تطبيقات مثل <br> إذا وجدت نفسك تستخدم مترو الأنفاق، فإن تنزيل هذه التطبيقات واستخدامها يمكن أن يجعل تجربة مترو الأنفاق أكثر ملاءمة</p><p><strong>:Iمواصلات عامة — تاكسي</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/402/0*obJlu4fpRwgMk2Uh.png" /></figure><p>واحدة من خيارات النقل في كوريا هي سيارات الأجرة. في حين أن هناك خيارات نقل غير مكلفة نسبيا مثل الحافلات ومترو الأنفاق ، إلا أن هناك أيضا خيارا أكثر تكلفة ولكنه مناسب لسيارات الأجرة. تتراوح الأجرة الأساسية لسيارات الأجرة الكورية من 3,800 إلى 4,000 وون ، مع رسوم إضافية لكل مسافة مقطوعة</p><p>:استدعاء سيارة أجرة مع</p><p><strong>“Kakao T”</strong></p><p>: تتمثل إحدى طرق ركوب سيارة أجرة في كوريا في استخدام منصة<br> “Kakao T”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/181/0*IV1SFYxISme-1i1D.png" /></figure><p>|.NAVERI|يمكنك تنزيل التطبيق مجانا من متجر<br>| Google Play | أو متجر التطبيقات</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/693/0*o9nB5CIdhi1Sq9lg.png" /></figure><p><em>هذه الصورة تنتمي إلى </em><strong>استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p>* نصيحة لأي شخص *<br>Kakao T<br> ، تختلف أسعار سيارات الأجرة حسب نوع سيارة الأجرة التي تختارها <strong>حسب</strong> الترتيب الأسود والأزرق والمكالمات الذكية والمكالمات العادية ، ترتفع الأسعار. لكسب المزيد ، غالبا ما يعطي سائقوا سيارات الأجرة الأولوية للركاب الذين يقطعون مسافات أطول. لذلك ، إذا كنت في عجلة من أمرك وتحتاج إلى ركوب سيارة أجرة بسرعة ، فيمكنك الحصول على سيارة أجرة زرقاء ، حتى لمسافة قصيرة نسبيا ، ومن المحتمل أن تجد واحدة على الفور. فقط تذكر أنه سيتعين عليك دفع أجرة أعلى مقابل هذه الراحة</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/912/0*vS6K7Lp_mejbAfQQ.png" /></figure><p><em>هذه الصورة تنتمي إلى</em><strong> استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p>Yellow: ركوب سيارة أجرة مباشرة</p><p>:i”يمكنك أيضا طلب سيارة أجرة مباشرة عن طريق الانتظار في مواقف سيارات الأجرة أو الإبلاغ عن سيارات الأجرة المارة التي تعرض علامة “فارغ <br>”(빈차)”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/666/0*mSPStvDmiamHs6P5.png" /></figure><p><em>هذه الصورة تنتمي إلى </em><strong>استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p>عند اتباع هذا النهج ، يجب عليك إبلاغ سائق سيارة الأجرة بوجهتك قبل بدء الرحلة. لا توجد رسوم إضافية لهذه الطريقة ، لكنك لن تعرف التكلفة الإجمالية مقدما ، وقد لا تتحكم في المسار</p><p>:I(1) طلب سيارة أجرة في موقف سيارات الأجرة</p><p>- انضم إلى طابور سيارات الأجرة إذا كان هناك واحد ، وانتظر في الطابور دورك*<br>- استقل سيارة الأجرة في مقدمة الخط*<br>- تقع مواقف سيارات الأجرة عادة بالقرب من محطات الحافلات ومخارج مترو الأنفاق والمتاجر الكبرى والمستشفيات*</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/676/0*SCkJP8aLWx-e39lA.png" /></figure><p><em>هذه الصورة تنتمي إلى</em><strong> استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p>(2) الإبلاغ عن سيارة أجرة عابرة:</p><p>- إشارة سائق سيارة أجرة مثل للتعبير عن رغبتك في اتخاذ سيارة أجرة<br>hitchhiking :قل</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/676/0*uYghRftyLRpL_lis.png" /></figure><p><em>هذه الصورة تنتمي إلى</em><strong> استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p><strong>:iدليل مستخدم الحافلات — النقل العام</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/407/0*smJNJE5QOGumByG0.png" /></figure><p><em>هذه الصورة تنتمي لى التقطت هذه الصورة أثناء سفري</em></p><p>يتم أخذ معظم الحافلات الكورية بهذه الطريقة. يجب عليك الدخول من الباب الأمامي للحافلة ووضع علامة على بطاقة الائتمان أو بطاقة النقل. وهي متاحة للدفع نقدا أيضا. في سيول ، عندما تدفعها نقدا ، ستكلف 1,300 وون كوري (3.05 دينار تونسي) وإذا دفعت ببطاقة ، فستكلف 1,200 وون كوري (2.81 دينار تونسي)</p><p>في كل محطة للحافلات يتضمنها مسار الحافلة ، سيكون هناك صوت يعلم اسم محطة الحافلات والمحطة التالية. إذا كان هناك شخص يريد ركوب الحافلة في<br>محطة الحافلات ، ستتوقف الحافلة. إن لم يكن بعض الحافلات لا تتوقف. لذا اضغط على الزر بالقرب من النافذة لإقلاع الحافلة</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/325/0*AtthDW-A1O55T67O.png" /></figure><p><em>هذه الصورة تنتمي لى التقطت هذه الصورة أثناء سفري</em></p><p>هناك العديد من ألوان الحافلات في سيول مثل الأصفر والأزرق والأخضر والأحمر. تمر الحافلات الصفراء عبر وسط المدينة. تربط الحافلات الزرقاء مناطق مختلفة داخل المدينة وتعمل الحافلات الخضراء داخل سيول. تذهب الحافلات الحمراء إلى الضواحي أو المنطقة الحضرية مثل مقاطعة جيونجي دو</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/832/0*BNyLN03OSGdyizOf.png" /></figure><p><em>هذه الصورة تنتمي لى التقطت هذه الصورة أثناء سفري</em></p><p>:مواصلات عامة — اتجاهات سير</p><p>نصائح المشي في كوريا ، لا تتوفر ميزة المشي في خرائط <br> ..Google <br> لأن الحكومة الكورية لا تقدم بيانات الخرائط المحلية إلى<br>جوجل لأسباب تتعلق بالأمن القومي. لذلك ، يوصى باستخدام<br>“KakaoMaps” و “Naver Maps”<br>.للتنقل في كوريا</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/812/0*K3kc_Wwog8Kq754d.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/628/0*z_Ud2FUxUB23N0jg.png" /></figure><p><em>هذه الصور تنتمي إلى</em><strong>استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p>بعد إدخال الوجهة ، سيؤدي الضغط على زر “الاتجاهات” على الجانب الأيمن من تفاصيل المكان إلى إكمال إعداد الوجهة. بالضغط على زر “معلومات الوصول” ، يمكنك حتى التحقق من معلومات وصول الحافلة في الوقت الفعلي</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/628/0*rpKt2253jFsnYPzy.png" /></figure><p><em>هذه الصورة تنتمي إلى </em><strong>استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p>بالنسبة لرحلات مترو الأنفاق ، إذا ضغطت على زر الجدول الزمني بجوار مترو الأنفاق ، يمكنك التحقق من معلومات وصول المتروفي الوقت الفعلي</p><p>:Naveriباستخدام خرائط نافر</p><p>في الشاشة الرئيسية للملاحة ، حدد علامة التبويب “المشي” ، ثم حدد نقطة البداية والوجهة لبدء اتجاهات المشي. يرجى ملاحظة أنه يتم توفير اتجاهات المشي فقط للمسافات داخل دائرة نصف قطرها خط مستقيم يبلغ 50 كيلومترا بين نقطة البداية والوجهة</p><p>:iتوفر اتجاهات المشي خيارين للبحث<br>(1) يبحث عن طريق المشي الأمثل ، مع مراعاة معلومات الطريق وعوامل أخرى<br>(2) الطرق الرئيسية المفضلة: تؤكد على طرق المشي بشكل أساسي على طول الطرق ذات الممرات الأربعة أو أكثر</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/688/0*rLbC2-plzo4gxijy.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/527/0*l-QE-y7xcJ62hzj6.png" /></figure><p><em>هذه الصورة تنتمي إلى </em><strong>استاذي</strong> للغة الكورية<em> وقد أعطيت الإذن لاستخدامها</em></p><p><em>T </em><strong>في الختام<em> </em></strong><em>،</em><strong> آمل أن تؤدي مشاركة تجربتي الشخصية إلى توجيه الجميع لتحقيق حلم<em>ه</em>م بالذهاب إلى كوريا الجنوبية والاستمتاع بالتنقل حول سيول </strong><em>.أود كذلك أن أشكر استاذي للغة الكورية لمساعدتي خلال هذه الرحلة وإرشادي خلال السفر</em><br> <br><em>(…Stay tuned for my next Article )</em></p><p>: بعث المراجع والمصادر للإستناد بها</p><p><a href="https://koreatravelplanning.com/transportation-in-korea/">https://koreatravelplanning.com/transportation-in-korea/</a><br> <a href="https://honoraryreporters.korea.net/studio/report/modify.do?articlecate=1&amp;board_no=16015#">https://youtu.be/QDfjhVzqiWU (Korean Vocabulary: Transportation) </a><br><a href="https://honoraryreporters.korea.net/studio/report/detail.do?articlecate=1&amp;board_no=16015">https://thesmartlocal.kr/things-to-know-korea/</a><br><a href="https://honoraryreporters.korea.net/studio/report/detail.do?articlecate=1&amp;board_no=16015">https://stay.enkor.kr/blog/how-to-avoid-over-charged-using-a-taxi-in-korea-kakao-t</a><br><a href="https://honoraryreporters.korea.net/studio/report/detail.do?articlecate=1&amp;board_no=16015">https://english.visitseoul.net/transportation</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/822/0*P5ImwV6ASXOSevJv.png" /></figure><blockquote><strong>فتاة تونسية من بلد سياحي معجبة جداً بدولة كوريا الجنوبية وجهودها الرائعة لتصبح مركز إستقطاب للأجانب وموقع سياحي ضخم..انقل لكم تجربتي في الإعداد والترتيب للسفر</strong></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fac92f24546c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Reviving South Korea’s Economy “Faltering flagship”]]></title>
            <link>https://medium.com/@HindaMelliti/reviving-south-koreas-economy-faltering-flagship-a3f9e2bea2cd?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/a3f9e2bea2cd</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Sun, 05 Nov 2023 17:11:55 GMT</pubDate>
            <atom:updated>2023-11-05T17:11:55.067Z</atom:updated>
            <content:encoded><![CDATA[<h3>Note that the size of fiscal stimulus is about 0.7% of GDP and many economists assume that fiscal multiplier is estimated to be 0.5 to 0.6. Hence, by calculating the effect of stimulus package, 0.4% GDP increase is possible.</h3><p>The following article is from The Economist 2016–07–02:</p><p>Reviving South Korea’s economy</p><p>Faltering flagship</p><p>The impact of a $17 billion pick-me-up is likely to be short-lived</p><p>Jul 2nd 2016 | SEOUL | From the print edition</p><p>HOW best to prop up the companies that power South Korea’s export-driven economy as the rest of the world slows? The government’s previous answer, the so-called “one-shot” bill, aims to help the worst-affected industries to restructure by offering tax breaks for firms that sell subsidiaries and by reducing the red tape around mergers. Parliament approved it in February; it will come into effect in August. But Park Geun-hye, South Korea’s president, thinks more is needed. On June 28th she proposed a stimulus of 20 trillion won ($17 billion).</p><p>South Korea’s exports have fallen every month year-on-year since January 2015. In early June the central bank trimmed its benchmark interest rate by 0.25 percentage points, taking it to an all-time low of 1.25%. Nonetheless, the government this week revised down its forecast of GDP growth this year from 3.1%, which it predicted in December, to 2.8%. Ms Park said that the economic situation inside and outside the country was “more serious than ever”.</p><p>Britain’s recent decision to leave the European Union, South Korea’s fourth-biggest market for exports, has rattled it. But the economy, Asia’s fourth-biggest, has been struggling for some time. Growth has slowed from an average of 4.4% between 2001 and 2011 to 2.8% since then. The slowdown in China, the destination for a quarter of South Korea’s exports, has been especially painful. Low oil prices, meanwhile, have hammered shipbuilders, which build lots of rigs and other equipment for the offshore oil industry.</p><p>This week the government said 60,000 people might lose their jobs in the shipbuilding sector, which employs 200,000 in total and accounts for 7.6% of South Korean exports. Earlier in June, Ms Park had urged “bone-crushing” efforts to overhaul the industry and prop up its three biggest yards — Hyundai Heavy Industries, Daewoo Shipbuilding &amp; Marine Engineering and Samsung Heavy Industries, which last year reported combined annual losses of 6.4 trillion won) — promising to pump 11 trillion won into state-run lenders saddled with loans to them.</p><p>All this is expected to weigh on already-feeble consumer spending. The interest-rate cuts should help a bit, mostly by lowering households’ high debt-servicing costs. Much of the stimulus will go towards retraining and wage subsidies for the long-term unemployed. Some are also aimed at boosting consumption through tax breaks. Lee Doo-won, an economics professor at Yonsei University in Seoul, the capital, says that if the latest injection is delivered promptly, it could add up to 0.4 percentage points to GDP growth this year.</p><p>However, the frequency of such packages — three since Ms Park took office in early 2013 — suggests that they are hardly cure-alls. A 41 trillion won stimulus in 2014 was followed by another 22 trillion won last July, after an outbreak of Middle East Respiratory Syndrome dampened consumption. Given South Korea’s relatively low debt-to-GDP ratio compared with other rich countries, at around 37%, it could afford to make the latest spree three times bigger, says Frederic Neumann of HSBC, a bank. Moreover, the government has not been quite as loose with its money as the occasional splurges suggest: half the latest package will be financed either with money left unspent from last year’s budget or with this year’s higher-than-expected tax receipts.</p><p>Mo Jongryn, also at Yonsei University, says the money being used to bail out older manufacturers would be better spent goading under-employed South Koreans, such as women and early retirees, into the workforce. There is also scope for greater investment in services, where the productivity of workers is half that in manufacturing; a more dynamic sector would help to ease the strain on traditional exporters.</p><p>In a recent survey of South Koreans by Choson Ilbo, a local newspaper, almost 60% said they expected the economy to be as bad this year as it was in the Asian financial crisis of 1997–98. South Korea has had the worst consumer-confidence levels in the world for four straight quarters, according to Nielsen, a pollster. Yet household credit grew by 11% in the period from January to March compared with the same period last year, one of the fastest rates in the region, according to HSBC, suggesting South Koreans are borrowing to maintain their standard of living. The “extraordinary” measures for what Ms. Park called this week are still needed.</p><p>From the print edition: Finance and economics</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a3f9e2bea2cd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[한국의 기적 :]]></title>
            <link>https://medium.com/@HindaMelliti/3-%ED%95%9C%EA%B5%AD%EC%9D%98-%EA%B8%B0%EC%A0%81-8bf3151b94bc?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/8bf3151b94bc</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Wed, 04 Oct 2023 17:59:21 GMT</pubDate>
            <atom:updated>2023-10-15T16:08:34.756Z</atom:updated>
            <content:encoded><![CDATA[<h3>My personal analysis on korean economic growth</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/563/1*XHtVtUNaY1N9_ccAQTOErg.png" /><figcaption>인포메이션 픽처스 — 1</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/587/1*OKOJjGjWlMwNHGIimvdNWw.png" /><figcaption>인포메이션 픽처스_2</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/562/1*yU6OtELgW29gB6lWnUrN-A.png" /><figcaption>인포메이션 픽처스__3</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/558/1*QOFORCYumTo4hCPIXQKP-w.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/547/1*iwxy_UbTaCeYS_2molgzVw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/561/1*Wyo-iqhJFT64R1X3-UQSQQ.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8bf3151b94bc" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Use the exponential distribution]]></title>
            <link>https://medium.com/@HindaMelliti/use-the-exponential-distribution-8c7c50213777?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/8c7c50213777</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Wed, 27 Sep 2023 19:19:45 GMT</pubDate>
            <atom:updated>2023-09-27T19:19:45.101Z</atom:updated>
            <content:encoded><![CDATA[<p>- One of the most important pieces of information you can derive about your business is how often a given event tends to occur. For example, if you sell products via your company’s website, knowing the average time between orders helps you plan the number of employees you’ll have on duty at the time. Arrival times are described by the exponential probability distribution. I’ll demonstrate how to use it in this movie. My sample file is the Exponential workbook. You can find it in the Chapter Four folder of your Exercise Files collection. You need to know three pieces of information to calculate a probability using the exponential distribution. The average time that something occurs, the time you want to check, and whether you want the probability of that specific time, or the probability that a task will be completed, or perhaps an order will arrive in a given time or less. I have my workbook set up so that I can look at customer orders that occur on an average of every 50 seconds. So I have seconds from one to 150 in column A, and then in column B I have probability calculations, but right now I just have zeros entered into those cells. If I want to calculate the probability that an order will occur exactly one second after the previous order, I can use the values in cell A2 and E1 to calculate that. So I’ll click in cell B2, type an equal sign, and the function they use is expon.dist so that is E-X-P-O and then I’ll pick the top of the two highlighted functions. They are actually the same but Excel updated the naming of a lot of statistical functions with Excel 2010, so I prefer to use the new name expon.dist. So I’ll press tab. Now I need to know my X and that is the number of seconds that’s in cell A2, and I’ll leave that reference relative so when I copy the formula, it will change, then a comma, lambda is one over the average, so one divided by and then the average is in cell E1. So I’ll click cell E1 to add it. I don’t want this reference changing, I always want to refer to that cell, so I’ll press F4 to make it an absolute reference, and then I’ll type a comma, and now I need to select whether I want the cumulative probability distribution, and that is this value or less, or the probability density function, which is the probability of exactly one second occurring. I’ll start out by doing the probability density function, so I will highlight false and press tab, type right parentheses and Enter. I see that the probability of the next order coming in at one second is about .19, just under .2, so that’s about 2%. I can copy my formula from B2 to the rest of the cells that have seconds values in column A. So I click cell B2 and then move the mouse pointer over the bottom right corner, which is where the fill handle is, and when my mouse pointer changes to a black crosshair, I’ll double click, and I see the values in my worksheet and also in the chart. Let’s go over and take a look at the chart. You can see that it is increasingly unlikely that an order will occur at a specific time as that time gets later. It appears that a lot of orders, relatively a lot, will occur after about one second, and then you have a slow decline past the average, and then getting down towards zero as you approach 150 seconds. Now let’s take a look at the opposite case where we’re looking at the cumulative probability function, in other words a specific time or less. I’ll double click cell B2, and I will change the last argument, which is false, indicating probability density function, so I’ll double click that and I’ll enter true so now we’re looking at the cumulative probability, press Enter, and there’s my value. I will click cell B2, double click the fill handle, and there you see the cumulative probability. We start at one second with a low probability, and we go up approaching one as we reach 150 seconds. As you can see, it is very likely that most orders will take about say 35 seconds or so, because that’s where the curve appears across the 0.5 or the 50% probability line. If you want to find the probability that an order will occur between two times, say between 10 and 15 seconds, then all you need to do is to subtract the smaller value from the larger. That means that I will put in the value for 15 seconds, and subtract the cumulative probability for 10 seconds. So in cell E3, I’ll type an equal sign and I’ll just click the cells where those calculations occur. I will click cell B16, which is the value for 15 seconds, and I will subtract the value in cell B11. The percent of orders that will occur between 10 and 15 seconds inclusive is 7.79%.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8c7c50213777" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Interpret the results of your analysis]]></title>
            <link>https://medium.com/@HindaMelliti/interpret-the-results-of-your-analysis-9808fc6ddab5?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/9808fc6ddab5</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Wed, 27 Sep 2023 19:18:00 GMT</pubDate>
            <atom:updated>2023-09-27T19:18:00.474Z</atom:updated>
            <content:encoded><![CDATA[<p>- Let’s say that you’ve performed your analysis. Now it’s time to start interpreting it. Businesses run on data, which is both good news and bad news. The good news is that it has never been easier to collect data about your customers, products, and sales. The bad news is that you still have to decide what that data means. As an example, suppose you ran a web advertising campaign with the goal of bringing in at least 70 new qualified customers per week. You ran the ads on 25 different sites for four weeks, so you have a sample size of 100. On average, each ad brought in 73 new customers with a standard deviation of 15.1. The central question, though, is whether the ads met your goal of bringing in 70 new customers with each campaign. As your sample size is 100 and your mean is 73, the standard deviation is pretty large, over 15. So you have to ask yourself one question. Did I just get lucky? I’ve used the numbers I collected to calculate my Z-score and a probability. The Z-score lets me calculate how likely it is my results were due to chance. In this case, that probability is 2.35%. So 2.35%, is that good, bad, neither? Most analysts say that a result is significant if the probability your results were due to chance is below 5%. In other words, if your data shows that your conclusion will be wrong less than one time out of 20, you can claim the result is significant. In this case, 97.65%, or 100% minus 2.35, appears to be significant past the 95% confidence level. Of course, there’s still the possibility that your results actually were due to chance and that your ads did not have a meaningful effect. That’s where your knowledge of your business, intuition, and willingness to continue analyzing comes in handy.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9808fc6ddab5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Calculate running averages]]></title>
            <link>https://medium.com/@HindaMelliti/calculate-running-averages-b31d6f3146d4?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/b31d6f3146d4</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Wed, 27 Sep 2023 19:17:30 GMT</pubDate>
            <atom:updated>2023-09-27T19:17:30.185Z</atom:updated>
            <content:encoded><![CDATA[<p>- Collecting data over time lets you perform many kinds of analysis. One useful way to analyze your data is to find the average. For example, you might have a count of the number of customers who’ve come to your store or website over the course of a year, and by calculating the average, you can find the number of customers who typically come to your store or site during a month. What I’ll do in this movie, is show you how to calculate running averages that only look at data from a certain number of months in your collection. My sample file is the running average workbook, and you can find it in the chapter two folder of your exercise files collection. You can see here that I have a number of customers broken down by the months in a year. What I’d like to do, rather than find the average across all months, is to find a running average. That gives me a better idea of how things change throughout the year. So for a running average, in cell C2, which I already have selected, I will type an equals sign, and then I want to start out with the range B2 to B2. So yes, I’m going to be taking the average of one cell, which if I do it correctly, should be that cell’s value. However, I also want to be able to copy the formula, so I’ll need to play around with cell references. So in cell C2, after the equals sign, I’ll type average, and then B2, which is my starting cell. I want that to stay the same across all the formulas when I copy it, so I’ll press F4 to make it an absolute reference. I’ll type a colon, and the other end of the range will be B2, so I’ll type B2 again, but because I want it to change and update as we include more months, I’ll leave that reference relative. Type a right parentheses to close out the formula, enter, and I get the average I expected. Now what I can do, is to copy that formula down to the remaining cells that are next to my original data list, from A1 to B13. Rather than copy it down by hand, which is prone to error, and also just annoying to have to do, you can select the cell that contains the formula, and then double click the fill handle, that’s at the bottom right corner, and looks like a green square. So I’ll move my mouse pointer over the fill handle, and when it changes to a black crosshair, I know I’m in the right place, double click, and there we have it. So you can see that I have a running average of 5,337 in cell C3, that’s for the first three months, it goes up to 6,798, and the running average settles as it goes down, but you can also see that it drops in August and September, and also October, before going back up in November and December. So that’s interesting, but there’s not a lot of difference between the running averages, and in fact, a large value in March can overwhelm smaller values elsewhere. A way to get around that, is to have a three month running average. So you need three months worth of data. I’ll click in cell D4, which corresponds to the month of March, and I will take a three month running average for January through March. And then in cell D4, I’ll type an equals sign, followed by average, and then after the left parentheses, I want to find the average of customers, so that’s B2 through B4, so B2 colon B4. And because I’m taking a three month running average, I want both the start and the end of the range to change as I copy the formula down. So I’ll type a right parentheses, and enter, and I get 6,798, which corresponds to the running average for March before. That also takes January through March, and so does my three month running average. Now once again, I can copy the running average formula down, so I will click cell D4, double click the fill handle, and it goes down, and you can see that the three month running average changes a lot more drastically based on the day that that is either included or excluded. And if I click cell D13, the last one, and I look up, I see that in fact it does look at B11 through B13. One thing to note before I go, is that these error indicators at the top left corner of a lot of the formula cells, those just indicate that the formula omits adjacent cells. In this case it’s okay, you can ignore the error, which will get rid of the indicator for that one cell, or you can turn it off entirely in Excel options.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b31d6f3146d4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Forecast future results]]></title>
            <link>https://medium.com/@HindaMelliti/forecast-future-results-f7b26593bf18?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/f7b26593bf18</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Wed, 27 Sep 2023 19:16:55 GMT</pubDate>
            <atom:updated>2023-09-27T19:16:55.133Z</atom:updated>
            <content:encoded><![CDATA[<p>- When you own or operate a business you are always wondering what happens next. In this movie, I will show you a couple of techniques that you can use to answer those questions at least as far as current trends allow. My sample file is the forecast workbook. You can find it in the chapter two folder of the exercise files collection. I’m starting on the trend worksheet. And on here you can see that I have sales values for all of 2017 and 2018 broken down by quarter. Let’s say that I want to see what the values would be for each of the four quarters in 2019 based on my previous values. There are a number of ways to do that, but the one I want to show you here is to use the fill handle to extend an existing data series. So I have my values in B2 through B9. I’ll select those. And then I’m going to drag the fill handle at the bottom right corner of the selection. It looks like a green square. So I’ll move my mouse pointer into position. I know I’m in the right place when it changes to a black crosshair. And then I will drag the fill handle down to cell B13 and there I have my values. So for quarter number one of 2019, if trends continue, I would expect to sell 412,750 dollars. And then it would go up to 426,333 in quarter number two, and so on. Now of course you don’t see the same up and down variation that you saw in the previous values. Instead what Excel has done is say, okay, what you can expect to see is a slight increase of about 13,500 dollars each quarter based on previous data. But of course, that’s just a prediction it probably won’t mirror reality. Now let’s switch over to the forecast worksheet. And you can see that I have another data set. This data set maps the distance a customer drove versus the amount they spent. And if I scroll down using the mouse scroll wheel, you can see that my values go all the way up to 152 miles. And if I scroll back up, you can see that the shortest distance was one mile and the amount spent corresponds to each of the distances. So let’s say that I want to predict how much a customer will spend if they drive 30 miles to my store. So in cell D2, which I’ve already selected, I’ll type the number 30 and then press Tab. And then in cell E2, I’ll create a forecast formula. So I’ll type in “=” and now I need to define my forecast function. So I’ll type “forecast” or F-O-R-E and you can see that I have a number of functions available to me. In this case I want to create a linear forecast, so I have two values that are mapped together and I don’t need to worry about confidence intervals, seasonality, or anything else. So I will click FORECAST.LINEAR and press Tab to accept it. Now I need to enter in a set of values. The first is my input value, called x, and that is the miles driven in cell D2. So I’ll click D2 then a comma. Now I have the known_y’s. The known_y’s are what are called the dependent variables. And the dependent variables are the result of an independent variable. So the amount that you drive is considered to be an independent variable and we’re assuming that there’s a causal relationship between it and the amount spent which is the dependent variable. So the known_y’s start in cell B2. I’ll click there and then I’ll press Control + Shift + down arrow to select the rest of the cells in the range. I’ll click back on the formula bar and type a comma, go back up, and the known_x’s are the distances driven. So I’ll click cell A2, Control + Shift + down arrow. So A2 through A27 is selected, type a right parenthesis and Enter and scroll up. And I see that for miles driven of 30, we would predict that that customer would spend 56 dollars and 29 cents. If they were to drive 110 miles, so I’ll edit cell D2 so it reads 110, Enter. And we would anticipate a spend of about 146 dollars and 58 cents. One thing to note about the forecast function, because we’re dealing with data that is not based on time, we can’t make any predictions outside of our data range. So on the previous worksheet of the trend, we were saying if current trends continue, what would it look like. In this case we’re trying to make a prediction so that means that our predictions are only accurate for values within our collected data range. It could be interesting for informational purposes to look at what would happen at values outside of your data range, such as if someone drove 200 miles. But in this case it’s best to stay within the data range and make reasonably accurate predictions.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f7b26593bf18" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Add trendlines to charts]]></title>
            <link>https://medium.com/@HindaMelliti/add-trendlines-to-charts-4b18ff2925da?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/4b18ff2925da</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Wed, 27 Sep 2023 19:16:18 GMT</pubDate>
            <atom:updated>2023-09-27T19:16:18.137Z</atom:updated>
            <content:encoded><![CDATA[<p>- Whenever you collect data in Microsoft Excel or another program, you should always examine it for trends. In this movie, I will show you how to examine your data visually by adding a trendline into a chart. My sample file is the Trendline workbook, and you can find it in the Chapter02 folder of your exercise files collection. This workbook contains a set of data which indicates the distance that customers drove to get to a store. In the second column, we have the corresponding amount that they spent on that particular trip. So in the first case, which is in row two, you can see that a customer drove one mile and spent $35. I created an XY scatter chart to map the distance traveled to the amount spent. And I used an XY scatter chart because I have two numerical values. If I had, say, a state that a customer came from, then I would use columns, or perhaps bars, or another indicator to map a particular state to the total amount spent. But let’s say that I want to create a trendline that best fits the data that appears within my chart. So that if I said, okay, let’s say someone drives 110 miles, how much would they spend? I can see that visually by adding a trendline. So I will click the chart to select it. And then on the right side of the chart, I will click the Chart Element button. The Chart Elements panel appears. And I will point to Trendline, click the right-pointing triangle that appears beside it, and then I will click More Options. I can use the controls in the Format Trendline task pane to change my chart, specifically the trendline. Under Trendline Options, you see that I have a number of data types or trendline types that I can use. If you don’t know what kind of data you have, always assume it’s linear unless you are told differently. So we’ll have Linear selected there. Then I’ll scroll down and under Forecast, you can either leave the trendline as is, or you can forecast forward a couple of periods. In this case, I don’t have time-based data, I just have distance versus amount spent, so I’ll leave it as it is. But I did want you to see how those values work within this dataset. So I’ll click the close button on the Format Trendline task pane to get rid of it. And we can see the trendline. So you see that there is a fairly obvious vertical trend. The farther someone travels, the more they are likely to spend. And you can use the trendline to estimate how much a particular customer would spend based on a trip of a given length. So if a customer drove 120 miles, you can see that it would cross here at approximately, I would call that 160, or so. One thing to note about trendlines when you are working with data that is not time-based. This trendline is only valid for the values in the range that you have already collected. So if you were to say, how much would someone spend if they drove 200 miles, you can’t answer that because the longest trip that you have is about 155. So use trendlines, but be aware of their limitations.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4b18ff2925da" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Visualize data using logarithmic scalesVisualize data using logarithmic scales]]></title>
            <link>https://medium.com/@HindaMelliti/visualize-data-using-logarithmic-scalesvisualize-data-using-logarithmic-scales-d7220672cdae?source=rss-a781e6fac771------2</link>
            <guid isPermaLink="false">https://medium.com/p/d7220672cdae</guid>
            <dc:creator><![CDATA[Hinda (힌다) Melliti (멜리티)]]></dc:creator>
            <pubDate>Wed, 27 Sep 2023 19:15:47 GMT</pubDate>
            <atom:updated>2023-09-27T19:15:47.423Z</atom:updated>
            <content:encoded><![CDATA[<p>- Most business data describes dollar amounts in the hundreds, thousands, or hundreds of thousands of dollars. A lot of scientific data, particularly in the fields of biology and chemistry, describe much larger quantities. Showing all of that data on a chart can be difficult using standard axis settings, so in this movie, I will show you how to use logarithmic values to fit your data into a readable chart. My sample file is LogarithmicScale, and that’s an Excel workbook you can find in the chapter two folder of your exercise files collection. The data that I have here in cells B6 through B11 is expressed in scientific notation. Scientific notation has a base number. In cell B6, that is 2.93, and then it is multiplied by 10 to the power, in this case, of four. So that’s what 2.93 times E plus 04 means. If you look at the value for cell B6 on the formula bar, you can see that it is actually 29,250. So it’s just another way of saying that we have 2.93 times 10,000 or 10 to the fourth power. And you can see that the numbers go up quite significantly from there. The next value in cell B7 is 9.76 times 10 to the eighth. So that’s a number that is 1000 times larger than the number in B2, and the next number in cell B8, 1.45 times E to the 13th, or 10 to the 13th, is 10,000 times larger than the value in cell B7. So you can see that values get very quickly when you are dealing in powers of 10. The graph, even though we’re dealing with large values, you can see that the value in cell B11, which is 9.02 times 10 to the 15th, overwhelms all of the other values, and the vertical axis goes from zero immediately up to one times E to the 15th, so that is 10 to the 15th power or one followed by 15 zeroes, and that, as you can see, is an extremely large number. So rather than use a scale where only the largest value has any sort of meaningful indication within the chart, we can change the vertical axis to use a logarithmic scale. To do that, right click any value on the vertical axis and then click Format Axis. In the Format Axis dialog box under Axis Options, scroll down, and you can see that there is a Logarithmic Scale check box. Go ahead and select that. And we’ll leave the base at 10 because we’re dealing with powers of 10 for scientific values, and you can see that the chart has changed. The values on the vertical axis are separated by two powers of 10, so 100 times. So that means that a value that is, say, one times E to the eighth, or 10 to the eighth, is 100 times larger than a value at one times E to the sixth, or 10 to the sixth. When you work with scientific data, this sort of logarithmic scale allows you to compare values more meaningfully than a chart that just has its largest value overwhelming all the others.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d7220672cdae" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>