Studied by 22 peopleWhich 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
Note
Flashcard