Question

Use Excel to find the critical value of z for each hypothesis test. (Negative values should...

Use Excel to find the critical value of z for each hypothesis test. (Negative values should be indicated by a minus sign. Round your answers to 3 decimal places.) (a) 9 percent level of significance, two-tailed test. Critical value of z ± __________ (b) 7 percent level of significance, right-tailed test. Critical value of z _______ (c) 4 percent level of significance, left-tailed test. Critical value of z___________.

Homework Answers

Answer #1

Answer)

A)

Excel command to find the area in tail for normal distribution is,

NORMDIST(x,mean,SD,cumulative)

And to find the critical value for given area or probability is

NORM.S.INV(Area)

As here test is two tailed, we will divide the given alpha into two equal parts.

0.09/2 = 0.045

So command is,

NORM.S.INV(0.045)

Z critical = -1.69 and 1.69

B)

It is a right tailed test, so we will have a positive critical value.

NORM.S.INV(0.07)

= 1.47

C)

Left tailed means we will have a negative value.

NORM.S.INV(0.04)

= -1.75

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use Excel to find the critical value of z for each hypothesis test. (Negative values should...
Use Excel to find the critical value of z for each hypothesis test. (Negative values should be indicated by a minus sign. Round your answers to 3 decimal places.) (a) 2 percent level of significance, two-tailed test. Critical value of z ± (b) 1 percent level of significance, right-tailed test. Critical value of z (c) 5 percent level of significance, left-tailed test. Critical value of z
12. Calculate the critical z-value(s) for each of the given hypothesis test scenarios below. If mulitple...
12. Calculate the critical z-value(s) for each of the given hypothesis test scenarios below. If mulitple critical values exist for a single scenario, enter the solutions using a comma-separated list. Round z-values to two decimal places. Find the critical z-value(s) for a left-tailed test of hypothesis for a mean, assuming the population standard deviation is known, with a sample size of 98 and let α=0.005. z= Find the critical z-value(s) for a right-tailed test of hypothesis for a mean, assuming...
Find the following z values for the standard normal variable Z. (Use Excel command instead of...
Find the following z values for the standard normal variable Z. (Use Excel command instead of the z table. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) a. P(Z ≤ z) = 0.9477 b. P(Z > z) = 0.63 c. P(−z ≤ Z ≤ z) = 0.85 d. P(0 ≤ Z ≤ z) = 0.2034
Find the following z values for the standard normal variable Z. (Negative values should be indicated...
Find the following z values for the standard normal variable Z. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)   a. P(Z ≤ z) = 0.9477      b. P(Z > z) = 0.6300      c. P(−z ≤ Z ≤ z) = 0.85      d. P(0 ≤ Z ≤ z) = 0.2034   
Find the following z values for the standard normal variable Z. (Negative values should be indicated...
Find the following z values for the standard normal variable Z. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) a. P(Z ≤ z) = 0.8133 b. P(Z > z) = 0.8125 c. P(−z ≤ Z ≤ z) = 0.96 d. P(0 ≤ Z ≤ z) = 0.2991
Find the following z values for the standard normal variable Z. Use Table 1. (Negative values...
Find the following z values for the standard normal variable Z. Use Table 1. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)   a. P(Z ≤ z) = 0.9478      b. P(Z > z) = 0.6140      c. P(−z ≤ Z ≤ z) = 0.80      d. P(0 ≤ Z ≤ z) = 0.2392    Hints
Find the following z values for the standard normal variable Z. (Use Excel command instead of...
Find the following z values for the standard normal variable Z. (Use Excel command instead of the z table.Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) a. P(Z ≤ z) = 0.8485 b. P(Z > z) = 0.7329 c. P(−z ≤ Z ≤ z) = 0.96 d. P(0 ≤ Z ≤ z) = 0.2517
14. Calculate the critical t-value(s) for each of the given hypothesis test scenarios below. If mulitple...
14. Calculate the critical t-value(s) for each of the given hypothesis test scenarios below. If mulitple critical values exist for a single scenario, enter the solutions using a comma-separated list. Round t-values to four decimal places. Find the critical t-value(s) for a left-tailed test of hypothesis for a mean, assuming the population standard deviation is unknown, with a sample size of 25 and let α=0.005. t= Find the critical t-value(s) for a right-tailed test of hypothesis for a mean, assuming...
a, Find the critical​ F-value for a​ right-tailed test using the indicated level of significance α...
a, Find the critical​ F-value for a​ right-tailed test using the indicated level of significance α and degrees of freedom d.f.N and d.f.D. α=0.10​, d.f.N=7​, Dd.f.=24 The critical​ F-value is _____ ​(Round to two decimal places as​ needed.) b.Find the expected​ frequency, Ei​, for the given values of n and pi. n=230​, pi=0.27 Ei= _____ ​(Type an integer or a​ decimal.)
find the p-value for the indicated hypothesis test with the given standardized test statistic, z. decide...
find the p-value for the indicated hypothesis test with the given standardized test statistic, z. decide whether to reject H0 for the given level of significance a. right-tailed test with statistic z=1.47 and a=0.06. p-valuue =