Question

Part I: Normal Probability Distribution and Inverse Normal
Probability

You will use Minitab or Excel to answer the following questions. No
hand computation. Minitab users: You can learn about the options
inside the dialogue box of Normal Distribution by calc >
probability distributions > Cumulative Probability > A single
value for form of input > Choose Normal for Distribution >
Enter Value and parameters > Display a table of cumulative
probabilities > OK

Use the ? button in the dialogue box for normal distribution to
find the definitions and steps for cumulative probability and
inverse cumulative probability if you need to.

Excel users: As soon as you type =NORM.DIST or NORM.INV, you will
see choices of Excel functions for normal distributions
immediately. Enter the arguments inside ( ).

Problem Statement: The tire mileage at the Everun Tire Company was
described by a normal probability distribution with μ = 50,000 and
? = 4,000 miles.

Q1: What is the probability that the tire mileage will exceed
Value, 60,000 miles?

Q2: What mileage guarantee should Everun Tire Co. set to ensure
that no more than 2 % of the tires qualify for the guarantee? Here,
the inverse cumulative normal probability is used.

In addition to the mean and standard deviation, you type in the
number in each question in the input constant, and select one out
of three options (probability density, cumulative probability, and
inverse cumulative probability

Answer #1

Open the Excel program Suppose we want to know the standard
normal distribution up to the given value. That is P(Z < a).
Lets use Excel instead of the standard normal distribution table
In cell A1 type mean. In cell B1 type 0. That means that we are
letting mean be zero. click on cell A2 and type SD. In cell B2 type
1. That means that we are letting standard deviation be one. That
is, the normal distribution is...

For each of the following questions,
use Microsoft Excel to find the solution. Be sure to describe which
functions you used and how you got the answer. Feel free to use
whatever approach you want to get the right answer. Here are some
functions you might find useful:
BINOM.DIST
POISSON.DIST
HYPGEOM.DIST
NORM.DIST
Over the next 30 days, the pool has a 15% chance of closing each
day. The closings are independent from each other. What is the
probability that the...

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

Question 3
The text mentions that
in order to use the normal distribution for binomial distributions
that EITHER n(p) OR n(q) must be > 5.
True
False
Question 4
The reason that both
n(p) and n(q) are > 5 is that otherwise the distribution is
likely skewed
True
False
Question 5
The reason that the
distribution should not be skewed is that the normal distribution
assumes that symmetrical distribtuion
True
False
Question 6
Using ONLY the 68, 95,
and 99.7...

Given a normal distribution with
muμequals=105
and
sigmaσequals=20,
and given you select a sample of
n equals 16n=16,
complete parts (a) through (d).Click here to view page 1 of
the cumulative standardized normal distribution table.
LOADING...
Click here to view page 2 of the cumulative standardized normal
distribution table.
LOADING...
a. What is the probability that
Upper X overbarX
is less than
9292?
P(Upper X overbarXless than<9292)equals=. 0047.0047
(Type an integer or decimal rounded to four decimal places as
needed.)...

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

Part 1: Use the following steps to create a standard normal in
StatKey and answer the following questions about the variable
Z.
Go to http://www.lock5stat.com/StatKey/
Click on Normal (This is located in the theoretical
distributions section)
Notice in the right hand corner StatKey has a mean of 0 and
standard deviation of 1 as default
Notice in the left hand corner are the usual left, right and 2
tail options these will be helpful in the problems below
For each...

Problem #1 Confidence Interval for Means using the t and
z Distribution. Psychologists studied
the percent tip at a restaurant when a message indicating that the
next day’s weather would be nice was written on the bill. Here are
tips from a random sample of patrons who received such a bill,
measured in percent of the total bill:
20.8 18.7
19.9 20.6
21.9 23.4
22.8 24.9
22.2 20.3
24.9 22.3
27.0 20.4
22.2 24.0
21.1 22.1
22.0 22.7
Open an...

Given a normal distribution with μ=100 and σ=8, and given you
select a sample of n equals=16, complete parts (a) through
(d).
a. What is the probability that X is less than 95?
P(X<95)
(Type an integer or decimal rounded to four decimal places as
needed.)
b. What is the probability that X is between 95 and 97.5?
P(95<X<97.5)
(Type an integer or decimal rounded to four decimal places as
needed.)
c. What is the probability that X is above...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 13 minutes ago

asked 25 minutes ago

asked 47 minutes ago

asked 47 minutes ago

asked 47 minutes ago

asked 50 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