How the Results were obtained

Authors Avatar

Stephen Watt

Communications and Information Technology

Assessed Project Part 1 – Excel

Report

Word count 858 words

How the Results were obtained

Firstly the data was sorted in ascending order by the categories ‘male’ and ‘married’.  This helped find where the boundaries for the four categories were.  It was found that:

  • Single males lie between      3976-5664
  • Married males lie between    5665-7641
  • Single females lie between   1-1863
  • Married females lie between 1864-3975

Using the ‘count if’ function within the range of f3976: f5644 the number of cells which contained 1 were counted this displayed the number of single male respondents who were self-employed.  In the cell below, for the same, the cells containing 2 were counted this showed the number of single male respondents who were employed.  This was completed for all of the 16 cells.

As a check the sum of each column was taken and matched against the number of respondents in each gender and marital status category.  As a double check the sum totals were taken and checked against the total number of respondents.

For the second section the distribution of length of Unemployment over Gender and marital status was calculated.  Again the data was sorted but this time by ‘male’, ‘married’ and ‘status’ so the unemployed respondents could be easily distinguished.  This time the range was different, as it was only information from unemployed respondents being used.

Join now!

There are 91 days in a quarter.  Therefore again using the ‘count if’ function, for single males, the cells in the range of 5112:5271 in the tenure row (row G) were counted if the value contained within was less than or equal to 91.  For ‘more than one quarter but less than two quarters’ the cells were counted if they were less than or equal to 182 minus the number in the cell above.  For example the formula in cell B7652 is “=COUNTIF(G5112:G5271,"<=182")-B7651”.  This method of counting if less than the number of days in the highest quarter then ...

This is a preview of the whole essay