The data provided represents the 2020 enrolment data for students at a popular inner-city Brisbane university in Bachelor programs.

a.From the data, construct a pivot table and createa cross tabulation showing the number of male and female students in each of the faculties. Note that uni-wide data represents double degree programs and can be included as a separate faculty designation. From that createa joint probability table ensuring that the results in the table meet all of the basic probability rules. Copy and Paste that table in your solution document.

b.From the joint probability table calculate the following:

I.What is the probability a randomly selected student is a health student?

II.What is the probability that a randomly selected student is a male law student?

III.What is the probability that a randomly selected student is a female student or a creative industries student?

IV.If you were to randomly select a female student, what is the probability they are enrolled in a health course?

V.From the data, can we say that gender and course selection are independent? Explain why or why not.

Pivot table: Sum of Student Column Labels Grand Row Labels Female Male (blank) Total Business School 1236268 1355009 2591277 Creative Industries 1035052 524462 1559514 Education 149434 7692 157126 Health 2032870 776569 2809439 Law 81989 27465 109454 Science and Engineering 450163 1849855 2300018 Uni-Wide 193256 183391 376647 (blank) Grand Total 5179032 4724443 9903475 Joint probability table: Joint probability table Column Labels Grand Row Labels Female Male (blank) Total Business School 12.48% 13.68% 0.00% 26.17% Creative Industries 10.45% 5.30% 0.00% 15.75% Education 1.51% 0.08% 0.00% 1.59% Health 20.53% 7.84% 0.00% 28.37% Law 0.83% 0.28% 0.00% 1.11% Science and Engineering 4.55% 18.68% 0.00% 23.22% Uni-Wide 1.95% 1.85% 0.00% 3.80% (blank) 0.00% 0.00% 0.00% 0.00% Grand Total 52.30% 47.70% 0.00% 100.00%