Explore the data provided in order to gain an understanding of the information required by the Government.

  102 Orders

Using Data to Build Business Practice - BSS004-1 

Assignment 2 – CIPD Data Analysis

Unit title & code

Using Data to Build Business Practice - BSS004-1

Assignment number and title

Assignment 2 – CIPD data analysis

Assessment type

Report + Excel file

Weighting of assessment


Size or length of assessment

2500 word report + Excel file

Unit learning outcomes

  1. Identify data requirements and the appropriate data collection instruments required for effective business decision making
  2. Conduct appropriate analysis and clearly communicate findings to a stated audience

What am I required to do in this assignment?

You have been provided with an edited subset of survey data collected and analysed by YouGov plc. for The Chartered Institute 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 public sector and the private 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 private sector and the public sector.
    1. Explore the data provided in order to gain an understanding of the information required by the Government.
    2. Select the questions you wish to analyse to provide the information required.
    3. Analyse the data for your selected questions using appropriate summary statistic in a spreadsheet.
    4. Highlight interesting findings.
    5. Make recommendations to the Government about the possible impact of Brexit and the proposed new immigration system on organisations.
  1. 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

The quoted price covers up to 3000 words. For custom requirements Live Chat or Whatsapp Click Here


Email: [email protected]

100% Plagiarism Free & Custom Written, Tailored to your instructions

Our Giveaways

Plagiarism Report

for د.إ50 Free


for د.إ32 Free

Title page

for د.إ20 Free


for د.إ36 Free


for د.إ19 Free

Limitless Amendments

for د.إ38 Free

Get all these features for
د.إ195.00 FREE

assignment bank giveaways

Our Ratings