S T 123456789 1 Data A B Question C D E F G H K M N P R Function(s) to Learn Answer Formula Used 60 60 How many data observations are present (sample size)? COUNT #N/A 74 What is the sum of the data? SUM #N/A 82 What is the mean (average) of the data? AVERAGE #N/A 99 What is the median of the data? MEDIAN #N/A 58 What is the minimum value of the data? MIN #N/A 88 What is the maximum value of the data? MAX #N/A 57 10 84 What is the square root of the sample size? SQRT #N/A 11 84 What is the value of the third observation when squared? POWER #N/A 12 99 13 What is the square root of the sample size rounded to two digits? ROUND #N/A 14 15 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? #N/A 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 28 29 31 35 36 37 38 39 22222222333333333340 How many observations are less than 75? COUNTIF #N/A Is the mean less than 75 (TRUE or FALSE)? IF #N/A 25 26 27 41 42 43 44 45 46 47 48 49 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 Support site and type the function into the search box at the top-right of the page. How many data observations are present (sample size)? What is the sum of the data? What is the mean (average) of the data (unrounded)? What is the median of the data? What is the minimum value of the data? What is the maximum value of the data? What is the square root of the sample size (unrounded)? What is the value of the third observation when squared? What is the square root of 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?

S T 123456789 1 Data A B Question C D E F G H K M N P R Function(s) to Learn Answer Formula Used 60 60 How many data observations are present (sample size)? COUNT #N/A 74 What is the sum of the data? SUM #N/A 82 What is the mean (average) of the data? AVERAGE #N/A 99 What is the median of the data? MEDIAN #N/A 58 What is the minimum value of the data? MIN #N/A 88 What is the maximum value of the data? MAX #N/A 57 10 84 What is the square root of the sample size? SQRT #N/A 11 84 What is the value of the third observation when squared? POWER #N/A 12 99 13 What is the square root of the sample size rounded to two digits? ROUND #N/A 14 15 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? #N/A 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 28 29 31 35 36 37 38 39 22222222333333333340 How many observations are less than 75? COUNTIF #N/A Is the mean less than 75 (TRUE or FALSE)? IF #N/A 25 26 27 41 42 43 44 45 46 47 48 49 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 Support site and type the function into the search box at the top-right of the page. How many data observations are present (sample size)? What is the sum of the data? What is the mean (average) of the data (unrounded)? What is the median of the data? What is the minimum value of the data? What is the maximum value of the data? What is the square root of the sample size (unrounded)? What is the value of the third observation when squared? What is the square root of 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?

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter2: Descriptive Statistics

Section: Chapter Questions

Problem 24P: Five observations taken for two variables follow. a. Develop a scatter diagram with x on the...

See similar textbooks