Quantitive Analysis

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