Exam 2: Solving Problems with Statistical Analysis Tools

The technique used to fix certain rows while you scroll to other rows in a worksheet is called ____ panes.

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

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

The ____ is the arithmetic average of a set of numbers.

The COUNTIF function accommodates a(n) single contiguous range argument. _________________________

The ROUND argument num_digits is the specified number of ____.

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision, which is six digits, to whatever format is displayed in that cell.

In the SMALL function, the first argument, array, is ____.

Case 2-2 Nevia is using Goal Seek for the first time. She is determining what to put in each text box inside the Goal Seek dialog box shown in the above figure. -Nevia has told you that the desired value is 325. In which text box should she insert the desired value?

A way to analyze the differences between two sets of data is to look at the percent difference of a value in one data set compared with that value in the second data set.

Performing a ____ analysis means, simply, to determine the outcome of changing one or more input values and to evaluate the recalculated results.

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. _________________________

The ____________________ Paste option button pastes only the formulas from the original (copied) cell(s).

The COUNTONLY function counts the number of items in a range that meet specified criteria.

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

Performing a(n) ____________________ analysis means, simply, to determine the outcome of changing one or more input values and to evaluate the recalculated results.

The ____________________ function counts the number of items in a range that meet specified criteria.

The formula =RANDBETWEEN(1,3) randomly returns a(n) ____.

With the COUNTIF function, the first time it encounters the comma delimiter, it assumes that what follows is ____.

____________________ is a measure of how widely the data values are dispersed from the arithmetic mean.