Question 1
(a)
(i) Using relevant Excel reports, provide a descriptive summary of the Bounty
rice’s Glycemic Index (GI). You are expected to describe and state relevant
descriptive statistics and use two types of charts to provide visualizations of the distribution of the data. You are also expected to make a preliminary conclusion on Bounty rice’s GI.
Please limit the answer to within two (2) pages.
(ii) By considering relevant probability, explain whether Bounty rice’s GI follows the GI distribution of White rice. Furthermore, explain if Bounty rice is healthier than White rice as claimed in the advertisement. You are expected to justify your analysis.
Please limit the answer to within one (1) page.
(b) Use relevant descriptive statistics and a chart to conduct a preliminary comparison of the Bounty rice’s GIs produced by Nito and Oxy.
Please limit the answer to within two (2) pages.
(20 marks)
(c) The CEO has requested you to make a short presentation to the management regarding your findings. In particular, the management wants to know the Bounty rice’s effectiveness in preventing diabetes. They are also interested to know the relative performance of the Nito and Oxy fertilizer. Develop a written script for the short presentation. You are expected to interpret the findings to provide insights that would be useful to the management. You also hope to use this opportunity to demonstrate to
management how quantitative information helps in decision-making. Your script should be less than 300 words. Please indicate the word count at the end of your answer.
(40 marks)
Bounty Rice’s Glycemic Index (GI) Data
| SN | Fertiliser | Bounty Rice’s GI |
|---|---|---|
| 1 | Nito | 66.95 |
| 2 | Nito | 55.6 |
| 3 | Oxy | 58.71 |
| 4 | Nito | 69.35 |
| 5 | Oxy | 70.33 |
| 6 | Oxy | 54.38 |
| 7 | Oxy | 60.81 |
| 8 | Nito | 70.77 |
| 9 | Nito | 59.2 |
| 10 | Oxy | 69.88 |
| 11 | Oxy | 66.4 |
| 12 | Oxy | 59.94 |
| 13 | Oxy | 68.26 |
| 14 | Oxy | 46.65 |
| 15 | Nito | 61.53 |
| 16 | Nito | 67.04 |
| 17 | Nito | 71.26 |
| 18 | Oxy | 49.35 |
| 19 | Oxy | 44.12 |
| 20 | Oxy | 58.07 |
| 21 | Oxy | 57.92 |
| 22 | Oxy | 82.06 |
| 23 | Nito | 70.8 |
| 24 | Oxy | 70.92 |
| 25 | Oxy | 76.18 |
| 26 | Nito | 68.45 |
| 27 | Nito | 84.41 |
| 28 | Nito | 34.3 |
| 29 | Nito | 74.84 |
| 30 | Nito | 56.3 |
| 31 | Oxy | 55.18 |
| 32 | Oxy | 72.73 |
| 33 | Nito | 60.82 |
| 34 | Nito | 75.16 |
| 35 | Nito | 75.87 |
| 36 | Oxy | 64.61 |
| 37 | Oxy | 56.87 |
| 38 | Oxy | 82.76 |
| 39 | Nito | 71.83 |
| 40 | Nito | 74.53 |
| 41 | Oxy | 77.64 |