Highlights
Task
Assignment 2 CIPD data analysis You have been provided with an edited subset of survey data collected and analysed by YouGov plc. for The Chartered Insititute of Personnel and Development and The Adecco Group. The data was collected between the dates of 25/03/2020 to 07/04/2020. The research department of a university business school has undertaken some consultancy work for the Government. The Government is interested in assessing the impact of Brexit on UK organisation s recruitment processes and making a comparison between the education sector and the healthcare sector. The Government is therefore interested in examining whether organisations are planning to grow or shrink their workforce, where the potential markets for new staff are seen to be, and whether a new points based immigration system would be seen as problematic in operation.Your tasks: 1. Analyse data on both education sector and the healthcare sector. a. Explore the data provided in order to gain an understanding of the information required by the Government. b. Select the questions you wish to analyse to provide the information required. c. Analyse the data for your selected questions using appropriate summary statistic in a spreadsheet. d. Highlight interesting findings. e. Make recommendations to the Government about the possible impact of Brexit and the proposed new immigration system on organisations. 2. Present your work in the form of a report in Word. Submit your analysis in an Excel file which could be used for further investigation. Suggested steps: ? Extract the required data and place it a new Excel file. ? Familiarise yourself with the data by using Excel s facilities like sorting, filtering, pivot table, etc. ? Pick particular aspects that you want to conduct further, more detailed analysis on. ? Conduct a visual examination of the data by plotting appropriate charts. ? Calculate some standard statistics (e.g., mean, median, mode, range, standard deviation, etc.). ? Conduct additional analysis that you feel is appropriate to address the tasks What do I need to do to pass? (Threshold Expectations from UIF) ? Demonstrate competence in a range of skills in Excel including charting and use of functions ? Select appropriate techniques to explore and summarise a given dataset ? Highlight and communicate results to the relevant audience
This Statistics Assignment has been solved by our Statistics Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.