Exam 29: Statistical Functions

The second quartile of both QUARTILE.EXC and QUARTILE.INC defines what percentile?

When using the CORREL function,a value of .00007 would indicate:

The PERCENTILE.INC function includes the 0 and 100th percentile.

When using the RANK.AVG function the order argument determines the ________.

The ________ function is best suited to determine the number of high school students under the age of 16.

Two or more conditions can be used with the SUMIFS function.

________ a measure of how two sets of data vary simultaneously.

Which of the following functions is best suited to calculate the covariance of a population?

Which of the following functions will help determine the strength of a relationship between two variables?

When using the QUARTILE.INC function the 4th quartile would include the highest number value.

The ________ function calculates the variance of a population.

Histograms can be created on a separate worksheet when using the Analysis ToolPak.

Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text?

Histogram is a tool of the Analysis ToolPak.

________ is a statistical hypothesis test that helps determine if samples of data were taken from the same population.

What is the difference between calculating standard deviation of a population versus a sample?

When using an array of data with the FREQUENCY function,the following keystroke is required.