Analysis of project data
jrshayma
AnalysisOfDataCollected.xlsxSheet1
| Police Station | Poor Frequency |
| A | 6 |
| B | 7 |
| C | 11 |
| D | 4 |
| E | 8 |
| F | 13 |
| G | 9 |
| H | 11 |
| I | 7 |
| J | 8 |
| Police Station | Wealthy Frequency |
| A | 0 |
| B | 2 |
| C | 1 |
| D | 5 |
| E | 4 |
| F | 4 |
| G | 1 |
| H | 2 |
| I | 4 |
| J | 0 |
Sheet2
Poor Frequency A B C D E F G H I J 6 7 11 4 8 13 9 11 7 8
Poor Frequency A B C D E F G H I J 6 7 11 4 8 13 9 11 7 8
Wealthy Frequency A B C D E F G H I J 0 2 1 5 4 4 1 2 4 0
Wealthy Frequency A B C D E F G H I J 0 2 1 5 4 4 1 2 4 0
Sheet3
| Class Interval Frequency Distribution | |||
| Age of Victims | Median | Frequency | |
| 0-10 | 5 | 3 | |
| 10-2O | 15 | 4 | |
| 20-30 | 25 | 12 | |
| 30-40 | 35 | 23 | |
| 40-50 | 45 | 16 | |
| 50-60 | 55 | 15 | |
| 60-70 | 65 | 12 | |
| 70-80 | 75 | 14 | |
| 80-90 | 85 | 7 | |
| 90-100 | 95 | 1 |
Sheet4
| Frequency Polygon of the Data |
Frequency Polygon
Frequency 5 15 25 35 45 55 65 75 85 95 3 4 12 23 16 15 12 14 7 1
