Author Question: The _____ function allows the user to pull a subset of data from a larger table of data based on ... (Read 210 times)

storky111 · **on:** Jun 24, 2018

The _____ function allows the user to pull a subset of data from a larger table of data based on some criterion.
a. VLOOKUP
b. IF
c. SUMIF
d. COUNTIF

Question 2

In a 3-sigma mean control chart for a process that is in control, what is the probability that a given sample mean will fall outside the control limits as the result of random variation alone?

wergv · **Reply #1 on:** Jun 24, 2018

Answer to Question 1

A

Answer to Question 2

Given 3-sigma control limits for a control chart, there is a 0.0026 (or 0.26) chance that a given sample will fall outside the control limits as the result of random variation alone. (Three-sigma limits include 99.74 of the area under the normal curve).