Author Question: The _____ function is used for the conditional computation of expressions in Excel. a. MAX b. IF ... (Read 221 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?

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?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

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.

For a complete list of videos, visit our video library