excel chapter 8 questions

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