Chapter 2 - Solving Problems with Statistical Analysis Tools Flashcards Preview

Quantitive Analysis with Excel > Chapter 2 - Solving Problems with Statistical Analysis Tools > Flashcards

Flashcards in Chapter 2 - Solving Problems with Statistical Analysis Tools Deck (35)
Loading flashcards...
1

What is the arithmetic average of a set of numbers?

The mean

2

What is the value in the middle?

The median

3

Which statistics fundamental occurs most frequently?

Mode

4

What is an indicator of how close together the values of a distribution are?

Standard deviation

5

What indicates that the mean, median, and mode are the same value?

Normal distribution

6

What is a distribution skewed?

When the mean, median, and mode aren't the same value

7

Which function changes the precision of data values stored?

The Round function

8

What is the format of the Round function?

=ROUND(number,num_digits)

9

Which function rounds a number down to the specific number of decimal places?

ROUNDDOWN(number,num_digits)

10

Which function rounds a number up to the next highest even integer?

EVEN(number)

11

Which function rounds a number up to the next highest odd integer?

ODD(number)

12

Which function rounds a number down to the nearest integer?

INT(number)

13

What is the format of the Mode function?

MODE.SNGL(range)

14

What is the format of the Standard deviation function?

STDEV.S(range)

15

List 2 ways that you can manage large worksheets

1. Freezing panes
2. Splitting the window

16

Which feature keeps titles displayed in the top pane while we scroll down the worksheet?

Freezing panes

17

Which feature allows you to scroll each portion individually, top/bottom and left/right, with separate scroll bars?

Splitting the window

18

Which worksheet places current values and historical values on a separate worksheet, side by side?

The comparison worksheet

19

What is a new contextual tool that enables easy access to data-analysis features?

Quick analysis

20

Which function allows a list to be sorted, then counts the number of entries either above or below the value in question?

The RANK.EQ function

21

What is the format of the RANK.EQ function?

=RANK.EQ(number,ref,[order])

22

True or False:

If the RANK.EU's order argument is 0 or left blank, the values are ranked in descending order

True

23

True or False:

If the RANK.EU's order argument is a positive number, the values are ranked in ascending order

True

24

Which function determines the nth largest value in a range?

The Large function

LARGE(range,cell that holds rank)

25

Which function determines the nth smallest value in a range?

The Small function

SMALL(range,cell that holds rank)

26

Which function counts the number of items in a range that meet specified criteria?

The COUNTIF function

COUNTIF(range,criteria)

27

Which function do you use to add all values in a range that meet the specified criteria?

The SUMIF function

SUMIF(range,criteria,sum_range)

28

Which argument identifies the corresponding cell range to sum if specified criteria have been met in the range established by the range argument?

The sum_range argument

29

What determines the outcome of changing one or more input values and evaluates the recalculated results?

What-if analysis

30

Which tool specifies the outcome you want and which input value you want to vary?

The goal seek tool