Exam 2: Solving Problems with Statistical Analysis Tools

The MODE.SNGL, MEDIAN, and STDEV.S functions work in a similar way, containing only one type of ____________________, which is a list of values.

The Paste Special dialog box offers the ____ option, which enables you to copy and paste a cell range that contains one or more blank cells where the blank cells are not pasted over any existing values in the range into which they are pasted.

The ____ symbol(s) insert(s) a comma as a thousands separator or as a scaling operator.

The ____ is the arithmetic value that occurs most frequently in a data set.

Case-Based Critical Thinking Questions Case 2-1 Julia is learning how to use relational operators with the COUNTIF function. Her boss handed her the chart in the above figure and asked her to solve some everyday business problems. -On a separate project, the head of Human Resources is looking for a list of people who do not have 100% attendance. In the database, the number 1 means 100% attendance; all other numbers indicate that some work was missed (for example, .75 is 75% attendance). The data is listed in column E of a worksheet. The correct COUNTIF formula would be ____.

Excel uses the Goal Find tool to try various input values in order to calculate the required input to achieve your desired outcome. _________________________

A(n) ____ distribution exhibits an equal number of occurrences of data values both below and above the arithmetic mean.

Wingdings are symbols that you can use as part of the criteria to search for text strings; each symbol can be substituted for a character or set of characters. _________________________

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision (____ digits) to whatever format is displayed in that cell, including the number of decimal places.

The ADDIF function adds all the values in a range that meet specified criteria. _________________________

The ____ symbol acts as a digit placeholder that does not display insignificant digits, but does hold a place so that decimal points will align.

If you wrote the formula =TRUNC(-4.382,1), the resulting value would be ____.

The ____ symbol(s) specify/specifies that text enclosed in between these marks should be inserted as shown.

Case-Based Critical Thinking Questions Case 2-1 Julia is learning how to use relational operators with the COUNTIF function. Her boss handed her the chart in the above figure and asked her to solve some everyday business problems. -Julia wants to take a count of all employees who are participating in exactly one committee. The correct formula would be ____.

In the Goal Seek dialog box, you use the Set cell box to specify the cell ____.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#4

Consider the following five values: 1, 1, 6, 7, and 10. The arithmetic mean of these values is ____.

A list of values can contain ____.

The MODE.SNGL, MEDIAN, and STDEV.S functions work in a similar way, containing only one type of argument, which is ____.

The ____ wildcard specifies that a single character can be substituted.