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

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

The universal features of living cells The universal features of living cells
Eye Model Eye Model
A model for priority setting A model for priority setting
Adult neurogenesis. The top panel shows new cells in the dentate gyrus of the hippocampus—the cell ... Adult neurogenesis. The top panel shows new cells in the dentate gyrus of the hippocampus—the cell ...
Natural Causes of Climate Change Natural Causes of Climate Change
Vulnerability – Stress Model Vulnerability – Stress Model
Video: Carbohydrate digestion (brush border enzymes, end products) & Carb absorption (fructose, galactose)

For a complete list of videos, visit our video library