Q1 . (17 marks) a. Classify the variables Age, No. of children, Farming status and annual prot from farming. (2 marks) b. Construct a grouped frequency distribution for the variable Age using 7 classes. (4 marks) c. Produce a histogram for grouped frequency distribution in part b. Give appropriate riiie and iabei to axis. (3 marks) d. Discuss the Histogram result, is there a serious problem in sugar industry regarding farmers age? lfyes than recommend a suitable way to minimize Hiisprobiem. (2 marks) e. Produce an ogive for grouped frequency distribution in part b. Give appropriate ride and iabe! to axis. (3 marks) f. Construct a Pie chart for variable Farming status. Any observations? (3 marks) Q2. (16 marks) Create a new column titled \"Level of education\" with following criteria: a all the farmers Education(years) less than equal to eight label it as primary I all the farmers Education(years) greater than B and less than equal to 13 label it secondary. . all the farmers Education(years) greaterthan 13 label it as tertiary. (2 marks) Now create a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output i cultivated area). (1 mark) a. Calculate the descriptive statistics using MS-Excel for cane output per acre based for farmers with primary education and for farmers with secondary education. (Hint: ignore non-numeric cells in computing). Interpret the following statistic (Mean, Median, Mode, Standard Deviation) obtained for farmers with primary education. (7 marks) b. What conclusion can be reach from the comparison of descriptive statistics between cane output per acre for farmers with primary education and for farmers with secondary education? Justify why or why note there is significant difference in output? (1 marks) c. Construct a box plot for cane output per acre based for farmers with primary education and for farmers with secondary education. Interpret the boxplots. (4 marks) Q3. (14 marks) Construct a contingency table and relative contingency table (using Pivot table tool in Excel) for farming status in raw and land Owned in column. (4 marks) a. What is the probability that a randomly selected farmer does not own the land? (1 mark) b. What is the probability that a randomly selected farmer is working full time and does not own the land? (1 mark) c. What is the probability that a randomly selected farmer is working full time or does not own the land? (2 mark) a. What is the probability that a randomly selected farmer does not own the land given that farming status is full time? (2 mark) b. Are the events \"does not own the land\" and \"farming status is ll] time\" independent? (2 mark) c. What can you conclude from above analysis in regards to land ownership in sugar industry? (2 marks) Q4. (3 marks) Assume that the annual prot from farming is approximately normally distributed with a mean of $1940 and standard deviation of $1700. Individual earning less than $2000 is believed to be in poverty. Calculate what proportion of sugar cane farmers are in Fiji are in poverty