Author Question: The _____ function is used for the conditional computation of expressions in Excel. a. MAX b. IF ... (Read 215 times)

ec501234

  • Hero Member
  • *****
  • Posts: 573
The _____ function is used for the conditional computation of expressions in Excel.
 a. MAX
  b. IF
  c. SUMSQ
  d. NOT

Question 2

How does the purpose of a range chart differ from that of a mean chart, and why is it a good idea to use both of them in monitoring the same process?



trampas

  • Sr. Member
  • ****
  • Posts: 320
Answer to Question 1

B

Answer to Question 2

The range chart measures the variation in the measurements; it is similar to a standard error chart. The mean chart, on the other hand, measures the central tendency of the measurements. Both the range and the mean should be monitored to assure product quality. The mean is important for obvious reasons: we must be close to the specifications on average. The range is also important because we cannot tolerate too much overall deviation.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

trampas

  • Sr. Member
  • ****
  • Posts: 320

 

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

For a complete list of videos, visit our video library