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

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

For a complete list of videos, visit our video library