The next four tables are summaries from a neighborhood survey. Use the information in the tables to write
2. The next four tables are summaries from a neighborhood survey. Use the information in the tables to write an Executive Summary that describes the results of the survey and neighborhood. What conclusions do you reach from the results? Your response may not exceed 15 sentences.
- For each table, use the frequency distributions to calculate Relative Frequency Distributions
- Plot a chart of the Relative Frequency Distribution for Table 1
- Plot a Stacked chart of the Relative Frequency Distribution for Table 2
- Using the Frequency or Relative Frequency values, calculate the Weighted Average Incomes for All Neighborhoods (Table I). Using your calculation, would you consider this neighborhood a low income or a high-income neighborhood? Explain your answers
- Using the Frequency or Relative Frequency values, calculate the Weighted Average Incomes for each Neighborhood (Table II). Which of the neighborhoods would you consider the lowest income neighborhood? Explain your answer?
TABLE 1 (All Neighborhoods)
| INCOME | Frequency |
Valid
Percent |
| LESS THAN $15,000 | 162 | |
| $15,000 - $24,999 | 338 | |
| $25,000 - $34,999 | 226 | |
| $35,000 - $44,999 | 174 | |
| $45,000 OR MORE | 100 |
TABLE 2 (Neighborhoods Compared)
| CROWN HEIGHTS, EAST NEW YORK |
PROSPECT
HEIGHTS / FLATBUSH |
BED-STUY / BUSHWICK | ||||
| INCOME | Count | % | Count | % | Count | % |
| LESS THAN $15,000 | 9 5 | 3 5 | 6 1 | |||
| $15,000 - $24,999 | 8 9 | 6 5 | 7 8 | |||
| $25,000 - $34,999 | 7 4 | 4 8 | 28 | |||
| $35,000 - $44,999 | 4 7 | 32 | 23 | |||
| $45,000 OR MORE | 35 | 2 0 | 10 | |||
Price: $8.93
Solution: The downloadable solution consists of 6 pages, 293 words and 2 charts.
Deliverable: Word Document
Deliverable: Word Document
