Use the data gathered in the Citizen Survey spreadsheet and calculate the mean, median, mode, and
standard deviation based on the data provided. Each team member should calculate a survey question.
Create an Excel document with the calculations.
Write a 700 to 1050-word paper that answers the following questions:
- Why was each question chosen for analysis and what did the results tell you?
- Was the question a good question or not and why?If you would change any of the questions, how and
why
would you change them?
- Did any of the answers or data surprise you?Anything significant that you identified?
- How could the results contribute to policy development?
Combine all calculations into a single Excel document for submission.
Sample Solution