Both calculations in Excel.

1.Calculate the mean number of Personnel in the database. Letting this mean represent the population mean for all hospitals and using a population standard deviation of 500, what is the probability of randomly selecting 40 hospitals and the sample mean number of personnel being between 700 and 900?

2.Determine the proportion of hospitals that are under the control of nongovernment not-for-profit organizations (category 4). Assume that this proportion represents the entire population of all hospitals. If you randomly selected 500 hospitals from across the United States, what is the probability that 17% or more are under the control of nongovernment not-for-profit organizations? If you randomly selected 100 hospitals, what is the probability that less than 11% are under the control of nongovernment not-for-profit organizations?