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
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer