<?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 Elizabeth Fayne on Medium]]></title>
        <description><![CDATA[Stories by Elizabeth Fayne on Medium]]></description>
        <link>https://medium.com/@lizziefayne?source=rss-a94ead1ec6c2------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*4Zq7ysddeFhBy_j_zM8jCQ.jpeg</url>
            <title>Stories by Elizabeth Fayne on Medium</title>
            <link>https://medium.com/@lizziefayne?source=rss-a94ead1ec6c2------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 15:10:09 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@lizziefayne/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[Google Data Analytics Certificate — Bike-Share Case Study]]></title>
            <link>https://medium.com/@lizziefayne/google-data-analytics-certificate-bike-share-case-study-957d7b05d362?source=rss-a94ead1ec6c2------2</link>
            <guid isPermaLink="false">https://medium.com/p/957d7b05d362</guid>
            <category><![CDATA[coursera]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[microsoft-excel]]></category>
            <dc:creator><![CDATA[Elizabeth Fayne]]></dc:creator>
            <pubDate>Sun, 31 Jul 2022 23:08:58 GMT</pubDate>
            <atom:updated>2022-08-01T23:27:05.636Z</atom:updated>
            <content:encoded><![CDATA[<h3>Google Data Analytics Certificate — Bike-Share Case Study</h3><p>Hello!</p><p>Thanks for stopping by.</p><p>In this mock case study, I will walk you through the steps I took to analyze the data for the bike-share company called Cyclistic. *Disclaimer: All of the data obtained in this set is from Coursera’s Google Data Analytics course.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/145/1*--ms65_Jqhy67tvEP5Z84A.png" /><figcaption>Company logo</figcaption></figure><h3><strong>About the company</strong></h3><p>In 2016, Cyclistic was launched and offered the public a bike-share company. This company has around 5,824 bicycles that are geotracked and placed around across the city of Chicago for anyone to use. The company offers a wide array of pass options when using the bikes. You can have a single-ride pass, a full-day pass, and even an annual membership. Allowing each individual to have flexibility, depending on their needs. The main goal of Cyclistic’s marketing team is to maximize the amount of annual membership owners because they are the most profitable compared to casual riders.</p><p>In order to find the best way to turn casual riders into annual membership holders, we need to dig deeper to identify certain trends with each pass holder.</p><h3>Scenario</h3><p>I am a junior data analyst working as a marketing analyst for Cyclistic. The director of marketing states that the company’s future success is in turning casual riders into annual membership holders. In order to start this process we must have a better understanding of how the bicycles are used.</p><p>With any project there are the 6 steps of data analysis:</p><ol><li>Ask</li><li>Prepare</li><li>Process</li><li>Analyze</li><li>Share</li><li>Act</li></ol><h3>What is being <strong>ASKED</strong> of me?</h3><p>The three questions are:</p><ol><li>How do annual members and casual riders use Cyclistic bikes differently?</li><li>Why would casual riders buy Cyclistic annual memberships?</li><li>How can Cyclistic use digital media to influence casual riders to become members?</li></ol><h3>How can I PREPARE this data?</h3><p>Here is the dataset: <a href="https://divvy-tripdata.s3.amazonaws.com/index.html">https://divvy-tripdata.s3.amazonaws.com/index.html</a></p><p>After uploading the file, I used Microsoft Excel Workbook to house the data.</p><p>For this particular example, I used the data obtained for January of 2021 labeled: “202101-divvy-tripdata.xlsx”</p><ul><li><strong>Data Cleaning </strong>done within Excel</li><li><strong>Visualizations</strong> created within: — Tableau: public.tableau.com</li></ul><p><em>Cleaning the data:</em></p><ol><li>Using “Find &amp; Select”:</li></ol><p>Select all the data by clicking the box in the upper left hand corner of the spreadsheet. By doing this, it should select all cells. Under the home tab, you will move your mouse over to the “Find &amp; Select” button and select “Go To Special”. You will then select blanks and hit ok. This will pull each cell from the database that has a blank cell.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/374/1*cI0cCfRqYH3M-NrOS-417g.png" /></figure><p>By identifying the blank cells, we are able to assign them as it best suits the subject of the cells. In this case, the blank cells were for the start_station_name, start_station_id, end_station_name, and end_station_id. To replace these blank cells, I put “unknown”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LTxk4zbQNQgxvsoIvTXZeg.png" /></figure><p>2. Using Conditional Formatting to find duplicate values:</p><p>Under the home tab within Excel in about the middle of the Excel window, you should see a drop down menu labeled “Conditional Formatting”. After you select this, you should see an option for “Highlight Cell Rules”. Select this and then select “Duplicate Values”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/876/1*SFhTNda_30QNEMsyA6HWwg.png" /></figure><p>It will then have a pop-up window that will ask you to create a new formatting rule. Here is an example of what it would look like.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1016/1*uR31Z0kePqGLYEtkUU8CKg.png" /></figure><p>If there are multiples of the same result, you would be able to void those entries so they would not skew the data.</p><h3>Asking further questions</h3><p>How long did each bicycle ride go on for? — To find this, we would create a new column and name it ride_length.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/394/1*WMVh6cyxSRCFAJN4xvjk6g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/164/1*0OyESur6pViJXtPLDX9rnw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/132/1*YMqGhyESaUgV7QCIwZP-kA.png" /></figure><p>After completing that function, it will give you this long number… We will then need to convert it into minutes and seconds. To do so, we would right click on our mouse while hovering over the number and move our cursor down to “Format Cells” and select this option below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ll7_7ErobiWV6VSRbFEyIg.png" /></figure><p>It will then show you the length of each ride by seconds and minutes. By double clicking the small green box on the bottom right hand corner of the individual cell, we are able to autofill the contents of the entire column without having to input the same formula over and over again!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/130/1*_8jkejBqVxWQazhpY1sRSA.png" /></figure><p>After this step has been completed, I was to calculate the maximum value located within this range. There are 96,835 rows in this spreadsheet, so the function to find the maximum value will be: =MAX(O2:O96835). The maximum value = 18 hours 25 minutes and 55 seconds was the longest ride_length.</p><h3><strong>Business Task</strong></h3><p>To identify trends within all types of pass holders we look closely at: what day of the week are they using the bicycle, the duration of the ride, and the type of pass they hold.</p><h3>Results</h3><ol><li>By using =COUNTIF() function within Excel, I was able to identify that Saturday is the busiest day for bicycle usage, with 16,323 rides.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/398/1*3PnEYxELHLDCIIj-dWhSbg.png" /></figure><p>2. By using =SUM() function within excel, the longest rental period is 18 hours and 25 minutes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/338/1*GiBfmq8FBtu1xCIp_otzhQ.png" /></figure><p>3. By using the COUNTIF() function, I identified how many customers were casual customers and how many paid for the membership.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/474/1*AMWpGhZBIdqRNSyQhxymfg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*1Dmn1SqjaiojoxPrWCRxGw.png" /></figure><p>There is a total of 18,117 casual members and 78,717 membership holders.</p><p>4. By using COUNTIF () function I found just how many people are casual riders at 18,117 and membership holders at 78,717.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*1Dmn1SqjaiojoxPrWCRxGw.png" /></figure><p>5 . The location with the most amount of rides was: Sedwick Street. To ensure that there plenty of bikes there, we will look at the average of users each day and make sure there is an ample supply of bikes to ensure that no one is ever without a bike.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/416/1*_QSBtMoWykP5Xh2I9-MdIw.png" /></figure><h3>Questions pulled from this data</h3><ol><li>What is keeping the casual riders from becoming membership holders? Is it that the price is too high? Is it that they don’t use it as often and wouldn’t benefit by buying the membership?</li><li>Are there incentives we could employ to have these customers become members?</li><li>Are the bikes always returned to the same location it was picked up from? What steps do we need to take with inventory to make sure that there are enough bicycles in rotation to never run out?</li></ol><h3>Marketing Strategies</h3><ol><li>Create a questionnaire to distribute to casual members investigating their reasons preventing them from becoming membership holders.</li><li>Incentivize memberships by providing a discount of 10% off the original price (Example: the membership costs $89 per year and is a 365-day pass. For the whole month of August, the membership will now be $79.99.) This reduction of price will promote further growth for the number of existing memberships.</li><li>To promote returning bicycles to their original pickup location by encouraging members through the use of free rides. To ensure that inventory is never limited, we will have to deploy drivers to maintain a designated inventory number.</li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=957d7b05d362" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Transplant Statistics from Organ Procurement & Transplantation Network]]></title>
            <link>https://medium.com/@lizziefayne/transplant-statistics-from-organ-procurement-transplantation-network-912199bd6c49?source=rss-a94ead1ec6c2------2</link>
            <guid isPermaLink="false">https://medium.com/p/912199bd6c49</guid>
            <dc:creator><![CDATA[Elizabeth Fayne]]></dc:creator>
            <pubDate>Thu, 28 Jul 2022 06:02:28 GMT</pubDate>
            <atom:updated>2022-08-09T16:42:03.656Z</atom:updated>
            <content:encoded><![CDATA[<p>After working as a nurse with chronic kidney disease patients, I have found a real interest in the statistics of organ transplants throughout the United States.</p><p>In this article, I will be analyzing data I was able to locate from the Organ Procurement &amp; Transplantation Network website. For this first visualization, it takes a look at the years from 2017 to 2022, how many donors were living or deceased, and the total transplants for that year.</p><p>Here is a screenshot of the data used to create the visualization:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/568/1*9URjLbLqfxlEhAg2hhKBxA.png" /></figure><p>Below is the visualization I created within Tableau.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bCOARNuO_sp4utNPlnvSHw.png" /></figure><p>To think that just in this year alone, there has been 22,445 transplants as of July 15, it makes me wonder if 2022 will be the year with the most transplants.</p><p>The second set of data I worked with looks at just how many transplants have happened each year going back to the year 1988. This visualization was also created within Microsoft Excel.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uZ92DMmZj9Ky1I1ZhRhiTw.png" /></figure><p>The third set of data I looked at was how many people are on the waiting list as of July 18, 2022 and what organ they are waiting for.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Bi4yTefOb5HGW7CxFTLQ3Q.png" /></figure><p>Here is the visualization I had created for the data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JBC2vnT164AGFPhRwmUCjg.png" /></figure><h3>Questions drawn from this data:</h3><ul><li>Did COVID-19 have any effect on these numbers?</li><li>What are the success rates of these transplants?</li></ul><p>This is my first project and I want to reflect on the things that I have learned. Microsoft Excel has been a challenge but a very good one at that. It has made me learn things in a different way. I’ve always been taught something and then I do it, but with Excel, you have to teach yourself and figure out ways to get the results you want.</p><p>Being a nurse and caring for those with Chronic Kidney Disease has been my career for the last year. The interest I have for both nursing and healthcare along with data collection and analysis go hand in hand. I hope to find a career where I can do both.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=912199bd6c49" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>