BUS-352-RS-CLCTitanicSurvival-StudentS23 (2)

CLC - Titanic Survival: Exploratory Data Ana Overview The sinking of the Titanic is one of the most infamous shipwrecks in history. While there was some element of luck involved in surviving, it seems some groups of people were more likely to survive than o You will use the DCOVAS framework. • Define the problem • Collect data from the appropriate source(s) • Organize data using tables • Visualize data using a chart or graph • Analyze data using a tool and/or calculation(s) • Solution: Provide a conclusion and solution Data Set Tasks (All students must complete this section individually) Create and submit one PowerPoint and the combined Excel file. Instructions for Pivot Table: Base CaseOn April 15, 1912, during her maiden voyage, the widely considered "unsinkable" RMS Titanic sank after colliding with an icebe resulting in the death of 1502 out of 2224 passengers and crew. In this Collaborative Learning Community (CLC) assignment, you will work as a group and explore the Titanic passenger sample survive using passenger data (i.e. Survived, Pclass, Gender, Age, and Fare). The "CLC - Titanic Survival: Exploratory Data Analysis" Excel spreadsheet contains data for 700 of the real Titanic passengers. E about the passengers including whether they survived (Survived), their social-economic status (Pclass), their gender (Gender), Each CLC group member will start with a randomized 150 records. Please refer to the detailed instruction in the Excel file. 1.Collect: On the "DefineCollectRawData" tab, sort the "recordShuffler" column from smallest to largest (descending). Copy include the labels. 2.Organize: Paste the first randomized 150 records to the "OrganizeVisualizeDataset" tab. Create a pivot table. 3.Visualize: Create a bar chart of the pivot table 4.Analyze: Create a descriptive statistic of the "Fare" column. What is the average and standard deviation for the survivors? 5.Paste the data fromeach CLC memberinto the "SummaryResults" tab and perform descriptive statistics on the samples. T the group average. 6.Solution: What did you learn? Validate with Research.