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 88 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?

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

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

The wild radish, Raphanus sativus, has become a model for studying the mating behaviour of plants. The wild radish, Raphanus sativus, has become a model for studying the mating behaviour of plants.
Masters and Johnson’s Four-Phase Model of the Sexual Response Cycle Masters and Johnson’s Four-Phase Model of the Sexual Response Cycle
The Revolutionary Change in the U.S Workforce The Revolutionary Change in the U.S Workforce
Geoengineering is not a solution to climate change Geoengineering is not a solution to climate change
Solow Model with Saving Dependent on Income Level Solow Model with Saving Dependent on Income Level
The attenuation model regulating the tryptophan operon The attenuation model regulating the tryptophan operon
Video: Acid-base imbalances - respiratory acidosis and alkalosis

For a complete list of videos, visit our video library