Complete the following question using Excel A large company gives each of its

Complete the following question using Excel A large company gives

question using Excel A large company gives each of its employees an aptitude test

Complete the following question using Excel A large

company gives each of its employees an aptitude test

Complete the following question using Excel

Complete the following

Category: | |

Words: | |

Amount: | $20 |

Writer: | 0 |

Paper instructions

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.)

# Answer

Get Essay Answer

1,200,000+ Questions

Satisfaction guaranteed

A professor at a local university finds that the mean exam grade for her students is 71 with a standard deviation of 13. It is known that the grades...

The average price of personal computers manufactured by the MNM company is $1,400 with a standard deviation of $260. It is known that the computer...

Complete the following question using Excel. A large company gives each of its employees an aptitude test.

Complete the following question using Excel. An advocacy group claims that 95% of the citizens in a large city oppose the construction of more...