nBuild a spreadsheet per template – complete each column of the spreadsheet to arrive at the desired calculations
nUse Excel tools (Countif and the Sum function to do the math) to summarize the data
nUse Excel tools to calculate mean, median, and mode for the categories of data, and derive the deviation, variance, and dispersion, and distribution
nUse the Analysis Toolpak to do those same functions
nCreate a chart in separate tab and create a histogram in a separate tab
nPrepare a short essay summary of your findings
"Are you looking for this answer? We can Help click Order Now"