10 Jul Individual Project 5
Question Description
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.
This assignment has 3 steps.
Step 1: Review the 3 videos at this site.
Use the information from the videos at the link above and what you learned in your intellipath lessons to help conduct this analysis and answer the questions that follow.
Step 2: 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:
Cut and paste the data from the table above into Microsoft Excel.
Click the Data tab and then the Data Analysis button to open the statistical analysis dialogue box.
Choose “ANOVA: Single Factor” as the type of analysis.
Click into the input range box, and then highlight all of the data (to include the headers) in the Group 1, Group 2, and Group 3 columns.
Click the Labels in First Row box to ensure Excel does not try to analyze the column headers as data.
Click the New Worksheet Ply button so that Excel spits the data output into a new worksheet.
Click “OK” to run the analysis.
Step 2: Answer the following questions using the analysis results that you generated:
What is the average years of education for Group 1 (Narcotics Investigators)?
What is the Average years of education for Group 3 (SWAT Officers)?
What is the p-value for your ANOVA model? Is the p-value greater than or less than 0.05?
Do you reject or accept the null hypothesis that states, “There is no difference between the groups in years of education.”
Why did you reject or accept the null hypothesis?
Which group, on average, has the most years of education?
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course materials.
Reference
Khan Academy. (2017). Analysis of variance (ANOVA) [Video file]. Retrieved from https://www.khanacademy.org/math/statistics-probab…
APA format for all references with 3 bring required.
Deliverable Length: 1,000 words
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.