View attached explanation and answer. Let me know if you have any questions.

CLC - Titanic Survival: Exploratory Data Analysis

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 su

You will use the DCOVAS framework. Reference Reading: The Statistician In You: Simple Everyday Life-Hacks (TSIY)
• 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)

3.

Visualize: Create a bar chart of the pivot table (refer to Chapter 4 in TSIY).

6.

Solution: Create and submit one PowerPoint and the combined Excel file.

Putting It All Together:

1.
2.
3.
4.

Create a roles and responsibility slide.
Introduction Slide (Define): Define the problem
Collect Slide: Describe the process to collect your group's data with emphasis on randomization.
Organize and Visualize Slides: Include your pivot tables and bar charts.

7.

References: Cite two or more sources.

Deliverables
As a group, one person needs to submit:

•

One group PowerPoint presentation (8-12 slides) include all the components listed in the "Tasks" section.

Instructions for Pivot Table:

Instructions for Descriptive Statistics: Click on Insert => Data Analysis => Descriptive Statistics

CLC - Titanic Survival: Exploratory Data Analysis

Overview

The sinking of the Titanic is one of the most infamous shipwrecks in history.
On April 15, 1912, during her maiden voyage, the widely considered “unsinkable” RMS Titanic sank after colliding
with an iceberg. Unfortunately, there weren’t enough lifeboats for everyone onboard, resulting in the death of
While there was some element of luck involved in surviving, it seems some groups of people were more likely to survive than
In this Collaborative Learning Community (CLC) assignment, you will work as a group and explore the Titanic
passenger sample dataset to answer the questions: what sorts of people were more likely to survive using
You will use the DCOVAS framework. Reference Reading: The Statistician In You: Simple Everyday Life-Hacks (TSIY).
• 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

Variable
Survived
Pclass
Gender
Age
Fare
Variable
pclass

Variable Definition
Definition
Key
Survival
0 = No, 1 = Yes
Ticket class
1 = 1st, 2 = 2nd, 3 = 3rd
Sex
male, female
Age in years
Passenger fare
Variable Notes
Notes
A proxy for socio-economic status (SES)

Data Set
The "CLC - Titanic Survival: Exploratory Data Analysis" Excel spreadsheet contains data for 700 of the real Titanic
passengers. Each row represents one person. The columns describe different attributes about the passengers
including whether they survived (Survived), their social-economic status (Pclass), their gender (Gender), their age
(Age), and the fare they paid (Fare).

Tasks (All students must complete this section individually)
1. Collect: On the "DefineCollectRawData" tab, sort the "recordShuffler" column from smallest to largest
(descending). Copy the first randomized 150 rows of raw data (only Column C to G). Do not 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 (refer to Chapter 4 in TSIY).
4. Analyze: Create a descriptive statistic of the "Fare" column. What is the average and standard deviation for
the survivors? Compare your results with a Titanic research fact (refer to Chapter 4.1 in TSIY).
5. Paste the data from each CLC member into the "SummaryResults" tab and perform descriptive statistics on
this new increased sample size. Then, complete the table. Note: Compare individual group member results to
6. Solution: Create and submit one PowerPoint and the combined Excel file.

Putting It All Together:

As a group, prepare and submit ONE group PowerPoint presentation (8-12 slides) based upon the combined
group analysis, calculations, and conclusions data set. The presentation should include speaker notes and
address the following:
1. Create a roles and responsibility slide.
2. Introduction Slide (Define): Define the problem
3. Collect Slide: Describe the process to collect your group's data with emphasis on randomization.
4. Organize and Visualize Slides: Include your pivot tables and bar charts.
5. Analyze Slides: Compare your group's averages and standard deviations. Explain the differences in a
6. Conclusion: Compare and contrast your group's results and validate it with Titanic research fact(s). The
rainbow is a sign (solution) that the earth will never completely flood again. What is your group’s
7. References: Cite two or more sources.

Deliverables
As a group, one person needs to submit:
• The Excel worksheet containing each individual group members calculations as well as the combined data
and completed summary table from the "SummaryResults" tab. Each student’s Excel file with all the tables,
• One group PowerPoint presentation (8-12 slides) include all the components listed in the "Tasks" section.
Instructions for Pivot Table:

Instructions for Descriptive Statistics: Click on Insert => Data Analysis => Descriptive Statistics

re likely to survive than others.

PassengerId
127
93
174
380
570
663
288
614
585
540
443
313
34
453
375
224
632
543
181
269
627
392
268
141
285
491
366
588
377
61
602
565
230
250
528
496
421
417
45
97
98
466
422
700
198
78

Name
Survived
Corn, Mr. Harry
0
Baxter, Mr. Quigg Edmond
0
Bazzani, Miss. Albina
1
Rouse, Mr. Richard Henry
0
Hodges, Mr. Henry Price
0
Mudd, Mr. Thomas Charles
0
Adahl, Mr. Mauritz Nils Martin
0
Emanuel, Miss. Virginia Ethel
1
McNamee, Mr. Neal
0
Fischer, Mr. Eberhard Thelander
0
Davies, Mr. Alfred J
0
Johansson, Mr. Erik
0
Laroche, Miss. Simonne Marie Anne Andree 1
Silvey, Mrs. William Baird (Alice Munger)
1
Renouf, Mr. Peter Henry
0
de Pelsmaeker, Mr. Alfons
0
Ponesell, Mr. Martin
0
Karun, Miss. Manca
1
Mellors, Mr. William John
1
Navratil, Master. Edmond Roger
1
Otter, Mr. Richard
0
Allison, Mrs. Hudson J C (Bessie Waldo Daniels)0
Blackwell, Mr. Stephen Weart
0
Klasen, Mr. Klas Albin
0
del Carlo, Mr. Sebastiano
0
Longley, Miss. Gretchen Fiske
1
Gee, Mr. Arthur H
0
Abbott, Mr. Rossmore Edward
0
Karlsson, Mr. Nils August
0
Waelens, Mr. Achille
0
Nirva, Mr. Iisakki Antino Aijo
0
Troutt, Miss. Edwina Celia "Winnie"
1
Connolly, Miss. Kate
1
Moraweck, Dr. Ernest
0
Edvardsson, Mr. Gustaf Hjalmar
0
Skoog, Miss. Mabel
0
Butt, Major. Archibald Willingham
0
Quick, Miss. Phyllis May
1
Goodwin, Master. William Frederick
0
Webber, Miss. Susan
1
White, Mr. Percival Wayland
0
Chapman, Mr. John Henry
0
LeRoy, Miss. Bertha
1
Sutehall, Mr. Henry Jr
0
Hamalainen, Mrs. William (Anna)
1
Petranec, Miss. Matilda
0

Pclass
3
1
1
3
2
2
3
3
3
3
3
3
2
1
2
3
2
3
2
2
2
1
1
3
2
1
1
3
3
3
3
2
3
2
3
3
1
2
3
2
1
2
1
3
2
3

Gender
male
male
female
male
male
male
male
female
male
male
male
male
female
female
male
male
male
female
male
male
male
female
male
male
male
female
male
male
male
male
male
female
female
male
male
female
male
female
male
female
male
male
female
male
female
female

Age

Fare
30
8.05
24 247.5208
32 76.2917
50
8.05
50
13
16
10.5
30
7.25
5
12.475
24
16.1
18
7.7958
24
24.15
22
7.7958
3 41.5792
39
55.9
34
21
16
9.5
34
13
4 13.4167
19
10.5
2
26
39
13
25
151.55
45
35.5
18
7.8542
29 27.7208
21 77.9583
47
38.5
16
20.25
22
7.5208
22
9
41
7.125
27
10.5
22
7.75
54
14
18
7.775
9
27.9
45
26.55
2
26
11
46.9
32
13
54 77.2875
37
26
30 106.425
25
7.05
24
14.5
28
7.8958

140
75
478
558
550
690
131
447
395
566
128
194
472
651
435
201
178
360
316
80
541
653
586
572
62
83
555
52
158
501
642
444
697
291
290
241
125
336
54
190
634
26
77
352
355
308
72

Smith, Mr. James Clinch
0
Greenfield, Mr. William Bertram
1
Brocklebank, Mr. William Alfred
0
Cleaver, Miss. Alice
1
Astor, Mrs. John Jacob (Madeleine Talmadge Force)
...