Ask question

Ask question

All categories

2 years ago

9

Which is the correct excel formula for the 80th percentile of a distribution that is n(475, 33)? =norm.dist(80,475,33,1) =norm.i

nv(0.80,475,33) =norm.s.inv((80-475)/33)?

1 answer:

Lesechka [4]2 years ago

4 0

To find the 80th percentile, you have to use one of the inverse CDF functions. NORM.DIST is not one of them; it returns a probability. The 80th percentile the value of the random variable for which 80% of the distributions falls below that value.

NORM.INV(0.80, 475, 33) returns what you want.

NORM.S.INV could also work, but not with the given arguments. NORM.S.INV(0.80) alone will give you the 80th percentile for the standard normal distribution (mean 0, standard deviation 1), approximately 0.8416. From here, you would convert this value to the given distribution using

$Z=\dfrac{X-\mu}\sigma\iff X=\mu+\sigma Z$

so that

$X=475+33(0.8416)\approx502.77$

NORM.INV gives this value directly.

You might be interested in

Given that Ray E B bisects ∠CEA, which statements must be true? Select three options. m∠CEA = 90° m∠CEF = m∠CEA + m∠BEF m∠CEB =

FromTheMoon [43]

Answer:

Here is the question attached with.

$m\angle CEA =90 \ (deg)$

$m\angle BEF=135\ (deg)$

$\angle CEF$ is a straight line.

$\angle AEF$ is a right angled triangle.

Options $1,4,5,6$ are correct answers.

Step-by-step explanation:

⇒As $\ ray\ AE$ is ⊥ $FEC$ so it will forms right angled triangle then $m\angle CEA =90\ (deg)$ .

⇒Measure of $\angle BEF =135\ (deg)$ as $\angle BEF =\angle AEB +\angle AEF = (45+90)=135\ (deg)$ as $\angle AEB$ is the bisector of $\angle AEC$ ,meaning that $\angle AEB$ is half of $\angle AEC$ so $\angle AEB = 45\ (deg)$ .

⇒ $\angle CEF$ is a straight line as the angles measure over it is $180\ (deg)$ .

⇒Measure of $\angle AEF = 90\ (deg)$ from linear pair concept.

As $\angle CEA + \angle AEF = 180\ (deg)$ ,plugging the values of $m\angle CEA =90\ (deg)$ we have $\angle AEF = 90\ (deg)$ .

The other two options are false as:

$m\angle CEF=m\angle CEA + m\angle BEF = (90+135)=225$

it is exceeding $180\ (deg)$ whereas $\angle CEF$ is a

straight line.

And $m\angle CEB=2(m\angle CEA)$ is not true.

As $\angle CEA = 90\ (deg)$ and $\angle CEB=45\ (deg)$

So we have total $4$ answers.

The correct options are $1,4,5,6$ .

5 0

2 years ago

Read 2 more answers

Which of the following is a binomial experiment? Rolling a six-sided number cube 24 times and recording if a 4 comes up Rolling

Nana76 [90]

The second one you did is.

4 0

2 years ago

Read 2 more answers

He temperature in Tampa, Florida is 15 degrees warmer than twice the temperature in Chicago, Illinois. The temperature in Tampa

dusya [7]

Answer:

2x+15=75

Step-by-step explanation:

Let the temperature of chicago be x

75-15=2x

Reversing the equation

2x+15=75

6 0

2 years ago

Read 2 more answers

Data sets A and B are dependent. Find sd.Assume that the paired data came from a population that is normally distributed.A. 1.73

marusya05 [52]

Complete question :

A : 2.7, 3.7, 5.6, 2.6, 2.7

B : 5.1, 4.0, 3.9, 3.8, 5.2

Data sets A and B are dependent. Find sd.Assume that the paired data came from a population that is normally distributed.A. 1.73B. 1.21C. 1.32D. 1.89

Answer: A.1.73

Step-by-step explanation:

Given the data:

A : 2.7, 3.7, 5.6, 2.6, 2.7

B : 5.1, 4.0, 3.9, 3.8, 5.2

Difference betweenA and B (A - B) :

Xd = (A - B) = - 2.4, -0.3, 1.7, - 1.2, - 2.5

Sum of (A - B) = Σ Xd = (-2.4 + (-0.3) + 1.7 + (-1.2) + (-2.5) = - 4. 7

Md = ΣXd / n = - 4.7 / 5 = - 0.94

Xd - Md = (-2.4 + 0.94), (-0.3 + 0.94), (1.7 + 0.94), (-1.2 + 0.94), (-2.5 + 0.94)

(Xd - Md) = - 1.46, 0.64, 2.64, - 0.26, - 1.56

(Xd - Md)^2 = (-1.46)^2 + 0.64^2 + 2.64^2 + (-0.26)^2 + (-1.56)^2

Σ(Xd - Md)^2 = (2.1316 + 0.4096 + 6.9696 + 0.0676 + 2.4336) = 12.012

Standard deviation = √[Σ(Xd - Md)^2 / (n-1)]

Standard deviation= √12.012 / 4

Standard deviation = 1.7329

Standard deviation= 1.73

3 0

2 years ago

An astronaut on the moon throws a baseball upward. The astronaut is 6 ft, 6 in. tall, and the initial velocity of the ball is 40

satela [25.4K]

Answer:

0.14 s

Step-by-step explanation:

s = -2.7 t² + 40t + 6.5

Let s = 12

12 = -2.7t² + 40t + 6.5 Subtract 12 from each side

-2.7t² + 40t + 6.5 - 12 = 0

-2.7t² + 40t - 5.5 = 0

Apply the <em>quadratic formula </em>

$x = \frac{-b\pm\sqrt{b^2-4ac}}{2a}$

a = -2.7; b = 40; c = -5.5

$x = \frac{-40\pm\sqrt{40^2 - 4\times (-2.7) \times (-5.5)}} {2(-2.7)}$

$x = \frac{-40\pm\sqrt{1600-59.4}}{-5.4}$

$x = \frac{-40\pm\sqrt{1540.6}}{-5.4}$

$x = \frac{-40\pm 39.25}{-5.4}$

x = 7.41 ± 7.27

x₁ = 0.14; x₂ = 14.68

The graph below shows the roots at x₁ = 0.134 and x₂ = 14.68.

The Moon’s surface is at -12 ft. The ball will be 12 ft above the Moon’s surface (crossing the x-axis) in 0.14 s.

The second root gives the time the ball will be 12 ft above the Moon’s surface on its way back down.

6 0

1 year ago