Question

Statistics/ Probability question- Please show me how to enter in to Excel to find values-thank you!

1. A) Assume that *z*-scores are normally distributed
with a mean of 0 and a standard deviation of 1.

If P(z>c)=0.0868P(z>c)=0.0868, find *c*.

B) Assume that *z*-scores are normally distributed with a
mean of 0 and a standard deviation of 1.

If P(z>d)=0.9935P(z>d)=0.9935, find *d*.

C) For the standard normal distribution, find the value of c
such that:

P(z > c) = 0.3271

D) For a standard normal distribution, find cc if

P(z > c) = 0.1551

Answer #1

Part a)

P(z>c)=0.0868

P ( Z > c ) = 1 - 0.0868 = 0.9132

Looking for the probability 0.9132 in standard normal table to find the critical value Z

Z = 1.36

P ( Z > 1.36 ) = 0.0868

Excel formula NORMSINV( 0.9132 )

Part b)

P(z>d)=0.9935

P ( Z > d )= 1 - 0.9935 = 0.0065

Looking for the probability 0.0065 in standard normal table to find the critical value Z

Z = -2.48

P ( Z > -2.48 ) = 0.9935

Excel formula NORMSINV( 0.0065)

Part c)

P(z > c) = 0.3271

P(z > c) = 1 - 0.3271 = 0.6729

Looking for the probability 0.6729 in standard normal table to find the critical value Z

Z = 0.45

P ( Z > 0.45 ) = 0.9935

Excel formula NORMSINV( 0.6729 )

Part d)

P(z > c) = 0.1551

P(z > c) = 1 - 0.1551 = 0.8449

Looking for the probability 0.8449in standard normal table to find the critical value Z

Z = 1.01

P ( Z > 1.01 ) = 0.1551

Excel formula NORMSINV( 0.8449)

For a standard normal distribution, find: P(-1.73 < z <
-0.77)
For a standard normal distribution, find: P(z > c) = 0.9494
Find c.
Assume that z-scores are normally distributed with a mean of 0
and a standard deviation of 1.
If P(z>c)=0.2789 P(z>c)=0.2789 , find c
Assume that z-scores are normally distributed with a mean of 0
and a standard deviation of 1. If P(z>d)=0.7887 P(z>d)=0.7887
, find d.
Assume that z-scores are normally distributed with a mean of...

I would prefer to use technology over tables if possible- please
show me how/what to enter into Excel. Thank you!!
1. A) The combined SAT scores for the students at a local high
school are normally distributed with a mean of 1507 and a standard
deviation of 296. The local college includes a minimum score of
1773 in its admission requirements.
What percentage of students from this school earn scores that fail
to satisfy the admission requirement? (Where on the...

A. For a standard normal distribution, find:
P(-1.14 < z < -0.41)
B. For a standard normal distribution, given:
P(z < c) = 0.0278
Find c.
C. For a standard normal distribution, find:
P(z > c) = 0.4907
Find c.
D. Assume that z-scores are normally distributed with a mean
of 0 and a standard deviation of 1.
IfP(0<z<a)=0.4686P(0<z<a) = 0.4686
find a.
E. Assume that the readings at freezing on a bundle of
thermometers are normally distributed with a...

This is a multi-part question.
First, find the following: For a standard normal distribution,
find: P(-1.17 < z < 0.02)+__________
Second, resolve this: Assume that the readings at freezing on a
batch of thermometers are normally distributed with a mean of 0°C
and a standard deviation of 1.00°C. A single thermometer is
randomly selected and tested. Find the probability of obtaining a
reading less than -0.08°C.
P(Z<−0.08)= ____________
Third, resolve this: Assume that the readings at freezing on a
batch...

Multiple question needing guidance please.
1. A distribution of values is normal with a mean of 173.2 and a
standard deviation of 39.
Find the probability that a randomly selected value is between
200.5 and 298.
P(200.5 < X < 298) =_______________
2. A distribution of values is normal with a mean of 229.7 and a
standard deviation of 83.5.
Find P32, which is the score separating the
bottom 32% from the top 68%.
P32 = __________________
3. Engineers must...

Use excel to find the following please thank you!
The probability distribution of X, the number of defective tires
on a randomly selected automobile checked at a certain station is
given by the table. X 0 1 2 3 4 p(X) 0.54 0.16 0.06 0.04 0.2 Table
4: Distribution for defective tires
Find:
a. E(X)
b. E(X2)
C. σX (8) A sample of 600 Scholastic Aptitude Test (SAT) results
has mean of 500 and standard deviation of 100.

PART A: A particular fruit's weights are normally distributed,
with a mean of 451 grams and a standard deviation of 29 grams. The
heaviest 14% of fruits weigh more than how many grams? Give your
answer to the nearest gram.
B) Assume that z-scores are normally distributed with a
mean of 0 and a standard deviation of 1.
If P(−b<z<b)=0.4434P(-b<z<b)=0.4434, find
b.
C) A distribution of values is normal with a mean of 21.1 and a
standard deviation of 88.3....

Please show how I would find this answer on a calculator
also.
1. For a standard normal distribution, find:
P(z > -1.73)
2. For a standard normal distribution, find:
P(1.98 < z < 2.09)
3. For a standard normal distribution, given:
P(z < c) = 0.6648
Find c.
Thank you

1. A distribution of values is normal with a mean of 110.8 and a
standard deviation of 33.5.
Find the probability that a randomly selected value is less than
20.7.
P(X < 20.7) =
Enter your answer as a number accurate to 4 decimal places. *Note:
all z-scores must be rounded to the nearest hundredth.
2. A distribution of values is normal with a mean of 2368.9 and
a standard deviation of 39.4.
Find the probability that a randomly selected...

1. For a standard normal distribution,
find:
P(z > 2.32)
Keep four decimal places.
2. For a standard normal distribution,
find:
P(-0.9 < z < 0.95)
3. For a standard normal distribution,
given:
P(z < c) = 0.7622
Find c.
4. For a standard normal distribution,
find:
P(z > c) = 0.1753
Find c
5. Assume
that the readings at freezing on a batch of thermometers
are normally distributed with a mean of 0°C and a standard
deviation of 1.00°C....

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 38 minutes ago

asked 42 minutes ago

asked 57 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago