Statistics are summaries of your dataLook at what Excel can do for youHappy Hideaways needs your helpHere’s what we’ll doWelcome to ExcelThe data’s held in a rangeLet’s convert the range to a tableExcel tables have superpowersLet’s analyze the approval ratings......by inserting a PivotTableYou need to tell the PivotTable what to displayHow to show the approval rating frequenciesExcel adds default headings to PivotTablesYou can change the headings and labelsYou can change a PivotTable’s calculationWhy use a chart?Let’s insert a column chartThe chart shows the PivotTable’s dataColumn charts help you visualize the frequenciesYou can tweak the chart’s appearanceHow to update the chartFind the percentage of calls per categoryInsert the PivotTableExcel MagnetsExcel Magnets SolutionCalculating the category frequenciesWe want to show the frequencies as percentagesIntroducing the percentage frequencyHow to make a PivotTable show percentagesDisplay percentage frequencies using a pie chartWe need to analyze the call durationsInsert a new PivotTableHow to group data in a PivotTableWe need to show the running count......by finding the cumulative frequencyHow to make a PivotTable show a running totalDisplay cumulative frequencies on a line chartThe completed PivotTable and line chartCrosswordCrossword SolutionYour Statistics Toolbox