« previous next »

Author Question: For a given mean and standard deviation, the ____________ function in Excel is used to generate a ... (Read 105 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?

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?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

How to use the quotient rule to find the derivative of a function How to use the quotient rule to find the derivative of a function
A Structure/Function Label Claim A Structure/Function Label Claim
Derivative of Reciprocal Trig Function Derivative of Reciprocal Trig Function
How reciprocal functions compare to the parent function How reciprocal functions compare to the parent function
Standard Symbols Used in Pedigrees Standard Symbols Used in Pedigrees
Comparison of loss- and gain-of-function alleles Comparison of loss- and gain-of-function alleles
Video: Splitting of Sugar, Oxidation/ Reduction & ATP Generation

For a complete list of videos, visit our video library