CIPD data

Section A
Take Question 1 as an example; the question which was asked is:
Q1. Is your organisation planning to recruit employees in the next THREE months?
The first thing to note is that the question is asked of an ORGANISATION (or lots of organisations).
What possible answers do you think an individual organisation may have given? I think the possibilities are:
Yes, No, and Don’t know
So, is this data qualitative or quantitative?
I hope you will agree that is qualitative.
Next, let’s look at some of the figures we are given. The table below is the data for Question 1. What does the figure of 532 highlighted in yellow tell you?

Would you agree that 532 organisations in the Private sector said “Yes” their organisation is planning to recruit employees in the next 3 months?
Next, what calculations can you do on this data?
Again, I hope you would agree that there is not much you can do in terms of calculations as the data is qualitative. So, what can you actually do with this data?
Before you proceed, make sure you do some simple calculations to make sure you really understand the data.
If you consider the Public sector labelled B (and highlighted in green), the numbers 217, 94, and 38 represent all the organisations in the Public sector which responded to the survey. How many organisations is this in total? I think it is (217 + 94 +38 = 349). This is the “Base” value. I am not sure what the Unweighted Base values are, and I would therefore not include them in my calculations.
Next let us look at the figures highlighted in blue. They represent “Private sector SME (2-249)” and “Private sector large (250+)”. The Base counts for Private sector SME and Private Sector Large are 708 and 852 respectively. So, what is the total number of organisations in the Private sector which responded? I think it is (708 + 852 = 1560). Would you agree? This is the figure which is highlighted in orange (as you would expect I hope).
Given that the actual data is “Yes”, “No” and “I don’t know”, and the figures in the table are counts, one thing we could do is calculate proportions (or percentages) to make comparisons easier.
As an example, what percentage of the Private sector, responded “Yes” to this question?
The calculation should be (532/1560 = 34%). Similar calculations can be done with other data in the table. You would be expected to set out these calculations in Excel with appropriate headings, etc. and using relative and absolute addressing wherever possible.
Once appropriate calculations have been set up, you can display the results in the form of charts – bar charts, pie charts, etc.
Section B
Let us look at another question now. Question 3a is:
Q3a. To what extent will these redundancies affect your overall headcount over the next three months?
The results are given in the table below:

As an example, let us consider the figure of 53 highlighted in gold. What does this figure tell us?
Would you agree that 53 organisations in the Private sector said these redundancies would affect their overall headcount over the next 3 months by between 20.01% to 30%?
So what can we do with the information in this table? Well, this will depend on whether the data is qualitative or quantitative. Which one do you think a response of “between 20.01% to 30%” is? I would argue this is quantitative data. So, we can work out things like the mean, median, mode, standard deviation.