« previous next »

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

ec501234

  • Hero Member
  • *****
  • Posts: 573
on: Jun 24, 2018
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
Reply #1 on: Jun 24, 2018
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

ec501234

  • Hero Member
  • *****
  • Posts: 573
Reply #2 on: Jun 24, 2018
Correct answers!


trampas

  • Sr. Member
  • ****
  • Posts: 320
Reply #3 on: Jun 24, 2018
Great! Please up vote :D


« previous next »
 

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Glioma. (a) Illustration of a large glioma (colored area) within the left cerebral hemisphere in a s Glioma. (a) Illustration of a large glioma (colored area) within the left cerebral hemisphere in a s
How to write a sine function when given the amplitude, period, and phase shift How to write a sine function when given the amplitude, period, and phase shift
How to determine if a table of values represents a function How to determine if a table of values represents a function
The Production Function The Production Function
How reciprocal functions compare to the parent function How reciprocal functions compare to the parent function
Discrete random variables- Probability Distribution Function Discrete random variables- Probability Distribution Function
Video: Metabolic Rate, Heat and Thermoregulation - response to heat and cold stresses

For a complete list of videos, visit our video library