Complete your analysis (Parts 1–3) on one Excel sheet. Include the following components in your analysis of the data.
Part 1: Questions 1, 2, 3, and 4 (Binary Questions)
Each question 1–4 should have the following elements:
- Sample size.
- Sample proportion of each response.
- Bar chart or pie chart.
Part 2: Questions 5 and 6 (Quantitative Questions)
Questions 5 and 6 should have the following elements:
- Sample mean.
- Sample median.
- Sample mode.
- Sample range.
- Sample standard deviation.
- Sample minimum and maximum.
- Histogram.
Part 3: Exploration of Data
Next, explore your data a bit further. What are two interesting findings from your survey responses? You might investigate responses for selected variables based on responses to your binomial questions. For example, if the answer to question 1 was Male or Female and to question 6 was Annual Income, you might examine average annual income for males only and females only and compare these results. Present your findings in an appropriate table, graph, or chart. Then write, in the same Excel spreadsheet, a 1–2 paragraph summary of your findings.
