1. The ______ chart is used to show relationships between two separate variables at the same time.

Group of answer choices

Line Chart

Bar Chart

Pie Chart

Scatter Chart

2. ________ distributions is one that has approximately equal numbers at each interval.

Group of answer choices

Skewed left

Skewed right

Normal

Uniform

3. When creating categories in a frequency distribution, it is important to creat a proper amount of categories. This means creating enough categories but not too many.

Group of answer choices

True

False

4. Pivot tables provide important means to organize and analyze data, one other chart that is used to compare both individual frequencies and the cumulative frequencies at the same time is called?

Group of answer choices

Pareto Chart

Scatter Chart

Line Chart

Bar Chart

5. When using a Pareto Chart, the categorical data are always arranged in order, from the least frequent to the most frequent.

Group of answer choices

True

False

6. A distribution is said to be skewed to the left when the data shows the bars on the left of the chart are smaller in height than the bars on the right side of the chart.

Group of answer choices

True

False

7. When the =FREQUENCY ( ) function is used, Excel looks at each data value and compares it with each ____ value.

Group of answer choices

Group

Number

Bin

Data

8. The functions =MIN ( ) and =MAX ( ) can be used to determine which of the following?

Group of answer choices

Difference

Min/Max values

Frequency

Repetition

9. It is necessary to enter each formula into excel multiple times in order to ensure your data will be computed on a consistent basis.

Group of answer choices

True

False

10. Types of charting tools used with excel are:

Group of answer choices

Line Chart

Bar Chart

Pie Chart

Scatter Chart

All of the above

11. A measure of dispersion can be produced for any data set.

Group of answer choices

True

False

12. The sample variances is calculated by?

Group of answer choices

The sum of all squared differences between actual values and the overall mean

The sum of all squared differences between actual values and the overall mean divided by the total number of observations less one

The sum of all squared differences between actual values and the overall mean divided by the total number of observations.

None of the above

13. In general, a working assumption is that whatever measure of dispersion is chosen, it should be centered on the ____.

Group of answer choices

Median

Mean

Mode

Highest value

14. Typically, most of the observations in almost any data set will be in the +/- ____ standard deviation range.

Group of answer choices

1

2

3

4

15. Which of the following is not a measure of central tendency?

Group of answer choices

Mean

Median

Mode

None of the above

16. The average value of the standard deviation of all possible samples from any population will not be equal to the standard deviation of the total population.

Group of answer choices

True

False

17. Typically it is more likely the mode will be used to describe a set of data than the median will be used.

Group of answer choices

True

False

18. The two ways of characterizing any data distribution are by the measures of central tendency and dispersion?

Group of answer choices

True

False

19. For the variance, the population value and the sample values are calculated in the same way.

Group of answer choices

True

False

20. Which of the following is not an excel function for the measures of central tendency?

Group of answer choices

=MODE( )

=MEDIAN( )

=MEAN( )

=AVERAGE( )