URGENT ANSWER PLEASE

QUESTION 4 Open with Google Docs Ahmad is a farmer, who plants cucumber. He is studying the risks associated with planting cucumber crop. Based on past experience, he assesses the probabilities associated with cucumber prices per kilogram (kg), yields kg per hectare, and costs (for fertilizer, water, seed and labor) per hectare. The probability distributions of price, yield and cost are given in the following spreadsheet. A B D E F G H 1 Lower Upper Yield per Random Random hectare No. No. (kg) 0.00 0.10 13000 (RM) Probability 0.10 Probability 0.10 0.20 0.50 Lower Upper Price per Random Random kilogram No. No. 0.00 0.10 1.60 0.11 0.30 1.40 0.80 1.20 0.81 0.90 0.91 0.95 0.80 0.96 1.00 0.60 0.20 0.11 0.31 0.50 mino 00 0 0.31 0.81 0.30 0.80 0.90 0.95 12900 12800 12700 12600 0.10 1.00 0.10 0.05 0.91 7 8 0.05 0.05 10 NO. Probability 0.10 Lower Upper Random Random No. 0.00 0.10 0.11 0.30 0.31 0.80 Cost per hectare (RM) 5590 5504 5418 11 12 0.20 13 0.50 Below is the simulation output for 15 trials using spreadsheet. B 15 5 Trial 16 1 17 2 3 4 18 19 20 21 5 6 D E F Price per Yield per cost per Profit per kilogram hectare hectare hectare (RM) (kg) (RM) (RM) 1.40 12900 5418 12642 1.20 12800 5418 9942 1.20 12800 5418 9942 1.20 12800 5418 9942 1.20 12800 5418 9942 1.20 12900 5418 1.00 12900 5504 7396 1.60 12800 5418 15062 1.20 12900 5504 9976 1.60 12800 5418 15062 1.40 12800 5504 12416 1.20 12800 5504 9856 1.40 12800 5418 1.20 13000 5418 10182 1.20 12700 5418 9822 22 7 23 8 9 24 25 10 26 11 12 13 27 28 29 30 14 15 a) What do you type in cells C21, D21, and E21 to get the respective displays? (6 marks) b) Calculate the value at cell F21, F28 respectively and the average profit per hectare for the 15 trials. (6 marks)