1) _________ is a calculation used in statistics to determine how far the data set varies from the mean.

A- Variance

B- Range

C- Standard deviation

D- Central tendency

2)

Managers at the Turquoise Oasis Spa are interested in knowing whether there is a relationship between the age of their clients and the amount of money they spend in the spa. Upon analyzing the data, they found a correlation coefficient of .672. Thus, the relationship between the two variables is _________.

A- strong

B- moderate

C- weak

D- very weak

3) Correlation coefficient values are easy to interpret, but it is often more powerful to create a _________ chart that illustrates that relationship visually.

A- matrix

B- quick analysis

C- histogram

D- scatter

4) The ________ filter displays the values in the field that can be toggled on and off through the use of check boxes.

A- advanced

B- enhanced

C- standard

D- additional

5) When using the_________ Filter feature in Excel, filtering criteria will be listed on the same worksheet.

A- Advanced

B- Enhanced

C- Standard

D- Additional