Exam 2: Solving Problems with Statistical Analysis Tools

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 more than one committee. The data is listed in column F of a worksheet. The correct formula would be ____.

When the # symbol acts as a placeholder for a digit, it is considered to be a(n) ____________________ code.

Excel provides several tools for displaying and scrolling columns and/or rows so that certain areas can be fixed, or ____________________, and the remainder of the worksheet can be scrolled easily.

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. -At the end of the project, Nevia is very pleased with the results and is giving a demo of Goal Seek to a few of her co-workers. To open Goal Seek, her first step is to click the ____ tab on the ribbon.

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

The ____ function provided by Excel averages a series of values if they meet specific criteria.

Identify the letter of the choice that best matches the function. -25

With a ____ function, you include that function inside another formula or function as one of its arguments.

The syntax of the AVERAGEIF function ____ is very similar to the syntax of the SUMIF function.

The Paste option button option called ____ pastes the formulas and formatting from the original cell(s), but not the format of the cell borders.

Goal Seek continues to enter values until it reaches ____.

Goal Seek uses ____ approach to finding the right input that achieves the desired result, or goal, in the dependent cell.

With the LARGE function, the argument called analysis describes the range of cells being evaluated.

The ____ is the arithmetic value that occurs in the middle of a data set when organized from lowest to highest, where half the values are less than and half the values are greater than the median value.

The input for Goal Seek can be ____.

The Paste Special dialog box offers Operation options, which allow you to paste values using only three arithmetic operations: Add, Subtract, and Multiply.

Microsoft Excel provides a variety of predefined functions, including statistical functions, that you can use to determine such values as the arithmetic mean, median, mode, and standard deviation of a set of data.

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

In Goal Seek, if the target value cannot be reached exactly, the ____.

The Paste option called ____ pastes the formulas and formatting from the original range of cells, but reverses the orientation so that the rows of the original cell range become the columns in the pasted range, and the original columns become rows.