QMB 3200 EXAM 1 QUESTIONS AND ANSWERS

QMB 3200 EXAM 1 QUESTIONS AND
ANSWERS



Frequency Distribution - Correct Answers -=COUNTIF

Reative Frequency - Correct Answers -= Frequency Distribution / Total

Cumulative Frequency - Correct Answers -Add up the relative frequency from low to
high. Should add add up to 100%

Create Histogram - Correct Answers -Highlight Data > Insert > Charts

Method to determine # of classes in a frequency distribution - Correct Answers -2^k > n
k = number of classes
n = number of data points

Empirical Probability - Correct Answers -P(A) = Frequency in which Event A occurs /
Total number of observations

Mutually Exclusive - Correct Answers -P(A or B) = P(A) + P(B)

Not Mutually Exclusive - Correct Answers -P(A or B) = P(A) + P(B) - P(A and B)

Estimated Class Width - Correct Answers -= ( Maximum Data Value - Minimum Data
Value) / k

Find frequencies with class widths - Correct Answers -Highlight data > insert > pivot
table
1) Move to rows and values,
2) Right click on pivot table
3) Click group and change to size of class width

How to create a Pareto Chart with Ogive - Correct Answers -Highlight y axis column,
relative, and cumulative data (skip frequency) > Insert > chart > cluster column chart >
right click change chart type> series 2: change to line chart

Ogive - Correct Answers -cumulative relative frequency as a line on Pareto chart