B D Function(s) to Learn F Formula Used Question Answer 1 2 3 4 5 A Data 94 76 57 84 54 65 61 51 56 76 58 How many data observations are present (sample size)? What is the sum of the data? What is the mean (average) of the data? What is the median of the data? What is the minimum value of the data? What is the maximum value of the data? COUNT SUM AVERAGE MEDIAN MIN MAX #N/A #N/A #N/A #N/A #N/A #N/A What is the square root of the sample size? What is the value of the third observation when squared? SQRT POWER #N/A #N/A 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 What is the square root of the sample size rounded to two digits? ROUND What is the square root of the sample size rounded down to the next whole number? ROUNDDOWN What is the square root of the sample size rounded up to the next whole number? ROUNDUP #N/A #N/A #N/A What is the sample variance? What is the sample standard deviation? What is the sample variance rounded to two decimals? What is the sample standard deviation rounded to two decimals? VAR.S STDEV.S VAR.S and ROUND STDEV.S and ROUND #N/A #N/A #N/A #N/A How many observations are less than 75? Is the mean less than 75 (TRUE or FALSE)? COUNTIF IF #N/A #N/A B D Function(s) to Learn F Formula Used Question Answer 1 2 3 4 5 A Data 94 76 57 84 54 65 61 51 56 76 58 How many data observations are present (sample size)? What is the sum of the data? What is the mean (average) of the data? What is the median of the data? What is the minimum value of the data? What is the maximum value of the data? COUNT SUM AVERAGE MEDIAN MIN MAX #N/A #N/A #N/A #N/A #N/A #N/A What is the square root of the sample size? What is the value of the third observation when squared? SQRT POWER #N/A #N/A 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 What is the square root of the sample size rounded to two digits? ROUND What is the square root of the sample size rounded down to the next whole number? ROUNDDOWN What is the square root of the sample size rounded up to the next whole number? ROUNDUP #N/A #N/A #N/A What is the sample variance? What is the sample standard deviation? What is the sample variance rounded to two decimals? What is the sample standard deviation rounded to two decimals? VAR.S STDEV.S VAR.S and ROUND STDEV.S and ROUND #N/A #N/A #N/A #N/A How many observations are less than 75? Is the mean less than 75 (TRUE or FALSE)? COUNTIF IF #N/A #N/A