« previous next »

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

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

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?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Deviation of Normal Posture Deviation of Normal Posture
Glioma. (a) Illustration of a large glioma (colored area) within the left cerebral hemisphere in a s Glioma. (a) Illustration of a large glioma (colored area) within the left cerebral hemisphere in a s
How to sketch a graph of a function using calculus only (Part 3) How to sketch a graph of a function using calculus only (Part 3)
Testing motor function of cranial nerve VII - Raise eyebrows Testing motor function of cranial nerve VII - Raise eyebrows
Basic Marketing Research: Using Microsoft Excel Data Analysis Basic Marketing Research: Using Microsoft Excel Data Analysis
Disrupted Myostatin Function Disrupted Myostatin Function
Video: Stomach peristalsis - Movement of Food Through the Small Intestine

For a complete list of videos, visit our video library