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 46 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 horizontal fraction bar was introduced by the Arabs.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Piercey-Normore and DePriest discovered that some lichens readily change partners. Piercey-Normore and DePriest discovered that some lichens readily change partners.
Pap smear. Cells of the cervix (shown in the center) change in appearance as they progress through Pap smear. Cells of the cervix (shown in the center) change in appearance as they progress through
Whitefish Blastula Cells under a microscope Whitefish Blastula Cells under a microscope
Stem cells in late development Stem cells in late development
A two-compartment model of pharmacokinetics. A two-compartment model of pharmacokinetics.
A model of the ATP cycle in muscle contraction A model of the ATP cycle in muscle contraction
Video: Conjunctivitis

For a complete list of videos, visit our video library