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

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

Human Heart Model Human Heart Model
Model of the Reading Process Model of the Reading Process
Two methods by which cells migrate in the developing neural tube: somal translocation and ... Two methods by which cells migrate in the developing neural tube: somal translocation and ...
Carbon Dioxide, Trace Gases, and Climate Change Carbon Dioxide, Trace Gases, and Climate Change
Type of Interactions, Model, Examples and Dependence of Energy on Distance Type of Interactions, Model, Examples and Dependence of Energy on Distance
Ethanol has the molecular formula C2H6O. Which ball and stick model shown above represents ... Ethanol has the molecular formula C2H6O. Which ball and stick model shown above represents ...
Video: Cerebral Cortex Animation

For a complete list of videos, visit our video library