<?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 Olagunju Olanrewaju on Medium]]></title>
        <description><![CDATA[Stories by Olagunju Olanrewaju on Medium]]></description>
        <link>https://medium.com/@ernal4me?source=rss-e5c21d0a9e12------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*LUA7Hgx0WuVjcKH4.jpg</url>
            <title>Stories by Olagunju Olanrewaju on Medium</title>
            <link>https://medium.com/@ernal4me?source=rss-e5c21d0a9e12------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 12:22:55 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@ernal4me/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[From Router-on-a-Stick to Layer 3 Switch: Upgrading Inter-VLAN Routing (Cisco Packet Tracer Lab)]]></title>
            <link>https://medium.com/@ernal4me/from-router-on-a-stick-to-layer-3-switch-upgrading-inter-vlan-routing-cisco-packet-tracer-lab-08f30fe0f4e2?source=rss-e5c21d0a9e12------2</link>
            <guid isPermaLink="false">https://medium.com/p/08f30fe0f4e2</guid>
            <category><![CDATA[ccna]]></category>
            <dc:creator><![CDATA[Olagunju Olanrewaju]]></dc:creator>
            <pubDate>Fri, 24 Jul 2026 11:55:40 GMT</pubDate>
            <atom:updated>2026-07-24T11:55:40.637Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Part 2 of my CCNA lab series — replacing ROAS with a multilayer switch and enabling internet connectivity.</em></p><h3>Overview</h3><p>In my previous lab, I configured inter-VLAN routing using the <strong>router-on-a-stick (ROAS)</strong> method — one router with sub-interfaces handling traffic between VLANs. It works, but it has a limitation: all inter-VLAN traffic has to travel up to the router and back down, which creates a bottleneck.</p><p>In this lab, I replaced that setup with a <strong>Layer 3 multilayer switch (SW2)</strong>, which can route traffic between VLANs internally using <strong>Switch Virtual Interfaces (SVIs)</strong> — much more efficient. I also configured a point-to-point Layer 3 link between SW2 and R1 so devices can reach the internet.</p><h3>Topology</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/645/1*CihLV7CfOotiESFugYnxKw.png" /></figure><p><strong>VLANs and Subnets:</strong></p><p>VLAN Subnet Last Usable IP (SVI Gateway) Location 10 10.0.0.0/26 10.0.0.62 SW1 + SW2 20 10.0.0.64/26 10.0.0.126 SW2 30 10.0.0.128/26 Configured on SW1 side only SW1</p><p><strong>Point-to-point link:</strong> 10.0.0.192/30 between SW2 (.193) and R1 (.194)</p><h3>What Changed From the Previous Lab</h3><p>Previous Setup (ROAS) This Lab (Layer 3 Switch) Sub-interfaces on R1 SVIs on SW2 Trunk between R1 and SW2 Routed point-to-point link (no trunk) R1 handled inter-VLAN routing SW2 handles inter-VLAN routing Less scalable More efficient and scalable</p><h3>Step 1 — Remove the ROAS Configuration on R1</h3><p>The first task was to tear down the old sub-interface configuration on R1’s G0/0. This meant removing sub-interfaces for VLANs 10, 20, and 30, then assigning a real IP to G0/0 for the point-to-point link with SW2.</p><pre>R1(config)# no interface GigabitEthernet0/0.10<br>R1(config)# no interface GigabitEthernet0/0.20<br>R1(config)# no interface GigabitEthernet0/0.30</pre><pre>R1(config)# interface GigabitEthernet0/0<br>R1(config-if)# ip address 10.0.0.194 255.255.255.252<br>R1(config-if)# no shutdown</pre><p>After this, show ip interface brief confirmed G0/0 was up with its new IP:</p><pre>GigabitEthernet0/0     10.0.0.194   YES manual  up  up<br>GigabitEthernet0/0/0   1.1.1.2      YES manual  up  up</pre><blockquote><strong><em>Note:</em></strong><em> R1 already had routes to the internet configured (via G0/0/0) and a default route pointing to the internet router. No changes were needed on that side.</em></blockquote><h3>Step 2 — Enable IP Routing on SW2</h3><p>By default, a multilayer switch operates at Layer 2 only. To enable routing, one command is needed:</p><pre>SW2(config)# ip routing</pre><p>This is the key difference between a Layer 2 and Layer 3 switch — without this command, SVIs can be created but no routing happens between them.</p><h3>Step 3 — Convert G1/0/2 to a Routed Port on SW2</h3><p>The interface connecting SW2 to R1 needed to become a <strong>routed (Layer 3) port</strong> rather than a switchport. This is where I hit my first mistake.</p><h3>⚠️ Mistake: Trying to assign an IP before removing switchport mode</h3><p>My first attempt:</p><pre>SW2(config)# interface GigabitEthernet1/0/2<br>SW2(config-if)# no switchport mode trunk<br>SW2(config-if)# ip address 10.0.0.193 255.255.255.252<br>                                      ^<br>% Invalid input detected at &#39;^&#39; marker.</pre><p>The error happened because I only removed the trunk mode — the interface was still a <strong>switchport</strong>. On a multilayer switch, you cannot assign an IP address to a switchport. You have to fully convert it to a routed port first using no switchport.</p><h3>✅ Fix:</h3><pre>SW2(config)# interface GigabitEthernet1/0/2<br>SW2(config-if)# no switchport<br>SW2(config-if)# ip address 10.0.0.193 255.255.255.252<br>SW2(config-if)# no shutdown</pre><p>Once no switchport was applied, the interface came up and accepted the IP address without any issues.</p><p><strong>Lesson learned:</strong> On a multilayer switch, no switchport mode trunk does not convert a port to a routed port. You need no switchport to fully strip the Layer 2 configuration.</p><h3>Step 4 — Configure a Default Route on SW2</h3><p>SW2 now needed to know where to send traffic destined for networks outside the VLANs — specifically, the internet. Since R1’s G0/0 is the next hop at 10.0.0.194:</p><pre>SW2(config)# ip route 0.0.0.0 0.0.0.0 10.0.0.194</pre><p>This tells SW2: <em>“For any destination you don’t know, forward it to R1.”</em></p><h3>Step 5 — Configure SVIs on SW2</h3><p>SVIs (Switch Virtual Interfaces) are virtual Layer 3 interfaces tied to a VLAN. They act as the <strong>default gateway</strong> for devices in that VLAN — similar to what the sub-interfaces did on R1 before.</p><p>The task required assigning the <strong>last usable IP</strong> of each subnet to the SVI.</p><h3>Another small mistake worth noting</h3><p>I initially assigned the wrong IP to VLAN20:</p><pre>SW2(config)# interface vlan 20<br>SW2(config-if)# ip address 10.0.0.62 255.255.255.192   ← wrong, this belongs to VLAN10</pre><p>I caught it and corrected it:</p><pre>SW2(config-if)# no ip address 10.0.0.62 255.255.255.192<br>SW2(config-if)# ip address 10.0.0.126 255.255.255.192   ← correct last usable for VLAN20</pre><p>Then configured VLAN10:</p><pre>SW2(config)# interface vlan 10<br>SW2(config-if)# ip address 10.0.0.62 255.255.255.192<br>SW2(config-if)# no shutdown</pre><blockquote><strong><em>Why no SVI for VLAN30?</em></strong><em> VLAN30 (10.0.0.128/26) is only connected to SW1 on the other side of the network. SW2 has no ports in VLAN30, so no SVI is needed there. Inter-VLAN routing for VLAN30 is handled via the trunk between SW1 and SW2.</em></blockquote><h3>How It All Works Together</h3><p><strong>Inter-VLAN routing (e.g. PC5 in VLAN20 pinging PC7 in VLAN10):</strong></p><ol><li>PC5 sends traffic to its gateway — SVI Vlan20 (10.0.0.126) on SW2</li><li>SW2 looks up its routing table and finds VLAN10’s subnet via SVI Vlan10</li><li>SW2 routes the packet internally and forwards it to PC7 — no router involved</li></ol><p><strong>Internet traffic (e.g. PC5 pinging 1.1.1.1):</strong></p><ol><li>PC5 sends traffic to SVI Vlan20 on SW2</li><li>SW2 checks its routing table — no match, hits the default route</li><li>Default route points to R1 (10.0.0.194) via the point-to-point link</li><li>R1 forwards it to the internet router via G0/0/0</li></ol><h3>Connectivity Test Results</h3><p>Pinging from PC2 (VLAN10) to PC5 (VLAN20) at 10.0.0.65:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/694/1*KmD2ALPrTUarak0OWH_u2A.png" /></figure><pre>First ping:  Packets Sent=4, Received=3, Lost=1 (25% loss)   ← ARP resolution on first ping<br>Second ping: Packets Sent=4, Received=4, Lost=0 (0% loss)    ✅</pre><p>Pinging the internet (1.1.1.1):</p><pre>Packets Sent=4, Received=1, Lost=3 (75% loss)</pre><blockquote><em>The partial loss on the internet ping is normal behaviour in Packet Tracer — the first few packets are dropped while ARP and routing tables converge. A second ping would show full connectivity.</em></blockquote><h3>Key Concepts Covered</h3><ul><li><strong>Layer 3 Switch / Multilayer Switch</strong> — A switch capable of both Layer 2 switching and Layer 3 routing</li><li><strong>SVI (Switch Virtual Interface)</strong> — A virtual interface on a switch tied to a VLAN, used as a gateway for devices in that VLAN</li><li><strong>ip routing</strong> — The command that enables Layer 3 routing on a multilayer switch</li><li><strong>Routed port (</strong><strong>no switchport)</strong> — Converts a switchport into a Layer 3 interface that can hold an IP address</li><li><strong>Point-to-point /30 link</strong> — A 4-address subnet used for direct connections between two routers or Layer 3 devices</li><li><strong>Default route</strong> — Catches all traffic with no specific match and forwards it to a defined next hop</li></ul><h3>ROAS vs Layer 3 Switch — Which Should You Use?</h3><p>Factor ROAS Layer 3 Switch Cost Cheaper (just a router) More expensive hardware Performance Router becomes a bottleneck Routing happens on the switch Scalability Limited Better for larger networks Best for Small networks, labs, CCNA Enterprise environments</p><p>In real networks, Layer 3 switches are preferred wherever inter-VLAN traffic is heavy. ROAS is still useful to understand — and it’s a core CCNA exam topic.</p><p><em>Lab built in Cisco Packet Tracer as part of my CCNA preparation. Configurations tested and verified.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=08f30fe0f4e2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Configured Inter-VLAN Routing Using Router-on-a-Stick (Cisco Packet Tracer Lab)]]></title>
            <link>https://medium.com/@ernal4me/how-i-configured-inter-vlan-routing-using-router-on-a-stick-cisco-packet-tracer-lab-50aad9485b76?source=rss-e5c21d0a9e12------2</link>
            <guid isPermaLink="false">https://medium.com/p/50aad9485b76</guid>
            <category><![CDATA[ccna-certification]]></category>
            <category><![CDATA[network-engineer]]></category>
            <category><![CDATA[networking]]></category>
            <category><![CDATA[it-support]]></category>
            <dc:creator><![CDATA[Olagunju Olanrewaju]]></dc:creator>
            <pubDate>Thu, 23 Jul 2026 16:42:21 GMT</pubDate>
            <atom:updated>2026-07-23T17:48:20.618Z</atom:updated>
            <content:encoded><![CDATA[<p><em>A hands-on lab walkthrough as I prepare for my CCNA exam.</em></p><h3>Overview</h3><p>In this lab, I built a small network with three VLANs and configured inter-VLAN routing using the <strong>router-on-a-stick</strong> method. I also connected an external network directly to the router to simulate traffic going outside the VLAN environment.</p><p>By the end of this lab, devices in different VLANs could communicate with each other, and all devices could reach the external network — without using a Layer 3 switch.</p><h3>Topology</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/352/1*5NQcbIrTqJrvfiyW8aWayg.png" /></figure><p><strong>Devices:</strong></p><ul><li>R1 — Cisco 2911 Router</li><li>SW1 — Cisco 3650 24-Port Switch</li><li>PC1 — External PC (connected directly to R1)</li><li>PC2 — VLAN 10 (IT)</li><li>PC3 — VLAN 20 (Sales)</li><li>PC4 — VLAN 30 (HR)</li></ul><h3>VLANs Defined</h3><p>VLAN Name Subnet Gateway 10 IT 10.0.2.0/24 10.0.2.1 20 Sales 10.0.3.0/24 10.0.3.1 30 HR 10.0.4.0/24 10.0.4.1</p><p><strong>External Network:</strong> 10.1.1.0/24 (connected directly to R1’s G0/2)</p><h3>Step 1 — Configure VLANs on the Switch</h3><p>The first step was to create the three VLANs on SW1 and assign names to them.</p><pre>vlan 10<br> name IT<br>!<br>vlan 20<br> name Sales<br>!<br>vlan 30<br> name HR</pre><h3>Step 2 — Assign Access Ports on the Switch</h3><p>Each PC connected to the switch was assigned to its respective VLAN as an access port. The switchport nonegotiate command disables DTP (Dynamic Trunking Protocol) negotiation, which is good practice for access ports.</p><pre>interface GigabitEthernet1/0/1<br> switchport access vlan 10<br> switchport mode access<br> switchport nonegotiate<br>!<br>interface GigabitEthernet1/0/2<br> switchport access vlan 20<br> switchport mode access<br> switchport nonegotiate<br>!<br>interface GigabitEthernet1/0/3<br> switchport access vlan 30<br> switchport mode access<br> switchport nonegotiate</pre><h3>Step 3 — Configure the Trunk Port on the Switch</h3><p>The interface connecting SW1 to R1 (G1/1/1) was configured as a trunk port, allowing tagged traffic for VLANs 10, 20, and 30 to pass through to the router.</p><pre>interface GigabitEthernet1/1/1<br> switchport trunk allowed vlan 10,20,30<br> switchport mode trunk</pre><blockquote><strong><em>Note:</em></strong><em> Inter-VLAN routing is not possible at the switch level here because Layer 3 routing was not enabled on SW1. All routing decisions are handled by R1.</em></blockquote><h3>Step 4 — Configure Sub-Interfaces on the Router (Router-on-a-Stick)</h3><p>This is the core of the lab. Instead of using a separate physical interface for each VLAN, I configured <strong>sub-interfaces</strong> on R1’s G0/1 — the interface connected to SW1.</p><p>The physical interface itself has <strong>no IP address</strong> — only the sub-interfaces do.</p><pre>interface GigabitEthernet0/1<br> no ip address<br> no shutdown<br>!<br>interface GigabitEthernet0/1.10<br> encapsulation dot1Q 10<br> ip address 10.0.2.1 255.255.255.0<br>!<br>interface GigabitEthernet0/1.20<br> encapsulation dot1Q 20<br> ip address 10.0.3.1 255.255.255.0<br>!<br>interface GigabitEthernet0/1.30<br> encapsulation dot1Q 30<br> ip address 10.0.4.1 255.255.255.0</pre><p>Each sub-interface uses encapsulation dot1Q [vlan-id] to tag and untag traffic for the correct VLAN. The IP address on each sub-interface becomes the <strong>default gateway</strong> for devices in that VLAN.</p><h3>Step 5 — Configure the External Interface on the Router</h3><p>PC1 is on a separate network (10.1.1.0/24) and connects directly to R1’s G0/2. This simulates an external or outside network.</p><pre>interface GigabitEthernet0/2<br> ip address 10.1.1.1 255.255.255.0<br> no shutdown</pre><p>Because PC1 is <strong>directly connected</strong> to the router, no static or default route was needed — R1 automatically adds a connected route for 10.1.1.0/24 to its routing table.</p><h3>How It All Works Together</h3><ol><li>PC2 (VLAN 10) sends traffic to PC4 (VLAN 30)</li><li>The frame is tagged with VLAN 10 and travels up the trunk link to R1</li><li>R1 receives it on sub-interface G0/1.10, strips the tag, and checks its routing table</li><li>R1 routes the packet to G0/1.30, re-tags it with VLAN 30, and sends it back down the trunk</li><li>SW1 forwards it to PC4 on the correct access port</li></ol><p>For traffic to PC1 (external network), R1 simply routes it out G0/2 — no extra configuration needed since it’s a directly connected network.</p><h3>Key Concepts Covered</h3><ul><li><strong>VLANs</strong> — Logical segmentation of a network at Layer 2</li><li><strong>Trunk ports</strong> — Carry traffic for multiple VLANs between switches and routers using 802.1Q tagging</li><li><strong>Router-on-a-Stick</strong> — A single router interface handling multiple VLANs via sub-interfaces</li><li><strong>dot1Q encapsulation</strong> — The 802.1Q standard for VLAN tagging</li><li><strong>Connected routes</strong> — Routes automatically added to a router’s routing table for directly attached networks</li><li><strong>Default gateway</strong> — The router IP that end devices send traffic to when the destination is outside their subnet</li></ul><h3>What I Learned</h3><p>Going through this lab reinforced something important: <strong>understanding why each command exists matters more than memorising it</strong>. For example, it’s easy to just type switchport mode trunk without thinking about why but knowing that the trunk is what allows tagged VLAN traffic to reach the router&#39;s sub-interfaces makes the whole setup click.</p><p>I also initially thought I’d need a default route for the external network, but realised that directly connected networks are automatically known to the router a reminder to always check the routing table before adding unnecessary config.</p><p><em>This lab was built in Cisco Packet Tracer as part of my CCNA preparation. All configurations were tested and verified.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=50aad9485b76" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unveiling Excel’s Hidden Powers: My Path to Advanced Expertise]]></title>
            <link>https://medium.com/@ernal4me/unveiling-excels-hidden-powers-my-path-to-advanced-expertise-5cd688d2d080?source=rss-e5c21d0a9e12------2</link>
            <guid isPermaLink="false">https://medium.com/p/5cd688d2d080</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel]]></category>
            <dc:creator><![CDATA[Olagunju Olanrewaju]]></dc:creator>
            <pubDate>Tue, 11 Jul 2023 03:19:12 GMT</pubDate>
            <atom:updated>2023-07-11T03:33:36.241Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/652/1*cM-6WqHU5M4bcPvyYAAMrQ.jpeg" /></figure><p>It’s week five, in the realm of spreadsheets and Data Analysis, I embarked on a quest to master the art of Excel. Armed with determination and a thirst for knowledge, I delved into the basics, intermediate concepts, and even ventured into the advanced functionalities of this powerful tool. Join me as I recount my learning experience on various Excel topics.</p><p>My journey began with Excel basics, where I learned the foundations of this software. I grasped the concept of cells, rows, and columns, understanding how they formed the building blocks of a spreadsheet. Basic mathematical operations like addition, subtraction, multiplication, and division became second nature to me. I discovered the power of cell references, enabling me to perform calculations efficiently and save time. Armed with this knowledge, I felt confident in navigating Excel’s interface and performing basic calculations effortlessly.</p><p>As I progressed to intermediate concepts, I dove into conditional statements. The IF function became my ally, allowing me to check if a condition was met and perform actions accordingly. I explored nested IF statements, where multiple conditions could be evaluated. To add visual appeal and highlight specific data, I delved into conditional formatting. With this tool, I could format cells based on predetermined criteria, making data analysis and interpretation more intuitive.</p><p>To further enhance my analytical skills, I delved into lookup functions. VLOOKUP and HLOOKUP opened doors to retrieving specific values from tables based on given criteria. These functions empowered me to quickly find and extract relevant information, simplifying data analysis tasks. And then, I stumbled upon XLOOKUP, Excel’s next-generation lookup function. This versatile function combined the best features of VLOOKUP, INDEX MATCH, HLOOKUP, and IFERROR/IFNA, giving me even more flexibility and accuracy in retrieving data.</p><p>One of the most powerful tools I encountered on my journey was pivot tables. With pivot tables, I could analyze and summarize large datasets effortlessly. I learned how to create pivot tables, select fields for analysis, and apply various calculations such as sums, averages, and counts. Pivot charts became my visual storytelling companions, enabling me to present data trends and patterns in a visually appealing manner. Pivot tables truly became my go-to tool for in-depth data analysis.</p><p>As my Excel skills expanded, I delved into the world of text formulas. I learned how to extract specific portions of text using functions like LEFT, MID, and RIGHT. CONCATENATE and TEXTJOIN allowed me to combine text from multiple cells, creating informative and organized outputs. I discovered the power of FIND and SUBSTITUTE, which helped me locate and replace specific text within a cell or expression. These text formulas proved invaluable in handling and manipulating large volumes of textual data.</p><p>To deal with date-related calculations, I explored Excel’s date functions. DAY, MONTH, and YEAR functions enabled me to extract individual components from a date, providing me with more granular control. I also learned how to create dates from separate values and determine the day of the week using the WEEKDAY function. EOMONTH proved particularly useful in finding the last day of a month based on a specific date. With these date functions, I could effectively analyze time-related data and gain deeper insights.</p><p>As I delved deeper into Excel’s advanced functionalities, I encountered Index and Match lookup. This powerful combination allowed me to retrieve values based on specific criteria, surpassing the limitations of VLOOKUP. The INDEX function helped me retrieve cells in a range based on their positions, while the MATCH function identified the position of a value within a range. This dynamic duo became my go-to approach for complex lookup scenarios.</p><p>Power Query emerged as a game-changer during my Excel journey. With Power Query, I could combine data from multiple workbooks effortlessly, clean and transform data with ease, and automate data retrieval processes. The Column from Examples tool was a hidden gem that enabled me to master Power Query without prior knowledge, making data manipulation a breeze. Unpivoting columns and performing complex data transformations became second nature with the help of Power Query.</p><p>My learning journey took an exciting turn when I stumbled upon Excel’s secret functions. These functions, not available in most Excel versions, unlocked a new set of capabilities. UNIQUE enabled me to extract unique values from a range, while SORT and SORTBY empowered me to sort data dynamically. FILTER allowed me to filter ranges based on specific criteria, enhancing my data analysis prowess. RANDARRAY and SEQUENCE helped me generate arrays of random numbers and sequential values, respectively. The LET function elevated my formula’s readability, ease of use, and performance by assigning values and calculations to names. And then, I encountered LAMBDA, the mother of all functions. With LAMBDA, I could create powerful custom functions tailored to my specific needs, further expanding my Excel arsenal.</p><p>To handle financial calculations, I explored Excel’s financial functions. These functions enabled me to perform various financial calculations, from calculating interest rates to evaluating investment returns. With their help, I gained the confidence to tackle complex financial analysis tasks within Excel itself.</p><p>Driven by curiosity, I sought to automate repetitive tasks and explore the realm of macros and VBA. I learned how to record and edit macros, creating custom shortcuts for repetitive actions. Gradually, I delved into Visual Basic for Applications (VBA), a powerful programming language embedded within Excel. With VBA, I could write custom macros, develop user interfaces, and manipulate data programmatically. The ability to automate tasks and create customized solutions enhanced my productivity and opened up a whole new world of possibilities.</p><p>As my Excel learning series continues, I couldn’t help but feel a sense of accomplishment and pride in the skills I had acquired. However, my hunger for knowledge and my passion for Data Analysis were far from satiated. I knew that the world of Excel had even more advanced features and techniques to offer, waiting to be explored and mastered. From the basics to advanced concepts, I acquired a vast array of skills that transformed the way I analyzed and manipulated data. Excel became more than just a software tool; it became my ally, empowering me to make informed decisions, derive meaningful insights, and present data effectively. My newfound Excel expertise not only saved time and increased efficiency, but also opened up new doors of opportunity in my personal and professional life. Excel had become my trusted companion in the world of data, and I was ready to tackle any analytical challenge that lay ahead.</p><p>Thanks to <a href="https://excel-practice-online.com/">Excel Practice Online</a>, I was able to relearn and practice the skills I have learnt.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5cd688d2d080" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[My Learning Experience: Exploring the Fundamentals of Statistics, Data Analysis, and Insights]]></title>
            <link>https://medium.com/@ernal4me/i-came-across-this-tweet-about-2-weeks-ago-while-i-was-scraping-twitter-for-a-possible-roadmap-to-c3bbb70ef6be?source=rss-e5c21d0a9e12------2</link>
            <guid isPermaLink="false">https://medium.com/p/c3bbb70ef6be</guid>
            <dc:creator><![CDATA[Olagunju Olanrewaju]]></dc:creator>
            <pubDate>Tue, 04 Jul 2023 20:40:41 GMT</pubDate>
            <atom:updated>2023-07-04T20:50:04.515Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Vyx6vMwJyTuJUNnlcILFDA.png" /><figcaption>Tina Okonkwo’s Tweet</figcaption></figure><p>I came across this tweet about 2 weeks ago while I was scraping twitter for a possible Roadmap to Becoming a Data Analyst that I could possibly work with. I would later realize <a href="https://twitter.com/Rita_tyna?s=20">Tina</a> had shared the million dollar info 6 months ago. Oh God! What have I been doing with my life?!</p><p>Though I may not have been working with a specific roadmap, I have taken free courses on Udacity that introduced me to Statistics in Data Analysis. I was excited to learn about this new subject, but I quickly realized that it was a lot more challenging than I expected. I struggled to understand the concepts and the math involved. I continued to take statistics classes, but I still didn’t feel like I had a good grasp of the material. I was starting to think that statistics was just not for me.</p><p>Then, I came across this YouTube course on Statistics recommended by <a href="https://twitter.com/Rita_tyna?s=20">Tina</a> . This course was different from the other statistics courses I had taken. The instructor was clear and concise, and the materials were well-organized. I also appreciated the practical exercises on <a href="https://www.varsitytutors.com/">varsitytutors</a> that helped me practice the concepts.</p><p>As I worked through the course, I started to understand statistics better. I was able to see how statistics could be used to solve real-world problems. I also realized that statistics was not just about math. It was also about critical thinking and problem-solving.</p><p>By the end of the course, I had a much better understanding of statistics. I was confident that I could use statistics to analyze data and make informed decisions. I was also excited to continue learning more about statistics.</p><p>During my exploration of statistics, I encountered several fascinating concepts that have broad applications in Data Analysis. Sampling, for instance, involves carefully selecting a subset of individuals or objects from a larger population to draw conclusions about the whole. It’s essential to ensure the sample is representative and unbiased.</p><p>When it comes to experimental design, I learned the significance of planning and organizing experiments effectively. Considering factors like treatment groups, control groups, placebo effect and random assignment ensures reliable and valid conclusions can be made from the data collected.</p><p>Understanding how to create frequency histograms and analyze distributions was eye-opening. Visualizing data through histograms helped me grasp the patterns and frequencies of different values or ranges. It allowed me to observe the shape, center, and spread of the distribution, which gives valuable insights.</p><p>Exploring different types of graphs, such as time series, bar, and pie graphs, taught me how to present data in a meaningful way. Time series graphs proved useful in analyzing trends over time, while bar and pie graphs effectively conveyed categorical data and proportions.</p><p>Frequency tables and stem-and-leaf plots were invaluable in organizing and summarizing data. They provided a structured format to observe the frequency or count of observations in specific categories or intervals. Stem-and-leaf plots, in particular, retained the original values, aiding in understanding the distribution more intuitively.</p><p>Measures of central tendency, such as the mean, median, and mode, helped me grasp the concept of a dataset’s typical value. They provided insights into the center of the distribution and were valuable in understanding the overall trend of the data.</p><p>Measures of variation, including the range, variance, and standard deviation, allowed me to quantify the spread or dispersion of data points. These measures helped me assess the diversity or consistency within a dataset.</p><p>Exploring percentiles and box-and-whisker plots enhanced my understanding of data distribution and outliers. Percentiles indicated the relative position of a value within a dataset, while box-and-whisker plots provided a clear visual representation of quartiles, median, and extreme values.</p><p>Scatter diagrams facilitated the exploration of relationships between variables, and linear correlation helped quantify the strength and direction of those relationships. These tools allowed me to understand patterns and potential dependencies in the data.</p><p>The concept of the normal distribution and the empirical rule opened my eyes to the prevalence of this bell-shaped distribution in various real-world phenomena. Additionally, understanding the Z-score and probability calculations helped me analyze and interpret data within the context of the standard normal distribution.</p><p>Finally, sampling distributions and the central limit theorem highlighted the importance of sample size and the behavior of sample statistics. Learning about these concepts helped me understand how sample statistics can be used to make inferences about a larger population.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*89yihkNEdl-RgR_eKEp11Q.jpeg" /><figcaption>My space</figcaption></figure><p>Overall, my journey through these statistical concepts has been enlightening. They have equipped me with valuable tools and techniques to analyze data effectively, make informed decisions, and gain meaningful insights from various datasets.</p><p>Introducing the captivating mnemonic “SISDACUN” that I came up with during the study to remember the fundamental guidelines for planning a statistical study: Step into the world of statistical exploration with “SISDACUN,” an enchanting acronym that will guide you through the intricate maze of study design. Let’s dive in and unravel the magic. I and my AI friend, ChatGPT, did just to this.</p><p>S — State your hypothesis: Start by clearly stating the hypothesis of your study. What are you hoping to test or investigate? Clarify your hypothesis to provide a solid foundation for the entire journey.</p><p>I — Identify the essentials: Next, identify the essential elements required for your study. What variables will you be measuring? Are there any confounding factors that need to be considered? Uncover the vital components that will shape your investigation.</p><p>S — Select the right sample: Sampling is a crucial aspect, so choose your participants or data points thoughtfully. Ensure that your sample is representative of the larger population you’re studying, and consider randomization to minimize bias and enhance reliability.</p><p>D — Design with care: Craft your study design with meticulous attention to detail. Determine whether an experimental or observational approach is appropriate, and establish the necessary control groups or conditions. Design your study like an artist, carefully placing each stroke of methodology.</p><p>A — Address ethical concerns: Throughout your journey, navigate with utmost integrity and respect for ethical considerations. Ensure proper consent, protect privacy, and follow established guidelines. Let your moral compass guide you through the ethical landscape</p><p>C — Collect the data: Analyze smartly as your data pours in, embark on the fascinating journey of analysis. Employ statistical techniques that suit your study’s objectives, whether it’s comparing means, examining correlations, or uncovering patterns. Dive into the sea of data armed with powerful tools.</p><p>U — Use compelling visuals: Using descriptive and inferential to answer your hypothesis, transform your findings into captivating visual representations. Create awe-inspiring charts, graphs, and visuals that breathe life into your data. Engage your audience and let the story of your study unfold in a visually stunning manner. Understand the story, delve deep into the story your data tells. Unravel the insights, implications, and significance of your findings. Unleash your analytical prowess to unlock the hidden treasures buried within the numbers.</p><p>N — Note concerns: By noting these concerns about data collection and analysis, you can proactively address potential issues and enhance the validity and reliability of your study. Paying attention to these details will help ensure that your findings accurately reflect the phenomena you’re investigating and contribute to the advancement of knowledge in your field.</p><p>Embark on your statistical quest armed with “SISDACUN,” a spellbinding companion that will infuse magic into your study planning. Let the excitement of discovery and the pursuit of knowledge fuel your statistical journey, unveiling the secrets that lie within the data.</p><p>Remember, statistical studies are not just about numbers; they’re captivating tales waiting to be told. So, embrace the enchantment of “SISDACUN” and unlock the wonders of statistical exploration!</p><p>I believe that everyone should learn some statistics. It is a valuable skill that can be used in many different fields. If you are struggling to learn statistics, I encourage you to check out <a href="https://youtu.be/xxpc-HPKN28">this YouTube video</a> (A Full University Lecture on Data Science Basics uploaded on the Freecode channel) which lectures are based on the textbook Understanding Basic Statistics. It was a great resource for me, and I think it could be helpful for you too.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c3bbb70ef6be" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>