Instructions: In this week's assignment, we will be implementing Entropy and Information Gain calculations in Excel to investigate how various informative attributes are. There is a data file associated with it (click on the link below to download): Week3_Titanic_Data.xlsx The Titanic has data on a subset of Titanic passengers, including whether or not they survived the disaster. The dataset is the 714-row dataset. For the Titanic data, the target variable is Survived. (Required, 30 points) For your assignment, calculate the following in a spreadsheet: Information gain for the ticket class attribute in the Titanic data. Information gain for the gender attribute. Information gain for the embarked attribute. Create a text box in the spreadsheet, summarize what you have done, and explain the meaning of the numbers you calculated briefly. Submit your Excel file here. You can create multiple spreadsheets in the file. Please include your first and last name in your filename