Question: Use MS Excel for this question, that is all calculations should be done using the MS excel functions. the MS excel file is in the

Use MS Excel for this question, that is all calculations should be done using the MS excel functions. the MS excel file is in the goggle drive link
https://docs.google.com/spreadsheets/d/1fwg87rb38gz8NKvIX6i7Xmw2u12NsnYK/edit?usp=sharing&ouid=114188060751964743273&rtpof=true&sd=true

Q4. (8 marks) 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? (3 marks) 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. (3 marks) c. Which sampling procedure would you recommend to the researcher in part (b), provide reason for your answer. (2 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
