Question: 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

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.

The data provided represents the 2020 enrolment data for students at a

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%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

this question has 3 parts.. This is part one and as i will need part 2 and part 3 as well How is the data insufficient.. The datat is provided in the question Candace Communications reported the...

Information The final project is designed to incorporate many of the techniques we have learned throughout the course and also to enhance your ability to communicate findings derived from data...

Caroline Communications reported the figures from its adjusted trial balance and from its multi-step income statement for its first year of business, which ended on July 31, 2024: (Click the icon to...

The final project is designed to incorporate many of the techniques we have learned throughout the course and also to enhance your ability to communicate findings derived from data analysis. The data...

this question has 3 parts.. This is part one and as i will need part 2 and part 3 as well Candace Communications reported the figures from its adjusted trial balance and from its multi-step income...

\begin{tabular}{|lrlr|} \hline Cash & $3,300 & Cost of Goods Sold & $18,800 \\ Selling Expenses & 1,500 & Equipment, net & 8,600 \\ Accounts Payable & 4,600 & Salaries Payable & 2,100 \\ Carrie,...

practic Carolina Communications reported the figures from its adjusted trial balance and from its multi-step income statement for its first year of business, which ended on July 31, 2024: (Click the...

Study Purpose Anecdotally, we know that volunteers1 generate significant value through their contributions to OAA programs and SHIPs. However, to date, little or no information is available about the...

txt file 12 swa Elon 9 0 0 0 qae Les 0 0 10 0 swe Todd 0 9 7 0 qae Jamey 0 0 8 0 swm Jeff 0 0 0 9 swe John 0 9 9 0 swe Eric 0 10 9 0 qae Darrel 0 0 9 0 swe Ariel 0 9 10 0 qae Joanne 0 0 8 0 swa Tim...

Topic: Observations on a supermarket Instructions: 1. Preparation: Review the assigned learning materials to date (Modules 1 to 4). Gather numeric primary research data through passive observational...

List four examples of feedback you can give to a speaker that would indicate you understand his or her message.

Irene is the Director of Sales in NED Technologies. The majority of the firm's business usually relies on a few major western European clients only. Since western Europe has been facing severe...

Autos arrive at a toll plaza located at the entrance to a bridge at a rate of 50 per minute during the 5:00-to-6:00 p.m. hour. If an auto has just arrived, a. what is the probability that the next...

11.15 Management has stated that it will tolerate one stockout per year. The forecast of annual demand for a particular SKU is 100,000 units, and it is ordered in quantities of 10,000 units. The lead...

5. Which metaphors do you mainly use when talking about organizations and companies? What do these metaphors express about an organization or a company? Are there other metaphors that may be more...

4. Using the same examples you gave in question 3, try to identify circular sequences, i.e. A affects B, but B also affects A.

6. Give three examples that nothing (doing nothing) can function as a cause.