This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: The user can monitor how listed cells change with a change in the model without searching through ... (Read 33 times)

leilurhhh

  • Hero Member
  • *****
  • Posts: 560
on: Jun 24, 2018
The user can monitor how listed cells change with a change in the model without searching through the worksheet or changing from one worksheet to another by using the ______________ functionality.
 a. Goal Seek b. Evaluate Formula
  c. Watch Window d. Trial-and-error

Question 2

The newest model of smart car is supposed to get excellent gas mileage. A thorough study showed that gas mileage (measured in miles per gallon) is normally distributed with a mean of 75 miles per gallon and a standard deviation of 10 miles per gallon. What is the probability that, if driven normally, the car will get 100 miles per gallon or better?
 a. 0.6
  b. 2.5
  c. 6
  d. 25


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Smiles0805

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

c
RATIONALE: The user can monitor how listed cells change with a change in the model without searching through the worksheet or changing from one worksheet to another by using the Watch Window functionality.

Answer to Question 2

a
RATIONALE: We are asked to calculate P(X > 100) given a normal distribution with a mean of 75 miles per gallon and a standard deviation of 10 miles per gallon. This probability can be calculated using the Excel function 1  NORM.DIST(100, 75, 10, TRUE) = 0.006.


leilurhhh

  • Hero Member
  • *****
  • Posts: 560
Reply #2 on: Jun 24, 2018
Thank you


Smiles0805

  • Sr. Member
  • ****
  • Posts: 305
Reply #3 on: Jun 24, 2018
No problemo


« previous next »
 

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

A molecular model showing chromosome territories in the cell nucleus of humans A molecular model showing chromosome territories in the cell nucleus of humans
The structure of stomatal guard cells affects their function. The structure of stomatal guard cells affects their function.
brain model brain model
Heart Model Heart Model
A two-compartment model of pharmacokinetics. A two-compartment model of pharmacokinetics.
Ethical Decision-Making Model Cont Ethical Decision-Making Model Cont
Video: Introduction to Herpes

For a complete list of videos, visit our video library