a. Using the excel spreadsheet found on xxx, analyze the data to determine what type of person would be most likely to survive? Least likely to survive?

b. Read about the Titanic and develop a CED to explain why so many people died on this ship?

On the evening of Sunday April 14, 1912, RMS Titanic, while on her maiden voyage, struck an iceberg about two days from New York City. Within three hours, she was gone (Monday April 15, 1912). On this voyage, there were 2,201 passengers and crewmembers, of which 711 survived. Initially, it was thought that the survivors came primarily from the first class (with some from the second class). After all, the passengers in first class had paid the most to travel on the Titanic’s maiden voyage (in some cases paying in excess of $100,000 in today’s dollars). These people were closest to the lifeboats. They represented some of the most important people in 1912 society – John Jacob Astor IV and his wife Madeleine Force Astor, industrialist Benjamin Guggenheim, Macy’s owner Isidor Straus and his wife Ida, Denver millionaire Margaret “Molly” Brown (who became known later on as the “Unsinkable Molly Brown”, Sir Cosmo Duff Gordon and his wife Lucy, and silent film actress Dorothy Gibson. In contrast, the third class was located the furthest away from the lifeboats. Also, as a result of the U.S. immigration requirements, the gates that would have given the third class passengers access to the lifeboats were locked when Titanic left Southampton.

You have been asked to study the passenger list for Titanic and to determine if the premises stated in the previous paragraph really did occur. Specifically, consider the following: