« previous next »

Author Question: For a given mean and standard deviation, the ____________ function in Excel is used to generate a ... (Read 104 times)

NClaborn

  • Hero Member
  • *****
  • Posts: 560
on: Jun 24, 2018
For a given mean and standard deviation, the ____________ function in Excel is used to generate a value for the random variable characterized by a normal distribution.
 a. NORM.INV
  b. RAND
  c. VLOOKUP
  d. FREQUENCY

Question 2

The weekly demand for an item in a retail store follows a uniform distribution over the range 70 to 83 . What would be the weekly demand if its corresponding computer-generated value is 0.5?
 a. 90.1 b. 83
  c. 76.5 d. 50.85


sailorcrescent

  • Sr. Member
  • ****
  • Posts: 334
Reply #1 on: Jun 24, 2018
Answer to Question 1

a
RATIONALE: For a given mean and standard deviation, the NORM.INV function in Excel is used to generate a value for the random variable characterized by a normal distribution.

Answer to Question 2

c
RATIONALE: To generate a value for a random variable characterized by a continuous uniform distribution, the following Excel formula is used: Value of uniform random variable = lower bound + (upper bound  lower bound)  RAND(). Upon substituting the given values, the weekly demand is obtained as 76.5.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Did you know?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Urinalysis. During a simple urinalysis, a stick with colored blocks is dipped into a urine specimen. Urinalysis. During a simple urinalysis, a stick with colored blocks is dipped into a urine specimen.
In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh
How to use L’Hospital’s Rule to find the limit of a function (Part 3) How to use L’Hospital’s Rule to find the limit of a function (Part 3)
How to quickly find the vertex of a quadratic equation that is in standard form How to quickly find the vertex of a quadratic equation that is in standard form
Testing motor function of cranial nerve VII - Raise eyebrows Testing motor function of cranial nerve VII - Raise eyebrows
Derivative of Trig Function Derivative of Trig Function
Video: Power Supply Polyacrylamide Gel Protein Sample

For a complete list of videos, visit our video library