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:SubjectGroup 1Group 2Group 311214182141218314141841414175121620618181671218128131614919181210121612For 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 = DoctorateSteps 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.ReferenceKhan 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

As a business leader, you would likely utilize a variety of theories, models, and applications in order to create a comprehensive approach to business strategy planning. Consider the following scenario: You are working with a department that has decided to incorporate the 7 S Model to enact change within the organization. As a business leader, you are to evaluate this model within a proposal, including potential benefits and examples of effective implementation.To prepare for this Discussion, review the section entitled “Alignment: The 7 S Model” on pages 239–244 in Dyer, Godfrey, Jensen, and Bryce (2016) and consider which components of the model might be the most beneficial in executing change within an organization. You may also want to utilize the Walden Library to identify scholarly examples of implementing the 7 S Model in professional contexts.By Day 3Post an evaluation of the 7 S Model as a tool for planning and executing change with an organization. Your evaluation should include the following: A description of the value of each step within the 7 S model to implementing change with the organization, including at least one supportive exampleAn analysis of which one or two specific component(s) of the 7 S Model could be most helpful from a change management perspective, including at least one supportive exampleAn explanation for which specific component(s) of the 7 S Model could be most challenging when implementing organizational change, including at least one supportive exampleBe sure to support your work with a minimum of two specific APA citations from this week’s Learning Resources and at least one additional scholarly source.Refer to the Week 4 Discussion Rubric for specific grading elements and criteria. Your Instructor will use this rubric to assess your work.Read a selection of your colleagues’ postings. By Day 5Respond to at least two of your colleagues’ postings in one or more of the following ways: Compare your initial posting with that of your colleague, including insights on the 7 S Model’s use for executing change within an organization.In what ways do you agree or disagree with your colleague on the value of the 7 S Model components, and how can this enhance or expand on your understanding of strategic planning?Provide a suggestion for an additional alternative for using the 7 S Model to execute change to better support your colleague’s posting, including a rationale for your suggestion.Please note that, for each response, you must include a minimum of one appropriately cited scholarly reference.Return to this Discussion in a few days to read the responses to your initial posting. Note what insights you gained as a result of reading the comments your colleagues made.Required ReadingsDyer, J. H., Godfrey, P., Jensen, R., & Bryce, D. (2016). Strategic management: Concepts and tools for creating real world strategy. Hoboken, NJ: John Wiley & Sons. Chapter 12: “Implementing Strategy” (pp. 236–255)Case 07: “Nike: Sourcing and Strategy in Athletic Footwear” (pp. C-62–C-69)Case 08: “AT&T and Apple: A Strategic Alliance” (pp. C-70–C-81)Case 10: “New Business Models: Netflix, Redbox, Hulu, and Others in Home Movie Entertainment” (pp. C-92–C-100)Case 11: “Smartphone Wars” (pp. C-101–C-111)Buller, P. F., & McEvoy, G. M. (2012). Strategy, human resource management and performance: Sharpening line of sight. Human Resource Management Review, 22(1), 43–56. doi:10.1016/j.hrmr.2011.11.002Note: Retrieved from the Walden Library databases.Chen, Y., Yu, Z., & Lin, T. W. (2015). How Zysco uses the balanced scorecard. Strategic Finance, 97(1), 27–36. Retrieved from http://www.imanet.org/resources-publications/strat...Note: Retrieved from the Walden Library databases.Peters, T. (2011). McKinsey 7-S model. Leadership Excellence Essentials, 28(10), 7. Retrieved from http://www.hr.com/en/topleaders/top_leaders_in_lea...Note: Retrieved from the Walden Library databases.