Show the steps by using Excel Formula.

15. Suppose that the scores on Midterm 2 for Principles of Statistics is normally distributed with population mean of 65 and population standard deviation of 10. What is the probability of scoring between 75 and 90?

0.152

16. Suppose you have the following data set: 49, 28, 20, 40, 6, 41, 13, 16, 22, 27, 45. What is the Standard deviation of this data set?

13.47

17. Suppose you have the following data set: 49, 28, 20, 40, 6, 41, 13, 16, 22, 27, 45. What is the Mean of this data set?

27.91

18. Suppose that an assembly line releases 5 defective products in a day. What is the probability that you will have less than 3 defects in a day?

0.12465

19. Colgate ran ads on television for one of its brands of mouthwash. Bases on a survey conducted, Colgate assigned probabilities to the following events: individual purchased the mouthwash with a probability of 30%, individuals recalls seeing the ad with a probability 55%, and individual did not purchase the mouthwash nor recalls seeing the ad with a probability of 65%. what is the probability that the individual recalls seeing the ad and purchases the mouthwash?

0.50

20. You are planning a workout in the gym. The first exercise you do will be when you are the most fresh and the last exercise will be when you are the least fresh. You have learned how to perform 12 exercises. For this workout, you want to perform 5 exercises. How many different workouts can you plan? Note that you cannot perform the same exercise twice.

95,040

21. You are planning a workout in the gym. You are preparing a shake for after your workout. You would like to add 4 fruit to your shake. You open the fridge and there are 12 fruit to choose from. How many different shakes can you make with the 12 fruit options in the fridge?

495

22. You are given the following parameters/numerical descriptions for a distribution: mean = 55, median = 51, standard deviation = 13, and coefficient of variation = 0.24. Which is the following is true about the distribution?

This distribution is right-skewed.

23. Suppose scores on the final exam for Principles of Statistics have an unknown distribution with a mean of 60 and standard deviation of 12. We know that At Least what percent of scores will fall in the range (36,84)?

75%

24. Suppose you are throwing a pair of fair dice. Each die has 6 sides numbered 1 through 6. If you multiply the value of each die after throwing them, that is your score. What is the probability that your score will be less than 6?

0.17

26. Suppose you are working at the State Department and to enter secure facilities requires a password. You create a 6 character password made up of 3 letters (A-Z) and 3 numbers (0-9). No letter or number can be repeated. How many different passwords are possible?

11232000

27. Suppose that the scores on Midterm 2 for principals of statistics is normally distributed with population mean of 65 and population standard deviation of 10. What score on midterm 2 is such that P (X greater than or equal x) = 0. 8?

73