Question
Q2.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
Q2.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. a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output / cultivated area). 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. 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?
Q3. Construct a contingency table and relative contingency table (using Pivot table tool in Excel) for farming status in raw and Land Owned in column. a. What is the probability that a randomly selected farmer does not own the land? b. What is the probability that a randomly selected farmer is working full time and does not own the land? c. What is the probability that a randomly selected farmer does not own the land given that farming status is full time? d. What can you conclude from above analysis in regards to land ownership in sugar industry? Q4. a. Assume that the annual profit from farming is nearly normally distributed. Individual earning less than $2000 is believed to be in poverty. Calculate what proportion of sugar cane farmers are in poverty? b. A researcher intends to estimate population proportions of farmers in Fiji are in poverty. The researcher intends to be 99% confident and expects that his estimation to be within 3% of population proportion. How large sample size should be taken to achieve these conditions. c. Which sampling procedure would you recommend to the researcher in part (b), provide reason for your answer. Q5. a. Construct a 99% confidence interval for the mean cane output per farmer. Interpret. b. Construct a 95% confidence interval for population mean can output per acre. Comment on your results. (3 marks) Q6. (8 marks) Test whether the mean annual profit from farming is more than $2000 or not. Use = 0.05 and the P-value method. Show all five steps of Hypothesis testing. Comment on your results in regards to poverty for sugar cane farmers.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started