(a.) Determine the following and present in a table below on MS Excel spreadsheet. Male Female Intersex County with the highest number of County with the least number of Average population of per county Standard deviation Coefficient of variation Total [6] (b.) Draw a well labelled chart to show how population varies by county. [3] (c.) Show using some graphical aid that there is correlation between the number of males and females in a county. [2] (d.) Sorted from the highest population to the least population per county answer the following questions. i. What number of counties constitute 10% of Kenya's population? II. What number of counties constitute 50% of Kenya's population? Revenue allocated to county | = 0.50 proportion of county population to country population + 0.35* proportion of county (1- relative poverty index) of total + 0.15* proportion of county land area to total country land area [11 [1] (e.) Assuming that the commission for revenue allocation uses the following formula to determine budget