msis 3223 multiple choice 30 questions okstate

1) Which measure of center is most robust to outliers?

A) Mean B) Median C) Mode D) Midrange | Answer: B

2) For a right-skewed distribution, which is typically true?

A) Mean < Median < Mode B) Mean > Median > Mode C) Mean = Median = Mode D) Median > Mean > Mode | Answer: B

3) The interquartile range (IQR) equals:

A) Q3 + Q1 B) Q3 − Q1 C) Mean − Median D) Max − Min | Answer: B

4) Which statement best distinguishes a histogram from a bar chart?

A) Histograms compare categories B) Bar charts show numeric bins C) Histograms plot numeric bins on a continuous axis D) Bar charts have no gaps | Answer: C

5) A correlation close to 0 indicates:

A) No relationship B) No linear relationship C) Strong nonlinear relationship D) Causation | Answer: B

6) Covariance vs correlation—what’s true?

A) Both are unit-free B) Only covariance is unit-free C) Correlation is unit-free; covariance is not D) Neither is unit-free | Answer: C

7) For categorical data, the appropriate summary measure is:

A) Mean B) Standard deviation C) Proportion D) Variance | Answer: C

8) Which variable is on a ratio scale?

A) Temperature (°F) B) Year (2025) C) Customer age D) T-shirt size (S/M/L) | Answer: C

9) Which is true about standard deviation?

A) It is the square of variance B) It uses the same units as the data C) It is unaffected by outliers D) It equals IQR/2 | Answer: B

10) A valid cross-tabulation requires categories that are:

A) Normal and independent B) Mutually exclusive and exhaustive C) Interval-scaled D) Equally spaced | Answer: B

11) Which visualization best shows distribution shape for numeric data?

A) Pie chart B) Histogram C) 100% stacked column D) Radar | Answer: B

12) In a left-skewed distribution, we typically have:

A) Mean > Median B) Mean < Median C) Mean = Median D) Mode > Mean > Median | Answer: B

13) Relative frequency is defined as:

A) Class midpoint B) Frequency divided by total C) Max minus Min D) Q3 − Q1 | Answer: B

14) Which measure is MOST affected by outliers?

A) Mean B) Median C) Mode D) IQR | Answer: A

15) When data are skewed, the best single “center” to report is usually:

A) Mean B) Median C) Mode D) Midrange | Answer: B

16) Which chart is best to display category shares at one point in time?

A) Line B) Pie C) Scatter D) Radar | Answer: B

17) Which analytics type finds the best decision under constraints?

A) Descriptive B) Predictive C) Prescriptive D) Diagnostic | Answer: C

18) Which comes immediately after “Recognize the problem” in the 6-phase process?

A) Structure B) Analyze C) Define the problem D) Implement | Answer: C

19) In a decision model, “decision variables” are:

A) Parameters B) Uncontrollable inputs C) Choices under the decision maker’s control D) Random errors | Answer: C

20) Reliability vs validity—pick the correct pair:

A) Reliability = measures what it should; Validity = consistent B) Reliability = consistent; Validity = measures what it should C) Both mean accuracy D) Both mean bias | Answer: B

21) Excel operator precedence (highest to lowest):

A) + −, * /, ^ B) ^, * /, + − C) * /, ^, + − D) ^, + −, * / | Answer: B

22) Lock ONLY the column in Excel for A1:

A) A$1 B) $A1 C) $A$1 D) A1 | Answer: B

23) COUNT vs COUNTIF—what’s correct?

A) COUNT counts text; COUNTIF counts numbers B) COUNT counts numeric cells; COUNTIF counts cells meeting a criterion C) Both count only blanks D) COUNTIF can’t use text criteria | Answer: B

24) In a PivotTable with “Show Values As: % of Row Total,” each row’s percentages should:

A) Sum to 0 B) Sum to 100% C) Match column totals D) Be equal | Answer: B

25) Advanced Filter OR criteria for Dept = “Sales” or “Support” requires:

A) One criteria row with “Sales, Support” B) Two criteria rows under the same Dept header C) Two criteria columns on one row D) A wildcard formula only | Answer: B

26) VLOOKUP vs INDEX/MATCH—what’s true?

A) VLOOKUP is unaffected by inserted columns B) INDEX/MATCH is more robust to column changes C) Both require sorted data D) Neither can return text | Answer: B

27) Which Excel function returns the position of a value within a range?

A) INDEX B) MATCH C) CHOOSE D) OFFSET | Answer: B

28) Best chart to compare trends for multiple categories over time:

A) Line chart B) 100% stacked column C) Pie chart D) Radar | Answer: A

29) A dashboard is best described as:

A) A table of raw data B) An interactive, compact view of key metrics for monitoring decisions C) A single pie chart D) A model solver | Answer: B

30) In Tableau, which is correct?

A) Dimensions are quantitative; Measures are categorical B) Dimensions are categorical; Measures are quantitative C) Both are categorical D) Both are quantitative | Answer: B