Question

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

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

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 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 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
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 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 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
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 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 α 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 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 =

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 35 minutes ago

asked 47 minutes ago

asked 55 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago