File Home Insert Draw Page Layout Formulas Data Review View Help 9v Fjv |Arial v10 v B _v av AV... 1 Ev gt; General v $v $3 $3 mv g @V Ev sz'vv ,0 :3 v f; A B c D G I J K 1 Data Question Fundiun(s) tn Lean Answer 2 53 - 88 How many data observations are present (sample size)? COUNT 4 64 What is the sum of the data? SUM 5 85 What is the mean (average) of the data? AVERAGE 6 75 What is the median of the data? MEDIAN 7 66 What is the minimum value at the data? MIN 8 95 What is the maximum value of the data? MAX 9 84 10 64 What is the square root of the sample size? SQRT 1 1 70 What is the value of the third observation when squared? POWER 12 67 13 What is the square root of the sample size rounded to two digits? ROUND 14 What is the square root of the sample size rounded down to the next whole number? ROUNDDOWN 15 What is the square root of the sample size rounded up to the next whole number? ROUNDUP 16 17 What is the sample vananoe? VAR S 18 What is the sample standard deviation? STDEVS 19 What is the sample variance rounded to two decimals? VARS and ROUND 20 What is the sample standard deviation rounded to two decimals? STDEVS and ROUND 21 22 Hew many observations are less than 75? COUNTIF 23 Is the mean less than 75 (TRUE or FALSE)? IF Z4 25 26 27 28 29 @(t > E'I Sheen + This problem is designed to familiarize you with basic Microsoft Excel functions that are commonly used in data analysis and in other Excel problems you will be working in MindTap. You will be using the Microsoft Excel Online file below to work in the spreadsheet and then answer the questions. Feel free to click on the Excel Online link now to open the spreadsheet. It will open in a separate browser tab. Open spreadsheet Column A contains a generic dataset. Column C is a list of questions that correspond to the questions below. Column D indicates which Excel function(s) that question is designed to teach. Column E is where you will work with the function(s) to generate the answer to each question. And nally Column F displays the formula you used to generate your answer in Column E. To place your answers from Column E into the blanks below, use the copy/paste keyboard shortcut: Ctrl+C and Ctrl+\\.il on a PC or Cmd+C and Cmd+V on a Mac. If you would like to learn more about a specific function, you can always visit the Microsoft Ofce Support site and type the function into the search box at the toprright of the page. How many data observations are present (sample size)? 11 9 What is the sum of the data? 313 0 What is the mean (average) of the data (unrounded)? 73.90909" 0 What is the sum 0f the data? _0 What is the mean [average] of the data (unrounded)? _9 What is the median [if the data? _@ What is the minimum value [if the data? _@ What is the maximum value at the data? _@ What is the square rest at the sample size (unraunded)? _@ What is the value of the third observation when squared? _9 What is the square rent at the sample size {to 2 digits)? _@ What is the square root of the sample size rounded down to the nearest whole number? _@ What is the square root of the sample size rounded up to the nearest whole number? _@ What is the sample varianoe (unrounded}? _9 What is the sample standard deviation (unrounded)? _9 What is the sample variance (to 2 decimals)? e What is the sample standard deviation (to 2 decimals}? _9 How mam.r observations are less than ?5? E9 Is the mean less than ?5 {TRUE or FALSE}? -@