Titanic case by Radhika Kashid using advance excel

It is a titanic case study using excel

1. - By Radhika kashid TITANIC CASE STUDY

2. INTRODUCTION The Sinking of Titanic was one of the deadliest peacetime maritime disaster in history and quickly became a catalyst for change. This incident happened in the North Atlantic Ocean in the early hours of April 15, 1912, The United States congress held hearings on causality that resulted in a report and measures to improve safety of navigation. We analyze this report with help of charts

3. SURVIVED AND DID NOT SURIVIVE Graph Represents Survived & Did not survive Of People On Titanic 41% people are survived where 59% people are not Survived number of deaths was comparatively greater than the survived people Data needed % survived % did not survive Total 41% 59%

4. GENDERWISE SURVIVORSHIP This Graph Represents Gender Impact On Survival 714 people traveled on Titanic, 453 were men and 261 women. Out of 453 men, 360 men died, and 93 men survived. Out of 261 women, 197 women survived, and 64 women died. Male fatality rate is greater than female fatality rate. Data needed Survived Did not survive Total Men 93 360 453 Women 197 64 261 Fig - 2

5. CLASS WISE SURVIVORSHIP The passenger class has impacted the survival rate as from the above graph we can observe that highest survival rate is for class 1 and highest did not survival rate is for class 3, whereas class 2 passenger are having equal survival and did not survival rate. From the above graph the observation is that, that out of total number of class 3 has an greater number of death rate of 7 6 % ,as compared to class 2 and class 3 that has the not survival percentage of 34 % and 5 2% respectively. First class- 66 % survived / 34 % demise Second class-48% survived / 52% demise Third class-24% survived / 76% demise Data needed Survived Did not survive Class 1 122 64 Class 2 83 90 Class 3 85 270

6. Passenger Age Impact On Survival From the graph the observation is that, the Age Class of 18-30 and age class of 30-50 passenger death is more as compare to age class <18 and age class >50 . has impacted the survival rate as from the above graph we can observe that highest survival rate is for Age Class <18 . As children were rescued on priority based their survival rate is highest i.e 54% Data needed Survived Did not survive Total <18 61 52 113 18-30 95 176 271 30-50 107 149 256 >50 27 47 74

7. conclusion After analysis of the data there was a significant impact on Sex, Passenger Class and Age. According to the statistics, women's lives were meagerly saved than men's lives because of that sex ratio was impacted. Class 3 passengers fatality rate was highest than class 1 and class 2 passengers fatality rate. This incident mostly impact on poor class passengers Working population that is age class 18-30 and age class 30-50 fatality rate was highest in the incident . Children survival rate is highest because they are the upcoming future generation so they got the highest priority at the time of rescue opration .

8. THANK YOU