excel chapter 8 questions

Which of the following functions should be used to determine how far the sample data is spread around the mean?

Which of the following functions should be used to determine how far the sample data is spread around the mean?

STDEV.S

In the linear equation y = mx + b, which function would you use to calculate b?

INTERCEPT

What does a negative COVARIANCE indicate?

An inverse relationship between datasets

A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $650, and $600. What function could be used to return the third largest value?

LARGE

What function would you use to calculate the strength of a relationship between two or more variables?

CORREL

You hypothesize that there is a relationship between lack of regular exercise and illness. To research this theory, you have compiled a sample set of data that contains numbers of days in which an hour or more of exercise is completed as well as numbers of days sick within a calendar year. What tool in Excel could you use to investigate the relationships between the data?

CORREL

Which of the following functions should be used to determine how closely a linear trendline represents the data being evaluated?

RSQ

What is the difference between STDEV.S and STDEV.P?

STDEV.S calculates the standard deviation of a sample; STDEV.P calculates the standard deviation of a population.

What is the difference between a sample and a population?

A population contains all data you want to evaluate, while a sample contains a portion of the data.

What keystroke combination is required to calculate a Frequency data array?

Ctrl+Shift+Enter