QUESTION 15 The demand for a product is Normally distributed with mean 230 and standard deviation 80. What is the probability that demand is less than 320, im s (Keep at least two decimals) 1) select the link below that opens a pre-populated spreadsheet, You can add rows, columns or even create a new sheet. Empty Excel.xisx 2) create the required formula or calculation, 3) If the numbers are not clearly visible, try expanding the column to view the numbers. QUESTION 16 Given the probability distribution below, find the expected value of X. X P(x) 60 0.2 10 0.8 ick Save and Submit to save and submit. Click Save All Answers to save all answers.QUESTION 17 Find the median of the following data (keep two decimal points) 64 17 54 34 79 37 1) select the link below that opens a pre-populated spreadsheet, You can add rows, columns or even create a new sheet. Empty Excel.xisx 2) create the required formula or calculation, 3) If the numbers are not clearly visible, try expanding the column to view the numbers. QUESTION 18 If A and B are positively related, then (Choose the best possible choice) 1. The correlation between A and B can be close to -1 or +1 if the relationship is strong O Il. The correlation coefficient between them will be close to -1 if their relationship is strong O III. A regression between variables A and B will return a very high R square O IV. All of the above. O V. None of the above are true Click Save and Submit to save and submit. Click Save All Answers to save all answers.QUESTION 19 Choose all the right choices from below. (There could be more than one choice that is right) For a Normal distribution with mean 4500 and standard deviation 500, the random value of X = 4000 Is exactly one standard deviation to the right of the mean O Has a z-score of +1 Has a z-score of -1 Is exactly one standard deviation to the left of the mean. QUESTION 20 For the average to be a valid measure, the data set must be of type ...... (There could be more than one right answer. Choose ALL correct am carry negative marking) O Categorical data Ratio data O Interval data Ordinal data Click Save and Submit to save and submit. Click Save All Answers to save all answers. MacBook ProQUESTION 21 P(310