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

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

The average adult has about 21 square feet of skin.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

For a complete list of videos, visit our video library