Question: 5. Using Excel - normal probabilities Consider the random variable x that follows a normal distribution, with a mean of u = 100 and


5. Using Excel - normal probabilities Consider the random variable x that follows a normal distribution, with a mean of u = 100 and a standard deviation of = 15. You will select some of your answers to the questions that follow in this sample Excel spreadsheet: 1 A P(x < 70) 2 P(68.5 < x < 70.5) B In cell B1 of the sample spreadsheet, select the correct Excel formula for computing the probability that x is less than 70. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. What is the probability that x is less than 70? O P(x
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
