Your police agency is interested in understanding whether there is a difference in education level among police officers in different specializations, such as Narcotics Investigations, Traffic Enforcement, and SWAT. This type of information can help determine whether particular educational backgrounds are more likely to end up in particular units, which could be helpful for recruiting and diversity purposes. One way to investigate this is through an analysis of variance (ANOVA). ANOVA is a type of analysis that helps determine whether there are differences on a continuous variable (such as years of education) among different categories or groups (such as police unit).
You have been tasked with conducting a study comparing the years of education completed between different officer specialization groups. Group1 is Narcotics Investigators, Group 2 is Traffic Enforcement Officers, and Group 3 is SWAT Officers.
Step 1: Follow the instructions below to conduct the ANOVA in Microsoft Excel. The data you will use is in the following table:
Subject | Group 1 | Group 2 | Group 3 |
1 | 12 | 14 | 18 |
2 | 14 | 12 | 18 |
3 | 14 | 14 | 18 |
4 | 14 | 14 | 17 |
5 | 12 | 16 | 20 |
6 | 18 | 18 | 16 |
7 | 12 | 18 | 12 |
8 | 13 | 16 | 14 |
9 | 19 | 18 | 12 |
10 | 12 | 16 | 12 |
For reference: Group1 = Narcotics Investigators, Group 2 = Traffic Enforcement Officers, Group 3 = SWAT Officers; 12 = high school/GED, 14 = Associate’s, 16 = Bachelor’s, 18 = Master’s, and 20 = Doctorate
Steps for analysis in Excel:
Step 2: Answer the following questions using the analysis results that you generated:
700-1000 words, APA Format