Deck 33: Statistical Analytic Tools

Question 1

The function to use in MS Excel to calculate correlations is:

A) CAL
B) CORREL
C) COMPUTE
D) REGRESS

Answer 1

CORREL

Question 2

In SPSS, most of the analyses like descriptives, correlations, and regression are under the tab __________.

A) COMPUTE
B) TRANSFORM
C) ANALYZE
D) DATA

Answer 2

ANALYZE

Question 3

To compute correlation between each pair of variables what option do you select in SPSS?

A) ANALYZE ? CORRELATE ? MULTIVARIATE
B) ANALYZE ? CORRELATE ? LINEAR
C) ANALYZE ? CORRELATE ? UNIVARIATE
D) ANALYZE ? CORRELATE ? BIVARIATE

Answer 3

ANALYZE ? CORRELATE ? BIVARIATE

Question 4

Bivariate correlation is correlation between two pairs of variables.

Question 5

ANALYZE ? CORRELATE ? BIVARIATE in SPSS produces correlation between two variables.

Question 6

Correlations cannot be calculated in MS Excel.

Question 7

Calculate the measures of central tendency for the following scores by inputting the following in MS Excel: 62, 67, 71, 77, 81, 82, 88, 89, 90, and 96. If two new scores, 66 and 92, are added, how does it change the average and median?