Exam 2: Solving Problems with Statistical Analysis Tools

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

The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).

Case-Based Critical Thinking Questions 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?

The ROUND argument num_digits is a single value that can be a constant, a cell reference where the cell contains a numerical value, or another formula that results in a single number value.

You can recalculate a worksheet at any time by pressing the ____ function key.

The Paste option button called ____ pastes the data and formulas from the original cell(s), and maintains the column width of the original cell(s).

The ____ symbol acts as a digit placeholder that displays both significant and insignificant zeros.

The relational operator >= stands for ____________________ than or equal to.

To specify that a value should be precisely stored to the nearest hundredth, use the ____________________ function.

In the SUMIF function, the criteria argument identifies the cell range where the criteria are located. _________________________

Case-Based Critical Thinking Questions 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. -Once Nevia clicks the correct tab, to open Goal Seek, she clicks the ____ button in the Data Tools group, then selects Goal Seek.

Automatic calculation can be turned off from the ribbon or from the ____ dialog box accessed via the FILE tab.

In the function RANK.EQ(number,ref,order), the number argument refers to the value to be ranked. _________________________

The ____ of a normal distribution are the same value.

In the LARGE function, the second argument, k, is the desired ranking, where 1 is ____.

To calculate a(n) ____________________ between two data sets, you subtract the old value from the new value and then divide the difference by the old value.

Once the Goal Seek Status dialog box gives the target value, you can click ____ to update your worksheet with the new values based on Goal Seek.

The BIG function determines the nth largest value in a range. _________________________

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.

Explain what the following four number formatting codes do when used in Excel: #, 0, ?, and %. Write one sentence about each symbol and give an example of how it can be used.