R = 1 Please show step by step
Question 2 In this question, you should refer to the worksheet "Food" The amount of food consumed by Crystal's dog (Dan) on a particular day (X) is normally distributed with an average of (250 + RX0.2)g (to be entered in Bl) and variance of 16g? (shown in D1). a) What is the mathematical expression in term of X to express the probability that Dan's food consumption of a randomly selected day is smaller than or equals to 255g? Also, write down the probability (to be calculated in Cell B3). (10 marks) Tasks Answers 1) Mathematical Expression in terms of X 11) Probability (Correct your answer to 4 decimal places.) b ) What is the mathematical expression in terms of Z (Standard Score) to express the probability that Dan's food consumption of a randomly selected day is between 246g to 256g? Also, write down the formula to be entered exactly in Cell B5 to find the above probability and hence write down the probability. (15 marks) Tasks Answers i) Mathematical Expression in terms of Z 11 Formula to be entered exactly in Cell B5 before standardization 111) Probability (Correct your answer to 4 decimal places.)Average daily consumption variance of the consumption Number of days (for part cl) a) Probability b) Probability c) Xk cl) Probability c) X in the following graph denotes the minimum daily food consumption of Dan. The shaded area is 0.8124+(R-200). Write down the formula to be entered exactly in Cell B7 to find the minimum food consumption (X) and hence find the value of X (10 marks) X Tasks Answers 1 ) Formula to be entered exactly in Cell B7 (Correct your answer to 4 decimal places.) d) In order to monitor Dan's eating pattern, the food consumption is now analyzed every 36 days. Write down the formula to be entered exactly in Cell B9 to find the probability that the average food consumption of Dan for 36 randomly selected days is larger than 251g and hence write down the probability. (10 marks) Tasks Answers 1) Formula to be inputted in Cell B9 before standardization 11) Probability (Correct your answer to 4 decimal places.)