Excel Online Student Work X + O X C about:blank Update Excel template - Saved Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Comments 1 v [ v Arial 10 Ev ab General V 00 .00 [v APV OV ... E3 X Vfx A B C D E F G H Data Question Function(s) to Learn Answer Formula Used 59 65 How many data observations are present (sample size)? COUNT #N/A OUT A W N- 63 What is the sum of the data? SUM #N/A 83 What is the mean (average) of the data? AVERAGE #N/A 92 What is the median of the data? MEDIAN #N/A 53 What is the minimum value of the data? MIN #N/A 63 What is the maximum value of the data? MAX #N/A 79 10 87 What is the square root of the sample size? SQRT #N/A 11 72 What is the value of the third observation when squared? POWER #N/A 12 68 13 What is the square root of the sample size rounded to two digits? ROUND #N/A 14 What is the square root of the sample size rounded down to the next whole number? ROUNDDOWN #N/A 15 What is the square root of the sample size rounded up to the next whole number? ROUNDUP #N/A 16 17 What is the sample variance? VAR.S #N/A 18 What is the sample standard deviation? STDEV.S #N/A 19 What is the sample variance rounded to two decimals? VAR.S and ROUND #N/A 20 What is the sample standard deviation rounded to two decimals? STDEV.S and ROUND #N/A 21 22 How many observations are less than 75? COUNTIF #N/A 23 Is the mean less than 75 (TRUE or FALSE)? IF #N/A D E Sheet1 + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +