Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider this dataset which includes information about passengers of the Titanic. Create a Jupyter notebook file that contains the following: Python code to clean the

Consider this dataset which includes information about passengers of the Titanic.

Create a Jupyter notebook file that contains the following:

  1. Python code to clean the data, remove any missing values, then find the mean, median, mode, standard deviation, and variance of each numerical column in the dataset.
  2. As the dataset doesnt contain the weight of adult passengers who were on the ship, and given the fact that the average weight of adults between ages 20 and 50 is 90kg (with a 50kg variance), write Python code to generate a number of weights equal to the number of records in the dataset using normal distribution that simulates the actual population.
  3. Find the probability of having someone of a weight less than 50kg.
  4. Find the probability of having someone of a weight between 100kg and 120kg.
  5. Find the probability of having someone of a weight thats exactly 77.7kg.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Databases With PostgreSQL From Novice To Professional

Authors: Richard Stones, Neil Matthew

2nd Edition

1590594789, 978-1590594780

More Books

Students also viewed these Databases questions

Question

What is the role of the data processing?

Answered: 1 week ago