Hypothesis testing and confidence interval using excel.

I need assistance solving these problem exercises in excel format.

CHAPTER 8 EXERCISE 2
The following is a list of 29 hospitals in the Cincinnati (Ohio) and Northern Kentucky region. The hospitals are identified by numbering them 00 through 28. Also included is whether the hospital is a general medical/surgical hospital (M/S) or a specialty hospital (S). We are interested in estimating the average number of full- and part-time nurses employed in the area hospitals.

A sample of five hospitals is to be randomly selected. The random numbers are 09, 16, 00, 49, 54, 12, and 04. Which hospitals are included in the sample? (Select hospital names included in sample in numerical order.)

________________________________________

A sample is to consist of every fifth location. We select 02 as the starting point. Which hospitals will be included in the sample? (Hint: Enter the ID number used to identify the hospitals) (Select hospital names included in sample in numerical order.)

________________________________________

rev: 10_14_2014_QC_55869, 11_22_2014_QC_59349
 
CHAPTER 8 EXERCISE 8

A population consists of the following five values: 2, 2, 3, 4, 5.

a. List all samples of size 3, and compute the mean of each sample. (Round sample means to 2 decimal places.)

Sample Values Sum Mean
1 2, 2, 3

2 2, 2, 4

3 2, 2, 5

4 2, 3, 4

5 2, 3, 5

6 2, 4, 5

7 2, 3, 4

8 2, 3, 5

9 2, 4, 5

10 3, 4, 5

________________________________________

b. Compute the mean of the distribution of sample means and the population mean. (Round your answers to 1 decimal place.)

Sample means

Population mean

 
CHAPTER 8 EXERCISE 16
A normal population has a mean of 75 and a standard deviation of 5. You select a sample of 40.

Compute the probability the sample mean is: (Round z values to 2 decimal places and final answers to 4 decimal places):

a. Less than 74.

Probability

b. Between 74 and 76.

Probability

c. Between 76 and 77.

Probability

d. Greater than 77.

Probability

CHAPTER 9 EXERCISE 4
Suppose you know σ and you want an 85% confidence level. What value would you use as z in formula of confidence interval for a population mean? (Round your answer to 2 decimal places.)

Value of z

CHAPTER 9 EXERCISE 6
A research firm conducted a survey to determine the mean amount steady smokers spend on cigarettes during a week. They found the distribution of amounts spent per week followed the normal distribution with a population standard deviation of $5. A sample of 64 steady smokers revealed that .

a. What is the 95% confidence interval estimate of ? (Round your answers to 3 decimal places.)

Confidence interval is between $ and $ .

CHAPTER 9 EXERCISE 10
Use Appendix B.5 to locate the value of t under the following conditions. (Round your answers to 3 decimal places.)

a. The sample size is 15 and the level of confidence is 95%.

Value of t

b. The sample size is 24 and the level of confidence is 98%.

Value of t

c. The sample size is 12 and the level of confidence is 90%.

Value of t

CHAPTER 9 EXERCISE 26
Past surveys reveal that 30% of tourists going to Las Vegas to gamble spend more than $1,000. The Visitor's Bureau of Las Vegas wants to update this percentage.

a. The new study is to use the 90% confidence level. The estimate is to be within 1% of the population proportion. What is the necessary sample size? (Round your answer to the next whole number.)

Sample size

b. The Bureau feels the sample size determined above is too large. What can be done to reduce the sample? Based on your suggestion, recalculate the sample size. (Hint: Use an allowable error in the range of 0.01 to 0.05) (Round your answer to the next whole number.)

Sample size

 
CHAPTER 9 EXERCISE 28
Forty-nine items are randomly selected from a population of 500 items. The sample mean is 40 and the sample standard deviation 9.

Develop a 99% confidence interval for the population mean. (Round your answers to 3 decimal places.)

The confidence interval is between and