Ay, farm survey [protected View] Q2. (1l marks) Create a new column titled "Level of education" with following criteria: - all the farmers Education(years) less than equal to eight label it as primary - all the farmers Education(years) greater than 8 and less than equal to 13 label it secondary. - all the farmers Education(years) greater than 13 label it as tertiary. (1 marks) Now create a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output / 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? (2 marks) VIEW Be careful- files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing ley [Protected View] i. PROTECTED VIEW Be carefu-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Fiji farm survey [Protected View] - Excel Home Insert Page Layout Formulas Data Review View Office Tab Help tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 1. Fiji farm survey [Protected View] Fiji farm survey [Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Office Tab Help Que tell me what you want to do i) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 1. Fiji farm survey [Protected View] inen recommena a sulade way to mint mize this proolem. c. "Samu is recommending Pie chart for Farming status" Comment on appropriateness of Samu's choice. (2 marks) Q2. (11 marks) Create a new column titled "Level of education" with following criteria: - all the farmers Education(years) less than equal to eight label it as primary - all the farmers Education(years) greater than 8 and less than equal to 13 label it secondary. - all the farmers Education(years) greater than 13 label it as tertiary. (1 marks) Now create a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output / 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? ( 2 marks) Fiji farm survey [Protected View] - Excel Home Insert Page Layout Formulas Data Review View Office Tab Help Tell me what you want to do PROTECTED VIEW Be careful-files from the internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Fiji farm survey [Protected View] Fiji farm survey [Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Office Tab Help Tell me what you want to do (i) PROTECTED VIEW Be careful- files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing E259 :x1 NA i) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stary in Protected View. Enable Editing W Fiji farm survey [Protected View] Ay, farm survey [protected View] Q2. (1l marks) Create a new column titled "Level of education" with following criteria: - all the farmers Education(years) less than equal to eight label it as primary - all the farmers Education(years) greater than 8 and less than equal to 13 label it secondary. - all the farmers Education(years) greater than 13 label it as tertiary. (1 marks) Now create a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output / 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? (2 marks) VIEW Be careful- files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing ley [Protected View] i. PROTECTED VIEW Be carefu-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Fiji farm survey [Protected View] - Excel Home Insert Page Layout Formulas Data Review View Office Tab Help tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 1. Fiji farm survey [Protected View] Fiji farm survey [Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Office Tab Help Que tell me what you want to do i) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 1. Fiji farm survey [Protected View] inen recommena a sulade way to mint mize this proolem. c. "Samu is recommending Pie chart for Farming status" Comment on appropriateness of Samu's choice. (2 marks) Q2. (11 marks) Create a new column titled "Level of education" with following criteria: - all the farmers Education(years) less than equal to eight label it as primary - all the farmers Education(years) greater than 8 and less than equal to 13 label it secondary. - all the farmers Education(years) greater than 13 label it as tertiary. (1 marks) Now create a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output / 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? ( 2 marks) Fiji farm survey [Protected View] - Excel Home Insert Page Layout Formulas Data Review View Office Tab Help Tell me what you want to do PROTECTED VIEW Be careful-files from the internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Fiji farm survey [Protected View] Fiji farm survey [Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Office Tab Help Tell me what you want to do (i) PROTECTED VIEW Be careful- files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing E259 :x1 NA i) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stary in Protected View. Enable Editing W Fiji farm survey [Protected View]