pls, I need help with these questions, you can take your time on doing it. pls screenshot on the process you used with excel to do it will help me to complete the rest of the assignment because I can only share 10 data input per row and I have 8k more to work on thanks.

(iv) Plot a scatter plot for attribute num_engs and height. What do you infer from this plot (any interesting findings)? (5 points) Hint: use Data ->Add-in Data Analysis ->histogram Define your bin width properly

(v) Compute the contingency matrix for the attributes phase_of_flt and time_of_day. Infer this contingency matrix based on the row proportion and column proportions. (4 points)

opid	operator	phase_of_flt	ac_mass	num_engs	time_of_day	state	height	speed	effect	sky	species
BUS	BUSINESS	Climb	2	2	Day	MN	180	125	None	No Cloud	AMERICAN BLACK DUCK
VJA	VALUJET	Climb	4	2	Night	LA	600	180	Engine Shut Down	No Cloud	AMERICAN COOT
PVT	PRIVATELY OWNED	Approach	1	1	Night	WV	1800	140	None	No Cloud	AMERICAN COOT
QXE	HORIZON AIR	Approach	2	2	Day	ID	75	111	None	Overcast	AMERICAN COOT
PVT	PRIVATELY OWNED	Climb	1	1	Day	OH	70	65	None	No Cloud	AMERICAN CROW
GAA	BUSINESS EXPRESS	Landing Roll	3	2	Day	NY	0	90	None	No Cloud	AMERICAN CROW
AAL	AMERICAN AIRLINES	Landing Roll	4	3	Day	OH	0	105	None	No Cloud	AMERICAN CROW
USA	US AIRWAYS	Landing Roll	4	2	Day	NY	0	110	None	No Cloud	AMERICAN CROW
PVT	PRIVATELY OWNED	Approach	1	2	Day	TX	300	110	None	No Cloud	AMERICAN CROW
COM	COMAIR AIRLINES	Climb	3	2	Day	DC	30	120	None	No Cloud	AMERICAN CROW