I need solution for this question Using pivot tables and slicers to describe data. The file named Analyzesurveydata.xlsx contains answers on a $1-7$ scale to various questions on a teaching evaluation survey. Create a pivot chart that charts for each question the fraction of the time each value $17)$

$.$ Then filter the chart to show the breakdown for any set of three questions you choose. Step $1$ Count how many responses $1-5$ each question. Step $2$ determine percentage responses for each question. Step $3$ Filter to show subset of questions.