Complete the following question using Excel.
A large company gives each of its employees an aptitude test. The scores on the test are normally distributed with a mean of 77 and a standard deviation of 14. A sample of 24 employees is taken.
- Is the distribution of the sample means normal? Enter "yes" or "no" in blank #1.
- In blank #2 enter the probability that the test score for a randomly selected employee is between 75 and 79. (Round your answer to 4 decimal places and enter your answer as 0.1234 not .1234.)
- In blank #3 enter the probability that the average test score in the sample is less than 78.93. (Round your answer to 4 decimal places and enter your answer as 0.1234 not .1234.)
- In blank #4 enter the probability that the average test score in the sample is at least 80.25. (Round your answer to 4 decimal places and enter your answer as 0.1234 not .1234.)
- In blank #5 enter the probability that the average test score in the sample is between 73.65 and 81.65. (Round your answer to 4 decimal places and enter your answer as 0.1234 not .1234.)