Statistics and Dispersion

Aggregate functions perform calculations on multiple values and return a single result. SUM and AVG are standard SQL aggregate functions. Median is also an aggregate function (though not available in all SQL dialects). Trim is a string manipulation function that operates on individual values, not sets.

Process capability (Cp) is defined as the specification width divided by 6 times the process standard deviation. This formula shows how many 6-sigma intervals fit within specification limits. A capable process typically has Cp at least 1.0, meaning 6 sigma fits within specifications. The 6 sigma relationship is fundamental to process capability analysis.

The binomial distribution model applies to random sampling where each item has the same probability of being selected, and selections are independent. Acceptance sampling is a specific application, not the sampling type itself. 100% inspection is not sampling at all. Binomial sampling is redundant. Random sampling is the fundamental method that enables binomial distribution assumptions.

Aggregate or group functions in SQL operate on sets of rows to return a single summary value, such as avg(), sum(), and max(). Conversely, sqrt() is a single-row mathematical scalar function, not a group function.

CLM (confidence limits for the mean) generates confidence intervals around the mean. Option A correctly specifies CLM with MEDIAN and MEAN. UCLM and LCLM are separate options for upper/lower limits only - using them individually wouldn't give the full interval. Option D incorrectly uses SUM instead of CLM.

ROUND operates on individual values, transforming each input row independently. In contrast, STDDEV, VARIANCE, and COUNT are aggregate functions that require processing multiple rows to compute statistical measures.

Group functions (aggregate functions) operate on sets of rows and return a single result. avg(), max(), and sum() are all group functions. sqrt() is a single-row function that operates on individual values.

To calculate the average of a column, you can either use the built-in AVG() aggregate function directly or divide the sum of the values using SUM() by the count of the values using COUNT(). Both methods produce the correct average.

sqrt() is a mathematical function, not a group function. Group functions like avg(), sum(), and max() operate on sets of values to return a single result.

In Informatica PowerCenter, the CUME() function calculates cumulative/running totals within a group. Unlike simple aggregation functions like SUM(), CUME maintains a running accumulation across rows, making it the correct choice for running total calculations.

Count, Avg, and Max are all standard SQL aggregate functions that operate on sets of rows in GROUP BY queries. Total is not a standard SQL aggregate function (SUM would be the correct function), making it the correct answer to 'which is NOT a group function.'

Group functions like AVG and SUM can only be used on numeric columns that contain actual numeric data. They cannot be used on non-numeric data types (strings, dates, etc.) even if they appear numeric - the underlying data type matters. Additionally, these functions ignore NULL values in the numeric columns.

The average function in SQL aggregate queries ignores NULL values. For the data set 5 and 10, the sum is 15 and the count of non-null values is 2, resulting in an average of 7.5.

The AVG function ignores NULL values and calculates the average of non-NULL values only. (5 + 10) / 2 = 7.5. It does not return NULL, 5, or 10.

Grouping (aggregate) functions operate on sets of values and return a single result. AVG, COUNT, and MIN are all standard SQL aggregate functions used with GROUP BY. ABS is a single-row numeric function that returns the absolute value of one number - it does NOT group or aggregate data, making it the correct answer.