Gender and Titanic. Let's use the data set titanic train.xlsx. In this dataset you will find a brief explanation of the variables. You can consider this dataset a large sample of a larger population. You can also assume that the conditions for inference are satisfied and that, therefore, the CLT holds. Use = 0.05 throughout your analysis. The variable 'Survived' takes value 1 if the passenger survived, and 0 otherwise. Calculate a confidence interval for the proportion of males who survived, and then repeat the analysis for females.