Question

Below is a Proper Data Set of classes that Business students have taken at Highline. Each line or record in the Table represents a class that a student took at Highline. There are 227 Rows (Records) in the Table. The Quarter Column represents the quarter the class was taken The Year Column represents the quarter the class was taken The Department Column represents the quarter the class was taken The Class # Column represents the quarter the class was taken The Credits Column represents the quarter the class was taken The Grade Column represents the quarter the class was taken Using a PivotTable, create a Joint Probability Table for the variables (Column) Department and Quarter).

From the Joint Probability Table answer the following questions:

What is the probability that a randomly selected Business Student would take a Accgt class in Summer? Place answer in green cell to right ==>>

What is the probability that a randomly selected Business Student would take a BUSN class OR a Summer Class? Place answer in green cell to right ==>>

Quarter	Year	Department	Class #	Credits	Grade
Sum	2015	MATH	97	5	3.2
Spring	2016	BUSN	210	5	4
Sum	2016	ECON	201	5	2.2
Spring	2016	BUSN	101	5	1.8
Spring	2016	MATH	148	5	2
Winter	2016	ECON	202	5	2
Fall	2016	Accgt	133	3	3.4
Spring	2016	Accgt	102	5	1.8
Winter	2016	Accgt	135	5	3
Winter	2016	Accgt	216	5	3.6
Fall	2016	Accgt	205	5	2.4
Spring	2016	Accgt	268	5	3.6
Spring	2017	COMM	101	5	3.1
Fall	2017	ENGL	101	5	2.6
Spring	2017	BUSN	218	5	3.1
Fall	2017	BUSN	190	5	2.7

Answer 1

There are supposed to be 227 Rows (Records) in the Table, but but only 16 records have been pasted. Please follow the following procedure by selecting all the 227 rows. The results obtained would be different.

Steps to create the Joint Probability Table for the variables (Column) Department and Quarter) using Pivot table.

Select data and choose insert--->pivot tables

Press OK. Then in the PivotTable Fields, drag department to the rows , Quarters to the columns and department to "sum values"

  

click on the arrow on Count of Department and pick value Field settings

make sure that the summarize Values by shows "count" and set the show values to "% of grand total"

Get this

The above is the Joint Probability Table for the variables (Column) Department and Quarter). These values are only indicative as all the 227 records are not used.

We can format the above by changing the name "Grand total" to "Marginal probability" and change the format to "number" from "percentages" and get the following

Now we can answer the following

the probability that a randomly selected Business Student would take a Accgt class in Summer is the joint probability

The value in the cell corresponding to this is

In this case the value is

ans: the probability that a randomly selected Business Student would take a Accgt class in Summer is 0 (Obviously this would change when you add all the 227 rows)

What is the probability that a randomly selected Business Student would take a BUSN class OR a Summer Class?

the probability that a randomly selected Business Student would take a BUSN class OR a Summer Class is

We can get the values for these from the table

We can get

ans: the probability that a randomly selected Business Student would take a BUSN class OR a Summer Class is 0.375 (update this answer using 227 rows)