Sitemap
Isaac Udom

Isaac Udom

Data Analyst | Data storyteller | I love Tableau | Footballer

TITANIC

5 min readJun 24, 2020
THE SINKING TITANIC

WOULD YOU HAVE SURVIVED?

Titanic movie is one of the most beautiful love story movies out there and that I’ve ever seen. A movie starring, the popular and Oscar award winner, Leonardo DiCaprio as Jack and Kate Winslet as Rose, in a love story that started in the ship. Rose was from a wealthy family and was on board with her fiancé Cal Hockley but fell in love with Jack. The ship then sinks by hitting a massive iceberg off the coast of Newfoundland in the North Atlantic. The lifeboats were sufficient enough for only 1,178 persons of the 2,224 passengers and crew that were on board.

However, this was not just a movie, it was a real-life story of the RMS Titanic ship that sank on its way to New York on April 15,1912.

This dataset happens to be the first dataset I worked on as I began my journey of storytelling with data.

The data we have contains a sample of the passengers on board during the mishap. I explored the dataset and discovered some pretty interesting insights about who really survived the Titanic.

DATATSET

Press enter or click to view image in full size

The dataset contains a sample of 891 which represents 40% of passengers with 12 columns representing the data for each passenger on board.

These features include the following:

1. Passenger Id: the ID of each passenger.

2. Survived: this feature has value 0 as ‘Died’ and 1 as ‘Survived’.

3. Pclass: A proxy for socio-economic status.

1st = upper class.

2nd = Middle class.

3rd = lower class.

4. Name: Name of passenger.

5. Sex: gender of passenger.

6. Age: Age of passenger.

7. Sibsp: Indicating passengers that have a sibling or spouse.

8. Parch: Indicating passengers that went with parents or children.

9. Ticket: Ticket number of the passenger.

Get Isaac Udom’s stories in your inbox

Join Medium for free to get updates from this writer.

10. Fare: indicating the passenger fare.

11.Cabin: The cabin number of the passenger.

12. Embarked: The port of embarkation.

Now, follow me as we explore this dataset.

DATA EXPLORATION

Let’s check first the number of passengers that survived and those who didn’t.

Press enter or click to view image in full size

It’s quite clear that the number of people who died (549) is more than those who survived (342)

65% of those on board were males, 35% females (including children).

Interestingly, we found that the rate of survival for men is much less than that women. This is because women and children were highly prioritized during rescue, as this is the rule of the sea in a case of emergency.

Press enter or click to view image in full size

Further into our analysis, let’s look at the Pclass feature. Majority were in the lower class on the ship as the tickets cost were as low as $2 and many lost their lives.

It is usually said that Money can’t buy you everything but, in this case, it gave the upper class a survival ticket as they were given higher priority during the rescue process and it can be assumed that they had more access to lifeboats than those of Middle and lower class. Paying huge sum as high as $510 in 1912 which is about $13,480 in today’s money, you sure would have access to lifeboats. So, Money and status matters.

Furthermore, the survival rate for women in the upper class was about 96% as only 3 of 94 died. So, in general we see a high priority for women across all classes during rescue seeing that survival rate even in the upper class was low for men.

Press enter or click to view image in full size

In a bid to further look at who survived the mishap, we’ll look at the Sibsp and Parch feature. I created a new feature called Family Size, adding SibSp and Parch to distinguish passengers that traveled alone and those whose family accompanied. Passengers with no family members aboard had about 18% survival rate. But here’s one astonishing yet troubling fact; the survival rate for families with 5–8 members was 0.8%. Could this be because of the Pclass? A sounding Yes!! You see, 90% of passengers who traveled with parents, siblings or spouses more than 5, were all in the lower class and it’s evidently sad that almost all the large families in the lower class died😢😢

What can we say about the age feature? Young adults (20-30 years) who constitutes about 50% of the population aboard, had the highest death rate (34%).

Let’s look particularly at the children ranged 0–10 years. 26 of 64 children died. But you ask ‘weren’t children highly prioritized during rescue?’ Well, majority all children seemed to belong to medium and large sized families in the lower class.

Humans tend to react differently in a crisis situation, in a seamlessly hopeless one at that in the middle of Atlantic. Fear creeps in, anxiety disorder displayed everywhere. There is chaos on board. Children going missing, spouses separated, parents in search of their kids. Pandemonium everywhere. Women with kids aboard seemed to have displayed their affectionate nature in the search of their missing kids and we are inspired to wonder if that affected their survival, as we see more women in large and medium sized families (49 of 72) who were in the lower class lose their lives compared to other classes.

Press enter or click to view image in full size

In conclusion, while others died due to insufficient lifeboats, some, who had access to lifeboats showed bravery trying to rescue others especially children, but lost their lives in the process. Not all heroes wear capes.

And yes, Jack died, for those who haven’t seen the movie.

You can find interesting insights from my Tableau page

You can also follow me on Twitter , LinkedIn

--

--

Isaac Udom
Isaac Udom

Written by Isaac Udom

Data Analyst | Data storyteller | I love Tableau | Footballer