Statistics or Sadistics? It’s Up to You
Part I. Multiple-Choice Questions (20 items)
1. What term is used to describe the science of organizing and analyzing information to make the
information more easily understood?
a. Analysis
b. Data
c. Interpretation
d. Statistics
Ans: d
2. Which of the following individuals used statistics methods during the 17th century to study the
intelligence of his family members?
a. Charles Darwin
b. Francis Galton
c. Isaac Newton
d. Alfred Binet
Ans: b
3. Which of the following would be used to describe the type of statistical methods used to
organize and describe the characteristics of a collection of data?
a. Inferential statistics
b. Descriptive statistics
c. Sampling methods
d. Population methods
Ans: b
4. Which of the following would be used to describe the type of statistical methods used to make
inferences about the population based on a sample?
a. Inferential statistics
b. Descriptive statistics
c. Sampling methods
d. Population methods
Ans: a
,5. What is a mathematical operator used to perform a mathematical task called?
a. function
b. formula
c. average
d. range
Ans: b
6. Which of the following would be considered a formula?
a. SUM(A1:A3)
b. AVERAGE(A1:A9)
c. SUM(3,4)
d. 2+5
Ans: d
7. Which of the following is an example of an Excel formula for taking the number 6 to the
power of 2?
a. =6+2
b. =6^2
c. 6+2
d. 6^2
Ans: b
8. What symbol is used for representing the mathematical operator “division” when using Excel?
a. =
b. *
c. /
d. –
Ans: c
9. What symbol is used for representing the mathematical operator “multiplication” when using
Excel?
a. =
b. *
c. /
d. –
Ans: b
, 10. What symbol is used for representing the mathematical operator “subtraction” when using
Excel?
a. =
b. *
c. /
d. –
Ans: d
11. In Excel, what is a collection of cells called?
a. average
b. sum
c. range
d. mean
Ans: c
12. Which of the following formulas subtracts the value of 3 from 6 and multiplies the outcome
by 2?
a. SUM(3,6)*2
b. =6-3*2
c. SUM(3,6,2)
d. =(6-3)*2
Ans: d
13. Which of following formulas averages the values of 6, 5, 7, 4, and 10?
a. AVERAGE(A4:A10)
b. SUM(4,5,6,7,10)
c. AVERAGE (10,4,5,6,7)
d. 6+5+7+4/10
Ans: c
14. What was the first ever Excel-like computer application called?
a. Visicalc
b. Calcgraph
c. Excel-graph
d. Excelcalc
Ans: a