Key terms matching.

Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition. a. Analysis ToolPak b. ANOVA c. AVERAGEIF function d. CORREL function e. COUNTIF function f. Covariance g. FREQUENCY function h. Histogram i. PERCENTILE.EXC function j. PERCENTILE.INC function k. PERCENTRANK.EXC function l. PERCENTRANK.INC function m. QUARTILE.EXC function n. QUARTILE.INC function o. RANK_AVG function p. RANK_EQ function q. Standard Deviation r. SUMIF function s. SUMIFS function t. Variance 1. ____ A visual display of tabulated frequencies. 2. ____ Measure of how two sample sets of data vary simultaneously. 3. ____ A statistical tool that compares the means between two data samples to determine if they were derived from the same population. 4. ____ An add-in program that contains tools for performing complex statistical analysis. 5. ____ A measure of a dataset's dispersion, such as the difference between the highest and lowest points in the data. 6. ____ Measures how far the data sample is spread around the mean. 7. ____ Determines the number of occurrences of numerical values in a dataset based on predetermined bins. 8. ____ Calculates the correlation coefficient of two data series. 9. ____ Calculates the total of a range of values when a specified condition is met. 10. ____ A statistical function that identifies the rank of a value, omitting the next rank when tie values exist. 11. ____ Identifies the rank of a value. providing an average ranking for identical values. 12. ____ Identifies the value at a specific quartile. 13. ____ A statistical function that identifies the value at a specific quartile, exclusive of 0 and 4. 14. ____ A statistical function that returns the percentile of a range including the 0 or 100% percentile. 15. ____ A statistical function that returns the percentile of a range excluding the 0 or 100% percentile. 16. ____ Counts the number of cells in a range when a specified condition is met. 17. ____ Calculates the average of values in a range when a specified condition is met. 18. ____ Identifies the kth percentile of a specified value within a list of values, including the 0th and 100th percentiles. 19. ____ A statistical function that returns the percentile of a range excluding the 0 or 100% percentile. 20. Calculates the total value of cells in a range that meet multiple criteria