How to analyze Likert Scale data using a Pivot Table in Excel

[@nabeelakhtarr]

Analyze Likert Scale Data Using a Pivot table in Excel.

[@chrisglifts]

how do i get grand total to reflect on just our single question, such as what responses contribute to 100% of a certain question, not entire test.

[@nabeelakhtarr]

Well, it is showing the grand total for each question. Watch again starting with the 4:02 marker.