Excel template , Saved / File Home Insert Draw Page Layout Formulas Data Review 9V Ev g) V V B i ('zw A E3 v fx A C 1 Data Question 2 74 3 70 How many data observations are present (sample size)? 4 62 What is the sum of the data? 5 99 What is the mean (average) of the data? 6 73 What is the median of the data? 7 99 What is the minimum value of the data? 8 52 What is the maximum value of the data? 9 94 1O 86 What is the square root of the sample size? 11 91 What is the value of the third observation when squared? 12 92 13 What is the square root of the sample size rounded to two digits? 14 What is the square root of the sample size rounded down to the next whole number? 15 What is the square root of the sample size rounded up to the next whole number? 16 17 What is the sample variance? 18 What is the sample standard deviation? 19 What is the sample variance rounded to two decimals? 20 What is the sample standard deviation rounded to two decimals? 21 22 How many observations are less than 75? 23 Is the mean less than 75 (TRUE or FALSE)? 24 25 26 27 28 29 30 31 32 33 34 : El Sheet1 + Calculation Mode: Automatic Workbook Statistics View Help v 3") : General V 1'13 D E F Function(s) to Learn Answer Formula Used COUNT f #N/A SUM V #NIA AVERAGE V #NIA MEDIAN V #NIA MIN V #NIA MAX V #N/A SORT V #N/A POWER V #N/A ROUND V #NIA ROUNDDOWN V #NIA ROUNDUP V #N/A VARs V #NIA STDEVtS V #NIA VAR.S and ROUND V #NIA STDEvs and ROUND V #NIA COUNTIF V #NIA IF V #N/A / Editing v [:1 Comments v v | J K L Give Feedback to Microsoft 100% + "=51 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 finally 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+V 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 Office SUQM site and type the function into the search box at the top-right of the page. How many data observations are present (sample size)? 11 60 What is the sum of the data? 865 0 What is the mean (average) of the data (unrounded)? 78.6363610 What is the median of the data? 800 What is the minimum value of the data? 530 What is the maximum value of the data? 01\" #1: Graded Tutorial #1 - Learning Common Excel Statistical Functions 0 What is the maximum value of the data? 930 What is the square root of the sample size (unrounded)? 3316624169 What is the value of the third observation when squared? 9216 63 What is the square root of the sample size (to 2 digits)? 3.3269 What is the square root of the sample size rounded down to the nearest whole number? 3 69 What is the square root of the sample size rounded up to the nearest whole number? 4 69 What is the sample variance (unrounded)? 286.0545 0 What is the sample standard deviation (unrounded)? 16.91314' (3 What is the sample variance (to Z decimals)? 286.05 0 lama. :. u.' --...._I- -a.__.l-_.l A-..:-a.:-_ In... '1 A--:~.-I-\\w t1: Graded Tutorial #1 - Learning Common Excel Statistical Functions 0 What is the square root of the sample size rounded down to the nearest whole number? 3 69 What is the square root of the sample size rounded up to the nearest whole number? 4 60 What is the sample variance (unrounded)? 2861154510 What is the sample standard deviation (unrounded)? 16.91314' 0 What is the sample variance (to 2 decimals)? 286.05 0 What is the sample standard deviation (to 2 decimals)? 16.91 0 How many observations are less than 75? 5 to Is the mean less than 75 (TRUE or FALSE)? FALSE 9 9 Check My Work Reset Problem \f#2: Structured Tutorial COUNTIF Function 0 Sorting through unsolicited e-mail and spam affects the productivity of office workers. An InsightExpress survey monitored office workers to determine the unproductive time per day devoted to unsolicited e-mail and spam (USA Today, November 13, 2003). The data in the Microsoft Excel Online file below show a sample of time in minutes devoted to this task. Summarize the data by constructing the following items. Open spreadsheet a. ll in the frequency (to the nearest whole number), the relative frequency (2 decimals), the cumulative frequency (to the nearest whole number), and the cumulative relative frequency (2 decimals) values below. Class (Minutes) Frequency Relative Frequency Cumulative Frequency Cumulative Relative Frequency 1-5 6-10 11-15 16-20 21-25 26-30 31-35 (Total) b. Use the graph below of these data to answer the following questions. Microsoft Excel #2: Structured Tutorial COUNTIF Function 0 Question 1 0/10 21-25 Submit 26-30 31-35 (Total) b. Use the graph below of these data to answer the following questions. 0 l i l l l 0 5 [0 IS 20 25 30 35 Time What percentage of office workers spend 5 minutes or less on unsolicited e-mail and spam? /o What percentage of office workers spend more than 10 minutes a day on this task? 0/0 Check My Work Reset