« previous next »

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

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Structure and function of the thick and thin filaments. Structure and function of the thick and thin filaments.
Female reproductive structure and function in humans. Female reproductive structure and function in humans.
Antiparkinson Drugs Focus on Restoring Dopamine Function and Blocking Cholinergic Activity in the ... Antiparkinson Drugs Focus on Restoring Dopamine Function and Blocking Cholinergic Activity in the ...
Testing motor function of cranial nerve VII - Frown Testing motor function of cranial nerve VII - Frown
Function divisions of nervous system Function divisions of nervous system
State the transformations on the function f(x)= 4sin(x-pi)-2 and then graph two cycles below. State the transformations on the function f(x)= 4sin(x-pi)-2 and then graph two cycles below.
Video: Bone Growth and Remodeling

For a complete list of videos, visit our video library