<?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 Olatunji Titobiloluwa on Medium]]></title>
        <description><![CDATA[Stories by Olatunji Titobiloluwa on Medium]]></description>
        <link>https://medium.com/@olatunjititobiloluwa?source=rss-1c619f63d408------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*G3e2Qj7JBF-IxCbLgcjUjQ.jpeg</url>
            <title>Stories by Olatunji Titobiloluwa on Medium</title>
            <link>https://medium.com/@olatunjititobiloluwa?source=rss-1c619f63d408------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 11:13:02 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@olatunjititobiloluwa/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[Bike Sales Analysis: Excel Project]]></title>
            <link>https://medium.com/@olatunjititobiloluwa/bike-sales-analysis-excel-project-b566292c2fc0?source=rss-1c619f63d408------2</link>
            <guid isPermaLink="false">https://medium.com/p/b566292c2fc0</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel-project]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Olatunji Titobiloluwa]]></dc:creator>
            <pubDate>Fri, 01 Sep 2023 09:03:08 GMT</pubDate>
            <atom:updated>2023-09-01T09:03:08.306Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/275/1*UGnVgXE0qCudUejkGr5k2A.jpeg" /></figure><p>Hi everyone!<br>I’m so glad to share my first Excel project with you guys.<br>Last month (August), I decided to learn more about Excel and how it is used for Data Analysis with the aim of wrapping up with a nice project to practice the skills learned.</p><h3><strong>Project Overview</strong></h3><p>The aim of this project is to practice my Excel skills and also to analyze the Bike Sales dataset in order to derive customer insights.</p><h3><strong>Dataset description</strong></h3><p>The Bike Sales dataset can be gotten from the description box of the video. Here’s the link:</p><p><a href="https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Excel%20Project%20Dataset.xlsx">https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Excel%20Project%20Dataset.xlsx</a></p><p><a href="https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Excel%20Project%20Dataset.xlsx">Excel-Tutorial/Excel Project Dataset.xlsx at main · AlexTheAnalyst/Excel-Tutorial</a></p><p>This dataset is about a Bike Sales data of an unknown company with 13 rows and 1027 columns. It consists of various fields such as ID, Marital Status, Gender, Income, Children, Education, Occupation, Cars, Commute distance, Region, Age, Purchased bike.</p><h3><strong>Research Questions</strong></h3><p>i. What is the average income of those who purchased bikes and those who did not, based on their gender?</p><p>ii. Does the commute distance affect the purchases of bikes?</p><p>iii. What age groups make the most bike purchases?</p><h3><strong>Data Cleaning and Preprocessing</strong></h3><p>The data looked clean to an extent but I had to still check for some quality issues.</p><ul><li>Checked for duplicates (26 duplicates were found and removed leaving 1000 unique values using the <em>Remove duplicates</em> feature), missing values but there were none.</li><li>Scanned<strong> </strong>through each of the columns one by one, replaced M with Married and S with Single in the <em>Marital Status</em> column, replaced M with Male and F with Female in the <em>Gender</em> column, using the Find and Replace feature.</li><li>Created a new column named “Age group” from the <em>Age column</em> using the Nested If statement in the formula:</li></ul><p><em>=IF(L2&gt;54,”Old (55+)”,IF(L2&gt;=31,”Middle Aged (31–54)”,IF(L2&lt; 31,”Adolescent (18–30)”,”Invalid”)))</em></p><p>- Converted the format in the <em>Income column</em> from Custom to Currency.</p><h3><strong>Data Visualization</strong></h3><ol><li><strong>Created Pivot table</strong>s and visualized the tables with recommended charts</li></ol><p><em>To create Pivot tables: Insert tab — Pivot Table — From Table/Range</em></p><p><strong>2. Created Slicer</strong>s — easy-to-use buttons or filters in a report or chart that help you quickly narrow down the information you want to see. 4 slicers were created; <em>Marital Status, Education, Occupation, Region</em></p><p><strong>3. Built an Interactive dashboard</strong></p><p>The charts generated from the pivot tables were put together and slicers were added. Here’s what the final dashboard looks like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/866/1*hbpQPp4gLtoLyIMRkHIpAA.jpeg" /><figcaption>Bike Sales Dashboard</figcaption></figure><h3>Answers to Research questions (Analysis and Insights)</h3><p><em>i. Average income of Males and Female who purchased bike or not</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/981/1*oy0jnmDCb7tH8cxuFYlDbQ.jpeg" /><figcaption>Average Income per Purchase based on gender</figcaption></figure><p>To assess average income of Male and Female bike purchasers and non-purchasers, a bar chart comparison was created. The bars for Male and Female purchasers were higher than non-purchasers, indicating higher average incomes among purchasers. This suggests that individuals with higher incomes are more likely to purchase bikes.</p><p><em>ii.</em><strong> </strong><em>Purchase of bikes based on Customer’s commute distance</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*0iK3G6X8FeLbF6Mcb_EOsg.jpeg" /><figcaption>Customer purchase per commute distance</figcaption></figure><p>The influence of “Commute distances” on bike purchases was assessed through a line chart to determine the peak commute distance. Bike purchases were at peak at 0–1 miles, 2–5 miles. Customers who fall within these ranges show a higher likelihood of purchasing bikes.</p><p><em>iii.</em> <em>Bikes purchase based on Customer’s Age group</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/954/1*Imy9XXfRXKil6B3v9f1SKA.jpeg" /><figcaption>Purchase based on Age groups</figcaption></figure><p>Analyzing age groups revealed that Middle-aged customers accounted for the highest bike purchases, suggesting a preference for bike usage among this demographic. This suggests that biking is particularly appealing to individuals in this age category. It might be seen as a recreational activity or a fitness option for middle-aged customers. It’s possible that they value the health benefits and leisure opportunities biking provides.</p><h3><strong>Summary</strong></h3><ul><li><strong>Income and Bike Purchase</strong>: People with higher incomes tend to purchase bikes. This suggests targeting higher-income individuals in marketing.</li><li><strong>Commute Distance and Bike Purchase</strong>: Bike purchases peak for short commutes (0–1 mile and 2–5 miles). Promoting biking as a convenient short-distance solution is recommended.</li><li><strong>Age Group and Bike Purchase</strong>: Middle-aged customers show the highest bike purchases. Marketing emphasizing health and leisure benefits for this group is advised.</li></ul><p>Overall, the data suggests targeting higher-income individuals, promoting biking for short commutes and tailoring marketing to middle-aged customers for increased bike sales.</p><p>Other insights can also be generated from the dashboard. I only focused on a few.</p><p>Thank you for reading!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b566292c2fc0" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>