Somewhere on this sheet create a well made PivotTable to calculate the percentag

Question

Somewhere on this sheet create a well made PivotTable to calculate the percentage for each response. Then add two Slicers to the PivotTable for the Fields Division and Employment Status. Then in cell B5 show the percentage of NO responses given that respondent was a Full Time Faculty in the Business Department P(No | Business AND Full Time) Original Question: Should Advising be Mandatory? Made up data below: Employment Status Full Time Part Time Response Division Business cience Humanities Full Time Business Humanities Part Time Humanities Full Time Humanities Full Time Business cience cience cience Business Business cience Humanities Full Time Rusiness Full Time Not Sure Yes Yes Yes Part Time Part Time Full Time Part Time One Year Contract Part Time One Year Contract Not Sure Yes Yes Not Sure Yes, but I need more information Yes Yes hut Ineed more information Part Time

Explanation / Answer

No of observations with Business and Full Time = 2

and One Response is No and other is Not sure

P(No/Business and Full Time) = 1/2

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.