The sinking of the RMS Titanic is one of the most infamous shipwrecks in history. On April 15, 1912, during her maiden voyage, the Titanic sank after colliding with an iceberg, killing 1502 out of 2224 passengers and crew. This sensational tragedy shocked the international community and led to better safety regulations for ships. One of the reasons that the shipwreck resulted in such loss of life was that there were not enough lifeboats for the passengers and crew. Although there was some element of luck involved in surviving, some groups of people were more likely to survive than others. The file Titanic. xls contains data for 1309 of the Titanic passengers. Each row represents one person. The columns describe different attributes about the person including whether they survived (survived), their gender (sex), and their passenger-class (pclass). You can find a short description of each variable in the variables worksheet included in the file. Answer the following based on the dataset:a. What percentage of the men suvived? What percentage of the women survived?b. What was the average fare for each passenger class?c. Compare the survival rates of each class of passengers. To retrieve Titanic. xls, please copy and paste the URL below:http://biostat. mc. vanderbilt. edu/wiki/pub/Main/DataSets/titanic3 .xls