A Statistical Analysis & ML workflow of Titanic Sort the passenger information based on passenger$$s name $($A to Z$).$

$4.$ Replace $3$ with $$Lower$,2$ with $$Middle$,$ and $1$ with $$Upper$$ in $$Passenger Class$$ field.

$5.$ Replace $$S$$ with $$Southampton$,$Q$$ with $$Queenstown$,$ and $$C$$ with $$Cherbourg$$ in

$$Embarked$$ field.

$6.$ How many male passengers did survive?

$7.$ How many female passengers did survive?

$8.$ How many female passengers did survive from upper class?

$9.$ What is the average age of male passengers in lower class?

$10.$ What is the average fare for female passengers in upper class?

$11.$ What is the maximum fare?

$12.$ What is the minimum fare?

Course Number & Title: MGT$3050$ Management Information Systems

Semester: Fall $2024$

Professor: Dr$.$ Mehmet Turkoz