Please show all working Thank you so much Assignment Content #1a: Find the P value If the Z 2.08. c. Suppose the mean height of

Please show all working

Thank you so much

Assignment Content

#1a: Find the P value If the Z<-0.70.

b. Find the P-value if Z >2.08.

c. Suppose the mean height of women age 20 years or older in a certain country is 62.5 inches. One hundred randomly selected women in a certain city had a mean height of 61.7 inches. At the 1% significancelevel, do the data provide sufficient evidence to conclude that the mean height of women in the city differs from the nationalmean? Assume that the population standard deviation of the heights of women in the city is 4.1 inches. Find the P-value only!

#2: A primary care provider is checking a patient glucose level over the past 9 weeks and found the following glucose readings (in mg/dl).

119 88 82 90 115 91 108 124 100

The sample mean top enclose x= 97.11. Let x be a random variable representing glucose reading taken from the patient. We may assume has a normal distribution, and we know from experience that sigma= 9.5. The mean glucose level for horses should be mu=90 mg/dl. Do these data indicate that the patient has an overall average glucose level higher than 90? Use a = 0.05.

Using Excel: A primary care provider is checking a patient glucose level over the past 9 weeks and found the following glucose readings (in mg/dl).

19 88 82 90 115 91 18 124 100

Let x be a random variable representing glucose reading taken from the patient. We may assume has a normal distribution, and we know from experience that sigma= 10.5. The mean glucose level for horses should be mu= 95 mg/dl. Do these data indicate that the patient has an overall average glucose level higher than 95? Use a= 0.05.

Please use excel and attach the screen shot of the full hypothesis test with step by step work.