chapter 3- Descriptive Stats: Measurements

a type of data that can be organized into groups, but does not have mathematical meaning

Categorical data

a type of statistics used to describe and summarize values in a data set

Descriptive statistics

What is this IF function telling you? =IF (C8=100, ''A+'','' '')

If cell C8 is 100 then enter A+; otherwise, enter nothing.

value that is the difference between the upper quartile value and the lower quartile value.

interquartile range

percentile

is a measure that indicates what percent of the given population scored at or below the measur

describes the variability of the data-- or how spread out the data is in a data set

measure of variation.

Which of the following is the number that appears most often? Mode. Mean. Skew. Central Tendency. Median.

Mode

A value that is significantly higher or lower than the rest of the values in the data set

Outliers

What does a quantile represent? a The grouping of data into tenths b The grouping of data by quantifiable results c The grouping of data into equal frequencies d The grouping of data into 10 equal frequencies

c The grouping of data into equal frequencies

he midpoint value of a data set, where the values are arranged in ascending or descending order

median

Find the second quartile, or the median, for the following data set: 7, 9, 13, 4, 18, 3, 9, 10, 15, 8, 2, 6, 9

9

Which of these IF functions tells you whether an item is over $100 or not? =IF (E2>100, ''yes'', ''no'') =IF (E2<100, ''yes'', ''no'') =IF (E2=100, ''yes'', ''no'') none of these all of these

=IF (E2>100, ''yes'', ''no'')

Which of the following is the correct formula for the IF function in Excel? a. =(logical_test, value_if_true, value_if_false) b. IF (logical_test, value_if_true, value_if_false) c. =IF (logical_test, value_if_true, value_if_false) d. all of these e. none of these

=IF (logical_test, value_if_true, value_if_false)

What is central tendency? None of the other answers are correct. A way of summarizing some data with a single number. A way of avoiding collecting data. A way of summarizing some data with a series of numbers. A way of summarizing some data with three numbers.

A way of summarizing some data with a single number.

A decile can be calculated using what types of input data?

Both raw data values and data represented by a frequency distribution

What is a measure that indicates what percent of the given population scored at or below the measure?

Percentile

What do you need to include when you are entering text into your formula?

quotes

From the following data, what is the mode, mean and median? 1, 3, 5, 5, 6, 6, 7, 9, 10, 10, 10 5.5, 6.5, 6 6.5, 10, 6 6, 6.5, 10 10, 6.5, 6 10, 6, 6.5

10, 6.5, 6

A decile can be defined as _____.

A quantile that groups the data into 10 equal frequencies

If the index is not a _____, round the number up, then count the values in the data set from least to greatest until you reach the index.

Whole number

a description of the variability or how spread out the data is in a data set.

Measure of variation

Irene is doing her best to lose a little weight by monitoring how many calories she consumes per day. She follows a one week diet just to test things out. If she eats 1620 calories on Monday, 1510 on Tuesday, 1720 on Wednesday, 1580 on Thursday, 1650 on Friday, 1705 on Saturday and 1835 on Sunday, what is her average daily consumption?

1,660 calories

What is the geometric mean of 2 and 4?

2.828

Find the first quartile for the following data set: 7, 9, 13, 4, 18, 3, 9, 10, 15, 8, 2, 6, 9

5

Jonathan knows he scored in the 25th percentile on his psychology test. The professor gives the students the following list of grades (without names): 51, 37, 87, 95, 99, 78, 63, 96, 68, 84, 92 Assuming that there are 11 students in the class, what was Jonathan's test score?

63

The class scores on an exam are 97, 85, 92, 78 and 90. What is the average score?

88.4

which is a formula that returns one value if the condition is true and another if the condition is false

IF function,

What is the frequency distribution pattern of data that has been grouped into deciles?

It is flat

when the data creates a symmetrical bell-curve on a graph

Symmetrical distribution

provides and average rate of growth

geometric mean

mode

most often seen digit

The geometric mean gives you the average rate of growth for growth that is what?

multiplied

If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, ''pass'', ''fail'')

pass

geometric mean

provide alternative methods for averaging numbers by using multiplication

a set of values used to divide any frequency distribution into equal groups

quantile

What is a group of values and/or means that divide a data set into quarters, or groups of four?

quartile

mean

the average

set of values is the ratio of their sum to the total number of values in the set

arithmetic mean

The mean of three numbers X, Y and Z equals 11.5. If X equals 12.5 and Z equals 10, what is the value of Y?

12

Given a decile cut point value of 10.4, where the tenth sequential value is 32 and the eleventh value is 42, what is the actual decile value?

36.0

Find the geometric mean. 4, 4, 4

4

Find the geometric mean. 5, 4, 9, 1, 5, 7, 8

4.696

Find the interquartile range for the following data set: 7, 9, 13, 4, 18, 3, 9, 10, 15, 8, 2, 6, 9

9

All of the students in Jasmine's class have had their height measured. Jasmine is the 12th tallest person out of 560 students. What percentile is Jasmine's height in?

98th

A spreadsheet program allows you to organize your data in rows and columns.

Excel

is a specific type of quantile that arranges data into 10 equal parts

decile

median

which is the number right in the middle of the list of data

Phyllis is also in Jonathan's psychology class. She knows she scored in the 90th percentile on his psychology test. The professor gives the students the following list of grades (without names): 51, 37, 87, 95, 99, 78, 63, 96, 68, 84, 92 Assuming that there are 11 students in the class, what was Phyllis's test score?

96

When the tail of a distribution is longer than the other. If the tail is longer towards the negative side of a number line, it is left-skewed. If the tail is longer on the positive side of a number line, it is right-skewed.

Skewed distribution

a way of summarizing some data with a single number. In real life, the word 'average' is most commonly used.

central tendency

What is the difference between the upper quartile value and the lower quartile value?

Interquartile range

Which of the following is the number that you get when you add all the data up and divide by how many numbers there are? Central Tendency. Mode. Median. Mean. Skew.

Mean

Which of the following is the number that appears in the middle of the data? Median. Mode. Central Tendency. Mean. Skew.

Median

What numbers besides zero cannot be used in geometric mean calculations?

Negative numbers