« previous next »

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

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

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
ROM exercises on a patient’s wrist: radial deviation. ROM exercises on a patient’s wrist: radial deviation.
How to find the anti-derivative of a function (Part 3) How to find the anti-derivative of a function (Part 3)
How to stretch or compress a function using transformations How to stretch or compress a function using transformations
Use the graph of the function f(x) to answer each question. Use the graph of the function f(x) to answer each question.
Prove that each of the following real functions f has a discontinuity. For each function, ... Prove that each of the following real functions f has a discontinuity. For each function, ...
Video: Leukemia

For a complete list of videos, visit our video library